Snowflake Exam DEA-C01 Topic 1 Question 19 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 19
Topic #: 1

A company built a sales reporting system with Python, connecting to Snowflake using the Python Connector. Based on the user's selections, the system generates the SQL queries needed to fetch the data for the report First it gets the customers that meet the given query parameters (on average 1000 customer records for each report run) and then it loops the customer records sequentially Inside that loop it runs the generated SQL clause for the current customer to get the detailed data for that customer number from the sales data table

When the Data Engineer tested the individual SQL clauses they were fast enough (1 second to get the customers 0 5 second to get the sales data for one customer) but the total runtime of the report is too long

How can this situation be improved?

AIncrease the size of the virtual warehouse

BIncrease the number of maximum clusters of the virtual warehouse

CDefine a clustering key for the sales data table

DRewrite the report to eliminate the use of the loop construct

Show Suggested Answer

Suggested Answer: D

This option is the best way to improve the situation, as using a loop construct to run SQL queries for each customer is very inefficient and slow. Instead, the report should be rewritten to use a single SQL query that joins the customer and sales data tables and applies the query parameters as filters. This way, the report can leverage Snowflake's parallel processing and optimization capabilities and reduce the network overhead and latency.

by Olive at Mar 17, 2024, 03:54 PM

Limited Time Offer

25%

7 months ago

I think rewriting the report to eliminate the loop construct could be a good solution.

upvoted 0 times

...