Question 290
An internal team regularly leaves a large warehouse active after the final scheduled transform finishes. The proposed response is: Tune the warehouse's auto-suspend setting and validate idle-period compute charges. Which limitation or trade-off should the team acknowledge?
Explanation
Correct Answer
Setting auto-suspend too aggressively can create restart churn during frequent short jobs. It qualifies the proposed action: tune the warehouse's auto-suspend setting and validate idle-period compute charges.
Incorrect Answers
Row access is not an automatic replacement for masking sensitive columns within visible rows. This is a trade-off for the separate proposal: apply a row access policy to the protected table or view. The proposed choice instead requires acknowledging this risk: setting auto-suspend too aggressively can create restart churn during frequent short jobs.
An object owner in a managed access schema cannot independently grant access to its objects. This is a trade-off for the separate proposal: use the object owner's discretionary grant authority, subject to Snowflake privilege rules. The proposed choice instead requires acknowledging this risk: setting auto-suspend too aggressively can create restart churn during frequent short jobs.
Managed access changes who manages grants, not whether ordinary SELECT and USAGE privileges are required. This is a trade-off for the separate proposal: use a managed access schema and perform grants through its owner or a role with MANAGE GRANTS. The proposed choice instead requires acknowledging this risk: setting auto-suspend too aggressively can create restart churn during frequent short jobs.





SnowPro Core COF-C03 Practice Tests