You are trying to create an object by joining two tables that and it is accessible to data scientist's team, so it does not get dropped if the cluster restarts or if the notebook is detached. What type of object are you trying to create?

• A.Temporary view
• B.Global Temporary view
• C.Global Temporary view with cache option
• D.External view
• E.View

Comment: *

Name: *

Email: *

Verification: *

A table named user_ltv is being used to create a view that will be used by data analysts on various teams. Users in the workspace are configured into groups, which are used for setting up data access using ACLs.
The user_ltv table has the following schema:
email STRING, age INT, ltv INT
The following view definition is executed:

An analyst who is not a member of the marketing group executes the following query:
SELECT * FROM email_ltv
Which statement describes the results returned by this query?

• A.Three columns will be returned, but one column will be named "redacted" and contain only null values.
• B.Only the email and itv columns will be returned; the email column will contain all null values.
• C.The email and ltv columns will be returned with the values in user itv.
• D.The email, age. and ltv columns will be returned with the values in user ltv.
• E.Only the email and ltv columns will be returned; the email column will contain the string "REDACTED" in each row.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has created a transactions Delta table on Databricks that should be used by the analytics team. The analytics team wants to use the table with another tool that requires Apache Iceberg format.
What should the data engineer do?

• A.Require the analytics team to use a tool that supports Delta table.
• B.Enable uniform on the transactions table to 'iceberg' so that the table can be read as an Iceberg table.
• C.Create an Iceberg copy of the transactions Delta table which can be used by the analytics team.
• D.Convert the transactions Delta table to Iceberg and enable uniform so that the table can be read as a Delta table.

Comment: *

Name: *

Email: *

Verification: *

A junior data engineer on your team has implemented the following code block.

The viewnew_eventscontains a batch of records with the same schema as theeventsDelta table.
Theevent_idfield serves as a unique key for this table.
When this query is executed, what will happen with new records that have the sameevent_idas an existing record?

• A.They are merged.
• B.They are ignored.
• C.They are updated.
• D.They are inserted.
• E.They are deleted.

Comment: *

Name: *

Email: *

Verification: *

A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on Task A.
If task A fails during a scheduled run, which statement describes the results of this run?

• A.Because all tasks are managed as a dependency graph, no changes will be committed to the Lakehouse until all tasks have successfully been completed.
• B.Tasks B and C will attempt to run as configured; any changes made in task A will be rolled back due to task failure.
• C.Unless all tasks complete successfully, no changes will be committed to the Lakehouse; because task A failed, all commits will be rolled back automatically.
• D.Tasks B and C will be skipped; some logic expressed in task A may have been committed before task failure.
• E.Tasks B and C will be skipped; task A will not commit any changes because of stage failure.

Comment: *

Name: *

Email: *

Verification: *