Question 1

A data engineer has joined an existing project and they see the following query in the project repository:

CREATE STREAMING LIVE TABLE loyal_customers AS

SELECT customer_id -

FROM STREAM(LIVE.customers)

WHERE loyalty_level = 'high';

Which of the following describes why the STREAM function is included in the query?

Options :

A : The STREAM function is not needed and will cause an error.

B : The table being created is a live table.

C : The customers table is a streaming live table.

D : The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.

E : The data in the customers table has been updated since its last run.

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

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 4

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

Question 5

A data engineering team has two tables. The first table march_transactions is a collection of all retail

transactions in the month of March. The second table april_transactions is a collection of all retail

transactions in the month of April. There are no duplicate records between the tables.

Which of the following commands should be run to create a new table all_transactions that contains all

records from march_transactions and april_transactions without duplicate records?

Options :

A :