Apply Data Governance Features Including Masking and Row Access Policies COF-C03 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   An administrator applied a masking policy to the CREDIT_CARD column of a CUSTOMERS table. Later, the policy definition needs to be changed to also mask the last four digits for users with the ANALYST role. What is the correct way to update the policy?

   • ADrop the policy and create a new one with the same name, then re-apply it.
   • BCreate a new masking policy and apply it to the column; the new policy overrides the old one.
   • CUse ALTER MASKING POLICY to modify the policy body and then re-apply it to the column.
   • DUse ALTER TABLE to change the column data type and then re-create the policy.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   What is the purpose of a row access policy in Snowflake?

   • ATo control which rows are visible to a user based on conditions
   • BTo create a materialized view of a table
   • CTo hide specific columns from users
   • DTo encrypt data in transit
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   In a conditional masking policy, what determines whether a user sees the original value or a masked value?

   • AThe query's execution time
   • BThe current role of the user
   • CThe user's IP address
   • DThe table's owner
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Snowflake object is used to define how a column's values are displayed to different users?

   • AView
   • BMasking policy
   • CTag
   • DRow access policy
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary purpose of column-level masking in Snowflake?

   • ATo create a copy of a column for backup purposes
   • BTo encrypt data at rest in the storage layer
   • CTo restrict access to entire tables based on user roles
   • DTo transform sensitive data in a column so that only authorized users see the original values
   Reveal Solution Discussion Select an answer first