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


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


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


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


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


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


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


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


9. Data marts are ________ in size

A. large
B. medium
C. small
D. very large

View Answer


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





Discussion


* You must be logged in to add comment.