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

문제1

Which of the following describes the relationship between Gold tables and Silver tables?

A. Gold tables are more likely to contain more data than Silver tables.

B. Gold tables are more likely to contain a less refined view of data than Silver tables.

C. Gold tables are more likely to contain truthful data than Silver tables.

D. Gold tables are more likely to contain aggregations than Silver tables.

E. Gold tables are more likely to contain valuable data than Silver tables.

정답: D

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

문제2

Which of the following approaches should be used to send the Databricks Job owner an email in the case that the Job fails?

A. Setting up an Alert in the Notebook

B. MLflow Model Registry Webhooks

C. Setting up an Alert in the Job page

D. There is no way to notify the Job owner in the case of Job failure

E. Manually programming in an alert system in each cell of the Notebook

정답: C

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

문제3

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

A. DELTA

B. autoloader

C. sqlite

D. org.apache.spark.sql.sqlite

E. org.apache.spark.sql.jdbc

정답: C

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

문제4

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

B. Dashboards

C. Databricks Filesystem

D. Data Explorer

E. Repos

정답: D

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

문제5

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

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 회원만 볼 수 있음)

문제6

Which of the following commands will return the number of null values in the member_id column?

A. SELECT count(member_id) FROM my_table;

B. SELECT count_if(member_id IS NULL) FROM my_table;

C. SELECT null(member_id) FROM my_table;

D. SELECT count(member_id) - count_null(member_id) FROM my_table;

E. SELECT count_null(member_id) FROM my_table;

정답: B

설명: (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 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 회원만 볼 수 있음)

문제9

A data organization leader is upset about the data analysis team's reports being different from the data engineering team's reports. The leader believes the siloed nature of their organization's data engineering and data analysis architectures is to blame.
Which of the following describes how a data lakehouse could alleviate this issue?

A. Both teams would be able to collaborate on projects in real-time

B. Both teams would reorganize to report to the same department

C. Both teams would respond more quickly to ad-hoc requests

D. Both teams would autoscale their work as data size evolves

E. Both teams would use the same source of truth for their work

정답: E

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

문제10

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.
Which of the following tools can the data engineer use to solve this problem?

A. Auto Loader

B. Unity Catalog

C. Data Explorer

D. Delta Live Tables

E. Delta Lake

정답: D

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

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

우리와 연락하기

유용한 링크

최신 업데이트