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

A data engineering team needs to incrementally ingest customer transactions from a SaaS app into Data Intelligence Platform with:
- Built-in change data capture (including updates and deletes)
- Automatic schema evolution
- Serverless execution with retries and minimal maintenance
- OAuth support and basic monitoring
Which solution meets all of these requirements?

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables. Which change will need to be made to the pipeline when migrating to Delta Live Tables?

A data engineering team needs to integrate two data sources into Databricks:
- Clickstream Events: Ingesting 5,000 events per second from an Apache
Kafka topic.
- Customer Master Data: Syncing only changed records every 4 hours from a Snowflake database.
The solution must meet two key requirements:
- Process the streaming clickstream data with a latency of under 30
seconds.
- Prevent the reprocessing of customer master data that has not
changed.
Which data ingestion approach meets these requirements?

A data engineer triggers a scheduled job but finds that the new run was not executed. The run history shows the run was skipped with a concurrency-related queue message. Which configuration should the engineer investigate?

Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?

A data engineer is onboarding a new bronze ingestion pipeline in Databricks with Unity Catalog.
The team wants Databricks to handle storage layout, apply platform optimizations over time, and simplify lifecycle management so that when a table is dropped, its underlying data is also cleaned up according to Databricks-managed retention policies.
Which table type should the data engineer create for these ingestion tables?

A data engineering project involves processing large batches of data on a daily schedule using ETL. The jobs are resource-intensive and vary in size, requiring a scalable, cost-efficient compute solution that can automatically scale based on the workload. Which compute approach will satisfy the needs described?

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?

A data engineer has inherited a Databricks pipeline from a previous team. The pipeline is missing SLAs and costs more than the allotted budget. On analysis, it is noted that the cluster is not being fully utilized, and the dataset is getting skewed. How should the data engineer resolve this issue?

A data engineer is designing a bronze-to-silver pipeline on the Databricks Data Intelligence Platform. The source system sends daily CSV files, and over time, new optional columns are added.
The data engineer wants a storage format and table feature that together ensure the following:
- The table prevents writes that do not conform to the defined schema.
- The table can evolve its schema to include new optional columns
without having to manually recreate the table.
- Previous versions of the table can be queried later for debugging and auditing.
Which solution fulfills the requirements?

An analyst reports that a dashboard showed incorrect numbers before a data correction was applied at 09:00 today. The engineer needs to query the table exactly as it existed at version 118.
Which statement returns that data?

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer's Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team.
Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?