Databricks-Certified-Data-Engineer-Associate試験無料問題集（102題）「Databricks Certified Data Engineer Associate 認定」

出題：1

A data engineer needs to determine whether to use the built-in Databricks Notebooks versioning or version their project using Databricks Repos.
Which of the following is an advantage of using Databricks Repos over the Databricks Notebooks versioning?

A. Databricks Repos allows users to revert to previous versions of a notebook

B. Databricks Repos automatically saves development progress

C. Databricks Repos provides the ability to comment on specific changes

D. Databricks Repos is wholly housed within the Databricks Lakehouse Platform

E. Databricks Repos supports the use of multiple branches

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which of the following Git operations must be performed outside of Databricks Repos?

A. Merge

B. Push

C. Commit

D. Pull

E. Clone

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

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

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

B. When they are working with SQL within Databricks SQL

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

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

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

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which of the following tools is used by Auto Loader process data incrementally?

A. Unity Catalog

B. Checkpointing

C. Data Explorer

D. Databricks SQL

E. Spark Structured Streaming

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.
Which of the following data entities should the data engineer create?

A. View

B. Temporary view

C. Database

D. Table

E. Function

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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

A. grant all privileges on table sales TO team;

B. GRANT ALL PRIVILEGES ON TABLE team TO sales;

C. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;

D. GRANT SELECT ON TABLE sales TO team;

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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

A. None of these

B. Data warehouse

C. Data lake

D. All of these

E. Data lakehouse

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

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 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database. They run the following command:
CREATE TABLE jdbc_customer360
USING
OPTIONS (
url "jdbc:sqlite:/customers.db", dbtable "customer360"
)
Which line of code fills in the above blank to successfully complete the task?

A. org.apache.spark.sql.jdbc

B. org.apache.spark.sql.sqlite

C. autoloader

D. sqlite

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

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. Cron syntax

B. datetime

C. pyspark.sql.types.DateType

D. pyspark.sql.types.TimestampType

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

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

Databricks-Certified-Data-Engineer-Associate試験無料問題集「Databricks Certified Data Engineer Associate 認定」