SnowPro Core Certification COF-C02 Exam Dumps

Masking policies in Snowflake are created and applied at the column level. These policies are used to obfuscate sensitive data by masking the values in a specific column. Masking policies can enforce data privacy and protection measures by dynamically masking the data based on the role of the user querying the data.

Snowflake Documentation: Dynamic Data Masking

When querying VARIANT columns (such as JSON), the values are often returned as strings. To convert them to usable SQL types, users must apply the CAST() function (e.g., CAST(column:value AS NUMBER)).

Session policies allow account administrators to define rules such as session timeout, requiring users to re-authenticate after inactivity. This is different from password or network policies, which manage login credentials and IP filtering.

A directory table in Snowflake is an implicit object layered on a stage, whether internal or external. It allows users to query the contents of a stage as if it were a table, providing metadata about the files stored in the stage, such as filenames, file sizes, and last modified timestamps.

Snowflake Documentation: Directory Tables