2023 Databricks-Certified-Professional-Data-Engineer Question Bank Free PDF Download Recently Updated Questions [Q53-Q75]

QUESTION 53
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?

QUESTION 54
you are currently working on creating a spark stream process to read and write in for a one-time micro batch, and also rewrite the existing target table, fill in the blanks to complete the below command sucesfully.
1.spark.table(“source_table”)
2..writeStream
3..option(“____”, “dbfs:/location/silver”)
4..outputMode(“____”)
5..trigger(Once=____)
6..table(“target_table”)

QUESTION 55
Which of the following commands can be used to run one notebook from another notebook?

QUESTION 56
Below sample input data contains two columns, one cartId also known as session id, and the second column is called items, every time a customer makes a change to the cart this is stored as an array in the table, the Marketing team asked you to create a unique list of item’s that were ever added to the cart by each customer, fill in blanks by choosing the appropriate array function so the query produces below expected result as shown below.
Schema: cartId INT, items Array<INT>
Sample Data

1.SELECT cartId, ___ (___(items)) as items
2.FROM carts GROUP BY cartId
Expected result:
cartId items
1 [1,100,200,300,250]

QUESTION 57
How does a Delta Lake differ from a traditional data lake?

QUESTION 58
You are working on IOT data where each device has 5 reading in an array collected in Celsius, you were asked to covert each individual reading from Celsius to Fahrenheit, fill in the blank with an appropriate function that can be used in this scenario.
Schema: deviceId INT, deviceTemp ARRAY<double>

SELECT deviceId, __(deviceTempC,i-> (i * 9/5) + 32) as deviceTempF
FROM sensors

QUESTION 59
You are asked to write a python function that can read data from a delta table and return the Data-Frame, which of the following is correct?

QUESTION 60
A data engineer wants to create a relational object by pulling data from two tables. The relational object must
be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to
avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

QUESTION 61
Which of the following data workloads will utilize a Bronze table as its destination?

QUESTION 62
How do you create a delta live tables pipeline and deploy using DLT UI?

QUESTION 63
A data analyst has provided a data engineering team with the following Spark SQL query:
1.SELECT district,
2.avg(sales)
3.FROM store_sales_20220101
4.GROUP BY district;
The data analyst would like the data engineering team to run this query every day. The date at the end of the
table name (20220101) should automatically be replaced with the current date each time the query is run.
Which of the following approaches could be used by the data engineering team to efficiently auto-mate this
process?

QUESTION 64
A data analyst has noticed that their Databricks SQL queries are running too slowly. They claim that this issue
is affecting all of their sequentially run queries. They ask the data engineering team for help. The data
engineering team notices that each of the queries uses the same SQL endpoint, but the SQL endpoint is not
used by any other user.
Which of the following approaches can the data engineering team use to improve the latency of the data
analyst’s queries?

QUESTION 65
Which of the following Structured Streaming queries successfully performs a hop from a Silver to Gold table?

QUESTION 66
Which of the following commands will return records from an existing Delta table my_table where duplicates
have been removed?

QUESTION 67
What is the best way to describe a data lakehouse compared to a data warehouse?

QUESTION 68
What is the main difference between the bronze layer and silver layer in a medallion architecture?

QUESTION 69
Which of the statement is correct about the cluster pools?

QUESTION 70
What are the different ways you can schedule a job in Databricks workspace?

QUESTION 71
What is the probability that the total of two dice will be greater than 8, given that the first die is a 6?

QUESTION 72
What type of table is created when you create delta table with below command?
CREATE TABLE transactions USING DELTA LOCATION “DBFS:/mnt/bronze/transactions”

QUESTION 73
Which of the statements are incorrect when choosing between lakehouse and Datawarehouse?

QUESTION 74
Which of the following describes how Databricks Repos can help facilitate CI/CD workflows on the
Databricks Lakehouse Platform?

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