Question 1

The sales team has asked the Data engineering team to develop a dashboard that shows sales performance for all stores, but the sales team would like to use the dashboard but would like to select individual store location, which of the following approaches Data Engineering team can use to build this functionality into the dashboard.

Options :

A : Use query Parameters which then allow user to choose any location

B : Currently dashboards do not support parameters

C : Use Databricks REST API to create a dashboard for each location

D : Use SQL UDF function to filter the data based on the location

E : Use Dynamic views to filter the data based on the location

Answer: A

Question 2

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.

Options :

A : Databricks notebooks support change tracking and versioning

B : Databricks notebooks should be copied to a local machine and setup source control locally to version the notebooks

C : Databricks notebooks can be exported into dbc archive files and stored in data lake

D : Databricks notebook can be exported as HTML and imported at a later time

Answer: A

Question 3

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?

Options :

A : SELECT * FROM sales

B : spark.table("sales")

C : spark.sql("sales")

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

Answer: B

Question 4

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

Options :

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

When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

Options :

A : Drops table from meta store, drops metadata, history, and data in storage.

B : Drops table from meta store and data from storage but keeps metadata and history in storage

C : Drops table from meta store, meta data and history but keeps the data in storage

D : Drops table but keeps meta data, history and data in storage

E : Drops table and history but keeps meta data and data in storage

Answer: A