Practice Databricks-Certified-Associate-Data-Engineer Exam Online

Question 1

The data engineering team is using a SQL query to review data completeness every day to monitor the ETL job, and query output is being used in multiple dashboards which of the following approaches can be used to set up a schedule and automate this process?

A : They can schedule the query to run every day from the Jobs UI.

B : They can schedule the query to refresh every day from the query’s page in Databricks SQL

C : They can schedule the query to run every 12 hours from the Jobs UI.

D : They can schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.

E : They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL

Answer: B

Question 2

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, schema of the file is expected to change overtime ingestion process should be able to handle these changes automatically. Below is the auto loader to command to load the data, fill in the blanks for successful execution of below code.

spark.readStream

.format("cloudfiles")

.option("_______",”csv)

.option("_______", ‘dbfs:/location/checkpoint/’)

.load(data_source)

.writeStream

.option("_______",’ dbfs:/location/checkpoint/’)

.option("_______", "true")

.table(table_name))

A : format, checkpointlocation, schemalocation, overwrite

B : cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwrite

C : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema

D : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, append

E : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwrite

Answer: C

Question 3

Which of the following data workloads will utilize a gold table as its source?

A : A job that enriches data by parsing its timestamps into a human-readable format

B : A job that queries aggregated data that already feeds into a dashboard

C : A job that ingests raw data from a streaming source into the Lakehouse

D : A job that aggregates cleaned data to create standard summary statistics

E : A job that cleans data by removing malformatted records

Answer: B

Question 4

Which of the following is not a privilege in the Unity catalog?

A : SELECT

B : MODIFY

C : EXECUTE

D : CREATE

E : USAGE

Answer: C

Question 5

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

A : All 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 : All of the data and log are stored in a single parquet file

C : All 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 : All of the data is broken down into one or many parquet files, log file is removed once the transaction is committed.

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

Answer: A

Name:	Databricks Certified Data Engineer Associate
Exam Code:	Databricks-Certified-Associate-Data-Engineer
Certification:	Databricks Certified Associate
Vendor:	Databricks
Total Questions:	307
Last Updated:	Apr 23, 2024

Databricks Databricks-Certified-Associate-Data-Engineer