Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DEA-C01 Topic 1 Question 9 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 9
Topic #: 1
[All DEA-C01 Questions]

A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.

---will Snowflake use the persisted query results from the result cache provided that the underlying data has not changed^

Show Suggested Answer Hide Answer
Suggested Answer: B

External functions must be scalar functions. A scalar external function returns a single value for each input row.


by Cammy at Aug 09, 2023, 07:00 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Timothy
1 days ago
I think the answer is A) 12 hours. The question states that the dashboard issues the same SQL select clause every 12 hours, so Snowflake should use the persisted query results from the result cache for up to 12 hours.
upvoted 0 times
...
Mabel
3 days ago
I'm not sure, but I think Snowflake will use the persisted query results for 14 days.
upvoted 0 times
...
Kip
10 days ago
I believe Snowflake will use the persisted query results for 31 days.
upvoted 0 times
...
Lavera
15 days ago
I think Snowflake will use the persisted query results for 24 hours.
upvoted 0 times
...

Save Cancel