Exam DAA-C01 Topic 1 Question 80 Discussion

Actual exam question for Snowflake's DAA-C01 exam
Question #: 80
Topic #: 1

Consider a scenario where you have a table 'CUSTOMER ORDERS' with columns 'CUSTOMER ID', 'ORDER DATE' , 'ORDER TOTAL' , and 'PRODUCT CATEGORY'. You want to create a materialized view that calculates the sum of order totals for each customer, grouped by product category, and refreshed automatically on a daily basis. However, you are also concerned about minimizing the cost of materialized view maintenance. Which of the following strategies would be MOST cost-effective while still providing reasonably up-to-date data?

A. Create a materialized view without specifying a refresh schedule, and manually refresh it whenever the report is run. B. Create a materialized view and set the refresh schedule to 'ON CHANGE'. C. Create a materialized view and set the refresh schedule to 'ON CHANGE' with a clustering key on D. Create a materialized view and schedule a daily refresh at a time of low system activity. E. Create a standard view with the same aggregation logic and optimize the underlying table using clustering.

Suggested Answer: D Vote an answer

Scheduling a daily refresh allows the materialized view to be updated regularly without incurring the overhead of 'ON CHANGE' refreshes, which can be very costly if the underlying table is frequently updated. Manual refreshes would not provide up-to-date data automatically. 'ON CHANGE' without further optimization can be extremely expensive. A standard view wouldn't provide the performance benefits of a materialized view. Clustering on CUSTOMER ID might improve performance but would not address the refresh cost directly.

by Debby at Jul 26, 2025, 04:11 PM

Limited Time Offer

15%

Off

Get Premium DAA-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business