Exit DEA-C01 SnowPro Advanced: Data Engineer Certification (DEA-C01)
Question 4 of 5
0% complete
Q4 Single choice

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?

  • A

    increase the size of the virtual warehouse.

  • B

    Increase the number of clusters in the virtual warehouse

  • C

    Implement the search optimization service on the table

  • D

    Add a date column as a cluster key on the table

Previous Next