Question 1

Which type of workloads are compatible with Auto Loader?

Options :

A : Streaming workloads

B : Machine learning workloads

C : Serverless workloads

D : Batch workloads

E : Dashboard workloads

Answer: A

Question 2

Which of the following data workloads will utilize a gold table as its source?

Options :

A : A job that enriches data by parsing its timestamps into a human-readable format

B : A job that queries aggregated data that already feeds into a dashboard

C : A job that ingests raw data from a streaming source into the Lakehouse

D : A job that aggregates cleaned data to create standard summary statistics

E : A job that cleans data by removing malformatted records

Answer: B

Question 3

Delete records from the transactions Delta table where transactionDate is greater than current timestamp?

Options :

A : DELETE FROM transactions FORMAT DELTA where transactionDate > currenct_timestmap()

B : DELETE FROM transactions if transctionDate > current_timestamp()

C : DELETE FROM transactions where transactionDate > current_timestamp()

D : DELETE FROM transactions where transactionDate > current_timestamp() KEEP_HISTORY

E : DELET FROM transactions where transactionDate GE current_timestamp()

Answer: C

Question 4

The data engineering team is using a SQL query to review data completeness every day to monitor the ETL job, and query output is being used in multiple dashboards which of the following approaches can be used to set up a schedule and automate this process?

Options :

A : They can schedule the query to run every day from the Jobs UI.

B : They can schedule the query to refresh every day from the query’s page in Databricks SQL

C : They can schedule the query to run every 12 hours from the Jobs UI.

D : They can schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.

E : They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL

Answer: B

Question 5

The sales team has asked the Data engineering team to develop a dashboard that shows sales performance for all stores, but the sales team would like to use the dashboard but would like to select individual store location, which of the following approaches Data Engineering team can use to build this functionality into the dashboard.

Options :

A : Use query Parameters which then allow user to choose any location

B : Currently dashboards do not support parameters

C : Use Databricks REST API to create a dashboard for each location

D : Use SQL UDF function to filter the data based on the location

E : Use Dynamic views to filter the data based on the location

Answer: A

Free Databricks-Certified-Associate-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: