CDP Data Warehousing and Business Intelligence 2

Question 1

What is 'conformed dimensions' in data warehousing?

Accepted Answer

Dimensions that have identical definitions and content, shared across multiple fact tables or data marts

Answer

Dimensions that automatically resize based on data volume

Answer

Dimensions containing only current (non-historical) data

Answer

Dimensions stored in a separate database from fact tables

Question 2

What is the purpose of a staging area in a data warehouse ETL process?

Accepted Answer

To temporarily hold extracted source data before transformation and loading into the warehouse

Answer

To serve final reports to end users

Answer

To store the final dimensional model

Answer

To cache frequently-run queries

Question 3

Which BI concept refers to the ability to analyze data from multiple perspectives simultaneously?

Accepted Answer

Pivot / Cross-tab Analysis

Answer

Sequential Analysis

Answer

Regression Analysis

Answer

Longitudinal Analysis

Question 4

What is a Key Performance Indicator (KPI) in business intelligence?

Accepted Answer

A measurable value that demonstrates how effectively an organization is achieving key business objectives

Answer

A database index for high-performance queries

Answer

A type of ETL transformation rule

Answer

A report template in a BI tool

Question 5

What is 'slowly changing dimension Type 1' (SCD Type 1)?

Accepted Answer

Overwriting the old attribute value with the new value, losing historical data

Answer

Adding new rows for each change to track history

Answer

Creating a separate history table for changed attributes

Answer

Flagging changed records with an 'is_current' indicator

Question 6

What does ROLAP stand for in OLAP technology?

Accepted Answer

Relational OLAP — storing OLAP data in relational database tables rather than multidimensional cubes

Answer

Rapid OLAP

Answer

Remote OLAP

Answer

Replicated OLAP