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

문제1

A data engineer needs to apply custom logic to identify employees with more than 5 years of experience in array column employees in table stores. The custom logic should create a new column exp_employees that is an array of all of the employees with more than 5 years of experience for each row. In order to apply this custom logic at scale, the data engineer wants to use the FILTER higher-order function.
Which of the following code blocks successfully completes this task?

A. Option E

B. Option D

C. Option C

D. Option B

E. Option A

정답: E

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

문제2

Which of the following describes a scenario in which a data engineer will want to use a single-node cluster?

A. When they are running automated reports to be refreshed as quickly as possible

B. When they are concerned about the ability to automatically scale with larger data

C. When they are manually running reports with a large amount of data

D. When they are working with SQL within Databricks SQL

E. When they are working interactively with a small amount of data

정답: E

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

문제3

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.
Which change will need to be made to the pipeline when migrating to Delta Live Tables?

A. The pipeline will need to be written entirely in Python.

B. The pipeline can have different notebook sources in SQL & Python.

C. The pipeline will need to use a batch source in place of a streaming source.

D. The pipeline will need to be written entirely in SQL.

정답: B

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

문제4

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. Write-ahead Logs and Idempotent Sinks

B. Replayable Sources and Idempotent Sinks

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

D. Checkpointing and Idempotent Sinks

E. Checkpointing and Write-ahead Logs

정답: E

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

문제5

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

A. View

B. Spark SQL Table

C. Delta Table

D. Temporary view

E. Database

정답: D

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

문제6

A data engineer is attempting to drop a Spark SQL table my_table. The data engineer wants to delete all table metadata and data.
They run the following command:
DROP TABLE IF EXISTS my_table
While the object no longer appears when they run SHOW TABLES, the data files still exist.
Which of the following describes why the data files still exist and the metadata files were deleted?

A. The table was external

B. The table was managed

C. The table's data was smaller than 10 GB

D. The table's data was larger than 10 GB

E. The table did not have a location

정답: A

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

문제7

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 cade block used by the data engineer is below:

If the data engineer only wants the query to execute a micro-batch to process data every 5 seconds, which of the following lines of code should the data engineer use to fill in the blank?

A. trigger(once="5 seconds")

B. trigger(continuous="5 seconds")

C. trigger(processingTime="5 seconds")

D. trigger("5 seconds")

E. trigger()

정답: C

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

문제8

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

A. PIVOT

B. SUM

C. CONVERT

D. TRANSFORM

E. WHERE

정답: A

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

문제9

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following commands could the data engineering team use to access sales in PySpark?

A. spark.delta.table("sales")

B. There is no way to share data between PySpark and SQL.

C. spark.sql("sales")

D. SELECT * FROM sales

E. spark.table("sales")

정답: E

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

문제10

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. New lead data engineer

B. Workspace administrator

C. This transfer is not possible

D. Original data engineer

E. Databricks account representative

정답: B

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

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

우리와 연락하기

유용한 링크

최신 업데이트