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: Aug 24, 2022

Add To Cart

Question 1

When working with AUTO LOADER you noticed that most of the columns that were inferred as part of loading are string data types including columns that were supposed to be integers, how can we fix this?

A : ovide the schema of the source table in the cloudfiles.schemalocation

B : ovide the schema of the target table in the cloudfiles.schemalocation

C : ovide schema hints

D : date the checkpoint location

E : rrect the incoming data by explicitly casting the data types

Answer: C

Question 2

You were asked to create a table that can store the below data, note that orderDate is the truncated date format of OrderTime, fill in the blank to complete the DDL.

2022-07-06-16-41-20-9e89d31650240d1b2e8d70a6bcae78b0

CREATE TABLE orders (

orderId int,

orderTime timestamp,

orderdate date _____________________________________________ ,

units int)

A : DEFAULT (CAST(orderTime as DATE))

B : NERATED ALWAYS AS (CAST(orderTime as DATE))

C : NERATED DEFAULT AS (CAST(orderTime as DATE))

D : (CAST(orderTime as DATE))

E : lta lake does not support calculated columns, value should be inserted into the table as part of the ingestion process

Answer: B

Question 3

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 4

Which of the following benefits is provided by the array functions from Spark SQL?

A : ability to work with data in a variety of types at once

B : ability to work with data within certain partitions and windows

C : ability to work with time-related data in specified intervals

D : ability to work with complex, nested data ingested from JSON files

E : ability to work with an array of tables for procedural automation

Answer: B

Question 5

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

Page: 1 / 63

Total 315 Questions | Updated On: Aug 24, 2022

Add To Cart