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

質問 1

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: 2
200 GB per Executor
80 Cores / Executor

（B）Total VMs: 1
400 GB per Executor
160 Cores / Executor

（C）Total VMs: 8
50 GB per Executor
20 Cores / Executor

（D）Total VMs: 4
100 GB per Executor
40 Cores/Executor

正解：B 解答を投票する

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

質問 2

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）The Hive metastore is scanned for min and max statistics for the latitude column

（C）All records are cached to attached storage and then the filter is applied Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

（D）All records are cached to an operational database and then the filter is applied

（E）The Parquet file footers are scanned for min and max statistics for the latitude column

正解：A 解答を投票する

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

質問 3

Which statement describes a key benefit of an end-to-end test?

（A）It pinpoint errors in the building blocks of your application.

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

（C）It makes it easier to automate your test suite

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

正解：B 解答を投票する

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

質問 4

The data engineering team has configured a Databricks SQL query and alert to monitor the values in a Delta Lake table. The recent_sensor_recordings table contains an identifying sensor_id alongside the timestamp and temperature for the most recent 5 minutes of recordings.
The below query is used to create the alert:

The query is set to refresh each minute and always completes in less than 10 seconds. The alert is set to trigger when mean (temperature) > 120. Notifications are triggered to be sent at most Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from every 1 minute.
If this alert raises notifications for 3 consecutive minutes and then stops, which statement must be true?

（A）The average temperature recordings for at least one sensor exceeded 120 on three consecutive executions of the query

（B）The maximum temperature recording for at least one sensor exceeded 120 on three consecutive executions of the query

（C）The total average temperature across all sensors exceeded 120 on three consecutive executions of the query

（D）The source query failed to update properly for three consecutive minutes and then restarted

（E）The recent_sensor_recordingstable was unresponsive for three consecutive runs of the query

正解：A 解答を投票する

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

質問 5

A data engineer is performing a join operating to combine values from a static userlookup table with a streaming DataFrame streamingDF.
Which code block attempts to perform an invalid stream-static join?

（A）userLookup.join(streamingDF, ["user_id"], how="right")

（B）streamingDF.join(userLookup, ["user_id"], how="left")

（C）userLookup.join(streamingDF, ["userid"], how="inner")

（D）streamingDF.join(userLookup, ["userid"], how="inner")

（E）streamingDF.join(userLookup, ["user_id"], how="outer")

正解：E 解答を投票する

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

質問 6

An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?

（A）An external table will be created in the storage container mounted to /mnt/finance eda bucket.

（B）An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.

（C）A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.

（D）A managed table will be created in the DBFS root storage container.

（E）A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.

正解：B 解答を投票する

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

質問 7

A data engineer is configuring a pipeline that will potentially see late-arriving, duplicate records.
In addition to de-duplicating records within the batch, which of the following approaches allows Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from the data engineer to deduplicate data against previously processed records as it is inserted into a Delta table?

（A）Rely on Delta Lake schema enforcement to prevent duplicate records.

（B）Perform a full outer join on a unique key and overwrite existing data.

（C）Perform an insert-only merge with a matching condition on a unique key.

（D）Set the configuration delta.deduplicate = true.

（E）VACUUM the Delta table after each batch completes.

正解：C 解答を投票する

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

質問 8

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:

A batch job is attempting to insert new records to the table, including a record where latitude =
45.50 and longitude = 212.67.
Which statement describes the outcome of this batch insert?

（A）The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.

（B）The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.

（C）The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.

（D）The write will fail completely because of the constraint violation and no records will be inserted into the target table.

（E）The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.

正解：D 解答を投票する

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

質問 9

Which distribution does Databricks support for installing custom Python code packages?

（A）CRAN

（B）jars

（C）CRAM

（D）sbt

（E）Wheels

（F）nom

正解：F 解答を投票する

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

質問 10

Which of the following technologies can be used to identify key areas of text when parsing Spark Driver log4j output?

（A）pyspsark.ml.feature

（B）Regex

（C）C++

（D）Scala Datasets

（E）Julia

正解：B 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験