Question 40
For this Snowflake situation — A trainee claims that adding warehouse compute nodes is the only way to increase the durable size of a Snowflake table. — the team adopts: Choose storage capacity planning and table lifecycle controls separately from warehouse resizing. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Review storage and compute cost categories independently in capacity reports. It controls the recurring exposure associated with this mechanism: Durable managed table storage scales independently of the virtual warehouse compute used to process queries. The original action, choose storage capacity planning and table lifecycle controls separately from warehouse resizing., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: Snowflake's shared data layer permits multiple compute clusters to access one logical dataset. Here the sustained control must address: Durable managed table storage scales independently of the virtual warehouse compute used to process queries. Choose “Review storage and compute cost categories independently in capacity reports”.
That safeguard is relevant to: Hybrid tables have transaction-oriented characteristics distinct from conventional analytic tables. The current failure instead follows from: Durable managed table storage scales independently of the virtual warehouse compute used to process queries. Its prevention measure is “Review storage and compute cost categories independently in capacity reports”.
This routine guards against another mechanism: Transient tables avoid Fail-safe storage and have different recovery characteristics from permanent tables. The recurring exposure in the current case is: Durable managed table storage scales independently of the virtual warehouse compute used to process queries. The matching preventive check is “Review storage and compute cost categories independently in capacity reports”.