Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 40 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 40
Topic #: 1
[All SnowPro Core Questions]

A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)

  • A. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
  • B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
  • C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
  • D. The ג€24 hourג€ timer on the precomputed results gets renewed every time the exact query is executed
Show Suggested Answer Hide Answer
Suggested Answer: BD 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
ggww
Highly Voted 2 years, 10 months ago
Selected Answer: BD
correct answer is B, D
upvoted 8 times
...
Mallikharjuna452
Most Recent 4 months ago
B and D
upvoted 1 times
...
_yyukta
9 months ago
Selected Answer: BD
B and D are correct
upvoted 1 times
...
444823b
11 months, 1 week ago
Selected Answer: BD
esas son las correctas b y d
upvoted 1 times
...
rich922
1 year, 5 months ago
BD I think, but bad wording on B: "previous" 24 hours would mean before the original query was run, so taken literally this is incorrect but I think they mean the next 24 hours.
upvoted 1 times
...
Mayuri917233
1 year, 6 months ago
Selected Answer: D
correct answer is B, D
upvoted 1 times
...
SV1122
1 year, 10 months ago
Selected Answer: BD
BD Explanation for D is here https://docs.snowflake.com/en/user-guide/querying-persisted-results.html
upvoted 3 times
...
Tapasgup007
1 year, 11 months ago
Selected Answer: BD
BD are correct
upvoted 1 times
...
Graghu
2 years, 6 months ago
BD is the correct answer
upvoted 2 times
...
Sly007
2 years, 6 months ago
Selected Answer: BD
BD for sure
upvoted 3 times
...
MinuteMaid
2 years, 8 months ago
Selected Answer: BD
Obviously it is B,D by MinuteMaid
upvoted 1 times
...
Fosterchild123
2 years, 8 months ago
Selected Answer: BD
The results cache will only be used if it's the same query AND the same role executing the query
upvoted 1 times
...
Anirudh2020
2 years, 9 months ago
B and D are correct
upvoted 1 times
...
Rajokkiyam
2 years, 9 months ago
answer BD
upvoted 1 times
...
Katewad_4465
2 years, 9 months ago
Answer is B,D.
upvoted 1 times
...
StrStudy
2 years, 9 months ago
Selected Answer: BD
correct answer is B, D
upvoted 1 times
...
Sid460545
2 years, 9 months ago
option B, D
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...