CDO Information Architecture & Strategy 5

Question 1

In Kimball dimensional modeling, what does the 'grain' of a fact table define?

Accepted Answer

Exactly what a single fact row represents

Answer

Declaring the grain, such as one row per order line, is the critical first step in designing a fact table.

Question 2

A dimension that keeps full history by adding a new row with effective dates whenever an attribute changes is which slowly changing dimension type?

Accepted Answer

Type 2

Answer

SCD Type 2 adds versioned rows, whereas Type 1 overwrites values and Type 3 keeps limited prior values in extra columns.

Question 3

What is the main purpose of an architecture review board (ARB) in a data strategy?

Accepted Answer

To ensure solutions align with target architecture, standards, and principles, and to manage exceptions

Answer

An ARB governs design decisions against agreed principles and standards, which reduces fragmentation and technical debt.

Question 4

Which statement best captures the difference between a data strategy and a data architecture?

Accepted Answer

Strategy defines the why and what (goals, priorities, operating model), while architecture defines how data is structured, integrated, and delivered

Answer

The data strategy sets direction and value, and the architecture is the blueprint that carries it out.

Question 5

An organization wants to query data across several source systems in real time without copying it into a central store. Which approach fits best?

Accepted Answer

Data virtualization

Answer

Data virtualization gives a unified logical view by querying sources in place, without physically moving the data.

CDO - Chief Data Officer Certification Practice Test