In Databricks, at which levels can access controls be applied?

Catalog, schema, and table levels.

Which statement is true about a managed table in Databricks?

Dropping the table leaves the data files intact.

The data files are stored in a user-specified external location.

Managed tables cannot be used with Delta Lake.

Databricks stores the data in a location managed by the platform.

What is the primary purpose of the Catalog Explorer interface?

To browse and manage data objects such as catalogs, schemas, tables, and views.

A data analyst is investigating a data quality issue. They notice that a table 'sales_summary' is derived from multiple source tables. They want to understand which source tables are used and how changes to those tables might affect 'sales_summary'. What should they use in Catalog Explorer?

Schema details of 'sales_summary'.

Lineage view for 'sales_summary'.

Certification status of 'sales_summary'.

Access control list for 'sales_summary'.

A company has a regulatory requirement to retain raw data for 7 years. They store this data in an external location that is managed by a separate storage team. The Databricks team creates external tables to query this data. What is the best way to ensure that the data is not accidentally deleted by Databricks operations?

Ensure the external tables are never dropped, and rely on the storage team's retention policies.

Convert the external tables to managed tables so Databricks manages retention.

Create views on top of the external tables and use the views for all queries.

Grant only SELECT permissions on the external tables to prevent accidental drops.

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 4)

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 16–20

16foundation · easy
In Databricks, at which levels can access controls be applied?
Select an answer first
17foundation · easy
Which statement is true about a managed table in Databricks?
Select an answer first
18foundation · easy
What is the primary purpose of the Catalog Explorer interface?
Select an answer first
19expert · medium
A data analyst is investigating a data quality issue. They notice that a table 'sales_summary' is derived from multiple source tables. They want to understand which source tables are used and how changes to those tables might affect 'sales_summary'. What should they use in Catalog Explorer?
Select an answer first
20expert · hard
A company has a regulatory requirement to retain raw data for 7 years. They store this data in an external location that is managed by a separate storage team. The Databricks team creates external tables to query this data. What is the best way to ensure that the data is not accidentally deleted by Databricks operations?
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.