Free Online Databricks Databricks-Certified-Associate-Data-Engineer Practice Test

Prepare Your Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions with Free online Databricks-Certified-Associate-Data-Engineer Practice Test. Get Brilliant Databricks Certified Data Engineer Associate Exam Results with Valid Databricks Certified Associate Data Engineer Exam Dumps.

Page: 1 / 63

Total 315 Questions | Updated On: May 11, 2024

Add To Cart

Question 1

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL. The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.

Which of the following changes will need to be made to the pipeline when migrating to Delta Live Tables?

A : None of these changes will need to be made

B : The pipeline will need to stop using the medallion-based multi-hop architecture

C : The pipeline will need to be written entirely in SQL

D : The pipeline will need to use a batch source in place of a streaming source

E : The pipeline will need to be written entirely in Python

Answer: B

Question 2

You are currently working on a project that requires the use of SQL and Python in a given notebook, what would be your approach

A : Create two separate notebooks, one for SQL and the second for Python

B : A single notebook can support multiple languages, use the magic command to switch between the two.

C : Use an All-purpose cluster for python, SQL endpoint for SQL

D : Use job cluster to run python and SQL Endpoint for SQL

Answer: B

Question 3

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 : 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 4

Which of the following statements are correct on how Delta Lake implements a lake house?

A : Delta lake uses a proprietary format to write data, optimized for cloud storage

B : Using Apache Hadoop on cloud object storage

C : Delta lake always stores meta data in memory vs storage

D : Delta lake uses open source, open format, optimized cloud storage and scalable meta data

Answer: D

Question 5

Which of the following SQL statement can be used to query a table by eliminating duplicate rows from the query results?

A : SELECT DISTINCT * FROM table_name

B : SELECT DISTINCT * FROM table_name HAVING COUNT(*) > 1

C : SELECT DISTINCT_ROWS (*) FROM table_name

D : SELECT * FROM table_name GROUP BY * HAVING COUNT(*) < 1

E : SELECT * FROM table_name GROUP BY * HAVING COUNT(*) > 1

Answer: A

Page: 1 / 63

Total 315 Questions | Updated On: May 11, 2024

Add To Cart