DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ6

VerifiedOfficial exam objectives/topics

A Data Engineer executed the following command:

ALTER WAREHOUSE my_wh SET -  
ENABLE_QUERY_ACCELERATION = true  
QUERY_ACCELERATION_MAX_SCALE_FACTOR

The warehouse is now using more credits than anticipated. What might be causing this, and which action would lower credit consumption?

Explanation

Snowflake Query Acceleration Service consumes separately billed serverless-compute credits. A scale factor of 0 removes the upper bound on the compute resources eligible queries can lease, so they can use as many available resources as needed. Setting a nonzero maximum scale factor limits that consumption and reduces potential credit usage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!