Question 26

Which of the following describes the relationship between Bronze tables and raw data?
  • Question 27

    A data architect has determined that a table of the following format is necessary:

    Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?
  • Question 28

    A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.
    Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?
  • Question 29

    A data engineer has created a new database using the following command:
    CREATE DATABASE IF NOT EXISTS customer360;
    In which of the following locations will the customer360 database be located?
  • Question 30

    A data engineer runs a statement every day to copy the previous day's sales into the table transactions. Each day's sales are in their own file in the location "/transactions/raw".
    Today, the data engineer runs the following command to complete this task:

    After running the command today, the data engineer notices that the number of records in table transactions has not changed.
    Which of the following describes why the statement might not have copied any new records into the table?