- Courses
- Tutorials
- Practice
- Jobs
Data Warehousing | Introduction to Data Warehouse Modelling
Question 1
The load and index is which of the following?
- A
A process to reject data from the data warehouse and to create the necessary indexes
- B
A process to load the data in the data warehouse and to create the necessary indexes
- C
A process to upgrade the quality of data after it is moved into a data warehouse
- D
A process to upgrade the quality of data before it is moved into a data warehouse
Question 2
What is the primary function of a data warehouse?
- A
Real-time transaction processing
- B
Long-term storage of historical data
- C
Operational decision support
- D
Real-time data analytics
Question 3
Which of the following tools is commonly compatible with Data Marts for visualization and analysis?
- A
GCC Compiler
- B
Tableau
- C
Apache Tomcat
- D
Notepad++
Question 4
What does a fact-less fact table in a data warehouse typically contain? A fact-less fact table is a specific type of fact table that does not include numerical measures or metrics but serves a particular purpose in capturing events or describing relationships between dimensions. Choose the correct answer from the options provided below:
- A
Only measures - The table includes solely numerical metrics for analysis
- B
Only dimensions - The table contains only dimensional attributes without any measures
- C
Keys and measures - The table includes a combination of surrogate keys and numerical measures
- D
Only surrogate keys - The table contains surrogate keys to represent relationships
Question 5
In a , facts are usually stored in which type of table?
- A
Dimension table
- B
Fact table
- C
Schema table
- D
Attribute table
Question 6
Which of the following best represents a dimension in a Multidimensional Data Model?
- A
Profit or loss
- B
Revenue
- C
Time
- D
Total sales amount
Question 7
Which of the following statements about Fact Tables is TRUE?
- A
Fact tables store descriptive attributes like customer name and location.
- B
Fact tables contain quantitative data and foreign keys referencing dimension tables.
- C
Fact tables store metadata about the data warehouse.
- D
Fact tables are not connected to dimension tables in a star schema.
Question 8
Which type of fact table is best suited to track process progress such as “Order → Shipment → Delivery” ?
- A
Transaction Fact Table
- B
Periodic Snapshot Fact Table
- C
Accumulating Snapshot Fact Table
- D
Summary Fact Table
Question 9
Which of the following correctly distinguishes a Fact Table from a Dimension Table?
- A
Fact tables store descriptive attributes; Dimension tables store numerical measures.
- B
Fact tables come before dimension tables in schema design
- C
Fact tables contain fewer records and more attributes than dimension tables.
. - D
Fact tables store numerical measures and foreign keys; Dimension tables store descriptive attributes.
Question 10
What is the main purpose of using Aggregate Fact Tables in a data warehouse?
- A
To summarize base data using aggregate functions for faster query performance.
- B
To store metadata for dimension tables.
- C
To replace all base fact tables permanently.
- D
To store raw transactional data for detailed analysis.
There are 10 questions to complete.