Which approach is commonly used to create a unified dataset from multiple source tables?

Using UNION to combine all columns.

Creating a table using CTAS with a JOIN query.

Copying data manually into a single file.

Creating a view that joins the tables.

What is the purpose of creating a unified dataset from multiple sources?

To reduce the number of tables in the metastore.

To make the data inaccessible to other users.

To combine data from different sources into a single table for easier analysis.

To increase the storage cost of the data.

A data analyst is working in a Databricks workspace with Unity Catalog enabled. They need to create a new managed table in the `sales` schema of the `analytics` catalog. The table will store daily sales data and will be managed by Databricks. Which statement should they use?

CREATE TABLE analytics.daily_sales (date DATE, amount DECIMAL);

CREATE TABLE daily_sales (date DATE, amount DECIMAL) LOCATION 's3://managed/sales';

CREATE TABLE sales.daily_sales (date DATE, amount DECIMAL);

CREATE TABLE analytics.sales.daily_sales (date DATE, amount DECIMAL);

Which of the following is a valid way to read a Parquet file in Databricks SQL?

SELECT * FROM parquet_file('/mnt/data/events.parquet')

SELECT * FROM file.parquet('/mnt/data/events.parquet')

SELECT * FROM parquet.`/mnt/data/events.parquet`

SELECT * FROM '/mnt/data/events.parquet'

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

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 11–15

11foundation · easy
Which approach is commonly used to create a unified dataset from multiple source tables?
Select an answer first
12foundation · easy
What is the purpose of creating a unified dataset from multiple sources?
Select an answer first
13application · medium
A data analyst is working in a Databricks workspace with Unity Catalog enabled. They need to create a new managed table in the `sales` schema of the `analytics` catalog. The table will store daily sales data and will be managed by Databricks. Which statement should they use?
Select an answer first
14foundation · easy
In Databricks SQL, which clause is used to combine rows from two tables based on a related column?
Select an answer first
15foundation · easy
Which of the following is a valid way to read a Parquet file in Databricks SQL?
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.