Snowflake
ADA-C01 · Question #87
ADA-C01 Question #87: Real Exam Question with Answer & Explanation
Sign in or unlock ADA-C01 to reveal the answer and full explanation for question #87. The question stem and answer options stay visible for context.
Question
An organization's sales team leverages this Snowflake query a few times a day: SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO FROM CUSTOMERS WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7); What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?
Options
- AWrap the query in a User-Defined Function (UDF) to match syntax execution.
- BAssign everyone on the sales team to the same virtual warehouse.
- CAssign everyone on the sales team to the same security role.
- DLeverage the CURRENT_DATE function for date calculations.
Unlock ADA-C01 to see the answer
You've previewed enough free ADA-C01 questions. Unlock ADA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.