Question 1

Delete records from the transactions Delta table where transactionDate is greater than current timestamp?

Options :

A : DELETE FROM transactions FORMAT DELTA where transactionDate > currenct_timestmap()

B : DELETE FROM transactions if transctionDate > current_timestamp()

C : DELETE FROM transactions where transactionDate > current_timestamp()

D : DELETE FROM transactions where transactionDate > current_timestamp() KEEP_HISTORY

E : DELET FROM transactions where transactionDate GE current_timestamp()

Answer: C

Question 2

Which of the following is not a privilege in the Unity catalog?

Options :

A : SELECT

B : MODIFY

C : EXECUTE

D : CREATE

E : USAGE

Answer: C

Question 3

What is the purpose of a gold layer in Multi-hop architecture?

Options :

A : Optimizes ETL throughput and analytic query performance

B : Eliminate duplicate records

C : Preserves grain of original data, without any aggregations

D : Data quality checks and schema enforcement

E : Powers ML applications, reporting, dashboards and adhoc reports.

Answer: A

Question 4

When defining external tables using formats CSV, JSON, TEXT, BINARY any query on the external tables caches the data and location for performance reasons, so within a given spark session any new files that may have arrived will not be available after the initial query. How can we address this limitation?

Options :

A :

UNCACHE TABLE table_name

B : CACHE TABLE table_name

C : REFRESH TABLE table_name

D : BROADCAST TABLE table_name

E : CLEAR CACH table_name

Answer: C

Question 5

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