Databricks-Certified-Data-Engineer-Professional無料問題集「Databricks Certified Data Engineer Professional」

質問 1

A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on Task A.
If task A fails during a scheduled run, which statement describes the results of this run?

（A）Because all tasks are managed as a dependency graph, no changes will be committed to the Lakehouse until all tasks have successfully been completed.

（B）Tasks B and C will be skipped; some logic expressed in task A may have been committed before task failure.

（C）Tasks B and C will attempt to run as configured; any changes made in task A will be rolled back due to task failure.

（D）Tasks B and C will be skipped; task A will not commit any changes because of stage failure.

（E）Unless all tasks complete successfully, no changes will be committed to the Lakehouse; because task A failed, all commits will be rolled back automatically.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

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）Bytes Received never exceeds 80 million bytes per second

（C）The five Minute Load Average remains consistent/flat

（D）Network I/O never spikes

（E）CPU Utilization is around 75% Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

正解：E 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

The following code has been migrated to a Databricks notebook from a legacy workload:

The code executes successfully and provides the logically correct results, however, it takes over
20 minutes to extract and load around 1 GB of data.
Which statement is a possible explanation for this behavior?

（A）%sh executes shell code on the driver node. The code does not take advantage of the worker nodes or Databricks optimized Spark.

（B）Instead of cloning, the code should use %sh pip install so that the Python code can get executed in parallel across all nodes in a cluster.

（C）%sh does not distribute file moving operations; the final line of code should be updated to use %fs instead.

（D）%sh triggers a cluster restart to collect and install Git. Most of the latency is related to cluster startup time.

（E）Python will always execute slower than Scala on Databricks. The run.py script should be refactored to Scala.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

The data science team has created and logged a production model using MLflow. The model accepts a list of column names and returns a new column of type DOUBLE.
The following code correctly imports the production model, loads the customers table containing the customer_id key column into a DataFrame, and defines the feature columns needed for the model.

Which code block will output a DataFrame with the schema "customer_id LONG, predictions DOUBLE"?

（A）model.predict(df, columns)

（B）df.select("customer_id", model(*columns).alias("predictions"))

（C）df.apply(model, columns).select("customer_id, predictions")

（D）df.select("customer_id", pandas_udf(model, columns).alias("predictions"))

（E）df.map(lambda x:model(x[columns])).select("customer_id, predictions")

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

The data science team has created and logged a production model using MLflow. The following code correctly imports and applies the production model to output the predictions as a new DataFrame named preds with the schema "customer_id LONG, predictions DOUBLE, date DATE".
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

The data science team would like predictions saved to a Delta Lake table with the ability to compare all predictions across time. Churn predictions will be made at most once per day.
Which code block accomplishes this task while minimizing potential compute costs?

（A）preds.write.format("delta").save("/preds/churn_preds")

（B）

（C）preds.write.mode("append").saveAsTable("churn_preds")

（D）

（E）

正解：C 解答を投票する

質問 6

A table is registered with the following code:
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

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

（D）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.

（E）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.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

In order to prevent accidental commits to production data, a senior data engineer has instituted a policy that all development work will reference clones of Delta Lake tables. After testing both deep and shallow clone, development tables are created using shallow clone. A few weeks after initial table creation, the cloned versions of several tables implemented as Type 1 Slowly Changing Dimension (SCD) stop working. The transaction logs for the source tables show that vacuum was run the day before.
Why are the cloned tables no longer working?

（A）The data files compacted by vacuum are not tracked by the cloned metadata; running refresh on the cloned table will pull in recent changes.

（B）The metadata created by the clone operation is referencing data files that were purged as invalid by the vacuum command

（C）Running vacuum automatically invalidates any shallow clones of a table; deep clone should always be used when a cloned table will be repeatedly queried.

（D）Because Type 1 changes overwrite existing records, Delta Lake cannot guarantee data consistency for cloned tables.

（E）Tables created with SHALLOW CLONE are automatically deleted after their default retention threshold of 7 days.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

What is the first of a Databricks Python notebook when viewed in a text editor?

（A）// Databricks notebook source

（B）-- Databricks notebook source

（C）# MAGIC %python

（D）# Databricks notebook source

（E）%python

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

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?

（A）Define units test and functions within the same notebook

（B）Run unit tests against non-production data that closely mirrors production

（C）Define and unit test functions using Files in Repos

（D）Define and import unit test functions from a separate Databricks notebook

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic.
What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?

（A）No permissions

（B）Can Read

（C）Can Manage

（D）Can Edit

（E）Can Run

正解：B 解答を投票する

Databricks-Certified-Data-Engineer-Professional 無料問題集「Databricks Certified Data Engineer Professional」

弊社を連絡する

関連リンク

トップ試験