Databricks Databricks-Certified-Data-Engineer-Associate 問題集

質問 1：
A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
Which of the following approaches can be used to identify the owner of new_table?
A. Review the Owner field in the table's page in Data Explorer
B. Review the Permissions tab in the table's page in Data Explorer
C. There is no way to identify the owner of the table
D. Review the Owner field in the table's page in the cloud storage solution
E. All of these options can be used to identify the owner of the table
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?
A. Replayable Sources and Idempotent Sinks
B. Checkpointing and Idempotent Sinks
C. Write-ahead Logs and Idempotent Sinks
D. Structured Streaming cannot record the offset range of the data being processed in each trigger.
E. Checkpointing and Write-ahead Logs
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?
A. Data lake
B. None of these
C. All of these
D. Data warehouse
E. Data lakehouse
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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. trigger(continuous="once")
B. trigger(availableNow=True)
C. processingTime(1)
D. trigger(processingTime="once")
E. trigger(parallelBatch=True)
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 can have different notebook sources in SQL & Python.
B. The pipeline will need to be written entirely in SQL.
C. The pipeline will need to use a batch source in place of a streaming source.
D. The pipeline will need to be written entirely in Python.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
In which of the following scenarios should a data engineer use the MERGE INTO command instead of the INSERT INTO command?
A. When the target table is an external table
B. When the target table cannot contain duplicate records
C. When the location of the data needs to be changed
D. When the source is not a Delta table
E. When the source table can be deleted
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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 of the following approaches can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
A. They can turn on the Auto Stop feature for the SQL endpoint.
B. They can set up the dashboard's SQL endpoint to be serverless.
C. They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
D. They can reduce the cluster size of the SQL endpoint.
E. They can ensure the dashboard's SQL endpoint is not one of the included query's SQL endpoint.
正解：A
解説: (Topexam メンバーにのみ表示されます)