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
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?
