Online Access Free Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-02-09.q22 Practice Test (Page 2)

Databricks-Certified-Professional-Data-Engineer Exam Question 1

Which of the following describes a scenario in which a data engineer will want to use a Job cluster instead of
an all-purpose cluster?

A.An ad-hoc analytics report needs to be developed while minimizing compute costs

B.A Databricks SQL query needs to be scheduled for upward reporting

C.A data engineer needs to manually investigate a production error

D.An automated workflow needs to be run every 30 minutes

E.A data team needs to collaborate on the development of a machine learning model

Databricks-Certified-Professional-Data-Engineer Exam Question 2

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above
format regardless of whether a table already exists with this name?

A.1. CREATE TABLE table_name AS
2. SELECT id STRING, birthDate DATE, avgRating FLOAT

B.1. CREATE TABLE IF NOT EXISTS table_name ( id STRING, birthDate DATE, avgRating FLOAT )

C.1. CREATE OR REPLACE TABLE table_name AS
2. SELECT id STRING, birthDate DATE, avgRating FLOAT USING DELTA

D.1. CREATE OR REPLACE TABLE table_name ( id STRING, birthDate DATE, avgRating FLOAT )

E.1. CREATE OR REPLACE TABLE table_name
2. WITH COLUMNS ( id STRING, birthDate DATE, avgRating FLOAT ) USING DELTA

Databricks-Certified-Professional-Data-Engineer Exam Question 3

Which of the following Structured Streaming queries is performing a hop from a Bronze table to a Silver
table?

A.1. (spark.read.load(rawSalesLocation)
2. .writeStream
3. .option("checkpointLocation", checkpointPath)
4. .outputMode("append")
5. .table("uncleanedSales")
6. )

B.1. (spark.table("sales")
2. .agg(sum("sales"),
3. sum("units"))
4. .writeStream
5. .option("checkpointLocation", checkpointPath)
6. .outputMode("complete")
7. .table("aggregatedSales")
8. )

C.1. (spark.readStream.load(rawSalesLocation)
2. .writeStream
3. .option("checkpointLocation", checkpointPath)
4. .outputMode("append")
5. .table("uncleanedSales")
6. )

D.1. (spark.table("sales")
2. .withColumn("avgPrice", col("sales") / col("units"))
3. .writeStream
4. .option("checkpointLocation", checkpointPath)
5. .outputMode("append")
6. .table("cleanedSales")
7.)

E.1. (spark.table("sales")
2. .groupBy("store")
3. .agg(sum("sales"))
4. .writeStream
5. .option("checkpointLocation", checkpointPath)
6. .outputMode("complete")
7. .table("aggregatedSales")
8.)

Databricks-Certified-Professional-Data-Engineer Exam Question 4

A junior data engineer has ingested a JSON file into a table raw_table with the following schema:
1. cart_id STRING,
2. items ARRAY<item_id:STRING>
The junior data engineer would like to unnest the items column in raw_table to result in a new table with the
following schema:
1.cart_id STRING,
2.item_id STRING
Which of the following commands should the junior data engineer run to complete this task?

A.1. SELECT cart_id, flatten(items) AS item_id
2. FROM raw_table;

B.1. SELECT cart_id, filter(items) AS item_id
2. FROM raw_table;

C.1. SELECT cart_id, slice(items) AS item_id
2. FROM raw_table;

D.1. SELECT cart_id, explode(items) AS item_id
2. FROM raw_table;

E.1. SELECT cart_id, reduce(items) AS item_id
2. FROM raw_table;

Databricks-Certified-Professional-Data-Engineer Exam Question 5

A data engineer has written the following query:
1. SELECT *
2. FROM json.`/path/to/json/file.json`;
The data engineer asks a colleague for help to convert this query for use in a Delta Live Tables (DLT)
pipeline. The query should create the first table in the DLT pipeline.
Which of the following describes the change the colleague needs to make to the query?

A.They need to add a live. prefix prior to json. in the FROM line

B.They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query

C.They need to add the cloud_files(...) wrapper to the JSON file path

D.They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query

E.They need to add a COMMENT line at the beginning of the query

Other Version: 1445Databricks.Databricks-Certified-Professional-Data-Engineer.v2026-04-08.q86; 2052Databricks.Databricks-Certified-Professional-Data-Engineer.v2025-06-26.q60; 2925Databricks.Databricks-Certified-Professional-Data-Engineer.v2024-11-21.q117; 915Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-10-09.q24; 2657Databricks.Databricks-Certified-Professional-Data-Engineer.v2023-03-10.q102; 1243Databricks.Databricks-Certified-Professional-Data-Engineer.v2022-09-06.q21

Latest Upload: 122ASQ.CSQE.v2026-07-20.q115; 112IAPP.CIPP-CN.v2026-07-20.q83; 127Oracle.1Z0-082.v2026-07-20.q79; 124Cisco.400-007.v2026-07-20.q225; 117Salesforce.Salesforce-Contact-Center.v2026-07-20.q85; 118Fortinet.NSE6_SDW_AD-7.6.v2026-07-20.q51; 117Oracle.1Z0-171.v2026-07-20.q53; 117Oracle.1Z0-1078-26.v2026-07-20.q36; 109CompTIA.N10-009.v2026-07-20.q260; 112Microsoft.AI-900-CN.v2026-07-20.q166

Databricks-Certified-Professional-Data-Engineer Exam Question 1

Databricks-Certified-Professional-Data-Engineer Exam Question 2

Databricks-Certified-Professional-Data-Engineer Exam Question 3

Databricks-Certified-Professional-Data-Engineer Exam Question 4

Databricks-Certified-Professional-Data-Engineer Exam Question 5

Download PDF File