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

出題：1

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 added to the target dataset and flagged as invalid in a field added to the target dataset.

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

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 recorded as invalid in the event log.

正解：A 解答を投票する

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

出題：2

A data engineer is attempting to drop a Spark SQL table my_table and runs the following command:
DROP TABLE IF EXISTS my_table;
After running this command, the engineer notices that the data files and metadata files have been deleted from the file system.
Which of the following describes why all of these files were deleted?

A. The table's data was larger than 10 GB

B. The table was external

C. The table was managed

D. The table did not have a location

E. The table's data was smaller than 10 GB

正解：C 解答を投票する

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

出題：3

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

A. Option E

B. Option D

C. Option C

D. Option A

E. Option B

正解：A 解答を投票する

出題：4

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

A. View

B. Temporary view

C. Delta Table

D. Database

E. Spark SQL Table

正解：B 解答を投票する

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

出題：5

An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results.
Which of the following approaches can the manager use to ensure the results of the query are updated each day?

A. They can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.

B. They can schedule the query to run every 1 day from the Jobs UI.

C. They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.

D. They can schedule the query to run every 12 hours from the Jobs UI.

E. They can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.

正解：C 解答を投票する

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

出題：6

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

A. USING DELTA

B. None of these lines of code are needed to successfully complete the task

C. FROM "path/to/csv"

D. FROM CSV

E. USING CSV

正解：C 解答を投票する

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

出題：7

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

A. A job that ingests raw data from a streaming source into the Lakehouse

B. A job that cleans data by removing malformatted records

C. A job that queries aggregated data designed to feed into a dashboard

D. A job that enriches data by parsing its timestamps into a human-readable format

E. A job that aggregates uncleaned data to create standard summary statistics

正解：C 解答を投票する

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

出題：8

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following commands could the data engineering team use to access sales in PySpark?

A. There is no way to share data between PySpark and SQL.

B. spark.table("sales")

C. SELECT * FROM sales

D. spark.delta.table("sales")

E. spark.sql("sales")

正解：B 解答を投票する

出題：9

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

A. Auto Loader

B. Unity Catalog

C. Data Explorer

D. Delta Lake

E. Delta Live Tables

正解：E 解答を投票する

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

出題：10

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which change will need to be made to the pipeline when migrating to Delta Live Tables?

A. The pipeline will need to be written entirely in SQL.

B. The pipeline will need to use a batch source in place of a streaming source.

C. The pipeline can have different notebook sources in SQL & Python.

D. The pipeline will need to be written entirely in Python.

正解：C 解答を投票する

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

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