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

문제1

A data engineer needs access to a table new_table, but they do not have the correct permissions. They can ask the table owner for permission, but they do not know who the table owner is.
Which of the following approaches can be used to identify the owner of new_table?

A. Review the Permissions tab in the table's page in Data Explorer

B. There is no way to identify the owner of the table

C. Review the Owner field in the table's page in the cloud storage solution

D. All of these options can be used to identify the owner of the table

E. Review the Owner field in the table's page in Data Explorer

정답: E

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

문제2

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

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

A. FROM CSV

B. None of these lines of code are needed to successfully complete the task

C. USING DELTA

D. FROM "path/to/csv"

E. USING CSV

정답: E

문제3

Which of the following benefits is provided by the array functions from Spark SQL?

A. An ability to work with complex, nested data ingested from JSON files

B. An ability to work with time-related data in specified intervals

C. An ability to work with an array of tables for procedural automation

D. An ability to work with data within certain partitions and windows

E. An ability to work with data in a variety of types at once

정답: A

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

문제4

A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.
Which of the following approaches could be used by the data engineering team to complete this task?

A. They could redesign the data model to separate the data used in the final query into a new table.

B. They could submit a feature request with Databricks to add this functionality.

C. They could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.

D. They could wrap the queries using PySpark and use Python's control flow system to determine when to run the final query.

E. They could only run the entire program on Sundays.

정답: D

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

문제5

Which of the following describes the relationship between Bronze tables and raw data?

A. Bronze tables contain less data than raw data files.

B. Bronze tables contain more truthful data than raw data.

C. Bronze tables contain raw data with a schema applied.

D. Bronze tables contain a less refined view of data than raw data.

E. Bronze tables contain aggregates while raw data is unaggregated.

정답: C

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

문제6

A data engineer has a Job that has a complex run schedule, and they want to transfer that schedule to other Jobs.
Rather than manually selecting each value in the scheduling form in Databricks, which of the following tools can the data engineer use to represent and submit the schedule programmatically?

A. pyspark.sql.types.DateType

B. pyspark.sql.types.TimestampType

C. datetime

D. There is no way to represent and submit this information programmatically

E. Cron syntax

정답: E

설명: (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 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

문제8

Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

A. Data warehouse

B. None of these

C. Data lake

D. Data lakehouse

E. All of these

정답: D

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

문제9

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

A. MERGE

B. INSERT

C. DROP

D. APPEND

E. IGNORE

정답: A

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

문제10

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

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

우리와 연락하기

유용한 링크

최신 업데이트