Which method is commonly used to detect PII in datasets?

Pattern matching and data profiling

A data team wants to ensure that access to a sensitive table is audited and that old data is automatically removed after a retention period. What should the team implement?

Enable Delta Lake change data feed and set a table TTL.

Create a view that only shows recent data and drop the base table.

Grant SELECT to all users and rely on cloud storage logging.

Use Unity Catalog audit logs and configure a data lifecycle policy.

A marketing team stores customer data in a Delta table. The table contains email addresses, purchase history, and IP addresses. The compliance team has flagged that IP addresses are considered PII in their region. What is the most important reason to protect this data?

PII protection is only required for data stored in the cloud, not on-premises.

IP addresses are the only PII in the table, so protecting them is sufficient.

Protecting PII helps the company avoid legal penalties and maintain customer trust.

IP addresses are always considered PII and must be encrypted at all times.

A healthcare company stores patient records in a Delta table. The compliance team requires that patient names be visible to doctors but masked for all other roles. Which approach should the data analyst use to meet this requirement?

Use column-level masking with a policy that shows the full name to the 'doctors' group and masks it for others.

Redact the name column by replacing it with 'XXX' for all users.

Create two separate tables: one with names for doctors and one without names for everyone else.

Encrypt the name column so that only users with the decryption key can read it.

DatabricksCertified Data Analyst Associate

Domain 9Objective 3

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

Part of the Section 9: Securing Data domain, which makes up ~8% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~3–5 in this domain), expect 1–2 from this objective — we provide 23 practice questions to prepare you well beyond it. (estimate)

23questions here

5free pages

8concepts

Questions 11–15

11foundation · easy
Which method is commonly used to detect PII in datasets?
Select an answer first
12foundation · easy
Which data management practice enhances security by tracking who accessed what data and when?
Select an answer first
13application · medium
A data team wants to ensure that access to a sensitive table is audited and that old data is automatically removed after a retention period. What should the team implement?
Select an answer first
14application · medium
A marketing team stores customer data in a Delta table. The table contains email addresses, purchase history, and IP addresses. The compliance team has flagged that IP addresses are considered PII in their region. What is the most important reason to protect this data?
Select an answer first
15application · medium
A healthcare company stores patient records in a Delta table. The compliance team requires that patient names be visible to doctors but masked for all other roles. Which approach should the data analyst use to meet this requirement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ANALYST-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ANALYST-ASSOCIATE” is a trademark of its owner, used for identification only.