Câu 31: DP-750: Implementing Data Engineering Solutions Using Azure Databricks

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a catalog named Catalog1. Catalog1 contains a table named Transactions. Transactions contains the following columns: transaction_id customer_name email_address credit_card_number transaction_amountYou need to ensure that business analysts can query all the rows in the Transactions table. The solution must meet the following requirements:Prevent the analysts from seeing the full values in the email_address and credit_card_number columns. Ensure that the analysts can see only the values after the @ character in each email address. Ensure that the analysts can see only the last four digits of each credit card number. Enable the analysts to query the table without errors. Follow the principle of least privilege. What should you do?

1. A. Grant the analysts the SELECT permission for the Transactions table and apply column-level encryption.
2. B. Grant the analysts the SELECT permission for columns that do NOT contain sensitive data.
3. C. Grant the analysts the SELECT permission for the Transactions table and implement row-level filters.
4. D. Grant the analysts the SELECT permission for the Transactions table and apply column masks to email_address and credit_card_number. — đáp án hiện tại