A data engineer needs to use a Delta table as part of a data pipeline, but they do not know if they have the appropriate permissions.
In which of the following locations can the data engineer review their permissions on the table?

• A.Repos
• B.Dashboards
• C.Databricks Filesystem
• D.Jobs
• E.Data Explorer

Comment: *

Name: *

Email: *

Verification: *

A data engineer uploads a CSV file using the Create or modify a table using file upload option in Databricks. To avoid incorrect schema inference, the engineer disables Automatically detect column types before creating a Unity Catalog-managed table.
What is the outcome?

• A.All columns are created with the STRING data type.
• B.Numeric columns are inferred as numeric types, while all other columns use STRING.
• C.Table creation fails because column types are not specified.
• D.Previously inferred column types are preserved.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has three tables in a Delta Live Tables (DLT) pipeline. They have configured the pipeline to drop invalid records at each table. They notice that some data is being dropped due to quality concerns at some point in the DLT pipeline. They would like to determine at which table in their pipeline the data is being dropped.
Which of the following approaches can the data engineer take to identify the table that is dropping the records?

• A.They can set up separate expectations for each table when developing their DLT pipeline.
• B.They cannot determine which table is dropping the records.
• C.They can set up DLT to notify them via email when records are dropped.
• D.They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
• E.They can navigate to the DLT pipeline page, click on the "Error" button, and review the present errors.

Comment: *

Name: *

Email: *

Verification: *

A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?
Which of the following code blocks can the data engineer use to complete this task?

• A.
• B.
• C.
• D.
• E.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has written a function in a Databricks Notebook to calculate the population of bacteria in a given medium.

Analysts use this function in the notebook and sometimes provide input arguments of the wrong data type, which can cause errors during execution.
Which Databricks feature will help the data engineer quickly identify if an incorrect data type has been provided as input?

• A.The Databricks debugger enables breakpoints that will raise an error if the wrong data type is submitted
• B.The Databricks debugger enables the use of a variable explorer to see at a glance the value of the variables.
• C.The Spark User interface has a debug tab that contains the variables that are used in this session.
• D.The Data Engineer should add print statements to find out what the variable is.

Comment: *

Name: *

Email: *

Verification: *