Apply Industry-Standard Data Modeling Techniques, Such as Star, Snowflake, and Data Vault Schemas, to Analytical Workloads. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   What does the 'grain' of a fact table refer to?

   • AThe total number of rows in the fact table.
   • BThe number of foreign keys in the fact table.
   • CThe level of detail at which the measures are recorded.
   • DThe type of measures stored, such as additive or non-additive.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which statement accurately describes a snowflake schema?

   • AA schema that uses hubs, links, and satellites to store historical data.
   • BA schema that stores all data in a single wide table for maximum query performance.
   • CA schema where all dimension tables are denormalized and directly joined to the fact table.
   • DA schema where dimension tables are normalized into multiple related tables.
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which schema is most flexible for adapting to changing business requirements and new data sources?

   • AStar schema
   • BData vault schema
   • CAll schemas are equally flexible.
   • DSnowflake schema
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is a best practice for maintaining analytical tables in Databricks SQL?

   • AStoring all tables as external tables to avoid managed table overhead.
   • BRegularly running OPTIMIZE to compact small files.
   • CDeleting old data frequently to keep tables small.
   • DAvoiding the use of Z-ORDER to reduce complexity.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which of the following is an example of a dimension table attribute?

   • AOrder line number
   • BProduct category
   • CQuantity sold
   • DSales amount
   Reveal Solution Discussion Select an answer first