Nam.vu 2

Question 1

A fact table in dimensional modeling records events or states at a declared grain.

Accepted Answer

o

Question 2

Dimension tables contain measures like quantity and amount.

Accepted Answer

x

Question 3

The grain of a fact table should be defined after modeling.

Accepted Answer

x

Question 4

Conformed dimensions are dimensions that are shared and standardized across multiple fact tables.

Accepted Answer

o

Question 5

Role-playing allows a single dimension to be used with different meanings in a fact table.

Accepted Answer

o

Question 6

A star schema has normalized dimensions that are broken down into sub-dimensions.

Accepted Answer

x

Question 7

Star schemas generally involve fewer joins, making queries simpler and faster.

Accepted Answer

o

Question 8

Snowflake schemas are always preferred over star schemas for better performance.

Accepted Answer

x

Question 9

Transaction fact tables are used to capture the state of something at a specific point in time.

Accepted Answer

x

Question 10

A periodic snapshot fact table tracks the state of a business process over time.

Accepted Answer

o

Question 11

Accumulating snapshot fact tables are used to track the lifecycle of a business process with multiple milestones.

Accepted Answer

o

Question 12

Dimension tables should use natural keys from the source system as their primary keys.

Accepted Answer

x

Question 13

The `dim_date` table typically contains attributes like day of the week, month, and year.

Accepted Answer

o

Question 14

SCD Type 1 involves adding a new row for every change to a dimension attribute.

Accepted Answer

x

Question 15

SCD Type 2 tracks history by creating new rows for each change and marking the old rows as inactive.

Accepted Answer

o

Question 16

SCD Type 3 stores the current and previous values of an attribute in the same row.

Accepted Answer

o

Question 17

SCD Type 1 is best used when you need to track the complete history of an attribute.

Accepted Answer

x

Question 18

SCD Type 2 is recommended for tracking changes to attributes that are important for 'as-was' analysis.

Accepted Answer

o

Question 19

SCD Type 3 is ideal for tracking many historical versions of an attribute.

Accepted Answer

x

Question 20

Surrogate keys are typically large, complex natural keys from the source system.

Accepted Answer

x