Courseiva

Databricks-DA-Assoc · domain

Securing Data

This domain covers how Databricks data analysts work with Unity Catalog security: privileges, dynamic views, row-level and column-level controls, and identity management across workspaces. Questions present concrete scenarios—querying a protected view, granting table access, restricting sensitive columns—and ask you to choose the correct SQL, privilege, or governance approach.

24 questions7 easy11 medium6 hard

Focused practice

Practice Securing Data questions

Scored sessions drawing only from this domain — pick a length below.

What this domain covers

What to know about Securing Data

Be able to write GRANT and REVOKE statements at the right Unity Catalog object level, and explain how dynamic views enforce row filters and column masks for users who lack direct table access. The key is granting least privilege on the exact object, not a broader container.

Unity Catalog privilege model: GRANT SELECT on tables, views, schemas, and catalogs

Dynamic views enforcing row-level security and column masking for analysts

Account-level identity management required for cross-workspace Unity Catalog governance

Column-level restrictions using GRANT/REVOKE and dynamic view masking functions

Watch out for

Common Securing Data exam traps

  • ▸Assuming SELECT on a dynamic view also requires SELECT on the underlying table; view owner privileges handle that
  • ▸Granting access at schema or catalog level when the question asks for one specific table only
  • ▸Confusing workspace-local metastore identity with account-level identity needed for centralized Unity Catalog governance

Question index

All Securing Data questions (24)

Click any question to see the full explanation, or start a practice session above.

1

A data platform administrator needs to configure secure data access policies in Unity Catalog. Which TWO actions can the administrator perform to restrict access to sensitive columns within a Delta table? (Choose TWO)

Medium
2

A data analyst needs to grant a service principal read access to a specific external location in Unity Catalog so that a scheduled job can read data from an S3 bucket. The analyst has already created a storage credential that references an IAM role with the necessary S3 permissions. Which Unity Catalog object must the analyst grant the service principal access to, in addition to the storage credential?

Hard
3

Refer to the exhibit. This IAM policy is attached to a Storage Credential. A user tries to run 'DROP TABLE' on a table stored in this bucket and fails. Why?

Hard
4

A data analyst is reviewing audit logs in Databricks to investigate unauthorized access attempts to a sensitive table. Which audit log event type should the analyst filter on to find failed attempts to query the table?

Medium
5

A data analyst has a Unity Catalog table `main.finance.payroll` that contains a column `ssn` with sensitive data. The analyst wants to allow the HR team to query the table but mask the `ssn` column so that only users in the `hr_admins` group see the actual values; all other users should see `***` instead. Which Unity Catalog feature should the analyst use to achieve this?

Medium
6

Refer to the exhibit. A data scientist can query both tables, but the join fails with a permission error. What is the most likely reason?

Hard
7

Which audit log category is most useful for identifying unauthorized attempts to access sensitive tables?

Medium
8

Which THREE actions are required to successfully secure an external location in Unity Catalog?

Medium
9

What is the primary function of a Storage Credential in Unity Catalog?

Medium
10

A data analyst is using Databricks SQL to query a table `main.sales.orders` that has a column `credit_card` containing sensitive data. The analyst needs to run a query that aggregates orders by region but must not see the actual credit card numbers. Which Unity Catalog feature should be used to mask the `credit_card` column for this analyst?

Hard
11

When sharing data with external organizations using Delta Sharing, which component manages the secure exchange of data?

Easy
12

A data analyst has been asked to grant a new team member read access to a specific table named 'customer_orders' in Unity Catalog. The analyst wants to ensure the team member can query the table but cannot see any other tables in the schema. Which SQL command should the analyst use?

Medium
13

An administrator needs to secure a table containing sensitive customer data. Which TWO options represent valid ways to restrict access using Unity Catalog?

Medium
14

A data analyst is reviewing audit logs in Databricks to investigate who accessed a sensitive table 'main.finance.payroll'. The analyst needs to identify the user, the timestamp, and the action performed. Which audit log service should the analyst query to find this information?

Easy
15

A data analyst wants to share a Unity Catalog table with an external partner using Delta Sharing. The partner uses a non-Databricks client that supports the Delta Sharing protocol. Which Unity Catalog object must the analyst create to enable the partner to access the shared data?

Easy
16

A data analyst needs to share a sensitive sales table with the marketing team in Databricks. The marketing team should only see rows where the region column matches 'North America' and should not have access to the credit_card column. Which Unity Catalog feature should the data analyst implement?

Medium
17

A data analyst at a multinational bank needs to ensure that queries against a Unity Catalog table 'main.risk.transactions' automatically hide the 'customer_ssn' column for users in the 'contractors' group, while all other users see the full data. The analyst wants to implement this without creating separate views for each user group. Which Unity Catalog feature should the analyst use?

Hard
18

An organization stores sensitive financial records in a Unity Catalog managed Delta table stored in cloud object storage. To comply with corporate security mandates, all data at rest must be encrypted using a customer-managed encryption key rather than the default cloud provider-managed keys. Where must the administrator configure this encryption setting?

Medium
19

A data analyst is using a Databricks SQL warehouse to query a table that is protected by row-level security using dynamic views in Unity Catalog. The analyst has SELECT on the view but not on the underlying table. When querying the view, the analyst receives an error about insufficient privileges on the base table. What is the most likely cause?

Hard
20

A data analyst needs to grant a team member the ability to view the metadata of a table `main.finance.transactions` in Unity Catalog, but not query the data. Which privilege should the analyst grant?

Easy
21

What is the purpose of the 'Account Admin' role in Databricks?

Easy
22

Which identity management approach is required to utilize Unity Catalog for centralized governance across multiple Databricks workspaces?

Easy
23

A data analyst needs to grant a colleague read access to a specific table named 'quarterly_sales' within Unity Catalog without exposing other tables in the same schema. Which SQL command should the analyst execute?

Easy
24

A data analyst in the 'marketing' group needs to query the table `main.sales.leads` but should not be able to read the underlying data files directly. The analyst currently has `SELECT` on the table and `READ FILES` on the external location where the table's data resides. Which Unity Catalog privilege should the analyst's `READ FILES` on the external location be removed to enforce least privilege?

Medium

Frequently asked questions

What does the Securing Data domain cover on the Databricks-DA-Assoc exam?
Be able to write GRANT and REVOKE statements at the right Unity Catalog object level, and explain how dynamic views enforce row filters and column masks for users who lack direct table access. The key is granting least privilege on the exact object, not a broader container.
How many questions are in this domain?
This page lists all 24 Securing Data questions in the Databricks-DA-Assoc question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
What is the best way to practise this domain?
Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
Can I practise only Securing Data questions?
Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.
Databricks Certified Data Analyst Associate Databricks-DA-Assoc Securing Data Practice Questions