Valid Databricks-Certified-Data-Engineer-Associate Dumps shared by ExamDiscuss.com for Helping Passing Databricks-Certified-Data-Engineer-Associate Exam! ExamDiscuss.com now offer the newest Databricks-Certified-Data-Engineer-Associate exam dumps, the ExamDiscuss.com Databricks-Certified-Data-Engineer-Associate exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Databricks-Certified-Data-Engineer-Associate dumps with Test Engine here:
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?
Correct 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 the datetime module 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