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

出題：1

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 and review_period == "True":

C. if day_of_week = 1 & review_period: = "True":

D. if day_of_week = 1 and review_period = "True":

E. if day_of_week == 1 and review_period:

正解：E 解答を投票する

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

出題：2

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

A. Option E

B. Option D

C. Option C

D. Option A

E. Option B

正解：A 解答を投票する

出題：3

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. View

B. Temporary view

C. Database

D. Table

E. Function

正解：D 解答を投票する

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

出題：4

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 job from scratch and add both tasks to run concurrently.

B. They can create a new task in the existing Job and then add it as a dependency of the original task.

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 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 to a new Job and then edit it to run the new notebook.

正解：B 解答を投票する

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

出題：5

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

出題：6

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to a data analytics dashboard for a retail use case. The job has a Databricks SQL query that returns the number of store-level records where sales is equal to zero. The data engineer wants their entire team to be notified via a messaging webhook whenever this value is greater than 0.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of stores with $0 in sales is greater than zero?

A. They can set up an Alert with a custom template.

B. They can set up an Alert without notifications.

C. They can set up an Alert with a new webhook alert destination.

D. They can set up an Alert with one-time notifications.

E. They can set up an Alert with a new email alert destination.

正解：C 解答を投票する

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

出題：7

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. Checkpointing and Idempotent Sinks

B. Write-ahead Logs and Idempotent Sinks

C. Checkpointing and Write-ahead Logs

D. Structured Streaming cannot record the offset range of the data being processed in each trigger.

E. Replayable Sources and Idempotent Sinks

正解：C 解答を投票する

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

出題：8

A data engineering team has two tables. The first table march_transactions is a collection of all retail transactions in the month of March. The second table april_transactions is a collection of all retail transactions in the month of April. There are no duplicate records between the tables.
Which of the following commands should be run to create a new table all_transactions that contains all records from march_transactions and april_transactions without duplicate records?

A. CREATE TABLE all_transactions AS
SELECT * FROM march_transactions
INNER JOIN SELECT * FROM april_transactions;

B. CREATE TABLE all_transactions AS
SELECT * FROM march_transactions
MERGE SELECT * FROM april_transactions;

C. CREATE TABLE all_transactions AS
SELECT * FROM march_transactions
UNION SELECT * FROM april_transactions;

D. CREATE TABLE all_transactions AS
SELECT * FROM march_transactions
OUTER JOIN SELECT * FROM april_transactions;

E. CREATE TABLE all_transactions AS
SELECT * FROM march_transactions
INTERSECT SELECT * from april_transactions;

正解：C 解答を投票する

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

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

出題：10

A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id -
FROM STREAM(LIVE.customers)
WHERE loyalty_level = 'high';
Which of the following describes why the STREAM function is included in the query?

A. The table being created is a live table.

B. The data in the customers table has been updated since its last run.

C. The customers table is a streaming live table.

D. The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.

E. The STREAM function is not needed and will cause an error.

正解：C 解答を投票する

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

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