What is a key advantage of using Delta format over Parquet for table creation?

Delta tables can only be created from CSV files.

Delta tables do not require a schema.

Delta tables support ACID transactions and time travel.

Delta tables are always smaller in size.

Which SQL statement creates a new table from the result of a SELECT query?

CREATE VIEW new_table AS SELECT * FROM source_table

INSERT INTO new_table SELECT * FROM source_table

CREATE TABLE new_table AS SELECT * FROM source_table

SELECT * INTO new_table FROM source_table

In Databricks, what is the key difference between a managed table and an external table?

Managed tables store data in the cloud object store, while external tables store data in the cluster's local storage.

Managed tables have their data files managed by Databricks, while external tables have their data files managed independently of the table's lifecycle.

Managed tables are stored in the metastore, while external tables are stored in the file system.

Managed tables can only be created from Delta files, while external tables can be created from any file format.

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

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 6–10

6foundation · easy
What is a key advantage of using Delta format over Parquet for table creation?
Select an answer first
7foundation · easy
In Unity Catalog, what is the correct three-level namespace for a table?
Select an answer first
8foundation · easy
Which SQL statement creates a new table from the result of a SELECT query?
Select an answer first
9foundation · easy
Which SQL JOIN type returns only the rows that have matching values in both tables?
Select an answer first
10foundation · easy
In Databricks, what is the key difference between a managed table and an external table?
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.

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

Questions 6–10

What is a key advantage of using Delta format over Parquet for table creation?

In Unity Catalog, what is the correct three-level namespace for a table?

Which SQL statement creates a new table from the result of a SELECT query?

Which SQL JOIN type returns only the rows that have matching values in both tables?

In Databricks, what is the key difference between a managed table and an external table?

Keep studying — Section 4: Executing queries using Databricks SQL and Databricks SQL Warehouses