A large table with 200 columns contains two years of historical data.

Snowflake DEA-C01 Question Answer

A large table with 200 columns contains two years of historical data. When queried. the table is filtered on a single day Below is the Query Profile:

Using a size 2XL virtual warehouse, this query look over an hour to complete

What will improve the query performance the MOST?

increase the size of the virtual warehouse.

Increase the number of clusters in the virtual warehouse

Implement the search optimization service on the table

Add a date column as a cluster key on the table

DEA-C01 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"