Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Go to 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

Suggested Answer: A 🗳️

by blazingliverbird at Jan. 3, 2022, 11:15 p.m.

Comments

Submit Cancel

blazingliverbird

Highly Voted 3 years, 4 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 10 months, 2 weeks ago

Yes,It is True

upvoted 1 times

...

pranalig

11 months, 2 weeks ago

correct answer:A

upvoted 1 times

...

Gavin1272

1 year, 2 months 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, 8 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

2 years ago

Selected Answer: B

B is correct

upvoted 1 times

...

isolated_sniper

2 years, 1 month ago

Answer is A.

upvoted 4 times

...

avijit1982

2 years, 1 month ago

Sorry, just tested it. It is A.

upvoted 3 times

...

avijit1982

2 years, 1 month 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

2 years, 1 month ago

There is metadata cache in the service layer, so answer A is correct.

upvoted 1 times

...

KarBiswa

2 years, 3 months ago

Selected Answer: A

Count min does not require

upvoted 2 times

...

12hj

2 years, 4 months ago

Answer - B, because metadata has no cache.

upvoted 1 times

...

Chandra720

2 years, 5 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

2 years, 5 months ago

Selected Answer: A

A is correct

upvoted 2 times

...

jveag

2 years, 8 months ago

Selected Answer: A

should be A

upvoted 2 times

...

viratang

2 years, 11 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, 11 months ago

Selected Answer: A

its A as metadata has aggregate data already

upvoted 2 times

...

Load full discussion...