Free Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions

Become Databricks Certified with updated Databricks-Certified-Associate-Data-Engineer exam questions and correct answers

Page: 1 / 63

Total 315 Questions | Updated On: Apr 19, 2025

Add To Cart

Question 1

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?

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

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

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

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

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

Answer: B

Question 2

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

A : ta plane

B : ntrol plane

C : tabricks Filesystem

D : BC data source

E : tabricks web application

Answer: A

Question 3

Define an external SQL table by connecting to a local instance of an SQLite database using JDBC

A : CREATE TABLE users_jdbcUSING SQLITEOPTIONS ( url = "jdbc:/sqmple_db", dbtable = "users")

B : CREATE TABLE users_jdbcUSING SQLURL = {server:"jdbc:/sqmple_db",dbtable: “users”}

C : CREATE TABLE users_jdbcUSING SQLOPTIONS ( url = "jdbc:sqlite:/sqmple_db", dbtable = "users")

D : CREATE TABLE users_jdbcUSING org.apache.spark.sql.jdbc.sqliteOPTIONS ( url = "jdbc:/sqmple_db", dbtable = "users")

E : CREATE TABLE users_jdbcUSING org.apache.spark.sql.jdbcOPTIONS ( url = "jdbc:sqlite:/sqmple_db", dbtable = "users")

Answer: A

Question 4

Which data lakehouse feature results in improved data quality over a traditional data lake?

A : A data lakehouse stores data in open formats.

B : A data lakehouse allows the use of SQL queries to examine data.

C : A data lakehouse provides storage solutions for structured and unstructured data.

D : A data lakehouse supports ACID-compliant transactions.

Answer: D

Question 5

You are designing a data model that works for both machine learning using images and Batch ETL/ELT workloads. Which of the following features of data lakehouse can help you meet the needs of both workloads?

A : ta lakehouse requires very little data modeling.

B : ta lakehouse combines compute and storage for simple governance

C : ta lakehouse provides autoscaling for compute clusters.

D : ta lakehouse can store unstructured data and support ACID transactions.

E : ta lakehouse fully exists in the cloud.

Answer: D

Page: 1 / 63

Total 315 Questions | Updated On: Apr 19, 2025

Add To Cart