Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70track

Free Databricks Databricks-Certified-Data-Engineer-Associate Practice Exam with Questions & Answers | Set: 4

Questions 31

Which method should a Data Engineer apply to ensure Workflows are being triggered on schedule?

Options:
A.

Scheduled Workflows require an always-running cluster, which is more expensive but reduces processing latency.

B.

Scheduled Workflows process data as it arrives at configured sources.

C.

Scheduled Workflows can reduce resource consumption and expense since the cluster runs only long enough to execute the pipeline.

D.

Scheduled Workflows run continuously until manually stopped.

Questions 32

A team creates YAML manifests that declare jobs, resources, and dependencies, then deploys them to Databricks using the Databricks CLI . The deployment succeeds.

Which feature are they using?

Options:
A.

Databricks Asset Bundles

B.

GitHub

C.

Terraform

D.

DataOps

Questions 33

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.

Databricks-Certified-Data-Engineer-Associate Question 33

The code block used by the data engineer is below:

Which line of code should the data engineer use to fill in the blank if the data engineer only wants the query to execute a micro-batch to process data every 5 seconds?

Options:
A.

trigger( " 5 seconds " )

B.

trigger(continuous= " 5 seconds " )

C.

trigger(once= " 5 seconds " )

D.

trigger(processingTime= " 5 seconds " )

Questions 34

A data engineer is managing a data pipeline in Databricks, where multiple Delta tables are used for various transformations. The team wants to track how data flows through the pipeline, including identifying dependencies between Delta tables, notebooks, jobs, and dashboards. The data engineer is utilizing the Unity Catalog lineage feature to monitor this process.

How does Unity Catalog’s data lineage feature support the visualization of relationships between Delta tables, notebooks, jobs, and dashboards?

Options:
A.

Unity Catalog lineage visualizes dependencies between Delta tables, notebooks, and jobs, but does not provide column-level tracing or relationships with dashboards.

B.

Unity Catalog lineage only supports visualizing relationships at the table level and does not extend to notebooks, jobs, or dashboards.

C.

Unity Catalog lineage provides an interactive graph that tracks dependencies between tables and notebooks but excludes any job-related dependencies or dashboard visualizations.

D.

Unity Catalog provides an interactive graph that visualizes the dependencies between Delta tables, notebooks, jobs, and dashboards, while also supporting column-level tracking of data transformations.

Questions 35

A data engineer has finished developing a new Declarative Automation Bundle, formerly known as a Databricks Asset Bundle, for a streaming pipeline. The engineer must verify that the configuration is syntactically correct, deploy the code to the workspace, and finally trigger the pipeline to confirm that it runs as expected.

Which sequence of Databricks CLI commands performs these steps in the correct order?

Options:
A.

databricks bundle init → databricks bundle deploy → databricks bundle run

B.

databricks bundle validate → databricks bundle deploy → databricks bundle run

C.

databricks bundle validate → databricks bundle sync → databricks bundle execute

D.

databricks bundle check → databricks bundle upload → databricks bundle start

Questions 36

An organization plans to share a large dataset stored in a Databricks workspace on AWS with a partner organization whose Databricks workspace is hosted on Azure. The data engineer wants to minimize data transfer costs while ensuring secure and efficient data sharing.

Which strategy will reduce data egress costs associated with cross-cloud data sharing?

Options:
A.

Sharing data via pre-signed URLs without monitoring egress costs

B.

Migrating the dataset to Cloudflare R2 object storage before sharing

C.

Configure VPN connection between AWS and Azure for faster data sharing

D.

Using Delta Sharing without any additional configurations

Questions 37

A global retail company sells products across multiple categories (e.g.. Electronics, Clothing) and regions (e.g.. North. South, East. West). The sales team has provided the data engineer with a PySpark dataframe named sales_df as below and the team wants the data engineer to analyze the sales data to help them make strategic decisions.

Databricks-Certified-Data-Engineer-Associate Question 37

Options:
A.

Category_sales = sales df.groupBy( " category " ).agg(sum( " sales amount " ) .alias ( " total sales amount " ))

B.

Category_sales = sales_df.sum( " 3ales_amount " ). g-1- upBy( " categcryn).alias( " toLal_sales_amount))

C.

Category_sale: .es df -agg (sum ( " sales amount " ) .-;r*i:rRy ( " category " ) .alias ( " total sa.en amount " ))

D.

Category_sales = sales_df.groupBy( " reqion " ). agq(sum( " sales_amountn).alias(ntotal_sales_amount ' ' ))

Questions 38

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

Options:
A.

A data lakehouse provides storage solutions for structured and unstructured data.

B.

A data lakehouse supports ACID-compliant transactions.

C.

A data lakehouse allows the use of SQL queries to examine data.

D.

A data lakehouse stores data in open formats.

E.

A data lakehouse enables machine learning and artificial Intelligence workloads.

Questions 39

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?

Options:
A.

Databricks account representative

B.

This transfer is not possible

C.

Workspace administrator

D.

New lead data engineer

E.

Original data engineer

Questions 40

Which Databricks Asset Bundle format is valid?

Options:
A.

resources:

jobs:

hello-job:

name: hello-job

tasks:

- task_key: hello-task

existing_cluster_id: 1234-567890-abcde123

notebook_task:

notebook_path: ./hello.py

B.

{

" resources " : {

" jobs " : {

" name " : " hello-job " ,

" tasks " : {

" task_key " : " hello-task " ,

" existing_cluster_id " : " 1234-567890-abcde123 " ,

" notebook_task " : {

" notebook_path " : " ./hello.py "

}

}

}

}

}

C.

configuration = {

" resources " : {

" jobs " : {

" name " : " hello-job " ,

" tasks " : {

" task_key " : " hello-task " ,

" existing_cluster_id " : " 1234-567890-abcde123 " ,

" notebook_task " : {

" notebook_path " : " ./hello.py "

}

}

}

}

}

D.

resources {

jobs {

name = " hello-job "

tasks {

task_key = " hello-task "

existing_cluster_id = " 1234-567890-abcde123 "

notebook_task {

notebook_path = " ./hello.py "

}

}

}

}