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 84 discussion

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

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

  • A. True
  • B. False
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
blazingliverbird
Highly Voted 2 years, 10 months ago
Selected Answer: A
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
upvoted 7 times
...
Mallikharjuna452
Most Recent 4 months ago
Yes,It is True
upvoted 1 times
...
pranalig
5 months ago
correct answer:A
upvoted 1 times
...
Gavin1272
8 months, 2 weeks ago
Selected Answer: A
Metadata queries can be done as metadata is stored in the services layer and does not require the compute layer to spin up a vm to access the storage layer.
upvoted 1 times
...
MahDeep
1 year, 2 months ago
Since Metadata cache and the Query Result cache are part of the Cloud Services Layer, they can run without the need of an active virtual warehouse
upvoted 1 times
...
Mayuri917233
1 year, 6 months ago
Selected Answer: B
B is correct
upvoted 1 times
...
isolated_sniper
1 year, 6 months ago
Answer is A.
upvoted 4 times
...
avijit1982
1 year, 7 months ago
Sorry, just tested it. It is A.
upvoted 3 times
...
avijit1982
1 year, 7 months ago
Selected Answer: B
Actually, I think one needs active datawarehouse to run the query but it would not use it.
upvoted 1 times
...
alanhuangjob
1 year, 7 months ago
There is metadata cache in the service layer, so answer A is correct.
upvoted 1 times
...
KarBiswa
1 year, 9 months ago
Selected Answer: A
Count min does not require
upvoted 2 times
...
12hj
1 year, 10 months ago
Answer - B, because metadata has no cache.
upvoted 1 times
...
Chandra720
1 year, 11 months ago
If there is no change in query then it will fetch from metadata cache I.e from cloud service layer.
upvoted 1 times
...
Tapasgup007
1 year, 11 months ago
Selected Answer: A
A is correct
upvoted 2 times
...
jveag
2 years, 2 months ago
Selected Answer: A
should be A
upvoted 2 times
...
viratang
2 years, 4 months ago
Selected Answer: A
Below query doesn't need an active warehouse to run for a seond time. SELECT COUNT(*) FROM "SNOWFLAKE_SAMPLE_DATA"."TPCH_SF1"."CUSTOMER";
upvoted 2 times
...
BungyTex
2 years, 5 months ago
Selected Answer: A
its A as metadata has aggregate data already
upvoted 2 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 ...