Applying Data Security Mechanisms. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A data engineer needs to protect a 'salary' column in a Delta table. Only HR managers should see actual salaries; all other users should see a masked value of '0'. Which approach should be used?

   • ACreate a column mask that returns the salary for HR managers and 0 for all other users.
   • BCreate a view that selects salary only for HR managers and grant access accordingly.
   • CEncrypt the salary column and provide the decryption key to HR managers.
   • DCreate a row filter that hides the salary column for non-HR users.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which statement best describes how ACLs govern permissions on workspace objects in Databricks?

   • AACLs are inherited from the parent object unless explicitly overridden
   • BACLs are automatically granted to all users in the workspace by default
   • CACLs are stored in the metastore and apply only to data tables
   • DACLs are only applied to tables and views, not to notebooks or folders
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   What is the primary purpose of a column mask in Databricks?

   • ATo encrypt the column data at rest
   • BTo hide entire columns from unauthorized users
   • CTo obfuscate sensitive data in a column for users without permission to see the raw values
   • DTo restrict which rows are visible in a table
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following is a type of workspace object in Databricks that can have ACL settings?

   • AJob
   • BNotebook
   • CData Source
   • DCluster
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the purpose of a row filter in Databricks?

   • ATo mask sensitive columns in a table
   • BTo improve query performance by filtering rows at scan time
   • CTo encrypt specific rows of a table
   • DTo restrict which rows of a table are visible to different users or groups
   Reveal Solution Discussion Select an answer first