A data analyst is writing a query and needs to join two tables: 'customers' in the 'sales' schema of the 'prod' catalog, and 'support_tickets' in the 'service' schema of the 'prod' catalog. Which of the following is the correct way to reference these tables in the JOIN clause?

JOIN prod.support_tickets.service ON ...

JOIN service.prod.support_tickets ON ...

JOIN prod.service.support_tickets ON ...

JOIN support_tickets.service.prod ON ...

A data analyst is writing a query that joins a table from the 'prod' catalog with a table from the 'dev' catalog. Both tables are in the 'analytics' schema. The analyst writes: SELECT * FROM prod.analytics.sales JOIN dev.analytics.forecast ON ... This query fails. What is the most likely reason?

The 'sales' table is in a different catalog.

The query syntax is incorrect for cross-catalog joins.

The 'forecast' table is in a different schema.

The analyst does not have permission to access the 'dev' catalog.

What is the primary difference between a table and a volume in Unity Catalog?

Tables are stored in schemas, while volumes are stored in catalogs.

Tables are managed by Unity Catalog, while volumes are not.

Tables store structured data, while volumes store unstructured data.

Tables are used for data analysis, while volumes are used for data storage only.

A company is implementing Unity Catalog for the first time. They want to ensure that all data assets are governed centrally and that permissions can be managed at a high level. What is the recommended approach for structuring their data in Unity Catalog?

Create a separate catalog for every table and grant permissions at the catalog level.

Create a single catalog with a single schema and grant permissions at the table level.

Create a few catalogs, each with multiple schemas, and grant permissions at the catalog or schema level.

Create a separate schema for every table and grant permissions at the schema level.

A data analyst is troubleshooting a query that fails with a 'table not found' error. The analyst knows the table exists and has the correct permissions. The table is named 'sales' and is in the 'analytics' schema. The analyst is currently using the 'prod' catalog. Which of the following is the most likely cause of the error?

The analyst is not using the fully qualified name 'prod.analytics.sales' in the query.

The analyst is using the wrong catalog name in the query.

The table is actually a volume, not a table.

The table is in a different schema than the analyst thinks.

DatabricksCertified Data Analyst Associate

Domain 9Objective 2

Tables or Volumes) Works in the Unity Catalog. DATA-ANALYST-ASSOCIATE Practice Questions (Page 4)

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

28questions here

6free pages

6concepts

Questions 16–20

16application · easy
A data analyst is writing a query and needs to join two tables: 'customers' in the 'sales' schema of the 'prod' catalog, and 'support_tickets' in the 'service' schema of the 'prod' catalog. Which of the following is the correct way to reference these tables in the JOIN clause?
Select an answer first
17expert · hard
A data analyst is writing a query that joins a table from the 'prod' catalog with a table from the 'dev' catalog. Both tables are in the 'analytics' schema. The analyst writes: SELECT * FROM prod.analytics.sales JOIN dev.analytics.forecast ON ... This query fails. What is the most likely reason?
Select an answer first
18foundation · easy
What is the primary difference between a table and a volume in Unity Catalog?
Select an answer first
19application · medium
A company is implementing Unity Catalog for the first time. They want to ensure that all data assets are governed centrally and that permissions can be managed at a high level. What is the recommended approach for structuring their data in Unity Catalog?
Select an answer first
20expert · hard
A data analyst is troubleshooting a query that fails with a 'table not found' error. The analyst knows the table exists and has the correct permissions. The table is named 'sales' and is in the 'analytics' schema. The analyst is currently using the 'prod' catalog. Which of the following is the most likely cause of the error?
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.