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

質問 1

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 it as a dependency of the original task.

（B）They can create a new job from scratch and add both tasks to run concurrently.

（C）They can clone the existing task to a new Job and then edit it to run the new notebook.

（D）They can create a new task in the existing Job and then add the original task as a dependency of the new task.

（E）They can clone the existing task in the existing Job and update it to run the new notebook.

正解：A 解答を投票する

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

質問 2

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）FROM CSV

（B）USING DELTA

（C）FROM "path/to/csv"

（D）USING CSV

（E）None of these lines of code are needed to successfully complete the task

正解：C 解答を投票する

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

質問 3

A data engineer has a Python notebook in Databricks, but they need to use SQL to accomplish a specific task within a cell. They still want all of the other cells to use Python without making any changes to those cells.
Which of the following describes how the data engineer can use SQL within a cell of their Python notebook?

（A）They can simply write SQL syntax in the cell

（B）They can change the default language of the notebook to SQL

（C）They can attach the cell to a SQL endpoint rather than a Databricks cluster

（D）It is not possible to use SQL in a Python notebook

（E）They can add %sql to the first line of the cell

正解：E 解答を投票する

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

質問 4

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 supports the use of multiple branches

（B）Databricks Repos allows users to revert to previous versions of a notebook

（C）Databricks Repos is wholly housed within the Databricks Lakehouse Platform

（D）Databricks Repos provides the ability to comment on specific changes

（E）Databricks Repos automatically saves development progress

正解：A 解答を投票する

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

質問 5

A data engineer has left the organization. The data team needs to transfer ownership of the data engineer's Delta tables to a new data engineer. The new data engineer is the lead engineer on the data team.
Assuming the original data engineer no longer has access, which of the following individuals must be the one to transfer ownership of the Delta tables in Data Explorer?

（A）Original data engineer

（B）New lead data engineer

（C）Workspace administrator

（D）Databricks account representative

（E）This transfer is not possible

正解：C 解答を投票する

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

質問 6

Which of the following statements regarding the relationship between Silver tables and Bronze tables is always true?

（A）Silver tables contain a less refined, less clean view of data than Bronze data.

（B）Silver tables contain less data than Bronze tables.

（C）Silver tables contain aggregates while Bronze data is unaggregated.

（D）Silver tables contain a more refined and cleaner view of data than Bronze tables.

（E）Silver tables contain more data than Bronze tables.

正解：D 解答を投票する

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

質問 7

Which of the following describes a scenario in which a data team will want to utilize cluster pools?

（A）An automated report needs to be refreshed as quickly as possible.

（B）An automated report needs to be runnable by all stakeholders.

（C）An automated report needs to be made reproducible.

（D）An automated report needs to be tested to identify errors.

（E）An automated report needs to be version-controlled across multiple collaborators.

正解：A 解答を投票する

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

質問 8

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?

正解：D 解答を投票する

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

質問 9

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project's release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release.
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?

（A）They cannot ensure the query does not cost the organization money beyond the first week of the project's release.

（B）They can set a limit to the number of individuals that are able to manage the query's refresh schedule.

（C）They can set the query's refresh schedule to end after a certain number of refreshes.

（D）They can set the query's refresh schedule to end on a certain date in the query scheduler.

（E）They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.

正解：D 解答を投票する

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

質問 10

A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also used by other processes. As a result, the files should be kept as is and will accumulate in the directory. The data engineer needs to identify which files are new since the previous run in the pipeline, and set up the pipeline to only ingest those new files with each run.
Which of the following tools can the data engineer use to solve this problem?

正解：C 解答を投票する

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

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

弊社を連絡する

関連リンク

トップ試験