Practice Library

All MCQs

Browse exam-wise, subject-wise, and country-wise MCQs with explanations.

Data Warehousing and Business IntelligenceMedium

What is the main risk of building independent data marts without shared standards?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceHard

Which description best matches an Inmon-style hub-and-spoke architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceHard

What is the central idea of the Kimball data warehouse bus architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

Why is a staging area used in warehouse architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What belongs primarily to the top tier of a DW architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What is the main responsibility of the middle tier in a three-tier DW architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What is the primary responsibility of the bottom tier in a DW architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What are the usual layers in a three-tier data warehouse architecture?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

What is the goal of capacity planning for a growing data warehouse?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

Why should designers characterize expected warehouse workloads?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

Which documentation most directly helps maintain an ETL process after its original developer leaves?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceHard

What is the purpose of release management in a DW environment?

Choose an option to check your answer.