Apply Best Practices for Storage and Management to Ensure Data Security, Including Table Ownership and PII Protection. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the primary purpose of encrypting PII at rest?

   • ATo make the data easier to query
   • BTo protect the data from unauthorized access if the storage medium is compromised
   • CTo allow data to be shared publicly
   • DTo reduce storage costs
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data analyst receives a dataset with columns: 'name', 'address', 'zip_code', 'purchase_date', and 'product_id'. Which columns should be flagged as PII?

   • Aname, address, zip_code, and purchase_date
   • Bname, address, and zip_code
   • Cname, address, zip_code, purchase_date, and product_id
   • Dname and address only
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A global company stores customer data in a single Delta table. The data includes 'email', 'country', and 'purchase_amount'. The EU team requires that email addresses be masked for non-EU users, while the US team requires that purchase amounts be masked for non-US users. A user in the EU should see emails but not purchase amounts. What is the best approach?

   • ARedact both columns for all users and provide a separate secure table for each region.
   • BCreate two separate views: one for EU users and one for US users, each with the appropriate masking.
   • CUse dynamic column masking with a policy that checks the user's region and masks the appropriate column.
   • DEncrypt both columns and provide decryption keys to all users.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A table 'inventory' is currently owned by 'user1'. The data analyst 'user2' needs to take over ownership to manage the table. Which command should be run?

   • AALTER TABLE inventory OWNER TO `user2`;
   • BGRANT OWNERSHIP ON TABLE inventory TO `user2`;
   • CUPDATE TABLE inventory SET OWNER = 'user2';
   • DCHANGE TABLE inventory OWNER TO `user2`;
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Why is table ownership important for data security in Databricks?

   • AIt prevents all users except the owner from seeing the table in the catalog
   • BIt ensures that only the owner can read the table data
   • CIt automatically encrypts the table data at rest
   • DIt provides a clear point of accountability for managing the table and its permissions
   Reveal Solution Discussion Select an answer first