Free Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions
Try our Free Demo Practice Tests for Comprehensive Databricks-Certified-Associate-Data-Engineer Exam Preparation
-
Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions
-
Provided By: Databricks
- Exam: Databricks Certified Data Engineer Associate
- Certification: Databricks Certified Associate
-
Total Questions: 315
-
Updated On: Sep 28, 2024
-
Rated: 4.9 |
-
Online Users: 630
-
Question 1
-
you are currently working on creating a spark stream process to read and write in for a one-time micro batch, and also rewrite the existing target table, fill in the blanks to complete the below command sucesfully.spark.table("source_table").writeStream.option("____", “dbfs:/location/silver").outputMode("____").trigger(Once=____).table("target_table")
Answer: A
-
-
Question 2
-
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Answer: A
-
-
Question 3
-
You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.
Answer: A
-
-
Question 4
-
Which of the following is a correct statement on how the data is organized in the storage when when managing a DELTA table?
Answer: A
-
-
Question 5
-
A data engineer has joined an existing project and they see the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS
SELECT customer_id -
FROM STREAM(LIVE.customers)
WHERE loyalty_level = 'high';
Which of the following describes why the STREAM function is included in the query?
Answer: C
-
A data engineer has joined an existing project and they see the following query in the project repository: