A data analyst is comparing two tables for a report: 'sales_raw' and 'sales_curated'. The 'sales_curated' table has a 'Certified' badge in Unity Catalog. What is the most appropriate action for the analyst?

Use 'sales_raw' because certification does not guarantee data quality.

Use 'sales_raw' because it contains the most granular data.

Use 'sales_curated' for the report because it is certified as a trusted dataset.

Use both tables and merge them in the report.

An analyst is using the Catalog Explorer to inspect a table. They need to see the table's schema, owner, and whether it is certified. Which tab or section in the Catalog Explorer should they navigate to?

The 'Permissions' tab of the table

The 'Overview' tab of the table

A table named `orders` is registered in Unity Catalog under the `sales` schema in the `retail` catalog. Which SQL statement correctly queries this table?

SELECT * FROM retail.sales.orders

An analyst is searching for a table to use in a high-stakes analysis. They find two tables with similar names: 'customer_data' and 'customer_data_v2'. The 'customer_data_v2' table is certified. What is the most appropriate action?

Use 'customer_data_v2' because it is certified and likely the most reliable.

Use 'customer_data' because certification is not important.

Use both tables and compare the results.

Use 'customer_data' because it is the original table.

DatabricksCertified Data Analyst Associate

Domain 2Objective 1

Use Unity Catalog to Discover, Query, and Manage Certified Datasets. DATA-ANALYST-ASSOCIATE Practice Questions (Page 3)

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

24questions here

5free pages

5concepts

Questions 11–15

11application · medium
A data analyst is comparing two tables for a report: 'sales_raw' and 'sales_curated'. The 'sales_curated' table has a 'Certified' badge in Unity Catalog. What is the most appropriate action for the analyst?
Select an answer first
12application · easy
An analyst is using the Catalog Explorer to inspect a table. They need to see the table's schema, owner, and whether it is certified. Which tab or section in the Catalog Explorer should they navigate to?
Select an answer first
13foundation · easy
A table named `orders` is registered in Unity Catalog under the `sales` schema in the `retail` catalog. Which SQL statement correctly queries this table?
Select an answer first
14expert · hard
An analyst is searching for a table to use in a high-stakes analysis. They find two tables with similar names: 'customer_data' and 'customer_data_v2'. The 'customer_data_v2' table is certified. What is the most appropriate action?
Select an answer first
15foundation · easy
When using the Databricks Search bar to find a dataset, which type of object can be discovered if it is registered in Unity Catalog?
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.