What is the first line of a Databricks Python notebook when viewed in a text editor?

• A.%python
• B.# Databricks notebook source
• C.-- Databricks notebook source
• D.// Databricks notebook source
• E.# MAGIC %python

Comment: *

Name: *

Email: *

Verification: *

To reduce storage and compute costs, the data engineering team has been tasked with curating a series of aggregate tables leveraged by business intelligence dashboards, customer-facing applications, production machine learning models, and ad hoc analytical queries.
The data engineering team has been made aware of new requirements from a customer-facing application, which is the only downstream workload they manage entirely. As a result, an aggregate table used by numerous teams across the organization will need to have a number of fields renamed, and additional fields will also be added.
Which of the solutions addresses the situation while minimally interrupting other teams in the organization without increasing the number of tables that need to be managed?

• A.Send all users notice that the schema for the table will be changing; include in the communication the logic necessary to revert the new table schema to match historic queries.
• B.Configure a new table with all the requisite fields and new names and use this as the source for the customer-facing application; create a view that maintains the original data schema and table name by aliasing select fields from the new table.
• C.Create a new table with the required schema and new fields and use Delta Lake's deep clone functionality to sync up changes committed to one table to the corresponding table.
• D.Replace the current table definition with a logical view defined with the query logic currently writing the aggregate table; create a new table to power the customer-facing application.
• E.Add a table comment warning all users that the table schema and field names will be changing on a given date; overwrite the table in place to the specifications of the customer-facing application.

Comment: *

Name: *

Email: *

Verification: *

A data engineer, User A, has promoted a new pipeline to production by using the REST API to programmatically create several jobs. A DevOps engineer, User B, has configured an external orchestration tool to trigger job runs through the REST API. Both users authorized the REST API calls using their personal access tokens.
Which statement describes the contents of the workspace audit logs concerning these events?

• A.Because the REST API was used for job creation and triggering runs, a Service Principal will be automatically used to identity these events.
• B.Because User B last configured the jobs, their identity will be associated with both the job creation events and the job run events.
• C.Because these events are managed separately, User A will have their identity associated with the job creation events and User B will have their identity associated with the job run events.
• D.Because the REST API was used for job creation and triggering runs, user identity will not be captured in the audit logs.
• E.Because User A created the jobs, their identity will be associated with both the job creation Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from events and the job run events.

Comment: *

Name: *

Email: *

Verification: *

Which statement describes Delta Lake optimized writes?

• A.A shuffle occurs prior to writing to try to group data together resulting in fewer files instead of each executor writing multiple files based on directory partitions.
• B.Optimized writes logical partitions instead of directory partitions partition boundaries are only Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from represented in metadata fewer small files are written.
• C.An asynchronous job runs after the write completes to detect if files could be further compacted; yes, an OPTIMIZE job is executed toward a default of 1 GB.
• D.Before a job cluster terminates, OPTIMIZE is executed on all tables modified during the most recent job.

Comment: *

Name: *

Email: *

Verification: *

The view updates represents an incremental batch of all newly ingested data to be inserted or updated in the customers table.
The following logic is used to process these records.
Get Latest & Actual Certified-Data-Engineer-Professional Exam's Question and Answers from

Which statement describes this implementation?

• A.The customers table is implemented as a Type 2 table; old values are overwritten and new customers are appended.
• B.The customers table is implemented as a Type 3 table; old values are maintained as a new column alongside the current value.
• C.The customers table is implemented as a Type 0 table; all writes are append only with no changes to existing values.
• D.The customers table is implemented as a Type 1 table; old values are overwritten by new values and no history is maintained.
• E.The customers table is implemented as a Type 2 table; old values are maintained but marked as no longer current and new values are inserted.

Comment: *

Name: *

Email: *

Verification: *