What does Databricks manage for a managed table?

Both the data files and the metadata.

Only the data files, not the metadata.

Neither the data files nor the metadata.

Only the metadata, not the data files.

A company is setting up Databricks for the first time. They want to organize data by project, with each project having its own set of tables and access controls. They also want to ensure that users can only see the projects they are assigned to. What should they create?

A schema for each project in a single catalog.

A catalog for each project, with schemas for different data types.

A view for each project that filters data based on the user.

A table for each project in a single schema.

A data steward wants to mark a table as certified, but they are not the owner of the table. They have been granted the necessary permission to certify tables. What is the best way to certify the table in Catalog Explorer?

Create a new table with the same data and certify that table.

Grant SELECT permission to all users to indicate the table is certified.

Ask the table owner to certify it on their behalf.

Navigate to the table in Catalog Explorer, open the table details, and use the certification option.

What is a key characteristic of an external table in Databricks?

The data files are stored in a location outside of Databricks-managed storage.

The table cannot be queried using SQL.

Databricks manages both the data and metadata.

The table is stored in the Databricks metastore only.

DatabricksCertified Data Analyst Associate

Domain 1Objective 2

Understand Catalogs, Schemas, Managed and External Tables, Access Controls, Views, Certified Tables, and Lineage Within the Catalog Explorer Interface. DATA-ANALYST-ASSOCIATE Practice Questions (Page 5)

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

30questions here

6free pages

9concepts

Questions 21–25

21foundation · easy
What does Databricks manage for a managed table?
Select an answer first
22application · easy
A data analyst is troubleshooting a discrepancy in a report. They suspect that a view they are using might be based on an outdated table. In Catalog Explorer, what feature should they use to see the dependencies of the view?
Select an answer first
23application · medium
A company is setting up Databricks for the first time. They want to organize data by project, with each project having its own set of tables and access controls. They also want to ensure that users can only see the projects they are assigned to. What should they create?
Select an answer first
24expert · medium
A data steward wants to mark a table as certified, but they are not the owner of the table. They have been granted the necessary permission to certify tables. What is the best way to certify the table in Catalog Explorer?
Select an answer first
25foundation · easy
What is a key characteristic of an external table in Databricks?
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.