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

Questions 21–23

1. 21foundation · easy

   Which of the following is a common type of PII?

   • AServer IP address
   • BTransaction timestamp
   • CSocial security number
   • DProduct SKU
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A table 'orders' is owned by 'analyst1'. The analyst leaves the company, and the admin transfers ownership to 'analyst2'. What is the impact on the existing permissions granted to other users?

   • AAll existing permissions remain unchanged.
   • BPermissions are now managed by analyst2 and must be re-approved by them.
   • COnly SELECT permissions remain, but other permissions are revoked.
   • DAll existing permissions are revoked and must be re-granted by analyst2.
   Reveal Solution Discussion Select an answer first
3. 23foundation · easy

   What is the relationship between table ownership and permissions in Databricks?

   • AOwnership is only relevant for external tables, not managed tables
   • BThe owner must be granted SELECT permission before they can query the table
   • CPermissions are independent of ownership; the owner has no special rights
   • DThe owner automatically has all privileges on the table, including the ability to grant them to others
   Reveal Solution Discussion Select an answer first