What does it mean when a dataset is marked as certified in Unity Catalog?

It has been reviewed and approved for use by an authorized user

It is automatically updated every hour

It is stored in a secure location

It is the only dataset that can be queried

An analyst is writing a query and needs to join two tables: 'customers' in the 'crm' schema of the 'main' catalog, and 'orders' in the 'sales' schema of the 'main' catalog. What is the correct way to reference these tables in the JOIN clause?

JOIN crm.customers ON sales.orders.customer_id = crm.customers.id

JOIN main.crm.customers ON main.sales.orders.customer_id = main.crm.customers.id

JOIN main.customers ON main.orders.customer_id = main.customers.id

JOIN customers ON orders.customer_id = customers.id

A data analyst is reviewing the Catalog Explorer and sees that a table 'sales_2023' is certified. However, the analyst also notices that the table's data seems incomplete compared to 'sales_2023_raw'. What should the analyst do?

Use 'sales_2023' because it is certified, but investigate the data discrepancy.

Ignore the certification and use 'sales_2023_raw'.

Report the issue to the data governance team immediately.

Use 'sales_2023_raw' because it has more data.

DatabricksCertified Data Analyst Associate

Domain 2Objective 1

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

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 1–5

1foundation · easy
What does it mean when a dataset is marked as certified in Unity Catalog?
Select an answer first
2foundation · easy
Which Databricks UI tool is specifically designed for browsing and inspecting datasets registered in Unity Catalog?
Select an answer first
3application · medium
An analyst is writing a query and needs to join two tables: 'customers' in the 'crm' schema of the 'main' catalog, and 'orders' in the 'sales' schema of the 'main' catalog. What is the correct way to reference these tables in the JOIN clause?
Select an answer first
4expert · hard
A data analyst is reviewing the Catalog Explorer and sees that a table 'sales_2023' is certified. However, the analyst also notices that the table's data seems incomplete compared to 'sales_2023_raw'. What should the analyst do?
Select an answer first
5foundation · easy
In Unity Catalog, which object is contained within a schema?
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.

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

Questions 1–5

What does it mean when a dataset is marked as certified in Unity Catalog?

Which Databricks UI tool is specifically designed for browsing and inspecting datasets registered in Unity Catalog?

An analyst is writing a query and needs to join two tables: 'customers' in the 'crm' schema of the 'main' catalog, and 'orders' in the 'sales' schema of the 'main' catalog. What is the correct way to reference these tables in the JOIN clause?

A data analyst is reviewing the Catalog Explorer and sees that a table 'sales_2023' is certified. However, the analyst also notices that the table's data seems incomplete compared to 'sales_2023_raw'. What should the analyst do?

In Unity Catalog, which object is contained within a schema?

Keep studying — Section 2: Managing Data