DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ29

VerifiedOfficial exam objectives/topics

A Data Engineer must secure the ACCOUNT_NAME column in the dynamic table, ACCT_DIM. The table is derived from the base table, ACCOUNT.

How should the data in the dynamic table be protected?

Explanation

Dynamic Data Masking is column-level security. A masking policy can be applied directly to a dynamic-table column with ALTER DYNAMIC TABLE ... MODIFY COLUMN ... SET MASKING POLICY, which protects ACCOUNT_NAME when the dynamic table is queried. Row access policies control access to rows, not masking of column values.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!