exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 349 discussion

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

What data is stored in the Snowflake storage layer? (Choose two.)

  • A. Snowflake parameters
  • B. Micro-partitions
  • C. Query history
  • D. Persisted query results
  • E. Standard and secure view results
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
EmiB
Highly Voted 1 year, 3 months ago
Selected Answer: BC
B. Micro-partitions C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)
upvoted 7 times
...
levisn1
Most Recent 3 days, 8 hours ago
Selected Answer: BC
I think is B and C - in the documentation when it uses the word persisted it talks about 24h period of retention, which is the result set retention time living in the service cloud layer. So i don't think D is correct. https://docs.snowflake.com/en/user-guide/querying-persisted-results
upvoted 1 times
...
0e504b5
4 months, 2 weeks ago
Selected Answer: BC
Service Layer: Which accepts SQL requests from users, coordinates queries, managing transactions and results. Logically, this can be assumed to hold the result cache – a cached copy of the results of every query executed. https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform D cannot be right because the services layer stores cache, not the the storage layer
upvoted 2 times
...
ganeshra
6 months ago
B & D. https://www.snowflake.com/data-cloud-glossary/data-storage/
upvoted 1 times
...
[Removed]
7 months, 3 weeks ago
Selected Answer: BC
D talks about result cache and E all query results go to result cache. Result cache is CSL so B and C
upvoted 1 times
...
SamuelZhang
9 months, 2 weeks ago
Selected Answer: BC
B. Micro-partitions C. Query history
upvoted 1 times
...
singhks
10 months ago
Selected Answer: BC
B and C are correct
upvoted 1 times
...
MultiCloudIronMan
11 months ago
Selected Answer: BE
Correct
upvoted 1 times
...
vini15
1 year, 1 month ago
should be BC. cannot be E as non-materialised view results are not stored.
upvoted 1 times
...
Kvk117
1 year, 2 months ago
Selected Answer: BE
Verified
upvoted 1 times
...
AS314
1 year, 5 months ago
Selected Answer: BE
https://docs.snowflake.com/en/user-guide/querying-persisted-results.html Persisted here means cached, so Persisted Query Results is the query result cache which is in the cloud service layer, not storage layer
upvoted 3 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago