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

出題：1

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?

A. CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.

B. CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.

C. CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.

D. CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.

E. CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

正解：A 解答を投票する

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

出題：2

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 set up the dashboard's SQL endpoint to be serverless.

B. They can turn on the Auto Stop feature for the SQL endpoint.

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.

正解：B 解答を投票する

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

出題：3

Which of the following SQL keywords can be used to convert a table from a long format to a wide format?

A. WHERE

B. PIVOT

C. TRANSFORM

D. SUM

E. CONVERT

正解：B 解答を投票する

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

出題：4

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 location of the data needs to be changed

C. When the source table can be deleted

D. When the target table cannot contain duplicate records

E. When the source is not a Delta table

正解：D 解答を投票する

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

出題：5

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 can set a limit to the number of individuals that are able to manage the query's refresh schedule.

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

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

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

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

正解：C 解答を投票する

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

出題：6

In which of the following scenarios should a data engineer select a Task in the Depends On field of a new Databricks Job Task?

A. When another task has the same dependency libraries as the new task

B. When another task needs to fail before the new task begins

C. When another task needs to be replaced by the new task

D. When another task needs to successfully complete before the new task begins

E. When another task needs to use as little compute resources as possible

正解：D 解答を投票する

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

出題：7

Which of the following must be specified when creating a new Delta Live Tables pipeline?

A. At least one notebook library to be executed

B. The preferred DBU/hour cost

C. A key-value pair configuration

D. A path to cloud storage location for the written data

E. A location of a target database for the written data

正解：A 解答を投票する

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

出題：8

A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs.
Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?

A. Cron syntax

B. datetime

C. pyspark.sql.types.DateType

D. pyspark.sql.types.TimestampType

E. There is no way to represent and submit this information programmatically

正解：A 解答を投票する

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

出題：9

A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.
In which of the following locations can the data engineer review their permissions on the table?

A. Repos

B. Jobs

C. Data Explorer

D. Databricks Filesystem

E. Dashboards

正解：C 解答を投票する

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

出題：10

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 runnable by all stakeholders.

B. An automated report needs to be refreshed as quickly as possible.

C. An automated report needs to be version-controlled across multiple collaborators.

D. An automated report needs to be made reproducible.

E. An automated report needs to be tested to identify errors.

正解：B 解答を投票する

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

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