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

質問 1

Which of the following describes the type of workloads that are always compatible with Auto Loader?

（A）Machine learning workloads

（B）Dashboard workloads

（C）Streaming workloads

（D）Batch workloads

（E）Serverless workloads

正解：C 解答を投票する

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

質問 2

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).
Which of the following code blocks creates this SQL UDF?

（A）

（B）

（C）

（D）

（E）

正解：C 解答を投票する

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

質問 3

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team's queries uses the same SQL endpoint.
Which of the following approaches can the data engineering team use to improve the latency of the team's queries?

（A）They can turn on the Serverless feature for the SQL endpoint.

（B）They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."

（C）They can increase the cluster size of the SQL endpoint.

（D）They can turn on the Auto Stop feature for the SQL endpoint.

（E）They can increase the maximum bound of the SQL endpoint's scaling range.

正解：E 解答を投票する

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

質問 4

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

（A）

（B）

（C）

（D）

（E）

正解：A 解答を投票する

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

質問 5

Which of the following describes the relationship between Bronze tables and raw data?

（A）Bronze tables contain less data than raw data files.

（B）Bronze tables contain raw data with a schema applied.

（C）Bronze tables contain more truthful data than raw data.

（D）Bronze tables contain aggregates while raw data is unaggregated.

（E）Bronze tables contain a less refined view of data than raw data.

正解：B 解答を投票する

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

質問 6

A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.
Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

（A）Databricks Repos supports the use of multiple branches

（B）Databricks Repos allows users to revert to previous versions of a notebook

（C）Databricks Repos is wholly housed within the Databricks Lakehouse Platform

（D）Databricks Repos provides the ability to comment on specific changes

（E）Databricks Repos automatically saves development progress

正解：A 解答を投票する

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

質問 7

A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION FAIL UPDATE What is the expected behavior when a batch of data containing data that violates these constraints is processed?

（A）Records that violate the expectation cause the job to fail.

（B）Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.

（C）Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.

（D）Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.

（E）Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.

正解：A 解答を投票する

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

質問 8

Which of the following describes the storage organization of a Delta table?

（A）Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.

（B）Delta tables are stored in a single file that contains only the data stored within the table.

（C）Delta tables are stored in a collection of files that contain only the data stored within the table.

（D）Delta tables store their data in a single file and all metadata in a collection of files in a separate location.

（E）Delta tables are stored in a single file that contains data, history, metadata, and other attributes.

正解：A 解答を投票する

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

質問 9

Which of the following data workloads will utilize a Gold table as its source?

（A）A job that cleans data by removing malformatted records

（B）A job that enriches data by parsing its timestamps into a human-readable format

（C）A job that ingests raw data from a streaming source into the Lakehouse

（D）A job that aggregates uncleaned data to create standard summary statistics

（E）A job that queries aggregated data designed to feed into a dashboard

正解：E 解答を投票する

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

質問 10

A data organization leader is upset about the data analysis team's reports being different from the data engineering team's reports. The leader believes the siloed nature of their organization's data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?

（A）Both teams would reorganize to report to the same department

（B）Both teams would use the same source of truth for their work

（C）Both teams would be able to collaborate on projects in real-time

（D）Both teams would respond more quickly to ad-hoc requests

（E）Both teams would autoscale their work as data size evolves

正解：B 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験