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 has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

• A.The VACUUM command was run on the table
• B.The TIME TRAVEL command was run on the table
• C.The DELETE HISTORY command was run on the table
• D.The OPTIMIZE command was nun on the table
• E.The HISTORY command was run on the table

Comment: *

Name: *

Email: *

Verification: *

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which command can be used to grant full permissions on the database to the new data engineering team?

• A.grant all privileges on table sales TO team;
• B.GRANT SELECT ON TABLE sales TO team;
• C.GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• D.GRANT ALL PRIVILEGES ON TABLE team TO sales;

Comment: *

Name: *

Email: *

Verification: *

Which of the following commands can be used to write data into a Delta table while avoiding the writing of duplicate records?

• A.DROP
• B.IGNORE
• C.MERGE
• D.APPEND
• E.INSERT

Comment: *

Name: *

Email: *

Verification: *

A data engineer has been using a Databricks SQL dashboard to monitor the cleanliness of the input data to an ELT job. The ELT job has its Databricks SQL query that returns the number of input records containing unexpected NULL values. The data engineer wants their entire team to be notified via a messaging webhook whenever this value reaches 100.
Which of the following approaches can the data engineer use to notify their entire team via a messaging webhook whenever the number of NULL values reaches 100?

• A.They can set up an Alert with a custom template.
• B.They can set up an Alert with a new email alert destination.
• C.They can set up an Alert with a new webhook alert destination.
• D.They can set up an Alert with one-time notifications.
• E.They can set up an Alert without notifications.

Comment: *

Name: *

Email: *

Verification: *