최신 Databricks-Certified-Data-Engineer-Associate 무료덤프 - Databricks Certified Data Engineer Associate

문제1

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. There is no way to determine why a Job task is running slowly.

C. They can navigate to the Runs tab in the Jobs UI to immediately review the processing notebook.

D. They can navigate to the Runs tab in the Jobs UI and click on the active run to review the processing notebook.

E. They can navigate to the Tasks tab in the Jobs UI and click on the active run to review the processing notebook.

정답: D

문제2

A data engineer has developed a data pipeline to ingest data from a JSON source using Auto Loader, but the engineer has not provided any type inference or schema hints in their pipeline. Upon reviewing the data, the data engineer has noticed that all of the columns in the target table are of the string type despite some of the fields only including float or boolean values.
Which of the following describes why Auto Loader inferred all of the columns to be of the string type?

A. JSON data is a text-based format

B. All of the fields had at least one null value

C. Auto Loader only works with string data

D. Auto Loader cannot infer the schema of ingested data

E. There was a type mismatch between the specific schema and the inferred schema

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제3

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 made reproducible.

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

C. An automated report needs to be runnable by all stakeholders.

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

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

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제4

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:
Which line of code should the data engineer use to fill in the blank if the data engineer only wants the query to execute a micro-batch to process data every 5 seconds?

A. trigger(once="5 seconds")

B. trigger(continuous="5 seconds")

C. trigger(processingTime="5 seconds")

D. trigger("5 seconds")

정답: C

문제5

A new data engineering team team. has been assigned to an ELT project. The new data engineering team will need full privileges on the database customers to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

A. GRANT ALL PRIVILEGES ON DATABASE team TO customers;

B. GRANT USAGE ON DATABASE customers TO team;

C. GRANT ALL PRIVILEGES ON DATABASE customers TO team;

D. GRANT SELECT PRIVILEGES ON DATABASE customers TO teams;

E. GRANT SELECT CREATE MODIFY USAGE PRIVILEGES ON DATABASE customers TO team;

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제6

A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:

Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

A. Replace spark.read with spark.readStream

B. Replace predict with a stream-friendly prediction function

C. Replace schema(schema) with option ("maxFilesPerTrigger", 1)

D. Replace format("delta") with format("stream")

E. Replace "transactions" with the path to the location of the Delta table

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제7

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 names of the files to be copied were not included with the FILES keyword.

B. The format of the files to be copied were not included with the FORMAT_OPTIONS keyword.

C. The previous day's file has already been copied into the table.

D. The PARQUET file format does not support COPY INTO.

E. The COPY INTO statement requires the table to be refreshed to view the copied rows.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제8

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

B. Clone

C. Push

D. Merge

E. Pull

정답: E

설명: (DumpTOP 회원만 볼 수 있음)

문제9

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 new webhook alert destination.

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

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

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

E. They can set up an Alert without notifications.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제10

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. TBLPROPERTIES PII

B. There is no way to indicate whether a table contains PII.

C. PII

D. COMMENT "Contains PII"

E. "COMMENT PII"

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

최신 Databricks-Certified-Data-Engineer-Associate 무료덤프 - Databricks Certified Data Engineer Associate

우리와 연락하기

유용한 링크

최신 업데이트