Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 2 Question 48 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam

Question #: 48
Topic #: 2

[All Databricks-Certified-Data-Engineer-Associate Questions]

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?

AThey could submit a feature request with Databricks to add this functionality.

BThey could wrap the queries using PySpark and use Python's control flow system to determine when to run the final query.

CThey could only run the entire program on Sundays.

DThey could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.

EThey could redesign the data model to separate the data used in the final query into a new table.

Show Suggested Answer

Suggested Answer: B

This approach would allow the data engineering team to use the existing SQL program and add some logic to control the execution of the final query based on the day of the week. They could use thedatetimemodule in Python to get the current date and check if it is a Sunday. If so, they could run the final query, otherwise they could skip it. This way, they could schedule the program to run every day without changing the data model or the source table.Reference:PySpark SQL Module,Python datetime Module,Databricks Jobs

by Brandon at Apr 09, 2025, 01:02 PM

Limited Time Offer

25%

Off

Get Premium Databricks-Certified-Data-Engineer-Associate Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Casie

7 days ago

Option B seems like a pretty straightforward solution. Using Python's control flow to selectively run the final query on Sundays is a smart approach.

upvoted 0 times

...