Databricks Certified Data Engineer Professional (DATABRICKS) - DataBricks Actual Exam Questions
Last updated on April 15, 2026
Which of the following code blocks returns about 150 randomly selected rows from the 1000-row DataFrame transactionsDf, assuming that any row can appear more than once in the returned DataFrame?
transactionsDf.resample(0.15, False, 3142)
transactionsDf.sample(0.15, False, 3142)
transactionsDf.sample(0.15)
transactionsDf.sample(0.85, 8429)
transactionsDf.sample(True, 0.15, 8261)
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following statements about Spark's DataFrames is incorrect?
Spark's DataFrames are immutable.
Spark's DataFrames are equal to Python's DataFrames.
Data in DataFrames is organized into named columns.
RDDs are at the core of DataFrames.
The data in DataFrames may be split into multiple chunks.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Which of the following code blocks adds a column predErrorSqrt to DataFrame transactionsDf that is the square root of column predError?
transactionsDf.withColumn("predErrorSqrt", sqrt(predError))
transactionsDf.select(sqrt(predError))
transactionsDf.withColumn("predErrorSqrt", col("predError").sqrt())
transactionsDf.withColumn("predErrorSqrt", sqrt(col("predError")))
transactionsDf.select(sqrt("predError"))
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
The code block displayed below contains an error. The code block is intended to return all columns of DataFrame transactionsDf except for columns predError, productId, and value. Find the error. Excerpt of DataFrame transactionsDf: transactionsDf.select(~col("predError"), ~col("productId"), ~col("value"))
The select operator should be replaced by the drop operator and the arguments to the drop operator should be column names predError, productId and value wrapped in the col operator so they should be expressed like drop(col(predError), col(productId), col(value)).
The select operator should be replaced with the deselect operator.
The column names in the select operator should not be strings and wrapped in the col operator, so they should be expressed like select(~col(predError), ~col(productId), ~col(value)).
The select operator should be replaced by the drop operator.
The select operator should be replaced by the drop operator and the arguments to the drop operator should be column names predError, productId and value as strings. (Correct)
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
The code block shown below should return a new 2-column DataFrame that shows one attribute from column attributes per row next to the associated itemName, for all suppliers in column supplier whose name includes Sports. Choose the answer that correctly fills the blanks in the code block to accomplish this. Sample of DataFrame itemsDf: 1. +------+----------------------------------+-----------------------------+-------------------+ 2. |itemId|itemName |attributes |supplier | 3. +------+----------------------------------+-----------------------------+-------------------+ 4. |1 |Thick Coat for Walking in the Snow|[blue, winter, cozy] |Sports Company Inc.| 5. |2 |Elegant Outdoors Summer Dress |[red, summer, fresh, cooling]|YetiX | 6. |3 |Outdoors Backpack |[green, summer, travel] |Sports Company Inc.| 7. +------+----------------------------------+-----------------------------+-------------------+ Code block: itemsDf.__1__(__2__).select(__3__, __4__)
1. filter 2. col("supplier").isin("Sports") 3. "itemName" 4. explode(col("attributes"))
1. where 2. col("supplier").contains("Sports") 3. "itemName" 4. "attributes"
1. where 2. col(supplier).contains("Sports") 3. explode(attributes) 4. itemName
1. where 2. "Sports".isin(col("Supplier")) 3. "itemName" 4. array_explode("attributes")
1. filter 2. col("supplier").contains("Sports") 3. "itemName" 4. explode("attributes")
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.