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 can set up DLT to notify them via email when records are dropped.
• C.They can navigate to the DLT pipeline page, click on each table, and view the data quality statistics.
• D.They can navigate to the DLT pipeline page, click on the "Error" button, and review the present errors.
• E.They cannot determine which table is dropping the records.

Comment: *

Name: *

Email: *

Verification: *

A data engineer wants to create a new table containing the names of customers that live in France.
They have written the following command:

A senior data engineer mentions that it is organization policy to include a table property indicating that the new table includes personally identifiable information (PII).
Which of the following lines of code fills in the above blank to successfully complete the task?

• A.There is no way to indicate whether a table contains PII.
• B."COMMENT PII"
• C.TBLPROPERTIES PII
• D.COMMENT "Contains PII"
• E.PII

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands will return the location of database customer360?

• A.DESCRIBE LOCATION customer360;
• B.DROP DATABASE customer360;
• C.DESCRIBE DATABASE customer360;
• D.ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• E.USE DATABASE customer360;

Comment: *

Name: *

Email: *

Verification: *

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

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

Comment: *

Name: *

Email: *

Verification: *

A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?

• A.if day_of_week = 1 and review_period:
• B.if day_of_week = 1 and review_period = "True":
• C.if day_of_week == 1 and review_period == "True":
• D.if day_of_week == 1 and review_period:
• E.if day_of_week = 1 & review_period: = "True":

Comment: *

Name: *

Email: *

Verification: *