Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation.A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated.How can the scenario be implemented?
A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.The code block used by the data engineer is below:The data engineer only wants the query to process all of the available data in as many batches as required.Which line of code should the data engineer use to fill in the blank?
A data engineer is working with two tables. Each of these tables is displayed below in its entirety.The data engineer runs the following query to join these tables together:Which of the following will be returned by the above query?
A data engineer wants to schedule their Databricks SQL dashboard to refresh once per day, but they only want the associated SQL endpoint to be running when it is necessary.Which approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
Which query is performing a streaming hop from raw data to a Bronze table?
An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query. For the first week following the project’s release, the manager wants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project’s release.Which approach can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project’s release?
