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

Conformed dimensions share identical definitions, keys, and hierarchies across multiple fact tables or data marts, enabling consistent cross-subject-area analysis.

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

The staging area is a temporary storage zone where raw extracted data is held and processed before being transformed and loaded into the permanent data warehouse tables.

Question 3

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

Accepted Answer

Pivot / Cross-tab Analysis

Answer

Pivot or cross-tabulation analysis allows users to analyze data from multiple dimensions simultaneously, rotating the view to see measures from different perspectives.

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

KPIs are quantifiable measurements that evaluate the success of an organization in meeting its strategic objectives, such as revenue growth or customer satisfaction scores.

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

SCD Type 1 simply overwrites the old attribute value with the new value, keeping only the current state and losing the history of previous values.

CDP - Certified Data Professional Practice Test

CDP - Certified Data Professional Practice Test

CDP Data Warehousing and Business Intelligence 2