DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #89
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #89: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.
Question
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?
Options
- 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
- 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
- EThey could redesign the data model to separate the data used in the final query into a new table.
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.