Data Warehouse Architecture MCQs
Data Warehousing Architecture MCQs : This section focuses on "Architecture" of Data Warehousing. These Multiple Choice Questions (mcq) should be practiced to improve the Data Warehousing skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.
1. How many tier data warehouse architecture?
A. 2
B. 1
C. 4
D. 3
View Answer
Ans : D
Explanation: Generally a data warehouses adopts a three-tier architecture : Bottom Tier, Middle Tier and Top Tier.
2. Which of the following tier is the front-end client layer?
A. Bottom Tier
B. Middle Tier
C. Top Tier
D. All of the above
View Answer
Ans : C
Explanation: Top Tier : This tier is the front-end client layer. This layer holds the query tools and reporting tools, analysis tools and data mining tools.
3. ____________ collects all the information and the subjects spanning an entire organization.
A. Data Mart
B. Enterprise Warehouse
C. Virtual Warehouse
D. data warehouse view
View Answer
Ans : B
Explanation: An enterprise warehouse collects all the information and the subjects spanning an entire organization.It provides us enterprise-wide data integration.
4. ____________ is responsible for directing the queries to the suitable tables.
A. Warehouse Manager
B. Load Manager
C. Fast Load
D. Query Manager
View Answer
Ans : D
Explanation: Query manager is responsible for directing the queries to the suitable tables
5. A warehouse Manager also analyzes query profiles to determine index and aggregations are appropriate.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, A warehouse Manager also analyzes query profiles to determine index and aggregations are appropriate.
6. Which view allows the selection of relevant information needed for a data warehouse?
A. data source view
B. top-down view
C. data warehouse view
D. business query view
View Answer
Ans : B
Explanation: top-down view : This view allows the selection of relevant information needed for a data warehouse.
7. Which of the following is true about business query view?
A. This view presents the information being captured, stored, and managed by the operational system
B. This view includes the fact tables and dimension tables. It represents the information stored inside the data warehouse
C. It is the view of the data from the viewpoint of the end-user.
D. None of the above
View Answer
Ans : C
Explanation: The business query view : It is the view of the data from the viewpoint of the end-user.
8. Data mart contains a subset of organization-wide data.
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: True, Data mart contains a subset of organization-wide data. This subset of data is valuable to specific groups of an organization.
9. Data marts are ________ in size
A. large
B. medium
C. small
D. very large
View Answer
Ans : C
Explanation: Data marts are small in size
10. The view over an operational data warehouse is known as a virtual warehouse.
A. Yes
B. No
C. Can be yes or no
D. Can not say
View Answer
Ans : A
Explanation: Yes, The view over an operational data warehouse is known as a virtual warehouse.
Discussion