SnowPro Associate: Platform Question 173
Single answer○ EXCLUDEA data engineering team is cleaning up old training materials for new Snowflake users. One slide states that users should configure and rely on the feature named "EXCLUDE" to control data access in Snowflake. A senior engineer reviews the slide and wants to correct it before onboarding begins. Which response is the most accurate?
- A
"EXCLUDE" is not a Snowflake platform feature that administrators configure for security or object management, so the training content should be corrected to reference actual Snowflake capabilities instead.
- B
"EXCLUDE" is the Snowflake feature used to prevent roles from inheriting privileges from parent roles.
- C
"EXCLUDE" is a warehouse setting that removes selected queries from billing calculations.
- D
"EXCLUDE" is a masking policy parameter used to omit columns from query results without changing SQL.
Show answer and explanation
Correct answer: A
Explanation
This question tests whether the candidate can distinguish valid Snowflake platform capabilities from nonexistent terminology in a practical review scenario. For the SnowPro Associate exam, it is important to recognize actual Snowflake features and not assume a named feature exists without validation. Snowflake documentation covers real governance and security mechanisms such as role-based access control, masking policies, row access policies, secure views, network policies, virtual warehouses, and resource monitors. If training content references "EXCLUDE" as a standalone platform feature, that content should be corrected because it does not represent a documented Snowflake capability in the way described here. A best practice is to verify feature names and behavior against official Snowflake documentation before using them in operational guidance or certification prep.
- A. Correct.
Correct. There is no core Snowflake platform feature named "EXCLUDE" that administrators configure for security, object management, or warehouse behavior in the way described. In a real onboarding scenario, the right action is to remove or replace the inaccurate term with valid Snowflake concepts such as role-based access control, masking policies, row access policies, secure views, warehouses, or SQL syntax that actually exists in Snowflake.
- B. Incorrect.
Incorrect. Snowflake role hierarchy supports privilege inheritance through granted roles, but there is no platform feature named "EXCLUDE" for turning off inheritance in this manner. Someone might choose this option if they confuse Snowflake RBAC concepts with access-control terminology from other systems.
- C. Incorrect.
Incorrect. Snowflake warehouse billing is based on warehouse usage and credit consumption rules, not on an "EXCLUDE" warehouse setting that omits queries from billing. This distractor is plausible because cost-control features do exist in Snowflake, such as auto-suspend and resource monitors, but this specific capability does not.
- D. Incorrect.
Incorrect. Snowflake supports masking policies to protect sensitive data, but there is no masking policy parameter named "EXCLUDE" that automatically removes columns from query results. Users might confuse dynamic data masking with projection behavior in SQL or with features from other database platforms.