Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 12 Topic 2 Discussion

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 12 Topic 2 Discussion

ADA-C02 Exam Topic 2 Question 12 Discussion:
Question #: 12
Topic #: 2

A sales team at an organization runs the following Snowflake query several times each day:

ADA-C02 Question 12

What can the Snowflake Administrator do to optimize use of persisted query results whenever possible?


A.

Wrap the query in a User-Defined Function (UDF) to match syntax execution.


B.

Assign everyone on the sales team to the same virtual warehouse.


C.

Assign everyone on the sales team to the same security role.


D.

Leverage the CURRENT_DATE function for date calculations.


Get Premium ADA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.