Databricks Databricks-Certified-Professional-Data-Engineer Dumps Questions Answers

Explanation

TRANSFORM -> Transforms elements in an array in expr using the function func.

1.transform(expr, func)

Explanation

The answer is Drops table from metastore, but keeps metadata and data in storage.

When an external table is dropped, only the table definition is dropped from metastore everything including data and metadata(Delta transaction log, time travel history) remains in the storage. Delta log is considered as part of metadata because if you drop a column in a delta table(managed or external) the column is not physically removed from the parquet files rather it is recorded in the delta log. The delta log becomes a key metadata layer for a Delta table to work.

Please see the below image to compare the external delta table and managed delta table and how they differ in how they are created and what happens if you drop the table.

Diagram Description automatically generated

Explanation

The answer is,

The entire dashboard with 10 queries can be refreshed at once, single schedule needs to be set up to refresh at 8 AM.

Automatically refresh a dashboard

A dashboard’s owner and users with the Can Edit permission can configure a dashboard to auto-matically refresh on a schedule. To automatically refresh a dashboard:

• uk.co.certification.simulator.questionpool.PList@e180b90