Design Data Models and Storage Strategies ARA-C01 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What is the primary purpose of defining a clustering key on a large Snowflake table?

   • ATo improve query performance by increasing micro-partition pruning
   • BTo replicate the table to other accounts
   • CTo enforce uniqueness of rows in the table
   • DTo automatically compress the data in the table
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A retail analytics team stores daily sales fact rows in a Snowflake table. Their most common query filters on `store_id` and `sale_date`, and they frequently aggregate sales by `product_id`. The table currently has no explicit clustering key. Query performance on large date ranges has degraded as the table grows. Which design change would most directly improve pruning for the dominant query pattern?

   • ADefine a composite clustering key on (`store_id`, `sale_date`).
   • BDefine a clustering key on `sale_date` only, because date is the most selective filter.
   • CRecreate the table with `ORDER BY store_id, sale_date` in the CTAS statement.
   • DDefine a clustering key on (`product_id`, `sale_date`).
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A Snowflake table has a clustering key on `event_date`. The table is loaded with data from multiple sources throughout the day, and the data for each source is inserted in large batches. Queries that filter on `event_date` and `source_id` are slow. The clustering depth is high. Which action would most effectively improve query performance?

   • ARun `ALTER TABLE ... CLUSTER BY` manually after each load.
   • BChange the clustering key to (`source_id`, `event_date`).
   • CUse a larger warehouse for the queries.
   • DRecreate the table with `ORDER BY event_date, source_id` using CTAS.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   In Snowflake, what is a micro-partition?

   • AA small virtual warehouse used for testing
   • BA logical grouping of tables in a database
   • CA type of clustering key
   • DA contiguous unit of storage that contains a subset of a table's rows
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the purpose of database replication in Snowflake?

   • ATo automatically optimize query performance
   • BTo provide a read-only copy of data to external partners
   • CTo enforce data retention policies
   • DTo create a physical copy of a database in another account or region for disaster recovery and global access
   Reveal Solution Discussion Select an answer first