Databricks-Certified-Professional-Data-Engineer試験無料問題集（129題）「Databricks Certified Professional Data Engineer 認定」

出題：1

An upstream system has been configured to pass the date for a given batch of data to the Databricks Jobs API as a parameter. The notebook to be scheduled will use this parameter to load data with the following code:
df = spark.read.format("parquet").load(f"/mnt/source/(date)")
Which code block should be used to create the date Python variable used in the above code block?

A. date = dbutils.notebooks.getParam("date")

B. input_dict = input()
date= input_dict["date"]

C. dbutils.widgets.text("date", "null")
date = dbutils.widgets.get("date")

D. date = spark.conf.get("date")

E. import sys
date = sys.argv[1]

正解：C 解答を投票する

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

出題：2

The data architect has mandated that all tables in the Lakehouse should be configured as external Delta Lake tables.
Which approach will ensure that this requirement is met?

A. When tables are created, make sure that the external keyword is used in the create table statement.

B. Whenever a database is being created, make sure that the location keyword is used

C. When the workspace is being configured, make sure that external cloud object storage has been mounted.

D. Whenever a table is being created, make sure that the location keyword is used.

E. When configuring an external data warehouse for all table storage. leverage Databricks for all ELT.

正解：D 解答を投票する

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

出題：3

Which is a key benefit of an end-to-end test?

A. It makes it easier to automate your test suite

B. It closely simulates real world usage of your application.

C. It pinpoint errors in the building blocks of your application.

D. It provides testing coverage for all code paths and branches.

正解：B 解答を投票する

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

出題：4

A junior data engineer has been asked to develop a streaming data pipeline with a grouped aggregation using DataFrame df. The pipeline needs to calculate the average humidity and average temperature for each non- overlapping five-minute interval. Incremental state information should be maintained for 10 minutes for late- arriving data.
Streaming DataFrame df has the following schema:
"device_id INT, event_time TIMESTAMP, temp FLOAT, humidity FLOAT"
Code block:

Choose the response that correctly fills in the blank within the code block to complete this task.

A. slidingWindow("event_time", "10 minutes")

B. await("event_time + '10 minutes'")

C. awaitArrival("event_time", "10 minutes")

D. delayWrite("event_time", "10 minutes")

E. withWatermark("event_time", "10 minutes")

正解：E 解答を投票する

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

出題：5

A user wants to use DLT expectations to validate that a derived table report contains all records from the source, included in the table validation_copy.
The user attempts and fails to accomplish this by adding an expectation to the report table definition.
Which approach would allow using DLT expectations to validate all expected records are present in this table?

A. Define a temporary table that perform a left outer join on validation_copy and report, and define an expectation that no report key values are null

B. Define a view that performs a left outer join on validation_copy and report, and reference this view in DLT expectations for the report table

C. Define a function that performs a left outer join on validation_copy and report and report, and check against the result in a DLT expectation for the report table

D. Define a SQL UDF that performs a left outer join on two tables, and check if this returns null values for report key values in a DLT expectation for the report table.

正解：B 解答を投票する

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

出題：6

Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?

A. libraries

B. jobs

C. fs

D. workspace

E. configure

正解：A 解答を投票する

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

出題：7

The data architect has mandated that all tables in the Lakehouse should be configured as external (also known as "unmanaged") Delta Lake tables.
Which approach will ensure that this requirement is met?

A. When configuring an external data warehouse for all table storage, leverage Databricks for all ELT.

B. When a database is being created, make sure that the LOCATION keyword is used.

C. When tables are created, make sure that the EXTERNAL keyword is used in the CREATE TABLE statement.

D. When the workspace is being configured, make sure that external cloud object storage has been mounted.

E. When data is saved to a table, make sure that a full file path is specified alongside the Delta format.

正解：C 解答を投票する

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

出題：8

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 triggers a cluster restart to collect and install Git. Most of the latency is related to cluster startup time.

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. Python will always execute slower than Scala on Databricks. The run.py script should be refactored to Scala.

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

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

正解：D 解答を投票する

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

出題：9

The data governance team has instituted a requirement that all tables containing Personal Identifiable Information (PH) must be clearly annotated. This includes adding column comments, table comments, and setting the custom table property"contains_pii" = true.
The following SQL DDL statement is executed to create a new table:

Which command allows manual confirmation that these three requirements have been met?

A. DESCRIBE EXTENDED dev.pii test

B. SHOW TBLPROPERTIES dev.pii test

C. DESCRIBE DETAIL dev.pii test

D. DESCRIBE HISTORY dev.pii test

E. SHOW TABLES dev

正解：A 解答を投票する

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

出題：10

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. Tasks B and C will attempt to run as configured; any changes made in task A will be rolled back due to task failure.

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

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

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

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

正解：E 解答を投票する

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

Databricks-Certified-Professional-Data-Engineer試験無料問題集「Databricks Certified Professional Data Engineer 認定」