A data architect is designing a data model for a large retail chain. The model will be used for both operational reporting and analytical queries. The architect needs to balance query performance with data integrity and update efficiency. Which design consideration is most important to address first?

Choosing between a star and snowflake schema

Deciding whether to use views or materialized views

Deciding on the grain of the fact tables

Selecting the appropriate slowly changing dimension strategy

A data modeler is designing a fact table for a retail company. The fact table will store daily sales by store and product. The modeler needs to decide whether to include a surrogate key for each row or use a composite natural key. Which consideration is most important when making this decision?

The natural key is required for foreign key relationships

The natural key is easier for business users to understand

The surrogate key ensures uniqueness even if natural keys change

The surrogate key reduces storage space

In a Type 2 slowly changing dimension, how is a change to a dimension attribute handled?

The change is ignored, and the original value is kept forever

The change is stored in a separate history table, and the main row is updated

The existing row is updated with the new value, losing the old value

A new row is added with the new value, and the old row is marked as inactive with effective dates

Snowflake SnowPro Advanced:Data Analyst

Domain 3Objective 2

Design and Use Data Models SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 4)

Part of the Data Transformation and Data Modeling domain, which accounts for 23% of the SNOWPRO-ADVANCED-DATA-ANALYST exam.

24questions here

5free pages

6concepts

23%of the exam

Questions 16–20

16foundation · easy
In Snowflake, which object is used to logically group tables, views, and other objects within a database?
Select an answer first
17application · medium
A data architect is designing a data model for a large retail chain. The model will be used for both operational reporting and analytical queries. The architect needs to balance query performance with data integrity and update efficiency. Which design consideration is most important to address first?
Select an answer first
18foundation · easy
Which slowly changing dimension type overwrites the old attribute value with the new value, losing historical information?
Select an answer first
19application · medium
A data modeler is designing a fact table for a retail company. The fact table will store daily sales by store and product. The modeler needs to decide whether to include a surrogate key for each row or use a composite natural key. Which consideration is most important when making this decision?
Select an answer first
20foundation · easy
In a Type 2 slowly changing dimension, how is a change to a dimension attribute handled?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-ANALYST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-ANALYST” is a trademark of its owner, used for identification only.

Design and Use Data Models SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 4)

Questions 16–20

In Snowflake, which object is used to logically group tables, views, and other objects within a database?

Which slowly changing dimension type overwrites the old attribute value with the new value, losing historical information?

A data modeler is designing a fact table for a retail company. The fact table will store daily sales by store and product. The modeler needs to decide whether to include a surrogate key for each row or use a composite natural key. Which consideration is most important when making this decision?

In a Type 2 slowly changing dimension, how is a change to a dimension attribute handled?

Keep studying — Data Transformation and Data Modeling