What does the TBLPROPERTIES clause do in a CTAS statement?

It defines the schema of the table.

It specifies the storage location of the table.

It specifies the data format of the table.

It sets custom metadata properties on the table.

When you drop an external table in Databricks, what happens to the underlying data files?

The data files are converted to managed table files.

The data files remain in the external location.

The data files are moved to the Databricks trash.

The data files are deleted immediately.

Where does Databricks store the data files for a managed table by default?

In the cloud object storage location managed by Databricks for the workspace.

In the Unity Catalog metastore database.

In the cluster's local disk storage.

In the location specified by the user in the CREATE TABLE statement.

What is the primary purpose of creating an external table in Databricks?

To store data in the Databricks-managed storage for better performance.

To create a copy of the data in the Databricks file system.

To access and query data that resides in external storage without moving it into Databricks.

To enforce schema constraints on the data.

DatabricksCertified Data Analyst Associate

Domain 4Objective 8

Create Managed Tables and External Tables, Including Creating Tables by Joining Data from Multiple Sources (e.g., CSV, Parquet, Delta Tables) to Create Unified Datasets, Including Unity Catalog. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Part of the Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses domain, which makes up ~22% of our current practice bank. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 1–1 from this objective — we provide 18 practice questions to prepare you well beyond it. (estimate)

18questions here

4free pages

10concepts

Questions 1–5

1foundation · easy
What does the TBLPROPERTIES clause do in a CTAS statement?
Select an answer first
2foundation · easy
When you drop an external table in Databricks, what happens to the underlying data files?
Select an answer first
3foundation · easy
Which data format is typically the most efficient for querying large datasets in Databricks?
Select an answer first
4foundation · easy
Where does Databricks store the data files for a managed table by default?
Select an answer first
5foundation · easy
What is the primary purpose of creating 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.