Question 1

You are asked to setup the alert to notify every time once the data is loaded into a reporting table, team also asked to include the number of records in the alert email notification.

Options :

A : Use notebook and python code to run every minute, using python variables to capture send the information in an email

B : Setup an alert but use the default template to notify the message in email’s subject

C : Setup an alert but use the custom template to notify the message in email’s subject

D : Use the webhook destination instead so alert message can be customized

E : Use custom email hook to customize the message

Answer: C

Question 2

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 3

A data engineer has joined an existing project and they see the following query in the project repository:CREATE STREAMING LIVE TABLE loyal_customers ASSELECT 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 4

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

Question 5

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

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

Buying Options: