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

Why Databricks Databricks-Certified-Associate-Data-Engineer Practice Exam Questions?

Ready to level up your Databricks Databricks-Certified-Associate-Data-Engineer exam study? Just TheExamsLab Databricks-Certified-Associate-Data-Engineer practice tests free.

Databricks-Certified-Associate-Data-Engineer exam questions are expertly crafted practice tests designed to simulate the real Databricks certification exam environment and help you assess your knowledge and figure out where you are lacking. From our free Databricks Certified Data Engineer Associate Databricks-Certified-Associate-Data-Engineer practice exam, you will feel secure in passing any question type or time limit. TheExamsLab offers the Databricks-Certified-Associate-Data-Engineer exam questions 2024. Don’t settle or do it half-heartedly get the best and invest in the best what you want is what you get.

Page: 1 / 63

Total 315 Questions | Updated On: Nov 21, 2024

Add To Cart

Question 1

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.

Which command could the data engineering team use to access sales in PySpark?

A : SELECT * FROM sales

B : spark.table("sales")

C : spark.sql("sales")

D : spark.delta.table("sales")

Answer: B

Question 2

At the end of the inventory process a file gets uploaded to the cloud object storage, you are asked to build a process to ingest data which of the following method can be used to ingest the data incrementally, schema of the file is expected to change overtime ingestion process should be able to handle these changes automatically. Below is the auto loader to command to load the data, fill in the blanks for successful execution of below code.

spark.readStream

.format("cloudfiles")

.option("_______",”csv)

.option("_______", ‘dbfs:/location/checkpoint/’)

.load(data_source)

.writeStream

.option("_______",’ dbfs:/location/checkpoint/’)

.option("_______", "true")

.table(table_name))

A : format, checkpointlocation, schemalocation, overwrite

B : cloudfiles.format, checkpointlocation, cloudfiles.schemalocation, overwrite

C : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, mergeSchema

D : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, append

E : cloudfiles.format, cloudfiles.schemalocation, checkpointlocation, overwrite

Answer: C

Question 3

You currently working with marketing team to setup a dashboard on ad campaign analysis, since the team is not sure how often the dashboard should refreshed they have decided to do a manual refresh on as needed basis. Which of the following steps can be taken to reduce the overall cost of the compute?

A : They can turn on the Serverless feature for the SQL endpoint.

B : They can decrease the maximum bound of the SQL endpoint’s scaling range.

C : They can decrease the cluster size of the SQL endpoint.

D : They can turn on the Auto Stop feature for the SQL endpoint.

E : They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy from “Reliability Optimized” to “Cost optimized”

Answer: D

Question 4

You are tasked to setup a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department how do you go about to setup this in job?

A : Use a single notebook as task in the job and use dbutils.notebook.run to run each notebook with parameter in a different cell

B : A task in the job cannot take an input parameter, create six notebooks with hardcoded dept number and setup six tasks with linear dependency in the job

C : A task accepts key-value pair parameters, creates six tasks pass department number as parameter foreach task with no dependency in the job as they can all run in parallel.

D : A parameter can only be passed at the job level, create six jobs pass department number to each job with linear job dependency

E : A parameter can only be passed at the job level, create six jobs pass department number to each job with no job dependency

Answer: C

Question 5

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

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

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

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

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

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

Answer: B

Page: 1 / 63

Total 315 Questions | Updated On: Nov 21, 2024

Add To Cart