Databricks Databricks-Certified-Data-Engineer-Associate Actual Free Exam Questions & Community Discussion
A data engineer needs to reduce the number of small files generated during streaming ingestion into Delta tables. Small files are causing performance issues during downstream queries. Which Delta Lake feature automatically compacts small files during writes?
Correct Answer: C
Vote an answer
A company uses Delta Sharing to collaborate with partners across different cloud providers and geographic regions. What will result in additional costs due to cross-region or egress fees?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A data engineer is building a PySpark ingestion pipeline in a local IDE and must execute heavy DataFrame transformations on a remote Databricks cluster for scale while stepping through business logic locally. The workspace uses Unity Catalog and a cluster running Databricks Runtime 15.4 LTS. The engineer also plans to register UDFs.
What should the data engineer do to avoid runtime issues during development with Databricks Connect?
What should the data engineer do to avoid runtime issues during development with Databricks Connect?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A data engineer team has decided to implement a new data platform on Databricks and is currently deciding how to store each kind of data on each data layer. What is the appropriate layer and data pairing for medallion architecture?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A data engineer wants to optimize query performance for a Delta table storing billions of records.
Queries frequently filter on the column transaction_date. Which Delta Lake feature should be applied to physically organize the data and reduce the amount of data scanned during query execution?
Queries frequently filter on the column transaction_date. Which Delta Lake feature should be applied to physically organize the data and reduce the amount of data scanned during query execution?
Correct Answer: C
Vote an answer
A data engineer is implementing a data pipeline using Databricks notebooks. The engineer wants to share parameters such as file paths and processing dates across multiple tasks within a job.
Which Databricks utility enables parameter passing?
Which Databricks utility enables parameter passing?
Correct Answer: B
Vote an answer
A data engineer needs to conduct Exploratory Analysis on data residing in a database that is within the company's custom-defined network in the cloud. The data engineer is using SQL for this task. Which type of SQL Warehouse will enable the data engineer to process large numbers of queries quickly and cost-effectively?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A data engineer is working in a Databricks notebook to design and manage a batch ETL pipeline.
The engineer is writing SQL and Python code to clean data, transform it, and join large datasets from different sources. The engineer wants to organize these steps into a structured process that can be run regularly and scheduled as part of a data pipeline. Which Databricks notebook feature is applicable in the use case?
The engineer is writing SQL and Python code to clean data, transform it, and join large datasets from different sources. The engineer wants to organize these steps into a structured process that can be run regularly and scheduled as part of a data pipeline. Which Databricks notebook feature is applicable in the use case?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
What can be used to simplify and unify siloed data architectures that are specialized for specific use cases?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
A data engineer notices that a Spark job repeatedly scans a large Delta table even though the dataset does not change during the session. Which technique can store the dataset in memory to speed up repeated queries?
Correct Answer: C
Vote an answer
A data engineer notices that a Spark job performing a join between a large table and a small lookup table is slow. The lookup table is only a few megabytes. Which Spark optimization technique should be applied to improve the performance of the join operation?
Correct Answer: A
Vote an answer
Which of the following benefits of using the Databricks Lakehouse Platform is provided by Delta Lake?
Correct Answer: D
Vote an answer
0
0
0
10