A data engineer has a Python notebook in Databricks, but they need to use SQL to accomplish a specific task within a cell. They still want all of the other cells to use Python without making any changes to those cells.
Which of the following describes how the data engineer can use SQL within a cell of their Python notebook?

• A.They can change the default language of the notebook to SQL
• B.They can add %sql to the first line of the cell
• C.They can simply write SQL syntax in the cell
• D.It is not possible to use SQL in a Python notebook
• E.They can attach the cell to a SQL endpoint rather than a Databricks cluster

Comment: *

Name: *

Email: *

Verification: *

A pipeline uses COPY INTO to ingest CSV files from cloud object storage into a Unity Catalog Delta table. Some files are occasionally re-uploaded with corrections using the same filename.
The engineer needs the corrected data to be ingested as soon as it becomes available.
What should the engineer do?

• A.Overwrite the target Delta table during every run.
• B.Load corrections as new files and apply updates to the target table.
• C.Recreate the target table before every run.
• D.Reload all files from the source path during every run.

Comment: *

Name: *

Email: *

Verification: *

A data engineer is designing an ETL pipeline to process both streaming and batch data from multiple sources The pipeline must ensure data quality, handle schema evolution, and provide easy maintenance. The team is considering using Delta Live Tables (DLT) in Databricks to achieve these goals. They want to understand the key features and benefits of DLT that make it suitable for this use case.
Why is Delta Live Tables (DLT) an appropriate choice?

• A.Automatic data quality checks, built-in support for schema evolution, and declarative pipeline development
• B.Supports only batch processing, no data versioning, and high infrastructure costs
• C.Requires custom code for data quality checks, no support for streaming data, and complex pipeline maintenance
• D.Manual schema enforcement, high operational overhead, and limited scalability

Comment: *

Name: *

Email: *

Verification: *

Which file format is used for storing Delta Lake Table?

• A.Parquet
• B.Delta
• C.SV
• D.JSON

Comment: *

Name: *

Email: *

Verification: *

A data engineer runs a statement every day to copy the previous day's sales into the table transactions. Each day's sales are in their own file in the location "/transactions/raw".
Today, the data engineer runs the following command to complete this task:

After running the command today, the data engineer notices that the number of records in table transactions has not changed.
Which of the following describes why the statement might not have copied any new records into the table?

• A.The format of the files to be copied were not included with the FORMAT_OPTIONS keyword.
• B.The names of the files to be copied were not included with the FILES keyword.
• C.The previous day's file has already been copied into the table.
• D.The PARQUET file format does not support COPY INTO.
• E.The COPY INTO statement requires the table to be refreshed to view the copied rows.

Comment: *

Name: *

Email: *

Verification: *