Snowflake Exam DEA-C01 Topic 1 Question 9 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 9
Topic #: 1

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^

A12 hours

B24 hours

C14 days

D31 days

Show Suggested 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

Zana

2 hours ago

A) 12 hours is the obvious answer here. If the question specifically mentions 12 hours, then that's gotta be the correct one. Although, I do wonder... does Snowflake have a 'snooze' feature for the result cache? Like, 'Hey, I'm feeling a little lazy today, so let's just keep these results for another 12 hours, mkay?'

upvoted 0 times

...

Wayne

3 days ago

Hmm, I'm not too sure about this one. B) 24 hours sounds like a reasonable guess, but I could be totally off. Maybe I should have paid more attention in my Snowflake training sessions.

upvoted 0 times

...

Wilda

5 days ago

I'm going with D) 31 days. Surely Snowflake's result cache can hold onto those query results for much longer than just 12 hours, right? I mean, how often does the underlying data really change, anyway?

upvoted 0 times

...

Timothy

10 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

...