[2024年01月18日] 最新更新されたのはDatabricks-Certified-Data-Engineer-Associate試験問題2024年更新
無料更新されたDatabricks Databricks-Certified-Data-Engineer-Associateテストエンジン問題には47問題と解答
質問 # 22
Which of the following describes the storage organization of a Delta table?
- A. Delta tables are stored in a single file that contains data, history, metadata, and other attributes.
- B. Delta tables store their data in a single file and all metadata in a collection of files in a separate location.
- C. Delta tables are stored in a collection of files that contain only the data stored within the table.
- D. Delta tables are stored in a collection of files that contain data, history, metadata, and other attributes.
- E. Delta tables are stored in a single file that contains only the data stored within the table.
正解：D
質問 # 23
A data engineer wants to create a new table containing the names of customers that live in France.
They have written the following command:
A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII).
Which of the following lines of code fills in the above blank to successfully complete the task?
- A. COMMENT "Contains PII"
- B. PII
- C. There is no way to indicate whether a table contains PII.
- D. "COMMENT PII"
- E. TBLPROPERTIES PII
正解：E
質問 # 24
Which of the following data lakehouse features results in improved data quality over a traditional data lake?
- A. A data lakehouse enables machine learning and artificial Intelligence workloads.
- B. A data lakehouse provides storage solutions for structured and unstructured data.
- C. A data lakehouse allows the use of SQL queries to examine data.
- D. A data lakehouse supports ACID-compliant transactions.
- E. A data lakehouse stores data in open formats.
正解：C
質問 # 25
A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.
Which of the following approaches can the data engineer use to set up the new task?
- A. They can create a new task in the existing Job and then add the original task as a dependency of the new task.
- B. They can clone the existing task to a new Job and then edit it to run the new notebook.
- C. They can clone the existing task in the existing Job and update it to run the new notebook.
- D. They can create a new job from scratch and add both tasks to run concurrently.
- E. They can create a new task in the existing Job and then add it as a dependency of the original task.
正解：B
質問 # 26
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 is wholly housed within the Databricks Lakehouse Platform
- B. Databricks Repos allows users to revert to previous versions of a notebook
- C. Databricks Repos provides the ability to comment on specific changes
- D. Databricks Repos supports the use of multiple branches
- E. Databricks Repos automatically saves development progress
正解：D
質問 # 27
A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?
- A. if day_of_week = 1 and review_period:
- B. if day_of_week = 1 & review_period: = "True":
- C. if day_of_week = 1 and review_period = "True":
- D. if day_of_week == 1 and review_period == "True":
- E. if day_of_week == 1 and review_period:
正解：D
質問 # 28
A single Job runs two notebooks as two separate tasks. A data engineer has noticed that one of the notebooks is running slowly in the Job's current run. The data engineer asks a tech lead for help in identifying why this might be the case.
Which of the following approaches can the tech lead use to identify why the notebook is running slowly as part of the Job?
- A. They can navigate to the Tasks tab in the Jobs UI to immediately review the processing notebook.
- B. They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.
- C. They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.
- D. There is no way to determine why a Job task is running slowly.
- E. They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.
正解：C
質問 # 29
Which of the following tools is used by Auto Loader process data incrementally?
- A. Unity Catalog
- B. Data Explorer
- C. Spark Structured Streaming
- D. Checkpointing
- E. Databricks SQL
正解：C
質問 # 30
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. spark.delta.table("sales")
- B. spark.sql("sales")
- C. There is no way to share data between PySpark and SQL.
- D. SELECT * FROM sales
- E. spark.table("sales")
正解：A
質問 # 31
A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.
Which of the following data entities should the data engineer create?
- A. Function
- B. Table
- C. View
- D. Database
- E. Temporary view
正解：C
質問 # 32
Which of the following benefits is provided by the array functions from Spark SQL?
- A. An ability to work with an array of tables for procedural automation
- B. An ability to work with complex, nested data ingested from JSON files
- C. An ability to work with data in a variety of types at once
- D. An ability to work with time-related data in specified intervals
- E. An ability to work with data within certain partitions and windows
正解：E
質問 # 33
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 did not have a location
- B. The table was managed
- C. The table's data was smaller than 10 GB
- D. The table was external
- E. The table's data was larger than 10 GB
正解：D
質問 # 34
A data engineer runs a statement every day to copy the previous day's sales into the table transactions. Each day's sales are in their own file in the location "/transactions/raw".
Today, the data engineer runs the following command to complete this task:
After running the command today, the data engineer notices that the number of records in table transactions has not changed.
Which of the following describes why the statement might not have copied any new records into the table?
- A. The previous day's file has already been copied into the table.
- B. The COPY INTO statement requires the table to be refreshed to view the copied rows.
- C. The PARQUET file format does not support COPY INTO.
- D. The names of the files to be copied were not included with the FILES keyword.
- E. The format of the files to be copied were not included with the FORMAT_OPTIONS keyword.
正解：A
質問 # 35
Which of the following Git operations must be performed outside of Databricks Repos?
- A. Commit
- B. Pull
- C. Clone
- D. Merge
- E. Push
正解：C
質問 # 36
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.
正解：A
質問 # 37
......
100%の合格率を試そう！更新されたのはDatabricks-Certified-Data-Engineer-Associate試験問題 [2024年更新]：https://www.passtest.jp/Databricks/Databricks-Certified-Data-Engineer-Associate-shiken.html
ベストな問題集を使おうDatabricks Certification Databricks-Certified-Data-Engineer-Associate専門試験問題：https://drive.google.com/open?id=18AwKmn-PfMc8KPlvT5-eA6UPOMI_sPx-