Databricks-Certified-Data-Engineer-Associate 試験問題を無料オンラインアクセス

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:

The data engineer only wants the query to process all of the available data in as many batches as required.
Which line of code should the data engineer use to fill in the blank?

• A.trigger(processingTime="once")
• B.trigger(once=True)
• C.trigger(continuous="once")
• D.trigger(availableNow=True)

A data engineering team runs nightly batch ETL pipelines that transform large volumes of data stored in Delta Lake. The workloads are predictable and run on a fixed schedule. The team wants automatic scaling and cost efficiency, paying only for compute used during job execution. Which Databricks compute option is appropriate for this workload?

• A.A Databricks SQL warehouse configured for serverless execution.
• B.A single-node compute cluster configured without autoscaling.
• C.A job compute cluster triggered by a scheduled workflow.
• D.An all-purpose compute cluster configured with autoscaling.

A data engineer must create a copy of a production Delta table for a one-time schema experiment. The copy must be fully independent so that later VACUUM operations on the source cannot invalidate it.
Which command should be used?

• A.CREATE TABLE test_orders LIKE prod_orders
• B.CREATE TABLE test_orders DEEP CLONE prod_orders
• C.CREATE VIEW test_orders AS SELECT * FROM prod_orders
• D.CREATE TABLE test_orders SHALLOW CLONE prod_orders

A data engineer wants to create a new table containing the names of customers that live in France.
They have written the following command:

A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII).
Which of the following lines of code fills in the above blank to successfully complete the task?

• A.COMMENT "Contains PII"
• B.There is no way to indicate whether a table contains PII.
• C.PII
• D.TBLPROPERTIES PII
• E."COMMENT PII"

Which languages are supported by Serverless compute clusters? (Choose two.)

• A.R
• B.Python
• C.Java
• D.Scala
• E.SQL