Use Masking Techniques as Guard Rails to Meet a Performance Objective GENERATIVE-AI-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   A company has a table with customer email addresses. They want the 'support' role to see the full email, but the 'analyst' role to see only the domain part (e.g., '*****@example.com'). Which feature allows this role-based visibility?

   • AColumn-level masking with a policy that applies different masking rules based on the user's role.
   • BNetwork-level access controls that block the analyst role from querying the email column.
   • CTable-level permissions that grant the analyst role access to a separate view with masked emails.
   • DRow-level security that filters out email addresses for the analyst role.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   In a Databricks environment, what is the primary purpose of using masking techniques as a governance guard rail?

   • ATo create an audit log of all data access attempts for compliance reporting.
   • BTo transform sensitive data into a format that hides the original values from users who lack the required permissions.
   • CTo permanently delete sensitive data from tables to comply with data retention policies.
   • DTo encrypt data at rest so that unauthorized users cannot read it without a decryption key.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A company needs to ensure that when a junior analyst queries a table containing employee salaries, the salary column shows 'XXXX' instead of the actual value, but the underlying data must remain unchanged for other users. Which approach should be used?

   • ACreate a separate table with masked salaries and grant the junior analyst access to that table instead of the original.
   • BEncrypt the salary column so that the junior analyst cannot read it without a decryption key.
   • CCreate a view that selects the salary column with a CASE statement that replaces the value with 'XXXX' for all users.
   • DApply a dynamic masking rule on the salary column that masks the value for the junior analyst role.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A data engineer wants to allow support staff to query a customer table for troubleshooting, but they should not see full credit card numbers. Which governance technique directly addresses this requirement?

   • AColumn-level masking that shows only the last four digits of the credit card to the support role.
   • BNetwork-level segmentation that prevents support staff from accessing the table over the network.
   • CEncryption of the entire table so that support staff cannot read any data without a key.
   • DRow-level filtering that removes all rows containing credit card data from the table.
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary purpose of static data masking in Databricks?

   • ATo encrypt the dataset so that only users with the decryption key can access it.
   • BTo create a sanitized copy of a dataset that can be safely used in non-production environments.
   • CTo redact sensitive data in query results in real time based on the user's role.
   • DTo delete sensitive columns from the source table to reduce the risk of data exposure.
   Reveal Solution Discussion Select an answer first