Free Databricks Certified Data Engineer Associate Exam Databricks-Certified-Data-Engineer-Associate Exam Practice Test

Which of the following Git operations must be performed outside of Databricks Repos?

• Commit
• Pull
• Push
• Clone
• Merge

Which of the following data lakehouse features results in improved data quality over a traditional data lake?

• A data lakehouse provides storage solutions for structured and unstructured data.
• A data lakehouse supports ACID-compliant transactions.
• A data lakehouse allows the use of SQL queries to examine data.
• A data lakehouse stores data in open formats.
• A data lakehouse enables machine learning and artificial Intelligence workloads.

Which of the following commands will return the location of database customer360?

• DESCRIBE LOCATION customer360;
• DROP DATABASE customer360;
• DESCRIBE DATABASE customer360;
• ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• USE DATABASE customer360;

Which of the following benefits is provided by the array functions from Spark SQL?

• An ability to work with data in a variety of types at once
• An ability to work with data within certain partitions and windows
• An ability to work with time-related data in specified intervals
• An ability to work with complex, nested data ingested from JSON files
• An ability to work with an array of tables for procedural automation

A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

• Databricks Repos automatically saves development progress
• Databricks Repos supports the use of multiple branches
• Databricks Repos allows users to revert to previous versions of a notebook
• Databricks Repos provides the ability to comment on specific changes
• Databricks Repos is wholly housed within the Databricks Lakehouse Platform

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

In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?

• Checkpointing and Write-ahead Logs
• Structured Streaming cannot record the offset range of the data being processed in each trigger.
• Replayable Sources and Idempotent Sinks
• Write-ahead Logs and Idempotent Sinks
• Checkpointing and Idempotent Sinks

A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job’s current run. The data engineer asks a tech lead for help in identifying why this might be the case.Which of the following approaches can the tech lead use to identify why the notebook is running slowly as part of the Job?

• They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.
• They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.
• They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.
• There is no way to determine why a Job task is running slowly.
• They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.

A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?

• They can use endpoints available in Databricks SQL
• They can use jobs clusters instead of all-purpose clusters
• They can configure the clusters to be single-node
• They can use clusters that are from a cluster pool
• They can configure the clusters to autoscale for larger data sizes

A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also used by other processes. As a result, the files should be kept as is and will accumulate in the directory. The data engineer needs to identify which files are new since the previous run in the pipeline, and set up the pipeline to only ingest those new files with each run.Which of the following tools can the data engineer use to solve this problem?

• Unity Catalog
• Delta Lake
• Databricks SQL
• Data Explorer
• Auto Loader