Which of the following describes a scenario in which a data team will want to utilize cluster pools?

• A.An automated report needs to be refreshed as quickly as possible.
• B.An automated report needs to be made reproducible.
• C.An automated report needs to be tested to identify errors.
• D.An automated report needs to be version-controlled across multiple collaborators.
• E.An automated report needs to be runnable by all stakeholders.

Comment: *

Name: *

Email: *

Verification: *

A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:

Which of the following lines of code fills in the above blank to successfully complete the task?

• A.USING DELTA
• B.FROM "path/to/csv"
• C.USING CSV
• D.FROM CSV
• E.None of these lines of code are needed to successfully complete the task

Comment: *

Name: *

Email: *

Verification: *

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following commands could the data engineering team use to access sales in PySpark?

• A.SELECT * FROM sales
• B.There is no way to share data between PySpark and SQL.
• C.spark.sql("sales")
• D.spark.delta.table("sales")
• E.spark.table("sales")

Comment: *

Name: *

Email: *

Verification: *

In order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing, which of the following two approaches is used by Spark to record the offset range of the data being processed in each trigger?

• A.Checkpointing and Write-ahead Logs
• B.Checkpointing and Idempotent Sinks
• C.Replayable Sources and Idempotent Sinks
• D.Structured Streaming cannot record the offset range of the data being processed in each trigger.
• E.Write-ahead Logs and Idempotent Sinks

Comment: *

Name: *

Email: *

Verification: *

A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day.
They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.
Which of the following approaches could be used by the data engineering team to complete this task?

• A.They could submit a feature request with Databricks to add this functionality.
• B.They could wrap the queries using PySpark and use Python's control flow system to determine when to run the final query.
• C.They could only run the entire program on Sundays.
• D.They could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.
• E.They could redesign the data model to separate the data used in the final query into a new table.

Comment: *

Name: *

Email: *

Verification: *