COF-C02 practice question 7 of 35
What is the minimum Snowflake edition required to use Dynamic Data Masking?
Full set: 778 questionsDynamic Data Masking is an advanced security feature in Snowflake that allows for the selective masking of plain-text data in table and view columns at query time. According to the official Snowflake documentation, this feature is not available in the Standard edition. It is introduced starting with the Enterprise Edition and is consequently available in all higher editions, including Business Critical and Virtual Private Snowflake (VPS). Therefore, Enterprise is the minimum edition required to implement and use Dynamic Data Masking policies.
A. Standard: The Standard edition provides core Snowflake functionality but lacks advanced security features like Dynamic Data Masking and Row-level Security.
C. Business Critical: While Business Critical edition includes Dynamic Data Masking, it is not the minimum edition required, as the feature is available in the less expensive Enterprise edition.
D. Virtual Private Snowflake (VPS): VPS is the highest-tier edition and includes all features of Business Critical, including Dynamic Data Masking, but it is not the minimum requirement.
1. Snowflake Documentation: Summary of Features by Edition.
Reference: In the table under the "Security and Data Protection" section
the row for "Dynamic Data Masking" is checked for Enterprise
Business Critical
and VPS editions
but not for the Standard edition. This explicitly shows Enterprise as the minimum requirement.
Link: https://docs.snowflake.com/en/user-guide/intro-editions#summary-of-features-by-edition
2. Snowflake Documentation: Introduction to Dynamic Data Masking.
Reference: The first paragraph of this documentation page explicitly states: "Dynamic Data Masking is an Enterprise Edition (or higher) feature."
Link: https://docs.snowflake.com/en/user-guide/security-column-ddm-intro
Keep practicing
Take the free COF-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other COF-C02 practice questions
- Question 1What does Snowflake recommend regarding database object ownership? (Select TWO).
- Question 2What kind of value does a User-Defined Function (UDF) return? (Select TWO).
- Question 3How do Snowflake data providers share data that resides in different databases?
- Question 4What are supported file formats for unloading data from Snowflake? (Choose three.)
- Question 5A marketing co-worker has requested the ability to change a warehouse size on their mediu…
- Question 6What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authe…
