Databricks Databricks-Certified-Professional-Data-Engineer Quiz 1 Topic 1 Questions 1-5

Question: 1

The downstream consumers of a Delta Lake table have been complaining about data quality issues impacting performance in their applications. Specifically, they have complained that invalid latitude and longitude values in the activity_details table have been breaking their ability to use other geolocation processes.

A junior engineer has written the following code to add CHECK constraints to the Delta Lake table:

q1_Databricks-Certified-Professional-Data-Engineer

A senior engineer has confirmed the above logic is correct and the valid ranges for latitude and longitude are provided, but the code fails when executed.

Which statement explains the cause of this failure?

ABecause another team uses this table to support a frequently running application, two-phase locking is preventing the operation from committing.

BThe activity details table already exists; CHECK constraints can only be added during initial table creation.

CThe activity details table already contains records that violate the constraints; all existing data must pass CHECK constraints in order to add them to an existing table.

DThe activity details table already contains records; CHECK constraints can only be added prior to inserting values into a table.

EThe current table schema does not contain the field valid coordinates; schema evolution will need to be enabled before altering the table to add a constraint.

Show Answer

Question: 2

The data governance team is reviewing code used for deleting records for compliance with GDPR. They note the following logic is used to delete records from the Delta Lake table named users.

q2_Databricks-Certified-Professional-Data-Engineer

Assuming that user_id is a unique identifying key and that delete_requests contains all users that have requested deletion, which statement describes whether successfully executing the above logic guarantees that the records to be deleted are no longer accessible and why?

AYes; Delta Lake ACID guarantees provide assurance that the delete command succeeded fully and permanently purged these records.

BNo; the Delta cache may return records from previous versions of the table until the cluster is restarted.

CYes; the Delta cache immediately updates to reflect the latest data files recorded to disk.

DNo; the Delta Lake delete command only provides ACID guarantees when combined with the merge into command.

ENo; files containing deleted records may still be accessible with time travel until a vacuum command is used to remove invalidated data files.

Show Answer

Question: 3

Each configuration below is identical to the extent that each cluster has 400 GB total of RAM, 160 total cores and only one Executor per VM.

Given a job with at least one wide transformation, which of the following cluster configurations will result in maximum performance?

A* Total VMs; 1
* 400 GB per Executor
* 160 Cores / Executor

B* Total VMs: 8
* 50 GB per Executor
* 20 Cores / Executor
C.
* Total VMs: 4
* 100 GB per Executor
* 40 Cores/Executor
D.
* Total VMs:2
* 200 GB per Executor
* 80 Cores / Executor

Show Answer

Question: 4

A Data engineer wants to run unit's tests using common Python testing frameworks on python functions defined across several Databricks notebooks currently used in production.

How can the data engineer run unit tests against function that work with data in production?

ARun unit tests against non-production data that closely mirrors production

BDefine and unit test functions using Files in Repos

CDefine units test and functions within the same notebook

DDefine and import unit test functions from a separate Databricks notebook

Show Answer

Question: 5

A junior data engineer has configured a workload that posts the following JSON to the Databricks REST API endpoint 2.0/jobs/create.

q5_Databricks-Certified-Professional-Data-Engineer

Assuming that all configurations and referenced resources are available, which statement describes the result of executing this workload three times?

AThree new jobs named 'Ingest new data' will be defined in the workspace, and they will each run once daily.

BThe logic defined in the referenced notebook will be executed three times on new clusters with the configurations of the provided cluster ID.

CThree new jobs named 'Ingest new data' will be defined in the workspace, but no jobs will be executed.

DOne new job named 'Ingest new data' will be defined in the workspace, but it will not be executed.

EThe logic defined in the referenced notebook will be executed three times on the referenced existing all purpose cluster.

Show Answer

Databricks Databricks-Certified-Professional-Data-Engineer Quiz:1 Topic:1 Questions:1-5