SOL-C01 Question #92: Real Exam Question with Answer & Explanation

Question

A Snowflake administrator observes slow query performance when querying data loaded from a large set of compressed CSV files stored in an external stage (AWS S3). Which of the following actions, performed in conjunction, would MOST likely improve query performance? (Choose TWO)

Options

• AIncrease the virtual warehouse size used for querying.
• BCreate a materialized view that pre-aggregates the data from the CSV files.
• CConfigure the external stage to use the IAM role.
• DCreate a file format object that specifies the compression type used in the CSV files.
• EPartition the data in S3 based on a commonly used filter column and update the stage definition to

Explanation

Increasing the virtual warehouse size (A) provides more compute resources for query execution, especially when dealing with large datasets. Defining the file format (D) with the correct compression type allows Snowflake to efficiently decompress the data during the read operation. Materialized views (B) help but might not be appropriate for all query patterns. (C) is a security risk and doesn't directly impact performance. While partitioning data can help, this requires manually altering the file storage in S3 outside of Snowflake's control.

No community discussion yet for this question.