Exam SnowPro Core topic 1 question 1335 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1335
Topic #: 1

[All SnowPro Core Questions]

Which type of query would benefit from enabling the query acceleration service on the virtual warehouse?

A. Queries with no filters or aggregation
B. Queries that are queued in the warehouse
C. Queries that use more resources than the typical query
D. Queries that contain a high cardinality GROUP BY expression

Show Suggested Answer

Suggested Answer: C 🗳️

by MultiCloudIronMan at Jan. 11, 2025, 3:58 p.m.

Comments

Submit Cancel

ArunRav

1 month ago

Selected Answer: C

https://docs.snowflake.com/en/user-guide/query-acceleration-service The query acceleration service (QAS) can accelerate parts of the query workload in a warehouse. When it is enabled for a warehouse, it can improve overall warehouse performance by reducing the impact of outlier queries, which are queries that use more resources than the typical query. The query acceleration service does this by offloading portions of the query processing work to shared compute resources that are provided by the service.

upvoted 1 times

...

37ceea2

5 months, 3 weeks ago

Selected Answer: C

It is not D. In docs.snowflake, there is exactly the text from Answer C. My answer is C

upvoted 4 times

2cb777b

5 months, 3 weeks ago

And the D answer is exactly one of the 4 types of queries not supported by QA

upvoted 1 times

...