最新的Databricks Certification認證 Databricks-Certified-Data-Engineer-Professional考試題庫

問題1

When evaluating the Ganglia Metrics for a given cluster with 3 executor nodes, which indicator would signal proper utilization of the VM's resources?

A. Total Disk Space remains constant

B. Network I/O never spikes

C. The five Minute Load Average remains consistent/flat

D. Bytes Received never exceeds 80 million bytes per second

E. CPU Utilization is around 75%

正確答案: E

說明：（僅 VCESoft 成員可見）

問題2

Which statement describes the default execution mode for Databricks Auto Loader?

A. New files are identified by listing the input directory; new files are incrementally and idempotently loaded into the target Delta Lake table.

B. Webhook trigger Databricks job to run anytime new data arrives in a source directory; new data automatically merged into target tables using rules inferred from the data.

C. New files are identified by listing the input directory; the target table is materialized by directory querying all valid files in the source directory.

D. Cloud vendor-specific queue storage and notification services are configured to track newly arriving files; the target table is materialized by directly querying all valid files in the source directory.

E. Cloud vendor-specific queue storage and notification services are configured to track newly arriving files; new files are incrementally and impotently into the target Delta Lake table.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題3

What is a method of installing a Python package scoped at the notebook level to all nodes in the currently active cluster?

A. Use &Pip install in a notebook cell

B. Use &sh install in a notebook cell

C. Run source env/bin/activate in a notebook setup script

D. Install libraries from PyPi using the cluster UI

正確答案: D

說明：（僅 VCESoft 成員可見）

問題4

A data engineer is designing an append-only pipeline that needs to handle both batch and streaming data in Delta Lake. The team wants to ensure that the streaming component can efficiently track which data has already been processed. Which configuration should be set to enable this?

A. mergeSchema

B. checkpointLocation

C. partitionBy

D. overwriteSchema

正確答案: B

說明：（僅 VCESoft 成員可見）

問題5

Spill occurs as a result of executing various wide transformations. However, diagnosing spill requires one to proactively look for key indicators.
Where in the Spark UI are two of the primary indicators that a partition is spilling to disk?

A. Stage's detail screen and Query's detail screen

B. Executor's detail screen and Executor's log files

C. Stage's detail screen and Executor's log files

D. Query's detail screen and Job's detail screen

E. Driver's and Executor's log files

正確答案: C

說明：（僅 VCESoft 成員可見）

問題6

A data engineer is configuring a Databricks Asset Bundle to deploy a job with granular permissions.
The requirements are:
- Grant the data-engineers group CAN_MANAGE access to the job.
- Ensure the auditors' group can view the job but not modify/run it.
- Avoid granting unintended permissions to other users/groups.
How should the data engineer deploy the job while meeting the requirements?

A. permissions:
- group_name: data-engineers
level: CAN_MANAGE
- group_name: auditors
level: CAN_VIEW
resources:
jobs:
my-job:
name: data-pipeline
tasks: [...]
job_clusters: [...]

B. resources:
jobs:
my-job:
name: data-pipeline
tasks: [...]
job_clusters: [...]
permissions:
- group_name: data-engineers
level: CAN_MANAGE
- group_name: auditors
level: CAN_VIEW

C. resources:
jobs:
my-job:
name: data-pipeline
tasks: [...]
job: [...]
permissions:
- group_name: data-engineers
level: CAN_MANAGE
permissions:
- group_name: auditors
level: CAN_VIEW

D. resources:
jobs:
my-job:
name: data-pipeline
tasks: [...]
job_clusters: [...]
permissions:
- group_name: data-engineers
level: CAN_MANAGE
- group_name: auditors
level: CAN_VIEW
- group_name: admin-team
level: IS_OWNER

正確答案: B

說明：（僅 VCESoft 成員可見）

問題7

A table 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 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.

B. 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.

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 began.

D. The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.

E. Results will be computed and cached when the table is defined; these cached results will incrementally update as new records are inserted into source tables.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題8

When a new Databricks project starts, the central IP team provisions the required infrastructure using Terraform and a Service Principal. This includes creating a Databricks workspace, a Unity Catalog linked to an External Location, and a Databricks group containing all project team members. Project teams must store all assets - e.g., tables and volumes, as Managed assets in Unity Catalog. This model hides infrastructure complexity while giving teams autonomy within their catalog. They can create and manage schemas, tables, volumes, and related objects but cannot rename, delete, or change catalog permissions, those remain under IT's control. Which rights should the project group be granted to enable this model?

A. The group should be made OWNER of the catalog.

B. The group needs to have ALL PRIVILEGES and the MANAGE on the catalog.

C. The group needs to have ALL PRIVILEGES on the catalog.

D. The group needs to have USE CATALOG and USE SCHEMA on the catalog.

正確答案: D

說明：（僅 VCESoft 成員可見）

最新的Databricks Certified Data Engineer Professional - Databricks-Certified-Data-Engineer-Professional免費考試真題

最新更新

站內鏈接

聯系我們