SOL-C01 Question #89: Real Exam Question with Answer & Explanation

Question

You are working with a Snowflake environment where cost optimization is critical. You need to limit the amount of data scanned by a specific query executed by a user with the 'ANALYST role. Which of the following options represent valid methods to achieve this, considering both query- level and account- level settings?

Options

• ASet the parameter for the 'ANALYST role to a low value to reduce resource consumption and,
• BSet the `STATEMENT _ parameter for the 'ANALYST role to limit the execution time of queries,
• CSet the parameter for the database to a low value. Also, limit the number of columns selected
• DUse resource monitors to set credit quotas at the warehouse level. Enforce the usage of the 'LIMIT
• EImplement row-level security policies and data masking to reduce the amount of data visible to the

Explanation

Options B and D are the most effective and valid methods. Setting limits execution time, which indirectly reduces data scanned. Using 'LIMIT directly controls the number of rows processed. Resource monitors with credit quotas directly control warehouse usage, impacting the total cost. Option A incorrectly focuses on concurrency. Option C's ` affects historical data storage, not query data scanned. Limitng the number of columns does help but is not as direct, and does not touch any Snowflake governance features. Option E: Snowflake does not have parameter

No community discussion yet for this question.