A data analyst needs to find a table containing customer churn scores. The analyst knows the table name starts with 'churn' but does not know which catalog or schema it lives in. Which approach will most efficiently locate this table in Unity Catalog?

Use the Catalog Explorer to expand every catalog and schema one by one until the table is found.

Query the system table information_schema.tables to search for the table name.

Use the search bar in the Databricks workspace and search for 'churn' to see matching tables across all catalogs and schemas.

Run SHOW TABLES IN main.default and filter the results for names starting with 'churn'.

An analyst needs to query a certified table named 'product_performance' in the 'analytics' schema of the 'retail' catalog. What is the correct SQL statement?

SELECT * FROM retail.analytics.product_performance

SELECT * FROM retail.product_performance

SELECT * FROM product_performance

SELECT * FROM analytics.product_performance

DatabricksCertified Data Analyst Associate

Domain 2Objective 1

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

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 21–24

21foundation · easy
A data analyst sees a badge icon next to a table name in Catalog Explorer. What does this badge indicate?
Select an answer first
22application · medium
A data analyst needs to find a table containing customer churn scores. The analyst knows the table name starts with 'churn' but does not know which catalog or schema it lives in. Which approach will most efficiently locate this table in Unity Catalog?
Select an answer first
23application · easy
An analyst needs to query a certified table named 'product_performance' in the 'analytics' schema of the 'retail' catalog. What is the correct SQL statement?
Select an answer first
24foundation · easy
What is the correct three-level namespace used by Unity Catalog to reference a dataset?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 5)

Questions 21–24

A data analyst sees a badge icon next to a table name in Catalog Explorer. What does this badge indicate?

A data analyst needs to find a table containing customer churn scores. The analyst knows the table name starts with 'churn' but does not know which catalog or schema it lives in. Which approach will most efficiently locate this table in Unity Catalog?

An analyst needs to query a certified table named 'product_performance' in the 'analytics' schema of the 'retail' catalog. What is the correct SQL statement?

What is the correct three-level namespace used by Unity Catalog to reference a dataset?

Keep studying — Section 2: Managing Data