How can lineage information be useful in data governance?

It controls user access to data.

It helps identify the impact of changes to a table.

It automatically backs up data.

How does Databricks handle metadata for an external table?

Databricks does not store any metadata for external tables.

Databricks stores both data and metadata in the metastore.

Databricks stores the table metadata in the metastore, but the data remains in the external location.

Databricks copies the data into its managed storage.

In Catalog Explorer, where would you go to view the properties of a table?

Open the 'Jobs' section and find the table in the job history.

Go to the 'Data' section and click on the catalog name only.

Select the table and open the 'Properties' tab.

Navigate to the 'Compute' section and select the table.

A data platform team is designing the Unity Catalog hierarchy for a multi-tenant application. Each tenant has its own set of tables, and the team wants to ensure that tenants cannot see each other's data. They also want to minimize the number of grants they need to manage. What is the best design?

Create a schema per tenant in a single catalog, with tables for each tenant.

Create a catalog per tenant, with schemas for different data domains within each tenant.

Create a single schema with tables named by tenant, and use row-level security.

Create a separate external location for each tenant and query the files directly.

How does a view provide a virtual table?

By creating a new physical file for the data.

By copying data from the underlying tables into a new table.

By running a saved SQL query each time the view is accessed.

By storing a snapshot of the data at creation time.

DatabricksCertified Data Analyst Associate

Domain 1Objective 2

Understand Catalogs, Schemas, Managed and External Tables, Access Controls, Views, Certified Tables, and Lineage Within the Catalog Explorer Interface. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

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

30questions here

6free pages

9concepts

Questions 6–10

6foundation · easy
How can lineage information be useful in data governance?
Select an answer first
7foundation · easy
How does Databricks handle metadata for an external table?
Select an answer first
8foundation · easy
In Catalog Explorer, where would you go to view the properties of a table?
Select an answer first
9expert · hard
A data platform team is designing the Unity Catalog hierarchy for a multi-tenant application. Each tenant has its own set of tables, and the team wants to ensure that tenants cannot see each other's data. They also want to minimize the number of grants they need to manage. What is the best design?
Select an answer first
10foundation · easy
How does a view provide a virtual table?
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.