Practice Library

All MCQs

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

Data Warehousing and Business IntelligenceMedium

An order number is stored in a fact table for drill-through but has no separate descriptive table. What is it?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

Which measure is typically semi-additive?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

Which measure is fully additive across product, store, and time dimensions?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

A sales fact row represents one product on one customer order line. What has been defined?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What is the primary role of a dimension table?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What does a fact table primarily store in a dimensional model?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What is the primary goal of high-availability architecture for a warehouse platform?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

A warehouse has reached the limits of one server. Which action represents scaling out rather than scaling up?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceMedium

What is the key idea of HOLAP?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

What distinguishes MOLAP storage?

Choose an option to check your answer.

Data Warehousing and Business IntelligenceEasy

In ROLAP, where are detailed and aggregated analytical data primarily stored?

Choose an option to check your answer.