A Delta Lake table representing metadata about content from user has the following schema:
user_id LONG, post_text STRING, post_id STRING, longitude FLOAT, latitude FLOAT, post_time TIMESTAMP, date DATE Based on the above schema, which column is a good candidate for partitioning the Delta Table?

• A.Date
• B.Post_id
• C.User_id
• D.Post_time

Comment: *

Name: *

Email: *

Verification: *

The business reporting tem requires that data for their dashboards be updated every hour. The total processing time for the pipeline that extracts transforms and load the data for their pipeline runs in 10 minutes.
Assuming normal operating conditions, which configuration will meet their service-level agreement requirements with the lowest cost?

• A.Schedule a jo to execute the pipeline once and hour on a dedicated interactive cluster.
• B.Schedule a Structured Streaming job with a trigger interval of 60 minutes.
• C.Schedule a job to execute the pipeline once hour on a new job cluster.
• D.Configure a job that executes every time new data lands in a given directory.

Comment: *

Name: *

Email: *

Verification: *

A new data engineer notices that a critical field was omitted from an application that writes its Kafka source to Delta Lake. This happened even though the critical field was in the Kafka source. That field was further missing from data written to dependent, long-term storage. The retention threshold on the Kafka service is seven days. The pipeline has been in production for three months.
Which describes how Delta Lake can help to avoid data loss of this nature in the future?

• A.The Delta log and Structured Streaming checkpoints record the full history of the Kafka producer.
• B.Delta Lake schema evolution can retroactively calculate the correct value for newly added fields, as long as the data was in the original source.
• C.Delta Lake automatically checks that all fields present in the source data are included in the ingestion layer.
• D.Data can never be permanently dropped or deleted from Delta Lake, so data loss is not possible under any circumstance.
• E.Ingestine all raw data and metadata from Kafka to a bronze Delta table creates a permanent, replayable history of the data state.

Comment: *

Name: *

Email: *

Verification: *

Assuming that the Databricks CLI has been installed and configured correctly, which Databricks CLI command can be used to upload a custom Python Wheel to object storage mounted with the DBFS for use with a production job?

• A.configure
• B.fs
• C.jobs
• D.libraries
• E.workspace

Comment: *

Name: *

Email: *

Verification: *

A data architect has determined that a table of the following format is necessary:
Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above
format regardless of whether a table already exists with this name?

• A.1. CREATE OR REPLACE TABLE table_name AS
  2. SELECT id STRING, birthDate DATE, avgRating FLOAT USING DELTA
• B.1. CREATE OR REPLACE TABLE table_name ( id STRING, birthDate DATE, avgRating FLOAT )
• C.1. CREATE TABLE IF NOT EXISTS table_name ( id STRING, birthDate DATE, avgRating FLOAT )
• D.1. CREATE OR REPLACE TABLE table_name
  2. WITH COLUMNS ( id STRING, birthDate DATE, avgRating FLOAT ) USING DELTA
• E.1. CREATE TABLE table_name AS
  2. SELECT id STRING, birthDate DATE, avgRating FLOAT

Comment: *

Name: *

Email: *

Verification: *