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

質問 1：
Which of the following must be specified when creating a new Delta Live Tables pipeline?
A. A location of a target database for the written data
B. A path to cloud storage location for the written data
C. The preferred DBU/hour cost
D. A key-value pair configuration
E. At least one notebook library to be executed
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which of the following describes the relationship between Gold tables and Silver tables?
A. Gold tables are more likely to contain aggregations than Silver tables.
B. Gold tables are more likely to contain truthful data than Silver tables.
C. Gold tables are more likely to contain a less refined view of data than Silver tables.
D. Gold tables are more likely to contain valuable data than Silver tables.
E. Gold tables are more likely to contain more data than Silver tables.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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 was managed
D. The table's data was smaller than 10 GB
E. The table was external
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
In which of the following file formats is data from Delta Lake tables primarily stored?
A. A proprietary, optimized format specific to Databricks
B. CSV
C. JSON
D. Parquet
E. Delta
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 メンバーにのみ表示されます)

質問 6：
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
A. A data lakehouse supports ACID-compliant transactions.
B. A data lakehouse stores data in open formats.
C. A data lakehouse provides storage solutions for structured and unstructured data.
D. A data lakehouse allows the use of SQL queries to examine data.
E. A data lakehouse enables machine learning and artificial Intelligence workloads.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this task?
A. Pull
B. Merge
C. Push
D. Clone
E. Commit
正解：A
解説: (Topexam メンバーにのみ表示されます)