Databricks Exam Databricks-Certified-Data-Engineer-Associate Topic 1 Question 6 Discussion

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

Question #: 6
Topic #: 1

[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

by Beatriz at Mar 30, 2023, 06:22 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

Currently there are no comments in this discussion, be the first to comment!