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 DELETE HISTORY command was run on the table
• B.The VACUUM command was run on the table
• C.The OPTIMIZE command was nun on the table
• D.The HISTORY command was run on the table
• E.The TIME TRAVEL command was run on the table

Comment: *

Name: *

Email: *

Verification: *

A data engineering team has noticed that their Databricks SQL queries are running too slowly when they are submitted to a non-running SQL endpoint. The data engineering team wants this issue to be resolved.
Which of the following approaches can the team use to reduce the time it takes to return results in this scenario?

• A.They can turn on the Serverless feature for the SQL endpoint and change the Spot Instance Policy to "Reliability Optimized."
• B.They can turn on the Auto Stop feature for the SQL endpoint.
• C.They can increase the cluster size of the SQL endpoint.
• D.They can turn on the Serverless feature for the SQL endpoint.
• E.They can increase the maximum bound of the SQL endpoint's scaling range

Comment: *

Name: *

Email: *

Verification: *

A data engineer is running code in a Databricks Repo that is cloned from a central Git repository. A colleague of the data engineer informs them that changes have been made and synced to the central Git repository. The data engineer now needs to sync their Databricks Repo to get the changes from the central Git repository.
Which of the following Git operations does the data engineer need to run to accomplish this task?

• A.Merge
• B.Push
• C.Pull
• D.Commit
• E.Clone

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 new data engineering team has been assigned to work on a project. The team will need access to database customers in order to see what tables already exist. The team has its own group team.
Which of the following commands can be used to grant the necessary permission on the entire database to the new team?

• A.GRANT VIEW ON CATALOG customers TO team;
• B.GRANT CREATE ON DATABASE customers TO team;
• C.GRANT USAGE ON CATALOG team TO customers;
• D.GRANT CREATE ON DATABASE team TO customers;
• E.GRANT USAGE ON DATABASE customers TO team;

Comment: *

Name: *

Email: *

Verification: *