Question 46

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?
  • Question 47

    A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.
    Which of the following data entities should the data engineer create?
  • Question 48

    A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.
    Which of the following approaches can the data engineer take to identify the table that is dropping the records?
  • Question 49

    Which of the following is hosted completely in the control plane of the classic Databricks architecture?
  • Question 50

    A data engineer needs to create a table in Databricks using data from their organization's existing SQLite database.
    They run the following command:

    Which of the following lines of code fills in the above blank to successfully complete the task?