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

Questions 11–15

1. 11foundation · easy

   Which data model type is characterized by the use of hub, link, and satellite tables to track the history of business keys and their relationships?

   • AEntity-relationship model
   • BData vault model
   • CDimensional model
   • DRelational model
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What is the primary purpose of a dimension table in a dimensional model?

   • ATo store transactional-level numeric measures
   • BTo enforce referential integrity between all tables
   • CTo provide descriptive context and attributes for the facts
   • DTo store raw source data before transformation
   Reveal Solution Discussion Select an answer first
4. 13expert · hard

   A data team is implementing a dimensional model in Snowflake. They have a fact table that is frequently queried with filters on multiple columns, including date, store, and product. The table is large, and query performance is degrading. The team is considering using clustering keys. Which approach should they take?

   • ADefine a single clustering key on the date column
   • BCreate separate materialized views for each filter combination
   • CDo not use clustering keys; rely on automatic micro-partition pruning
   • DDefine clustering keys on date, store, and product in that order
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In a dimensional model, which table contains the quantitative measures that can be aggregated, such as sales amount or quantity sold?

   • ADimension table
   • BBridge table
   • CStaging table
   • DFact table
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which design approach reduces data redundancy by splitting tables into smaller, related tables, but can increase the number of joins needed for queries?

   • ANormalization
   • BClustering
   • CPartitioning
   • DDenormalization
   Reveal Solution Discussion Select an answer first