A data engineer needs to incrementally load new CSV files that arrive hourly into an existing Delta table in Unity Catalog. The files are in an external location and may contain duplicate records if the same file is reprocessed. The engineer wants to use a SQL statement that handles schema inference and deduplication. Which SQL statement should they use?

COPY INTO sales.events FROM '/mnt/external/events' FILEFORMAT = CSV WITH (HEADER = true, INFERSCHEMA = true)

INSERT INTO sales.events SELECT * FROM csv.`/mnt/external/events`

CREATE TABLE IF NOT EXISTS sales.events USING DELTA AS SELECT * FROM csv.`/mnt/external/events`

CREATE OR REPLACE TABLE sales.events USING DELTA AS SELECT * FROM csv.`/mnt/external/events`

In a Databricks notebook, which method is used to read streaming data from a directory of files into a streaming DataFrame?

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

spark.readStream.table("table")

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

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

A data engineer needs to create a new Unity Catalog table from a Parquet file in ADLS Gen2. The table should be created only if it does not already exist; if it exists, the ingestion should fail. The engineer wants to use SQL. Which SQL statement should the engineer use?

CREATE TABLE IF NOT EXISTS ... AS SELECT * FROM parquet.`path`

CREATE OR REPLACE TABLE ... AS SELECT * FROM parquet.`path`

INSERT INTO ... SELECT * FROM parquet.`path`

COPY INTO ... FROM 'path' FILEFORMAT = PARQUET

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 3Objective 2

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

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 41–44

41application · medium
A data engineer needs to incrementally load new CSV files that arrive hourly into an existing Delta table in Unity Catalog. The files are in an external location and may contain duplicate records if the same file is reprocessed. The engineer wants to use a SQL statement that handles schema inference and deduplication. Which SQL statement should they use?
Select an answer first
42foundation · easy
What is the primary destination for tables created by Lakeflow Connect batch ingestion jobs?
Select an answer first
43foundation · easy
In a Databricks notebook, which method is used to read streaming data from a directory of files into a streaming DataFrame?
Select an answer first
44application · medium
A data engineer needs to create a new Unity Catalog table from a Parquet file in ADLS Gen2. The table should be created only if it does not already exist; if it exists, the ingestion should fail. The engineer wants to use SQL. Which SQL statement should the engineer use?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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 9)

Questions 41–44

What is the primary destination for tables created by Lakeflow Connect batch ingestion jobs?

In a Databricks notebook, which method is used to read streaming data from a directory of files into a streaming DataFrame?

A data engineer needs to create a new Unity Catalog table from a Parquet file in ADLS Gen2. The table should be created only if it does not already exist; if it exists, the ingestion should fail. The engineer wants to use SQL. Which SQL statement should the engineer use?

Keep studying — Prepare and process data