Try our Free Demo Practice Tests for Comprehensive Databricks-Certified-Associate-Data-Engineer Exam Preparation

Which of the following locations hosts the driver and worker nodes of a Databricks-managed cluster?

A data engineering team has two tables. The first table march_transactions is a collection of all retail

transactions in the month of March. The second table april_transactions is a collection of all retail

transactions in the month of April. There are no duplicate records between the tables.

Which of the following commands should be run to create a new table all_transactions that contains all

records from march_transactions and april_transactions without duplicate records?

A data analysis team has noticed that their Databricks SQL queries are running too slowly when connected to their always-on SQL endpoint. They claim that this issue is present when many members of the team are running small queries simultaneously. They ask the data engineering team for help. The data engineering team notices that each of the team’s queries uses the same SQL endpoint.

Which approach can the data engineering team use to improve the latency of the team’s queries?

Data science team members are using a single cluster to perform data analysis, although cluster size was chosen to handle multiple users and auto-scaling was enabled, the team realized queries are still running slow, what would be the suggested fix for this?