Databricks-Certified-Data-Engineer-Associate by Databricks Actual Free Exam Q&As

Question 1

A data engineer wants to delegate day-to-day permission management for the schema main marketing to the mkt-admins group, without making them workspace admins. They should be able to grant and revoke privileges for other users on objects within that schema.
Which approach aligns with UC's ownership and privilege model?

A. Grant MANAGE permissions on the metastore to mkt-admins, which allows managing privileges for all schemas and tables globally. B. Grant USE SCHEMA on main.marketing and MODIFY on all tables to mkt-admins, which enables managing grants within the schema. C. Make mkt-admins a workspace-level admins group, then SELECT on main.marketing to allow privilege delegation. D. Transfer ownership of the schema main.marketing to mkt-admins; owners can manage privileges on the schema and its contained objects.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

Which Databricks asset bundle format is valid?

A. resources { jobs { name = "hello-job" tasks{ task_key = "hello-task" existing_cluster_id = "1234-
567890-abcde123" notebook_task{ notebook_path = ".hello.py" } } } } B. resources: jobs: hello-job: name: hello-job tasks: - task_key: hello-task existing_cluster_id: 1234-
567890-abcde123 notebook_task: notebook_path: ./hello.py C. "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task",
"existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path":
".hello.py" } } } D. configuration = { "resources":{ "jobs":{ "name":"hello-job", "tasks":{ "task_key:"hello-task",
"existing_cluster_id":"1234-567890-abcde123", "notebook_task":{ "notebook_path":
".hello.py" } } } }

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

A data engineer wants to analyze historical versions of a Delta table to debug a data quality issue. The engineer needs to query the table as it existed two days ago. Which Delta Lake feature allows querying older snapshots of a table?

A. VACUUM B. Time Travel C. Z-Ordering D. OPTIMIZE

Discussion 0

Correct Answer: B Vote an answer

Question 4

A data engineer is maintaining an ETL pipeline code with a GitHub repository linked to their Databricks account. The data engineer wants to deploy the ETL pipeline to production as a databricks workflow. Which approach should the data engineer use?

A. Databricks Asset Bundles (DAB) + GitHub Integration B. Maintain workflow_config.json and deploy it using Databricks CLI C. Manually create and manage the workflow in UI D. Maintain workflow_config.json and deploy it using Terraform

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

A data engineer needs to ingest streaming data from Kafka into a Delta Lake table using Databricks. The pipeline must guarantee exactly-once processing semantics and maintain checkpoint information to recover from failures. Which Spark Structured Streaming feature ensures reliable processing and fault tolerance?

A. Partition pruning B. Checkpointing C. Watermarking D. Caching

Discussion 0

Correct Answer: B Vote an answer

Question 6

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions. In which location can the data engineer review their permissions on the table?

A. Jobs B. Repos C. Catalog Explorer D. Dashboards

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

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?

A. Accessing Delta Sharing data using a VPN within the same data center B. Utilizing Delta Sharing for internal data analytics within a single cloud environment C. Transferring data via Delta Sharing across clouds and across different geographic regions D. Sharing data within the same cloud provider and region

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

A data engineer has developed an ETL that produce a Delta managed table with liquid clustering feature activated as output. Several consumers are having issues regarding time delay when reading this table. How could the Data Engineer be sure about the OPTIMIZE command has been executed explicitly?

A. Use DESCRIBE DETAIL table to see the file size and number of files for the table B. Use DESCRIBE HISTORY table to check if exists any OPTIMIZE operation C. Use SHOW TABLES EXTENDED to check the partitions columns used D. Check the system table system.storage.predictive_optimization_operations_history

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

A data engineer is configuring Delta Sharing for a multi-team project where teams from different departments will need to access shared data. The data engineer has successfully created a Unity Catalog metastore and is now setting up the Delta Share. The goal is to ensure that internal teams can access the shared data with full permissions, while external partners can only read the data. Which action should the Data Engineer take to configure the sharing correctly?

A. Assign READ permissions to external partners through the Delta Share and READ/WRITE permissions to internal teams, and ensure the correct tables and views are shared. B. Create a Delta Share, set up a secure access URL for internal teams and external partners, and distribute the URL to provide them access to the shared data. C. Create a Delta Share, add the internal team's tables and views, and assign READ/WRITE permissions to both external partners and internal teams. D. Grant READ permissions to external partners and READ/WRITE permissions to internal teams through the Delta Share.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 10

A Databricks single-task workflow fails due to an error in a notebook. The data engineer fixes the mistake in the notebook.
What should the data engineer do to rerun the workflow?

A. Swap the cluster B. Restart the Cluster C. Repair the task D. Repair the run

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 11

Which two items are characteristics of the Gold Layer? (Choose two.)

A. De-normalised B. Read-optimized C. Historical lineage D. Raw Data E. Normalised

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 12

A data engineer is working with two tables. Each of these tables is displayed below in its entirety.

The data engineer runs the following query to join these tables together:

Which of the following will be returned by the above query?

Discussion 0

Correct Answer: A Vote an answer

Question 13

In a healthcare provider organization using Delta Lake to store electronic health records (EHRs), a data analyst needs to analyze a snapshot of the patient_records table from two weeks ago before some recent data corrections were applied. What approach should the Data Engineer take to allow the analyst to query that specific prior version?

A. Truncate the table to remove all data, then reload the data from two weeks ago into the truncated table for the analyst to query. B. Identify the version number corresponding to two weeks ago from the Delta transaction log, share that version number with the analyst to query using VERSION AS OF syntax, or export that version to a new Delta table for the analyst to query. C. Restore the table to the version from two weeks ago using the RESTOREcommand, and have the analyst query the restored table. D. Use the VACUUMcommand to remove all versions of the table older than two weeks, then the analyst can query the remaining version.

Discussion 0

Correct Answer: B Vote an answer

Question 14

In which of the following file formats is data from Delta Lake tables primarily stored?

A. Delta B. CSV C. JSON D. A proprietary, optimized format specific to Databricks E. Parquet

Discussion 0

Correct Answer: E Vote an answer

Question 15

A data engineer wants to delete records from a Delta table where the status column equals
"inactive". The operation should modify only the affected rows without rewriting the entire dataset.
Which SQL command should be used?

A. INSERT B. MERGE C. DELETE D. UPDATE

Discussion 0

Correct Answer: C Vote an answer

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