Databricks-Certified-Professional-Data-Engineer Exam Question 11

The current ELT pipeline is receiving data from the operations team once a day so you had setup an AUTO LOADER process to run once a day using trigger (Once = True) and scheduled a job to run once a day, operations team recently rolled out a new feature that allows them to send data every 1 min, what changes do you need to make to AUTO LOADER to process the data every 1 min.
  • Databricks-Certified-Professional-Data-Engineer Exam Question 12

    Which of the following results in the creation of an external table?
  • Databricks-Certified-Professional-Data-Engineer Exam Question 13

    You are working on a process to load external CSV files into a delta table by leveraging the COPY INTO command, but after running the command for the second time no data was loaded into the table name, why is that?
    1.COPY INTO table_name
    2.FROM 'dbfs:/mnt/raw/*.csv'
    3.FILEFORMAT = CSV
  • Databricks-Certified-Professional-Data-Engineer Exam Question 14

    You are currently working on a notebook that will populate a reporting table for downstream process consumption, this process needs to run on a schedule every hour, what type of cluster are you going to use to set up this job?
  • Databricks-Certified-Professional-Data-Engineer Exam Question 15

    The data engineering team noticed that one of the job normally finishes in 15 mins but gets stuck randomly when reading remote databases due to a network packet drop, which of the following steps can be used to improve the stability of the job?