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 section in the UI can be used to manage permissions and grants to tables?

Options :

A : User Settings

B : Admin UI

C : Workspace admin settings

D : User access control lists

E : Data Explorer

Answer: A

Question 3

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)

Options :

A : AS DEFAULT (CAST(orderTime as DATE))

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

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

D : AS (CAST(orderTime as DATE))

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

Answer: B

Question 4

The data engineering team is looking to add a new column to the table, but the QA team would like to test the change which of the below options allow you to quickly copy the table from Prod to QA environment, modify and run the tests

Options :

A : DEEP CLONE

B : SHADOW CLONE

C :

ZERO COPY CLONE

D : SHALLOW CLONE

E : METADATA CLONE

Answer: D

Question 5

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In

order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).

Which of the following code blocks creates this SQL UDF?