Understand Column-Level Masking and Row-Level Security to Restrict Data Visibility Based on User Groups. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   What happens when a masking policy is applied to a column in a table?

   • AThe column is dropped from the table
   • BQueries on that column automatically invoke the policy to return masked values for unauthorized users
   • CThe underlying data in the table is permanently changed to the masked values
   • DAll users see the masked values, regardless of their permissions
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

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

   • ATo dynamically hide or obfuscate column values based on user attributes
   • BTo permanently delete sensitive data from tables
   • CTo encrypt data at rest in the storage layer
   • DTo restrict which rows a user can see in a table
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   When both column masking and row-level security are applied to a table, what is the combined effect?

   • AOnly column masking is applied; row-level security is ignored
   • BThe table becomes inaccessible to all users
   • COnly row-level security is applied; column masking is ignored
   • DUsers see only allowed rows, and sensitive columns in those rows are masked as per the masking policy
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   How can you verify that a masking policy produces the expected output for a specific user group?

   • ABy running a DESCRIBE command on the policy
   • BBy examining the table's schema in the catalog
   • CBy checking the table's storage location
   • DBy querying the table as a user in that group and inspecting the returned values
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What happens when you drop a masking policy that is currently applied to a column?

   • AThe policy is replaced with a default masking policy
   • BThe table becomes inaccessible
   • CThe column is dropped from the table
   • DThe column becomes unmasked, and all users see the original values
   Reveal Solution Discussion Select an answer first