A data engineer needs to access the view created by the sales team, using a shared cluster. The data engineer has been provided usage permissions on the catalog and schema. In order to access the view created by sales team. What are the minimum permissions the data engineer would require in addition?

• A.Needs SELECT permission on the VIEW and the underlying TABLE.
• B.Needs ALL PRIVILEGES on the VIEW
• C.Needs SELECT permission only on the VIEW
• D.Needs ALL PRIVILEGES at the SCHEMA level

Comment: *

Name: *

Email: *

Verification: *

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following commands could the data engineering team use to access sales in PySpark?

• A.SELECT * FROM sales
• B.There is no way to share data between PySpark and SQL.
• C.spark.sql("sales")
• D.spark.delta.table("sales")
• E.spark.table("sales")

Comment: *

Name: *

Email: *

Verification: *

A data engineer is reviewing the documentation on audit logs in Databricks for compliance purposes and needs to understand the format in which audit logs output events. How are events formatted in Databricks audit logs?

• A.In Databricks, audit logs output events in a JSON format.
• B.In Databricks, audit logs output events in a CSV format.
• C.In Databricks, audit logs output events in an XML format.
• D.In Databricks, audit logs output events in a plain text format.

Comment: *

Name: *

Email: *

Verification: *

A data architect has determined that a table of the following format is necessary:

Which of the following code blocks uses SQL DDL commands to create an empty Delta table in the above format regardless of whether a table already exists with this name?

• A.Option A
• B.Option B
• C.Option C
• D.Option D
• E.Option 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: *