Free Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions

Become Databricks Certified with updated Databricks-Certified-Associate-Data-Engineer exam questions and correct answers

Page: 1 / 63

Total 315 Questions | Updated On: Nov 13, 2024

Add To Cart

Question 1

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.

Which command could the data engineering team use to access sales in PySpark?

A : SELECT * FROM sales

B : spark.table("sales")

C : spark.sql("sales")

D : spark.delta.table("sales")

Answer: B

Question 2

A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.

Which of the following approaches can be used to identify the owner of new_table?

A : Review the Permissions tab in the table's page in Data Explorer

B : All of these options can be used to identify the owner of the table

C : Review the Owner field in the table's page in Data Explorer

D : Review the Owner field in the table's page in the cloud storage solution

E : There is no way to identify the owner of the table

Answer: C

Question 3

The data engineering team is looking to add a new column to the table, but the QA team would like to test the change which of the below options allow you to quickly copy the table from Prod to QA environment, modify and run the tests

A : EP CLONE

B : ADOW CLONE

C : ZERO COPY CLONE

D : ALLOW CLONE

E : TADATA CLONE

Answer: D

Question 4

Which of the following is a correct statement on how the data is organized in the storage when when managing a DELTA table?

A : l of the data is broken down into one or many parquet files, log files are broken down into one or many JSON files, and each transaction creates a new data file(s) and log file.

B : l of the data and log are stored in a single parquet file

C : l of the data is broken down into one or many parquet files, but the log file is stored as a single json file, and every transaction creates a new data file(s) and log file gets appended.

D : l of the data is broken down into one or many parquet files, log file is removed once the transaction is committed.

E : l of the data is stored into one parquet file, log files are broken down into one or many json files.

Answer: A

Question 5

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.

spark.table("source_table")

.writeStream

.option("____", “dbfs:/location/silver")

.outputMode("____")

.trigger(Once=____)

.table("target_table")

A : eckpointlocation, complete, True

B : rgetlocation, overwrite, True

C : eckpointlocation, True, overwrite

D : eckpointlocation, True, complete

E : eckpointlocation, overwrite, True

Answer: A

Page: 1 / 63

Total 315 Questions | Updated On: Nov 13, 2024

Add To Cart