COF-C02 practice question 7 of 35

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Full set: 778 questions
Answer options
A: Standard
B: Enterprise Correct answer
C: Business Critical
D: Virtual Private Snowflake (VPC)
Correct Answer:
B. Enterprise
Explanation

Dynamic 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.

Why Incorrect

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.

References

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

Scroll to Top