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: *

An engineering manager wants to monitor the performance of a recent project using a Databricks SQL query.
For the first week following the project's release, the managerwants the query results to be updated every minute. However, the manager is concerned that the compute resources used for the query will be left running and cost the organization a lot of money beyond the first week of the project's release.
Which of the following approaches can the engineering team use to ensure the query does not cost the organization any money beyond the first week of the project's release?

• A.They can set the query's refresh schedule to end after a certain number of refreshes.
• B.They cannot ensure the query does not cost the organization money beyond the first week of the project's release.
• C.They can set the query's refresh schedule to end on a certain date in the query scheduler.
• D.They can set a limit to the number of individuals that are able to manage the query's refresh schedule.
• E.They can set a limit to the number of DBUs that are consumed by the SQL Endpoint.

Comment: *

Name: *

Email: *

Verification: *

A data engineer is designing a data pipeline. The source system generates files in a shared directory that is also used by other processes. As a result, the files should be kept as is and will accumulate in the directory. The data engineer needs to identify which files are new since the previous run in the pipeline, and set up the pipeline to only ingest those new files with each run.
Which of the following tools can the data engineer use to solve this problem?

• A.Unity Catalog
• B.Data Explorer
• C.Databricks SQL
• D.Delta Lake
• E.Auto Loader

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?

• A.CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.
• B.CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
• C.CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.
• D.CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.
• E.CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?

• A.Cloud-specific integrations
• B.Simplified governance
• C.Ability to scale storage
• D.Ability to scale workloads
• E.Avoiding vendor lock-in

Comment: *

Name: *

Email: *

Verification: *