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

문제1

A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?
Which of the following code blocks can the data engineer use to complete this task?

A.

B.

C.

D.

E.

정답: B

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

문제2

Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?

A. Avoiding vendor lock-in

B. Simplified governance

C. Cloud-specific integrations

D. Ability to scale workloads

E. Ability to scale storage

정답: A

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

문제3

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team's queries uses the same SQL endpoint.
Which of the following approaches can the data engineering team use to improve the latency of the team's queries?

A. They can turn on the Serverless feature for the SQL endpoint.

B. They can increase the maximum bound of the SQL endpoint's scaling range.

C. They can increase the cluster size of the SQL endpoint.

D. They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."

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

정답: B

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

문제4

A data engineer is working with two tables. Each of these tables is displayed below in its entirety.
The data engineer runs the following query to join these tables together:
Which of the following will be returned by the above query?

A. Option E

B. Option D

C. Option C

D. Option B

E. Option A

정답: E

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

문제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 DBUs that are consumed by the SQL Endpoint.

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

C. They can set a limit to the number of individuals that are able to manage the query's refresh schedule.

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 on a certain date in the query scheduler.

정답: E

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

문제6

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

문제7

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

문제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
UNION SELECT * FROM april_transactions;

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

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

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

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

정답: A

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

문제9

A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.
Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?

A. They can configure the clusters to be single-node

B. They can use endpoints available in Databricks SQL

C. They can configure the clusters to autoscale for larger data sizes

D. They can use clusters that are from a cluster pool

E. They can use jobs clusters instead of all-purpose clusters

정답: D

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

문제10

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

A. The DELETE HISTORY command was run on the table

B. The OPTIMIZE command was nun on the table

C. The VACUUM command was run on the table

D. The TIME TRAVEL command was run on the table

E. The HISTORY command was run on the table

정답: C

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

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

우리와 연락하기

유용한 링크

최신 업데이트