A data analyst is looking at the Catalog Explorer and sees a 'Certified' badge next to a table named 'customer_revenue'. What does this badge indicate about the table?

The table can only be queried by users with admin privileges.

The table is automatically refreshed with new data every hour.

The table is physically stored in a secure, encrypted location.

The table has been reviewed and approved by the data governance team as a trusted source of truth.

A data analyst wants to query a view named `active_customers` that is registered in Unity Catalog. What is the correct way to reference this view in a SQL query?

Use the full catalog.schema.view name

Use the schema and view name only

Use the catalog and view name only

An analyst is using the Catalog Explorer and wants to preview the first few rows of a table to understand its content. What is the most direct way to do this?

Click on the 'History' tab to see the data.

Click on the table and then select the 'Data' tab to see a preview.

Check the 'Permissions' tab to see the data.

Run a SELECT * query in a notebook.

An analyst is writing a query and needs to reference a view named 'active_customers' in the 'customer360' schema of the 'marketing' catalog. What is the correct SQL statement to select all columns from this view?

SELECT * FROM customer360.active_customers

USE marketing.customer360; SELECT * FROM active_customers

SELECT * FROM marketing.customer360.active_customers

SELECT * FROM marketing.active_customers

DatabricksCertified Data Analyst Associate

Domain 2Objective 1

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

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 6–10

6application · easy
A data analyst is looking at the Catalog Explorer and sees a 'Certified' badge next to a table named 'customer_revenue'. What does this badge indicate about the table?
Select an answer first
7foundation · easy
A data analyst wants to query a view named `active_customers` that is registered in Unity Catalog. What is the correct way to reference this view in a SQL query?
Select an answer first
8application · easy
An analyst is using the Catalog Explorer and wants to preview the first few rows of a table to understand its content. What is the most direct way to do this?
Select an answer first
9application · medium
An analyst needs to query a table named 'orders' but only knows it is in the 'sales' catalog. What is the minimum information needed to write a valid query?
Select an answer first
10application · easy
An analyst is writing a query and needs to reference a view named 'active_customers' in the 'customer360' schema of the 'marketing' catalog. What is the correct SQL statement to select all columns from this view?
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.