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

You are designing a data model that works for both machine learning using images and Batch ETL/ELT workloads. Which of the following features of data lakehouse can help you meet the needs of both workloads?

Options :

A : Data lakehouse requires very little data modeling.

B : Data lakehouse combines compute and storage for simple governance

C : Data lakehouse provides autoscaling for compute clusters.

D : Data lakehouse can store unstructured data and support ACID transactions.

E : Data lakehouse fully exists in the cloud.

Answer: D

Question 3

Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

Options :

A : None of these

B : Data lake

C : Data warehouse

D : All of these

E : Data lakehouse

Answer: E

Question 4

When working with AUTO LOADER you noticed that most of the columns that were inferred as part of loading are string data types including columns that were supposed to be integers, how can we fix this?

Options :

A : Provide the schema of the source table in the cloudfiles.schemalocation

B : Provide the schema of the target table in the cloudfiles.schemalocation

C : Provide schema hints

D : Update the checkpoint location

E : Correct the incoming data by explicitly casting the data types

Answer: C

Question 5

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