Question 1

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 2

You are currently working on a project that requires the use of SQL and Python in a given notebook, what would be your approach

Options :

A : Create two separate notebooks, one for SQL and the second for Python

B : A single notebook can support multiple languages, use the magic command to switch between the two.

C : Use an All-purpose cluster for python, SQL endpoint for SQL

D : Use job cluster to run python and SQL Endpoint for SQL

Answer: B

Question 3

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 4

A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.

Which approach can the data engineer use to set up the new task?

Options :

A : They can clone the existing task in the existing Job and update it to run the new notebook.

B :

They can create a new task in the existing Job and then add it as a dependency of the original task.

C :

They can create a new task in the existing Job and then add the original task as a dependency of the new task.

D : They can create a new job from scratch and add both tasks to run concurrently.

E : They can clone the existing task to a new Job and then edit it to run the new notebook.

Answer: C

Question 5

Which of the following python statement can be used to replace the schema name and table name in the query statement?

Options :

A :

table_name = "sales"

schema_name = "bronze"

query = f”select * from schema_name.table_name”

B :

table_name = "sales"

schema_name = "bronze"

query = "select * from {schema_name}.{table_name}"

C :

table_name = "sales"

schema_name = "bronze"

query = f"select * from { schema_name}.{table_name}"

D :

table_name = "sales"

schema_name = "bronze"

query = f"select * from + schema_name +"."+table_name"

Answer: C

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

Buying Options: