Size Warehouses and Use Query Pruning DEA-C02 Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   What is the primary purpose of a multi-cluster warehouse in Snowflake?

   • ATo allow multiple warehouses to share the same compute resources.
   • BTo provide high availability by replicating data across multiple clusters.
   • CTo scale out compute resources to handle concurrent workloads by adding more clusters.
   • DTo increase the storage capacity available for the warehouse.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which type of metadata does Snowflake use to prune micro-partitions during query execution?

   • AThe number of rows in each micro-partition.
   • BThe compression ratio of each micro-partition.
   • CThe creation timestamp of each micro-partition.
   • DThe minimum and maximum values for columns in each micro-partition.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   How does a clustering key improve query pruning in Snowflake?

   • AIt stores the clustering key columns in a separate metadata store for faster access.
   • BIt increases the number of micro-partitions, providing more granular metadata.
   • CIt organizes data in micro-partitions so that partitions have narrower value ranges for the key columns.
   • DIt compresses the data in each micro-partition, reducing storage and I/O.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which statement accurately describes how warehouse size affects query performance in Snowflake?

   • ALarger warehouses reduce the number of credits consumed per query because queries finish faster.
   • BLarger warehouses provide more compute resources, which can improve performance for queries that can use parallelism.
   • CLarger warehouses always reduce query latency for every query, regardless of the query's complexity.
   • DLarger warehouses increase the amount of data that can be stored in the warehouse.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which Snowflake feature provides detailed information about query execution, including the amount of data scanned and pruning efficiency?

   • AWarehouse Usage History
   • BAccount Usage Views
   • CInformation Schema
   • DQuery Profile
   Reveal Solution Discussion Select an answer first