Question 1

Which of the following is a correct statement on how the data is organized in the storage when when managing a DELTA table?

Options :

A : All of the data is broken down into one or many parquet files, log files are broken down into one or many JSON files, and each transaction creates a new data file(s) and log file.

B : All of the data and log are stored in a single parquet file

C : All of the data is broken down into one or many parquet files, but the log file is stored as a single json file, and every transaction creates a new data file(s) and log file gets appended.

D : All of the data is broken down into one or many parquet files, log file is removed once the transaction is committed.

E : All of the data is stored into one parquet file, log files are broken down into one or many json files.

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?

Options :

A : MERGE INTO table_name

B : COPY INTO table_name

C : UPDATE table_name

D : INSERT INTO OVERWRITE table_name

E : INSERT IF EXISTS table_name

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.

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 4

Which of the following statements are incorrect about the lakehouse

Options :

A : Support end-to-end streaming and batch workloads

B : Supports ACID

C : Support for diverse data types that can store both structured and unstructured

D : Supports BI and Machine learning

E : Storage is coupled with Compute

Answer: E

Question 5

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

Options :

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

Confidently Practice Online with Free Databricks-Certified-Associate-Data-Engineer Exam Cram

Buying Options: