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

Rima

4 months ago

Aha! I've got this one. The answer is clearly C) 14 days. Why? Because 12 hours is just too short, and 31 days is way too long. 14 days is the Goldilocks of result cache durations - not too hot, not too cold, just right!

upvoted 0 times

Avery

2 months ago

C: Actually, I agree with the user comment, C) 14 days seems like the best option.

upvoted 0 times

...

Roxanne

3 months ago

B: No way, it has to be D) 31 days.

upvoted 0 times

...

Glendora

3 months ago

A: I think the answer is A) 12 hours.

upvoted 0 times

...

Zana

4 months 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

4 months 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

Jin

2 months ago

D) 31 days

upvoted 0 times

...

Belen

2 months ago

C) 14 days

upvoted 0 times

...

Stephane

3 months ago

B) 24 hours

upvoted 0 times

...

Theodora

3 months ago

A) 12 hours

upvoted 0 times

...

Wilda

4 months 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

4 months 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