Pass with professional Certified-Data-Engineer-Professional actual quiz materials

Databricks Certified-Data-Engineer-Professional Exam Overview:

Databricks Certified-Data-Engineer-Professional Exam Syllabus Topics:

Databricks Certified Data Engineer Professional Sample Questions:

1. An analytics team wants to run a short-term experiment in Databricks SQL on the customer transactions Delta table (about 20 billion records) created by the data engineering team. Which strategy should the data engineering team use to ensure minimal downtime and no impact on the ongoing ETL processes?

A) Deep clone the table for the analytics team.
B) Shallow clone the table for the analytics team.
C) Give the analytics team direct access to the production table.
D) Create a new table for the analytics team using a CTAS statement.

2. A production cluster has 3 executor nodes and uses the same virtual machine type for the driver and executor.
When evaluating the Ganglia Metrics for this cluster, which indicator would signal a bottleneck caused by code executing on the driver?

A) The five Minute Load Average remains consistent/flat
B) Bytes Received never exceeds 80 million bytes per second
C) Overall cluster CPU utilization is around 25%
D) Network I/O never spikes
E) Total Disk Space remains constant

3. A Delta table of weather records is partitioned by date and has the below schema:
date DATE, device_id INT, temp FLOAT, latitude FLOAT, longitude FLOAT
To find all the records from within the Arctic Circle, you execute a query with the below filter:
latitude > 66.3
Which statement describes how the Delta engine identifies which files to load?

A) The Delta log is scanned for min and max statistics for the latitude column
B) All records are cached to attached storage and then the filter is applied
C) The Hive metastore is scanned for min and max statistics for the latitude column
D) The Parquet file footers are scanned for min and max statistics for the latitude column
E) All records are cached to an operational database and then the filter is applied

4. A view is registered with the following code:

Both users and orders are Delta Lake tables.
Which statement describes the results of querying recent_orders?

A) All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.
B) The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.
C) All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.
D) All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried.

5. A data engineer wants to enforce the principle of least privilege when configuring ACLs for Databricks jobs in a collaborative workspace. Which approach should the data engineer use?

A) Assign users only the minimum permission level (e.g., CAN RUN or CAN VIEW) required for their role on each job.
B) Grant all users CAN MANAGE permission on all jobs to avoid access issues.
C) Grant CAN RUN permission to everyone and CAN MANAGE to a single admin group.
D) Use only folder-level permissions and avoid setting permissions on individual jobs.

Solutions: