A data engineer needs to load data from a set of CSV files into a new Delta table in Unity Catalog. The files have inconsistent schemas across different partitions, and the engineer wants to use a notebook to perform the ingestion. The table should be created with a schema that is the union of all files. Which approach should they use?

Use `spark.read.csv("/mnt/data")` and then write to a Delta table

Use `COPY INTO` with `MERGE_SCHEMA = true`

Use `spark.read.option("mergeSchema", "true").csv("/mnt/data")` and then write to a Delta table

Use SQL CTAS with `SELECT * FROM csv.`/mnt/data``

Which SQL statement replaces an existing table's data and schema with the results of a query, effectively overwriting the table?

MERGE INTO ... WHEN MATCHED THEN UPDATE

INSERT OVERWRITE TABLE ... SELECT

CREATE OR REPLACE TABLE ... AS SELECT

Which DataFrameReader method is commonly used in a Databricks notebook to read a batch of JSON files from cloud storage into a DataFrame for ingestion into Unity Catalog?

spark.read.format("json").load(path)

spark.readStream.format("json").load(path)

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 3Objective 2

Ingest Data into Unity Catalog DP-750 Practice Questions (Page 1)

Part of the Prepare and process data domain, which accounts for 30–35% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~15–28 in this domain), expect 4–7 from this objective — we provide 44 practice questions to prepare you well beyond it. (estimate)

44questions here

9free pages

11concepts

30–35%of the exam

Questions 1–5

1foundation · easy
What is the primary abstraction in Spark Structured Streaming for representing a stream of data?
Select an answer first
2application · medium
A data engineer needs to load data from a set of CSV files into a new Delta table in Unity Catalog. The files have inconsistent schemas across different partitions, and the engineer wants to use a notebook to perform the ingestion. The table should be created with a schema that is the union of all files. Which approach should they use?
Select an answer first
3foundation · easy
Which SQL statement creates a new table in Unity Catalog by querying data from an external source or existing table?
Select an answer first
4foundation · easy
Which SQL statement replaces an existing table's data and schema with the results of a query, effectively overwriting the table?
Select an answer first
5foundation · easy
Which DataFrameReader method is commonly used in a Databricks notebook to read a batch of JSON files from cloud storage into a DataFrame for ingestion into Unity Catalog?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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 Microsoft. “DP-750” is a trademark of its owner, used for identification only.

Ingest Data into Unity Catalog DP-750 Practice Questions (Page 1)

Questions 1–5

What is the primary abstraction in Spark Structured Streaming for representing a stream of data?

Which SQL statement creates a new table in Unity Catalog by querying data from an external source or existing table?

Which SQL statement replaces an existing table's data and schema with the results of a query, effectively overwriting the table?

Which DataFrameReader method is commonly used in a Databricks notebook to read a batch of JSON files from cloud storage into a DataFrame for ingestion into Unity Catalog?

Keep studying — Prepare and process data