Databricks DATABRICKS Practice Questions

The latest changes and updates from the administration for this exam.

verified

Latest Update: May 14 2026

All questions are working fine.

All Questions (225)bookmarkBookmarked (0)

All225Show all accessible questions in this exam.Missed225Questions you haven't attempted yet.Incorrect0Questions you answered incorrectly on your last attempt.

Question 21

Sales team is looking to get a report on a measure number of units sold by date, below is the schema. Fill in the blank with the appropriate array function.

Table orders: orderDate DATE, orderIds ARRAY<INT>

Table orderDetail: orderId INT, unitsSold INT, salesAmt DOUBLE

Question 22

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

Python function cannot return a DataFrame

Write SQL UDF to return a DataFrame

Write SQL UDF that can return tabular data

Python function will result in out of memory error due to data volume

Python function can return a DataFrame

Question 23

What is the output of the below function when executed with input parameters 1, 3 :

check_input(1,3)

Question 24

Which of the following SQL statements can replace a python variable, when the notebook is set in SQL mode

spark.sql(f"SELECT * FROM f{schema_name.table_name}")

spark.sql(f"SELECT * FROM {schem_name.table_name}")

spark.sql(f"SELECT * FROM ${schema_name}.${table_name}")

spark.sql(f"SELECT * FROM {schema_name}.{table_name}")

spark.sql("SELECT * FROM schema_name.table_name")

Question 25

When writing streaming data, Spark’s structured stream supports the below write modes

Question 26

When using the complete mode to write stream data, how does it impact the target table?

Entire stream waits for complete data to write

Stream must complete to write the data

Target table cannot be updated while stream is pending

Target table is overwritten for each batch

Delta commits transaction once the stream is stopped

Question 27

At the end of the inventory process a file gets uploaded to the cloud object storage, you are asked to build a process to ingest data which of the following method can be used to ingest the data incrementally, the schema of the file is expected to change overtime ingestion process should be able to handle these changes automatically. Below is the auto loader command to load the data, fill in the blanks for successful execution of the below code.

checkpointlocation, schemalocation

checkpointlocation, cloudfiles.schemalocation

schemalocation, checkpointlocation

cloudfiles.schemalocation, checkpointlocation

cloudfiles.schemalocation, cloudfiles.checkpointlocation

Question 28

When working with AUTO LOADER you noticed that most of the columns that were inferred as part of loading are string data types including columns that were supposed to be integers, how can we fix this?

Provide the schema of the source table in the cloudfiles.schemalocation

Provide the schema of the target table in the cloudfiles.schemalocation

Provide schema hints

Update the checkpoint location

Correct the incoming data by explicitly casting the data types

Question 29

You have configured AUTO LOADER to process incoming IOT data from cloud object storage every 15 mins, recently a change was made to the notebook code to update the processing logic but the team later realized that the notebook was failing for the last 24 hours, what steps team needs to take to reprocess the data that was not loaded after the notebook was corrected?

Move the files that were not processed to another location and manually copy the files into the ingestion path to reprocess them

Enable back_fill = TRUE to reprocess the data

Delete the checkpoint folder and run the autoloader again

Autoloader automatically re-processes data that was not loaded

Manually re-load the data

Question 30

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

Update History

Update History