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

質問 1

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

（A）The table's data was larger than 10 GB

（B）The table did not have a location

（C）The table's data was smaller than 10 GB

（D）The table was external

（E）The table was managed

正解：D 解答を投票する

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

質問 2

A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when It is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.
Which approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?

（A）0 They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.

（B）O They can set up the dashboard's SQL endpoint to be serverless.

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

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

正解：D 解答を投票する

解説: (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

What is stored in a Databricks customer's cloud account?

（A）Data

（B）Databricks web application

（C）Notebooks

（D）Cluster management metadata

正解：A 解答を投票する

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

質問 5

Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?

（A）Cloud-specific integrations

（B）Ability to scale storage

（C）Ability to scale workloads

（D）Avoiding vendor lock-in

（E）Simplified governance

正解：D 解答を投票する

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

質問 6

A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.
The code block used by the data engineer is below:

If the data engineer only wants the query to process all of the available data in as many batches as required, which of the following lines of code should the data engineer use to fill in the blank?

（A）processingTime(1)

（B）trigger(availableNow=True)

（C）trigger(continuous="once")

（D）trigger(processingTime="once")

（E）trigger(parallelBatch=True)

正解：B 解答を投票する

解説: (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 DROP ROW 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.

正解：B 解答を投票する

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

質問 8

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

（A）SELECT * FROM my_table WHERE age > 25;

（B）UPDATE my_table WHERE age <= 25;

（C）DELETE FROM my_table WHERE age > 25;

（D）UPDATE my_table WHERE age > 25;

（E）DELETE FROM my_table WHERE age <= 25;

正解：C 解答を投票する

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

質問 9

Which of the following commands will return the number of null values in the member_id column?

（A）SELECT null(member_id) FROM my_table;

（B）SELECT count_null(member_id) FROM my_table;

（C）SELECT count_if(member_id IS NULL) FROM my_table;

（D）SELECT count(member_id) - count_null(member_id) FROM my_table;

（E）SELECT count(member_id) FROM my_table;

正解：C 解答を投票する

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

質問 10

Which of the following benefits is provided by the array functions from Spark SQL?

（A）An ability to work with time-related data in specified intervals

（B）An ability to work with data in a variety of types at once

（C）An ability to work with an array of tables for procedural automation

（D）An ability to work with data within certain partitions and windows

（E）An ability to work with complex, nested data ingested from JSON files

正解：E 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験