The answer is

The gold layer is normally used to store aggregated data

Review the below link for more info,

Medallion Architecture – Databricks

Gold Layer:

1. Powers Ml applications, reporting, dashboards, ad hoc analytics

2. Refined views of data, typically with aggregations

3. Reduces strain on production systems

4. Optimizes query performance for business-critical data

Exam focus: Please review the below image and understand the role of each layer(bronze, silver, gold) in medallion architecture, you will see varying questions targeting each layer and its purpose.

The answer is

Note: if you chose the below option which is incorrect because it does not have readStream

Exam focus: Please review the below image and understand the role of each layer(bronze, silver, gold) in medallion architecture, you will see varying questions targeting each layer and its purpose.

The answer is Triggered, Continuous

https://docs.microsoft.com/en-us/azure/databricks/data-engineering/delta-live-tables/delta-live-tables-concepts#--continuous-and-triggered-pipelines

• Triggered pipelines update each table with whatever data is currently available and then stop the cluster running the pipeline. Delta Live Tables automatically analyzes the dependencies between your tables and starts by computing those that read from external sources. Tables within the pipeline are updated after their dependent data sources have been updated.
• Continuous pipelines update tables continuously as input data changes. Once an update is started, it continues to run until manually stopped. Continuous pipelines require an always-running cluster but ensure that downstream consumers have the most up-to-date data.

The answer is, Sales_orders_cleaned table is missing schema name LIVE

Every Delta live table should have schema LIVE

Here is the correct syntax,

The answer is,

Select Workflows UI and Delta live tables tab, under task type select Delta live tables pipeline and select the notebook.

Create a pipeline

To create a new pipeline using the Delta Live Tables notebook:

1. Click  Workflows in the sidebar, click the Delta Live Tables tab, and click Create Pipeline.
2. Give the pipeline a name and click  to select a notebook.
3. Optionally enter a storage location for output data from the pipeline. The system uses a default location if you leave Storage Location empty.
4. Select Triggered for Pipeline Mode.
5. Click Create.

The system displays the Pipeline Details page after you click Create. You can also access your pipeline by clicking the pipeline name in the Delta Live Tables tab.

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 automatically refresh on a schedule. To automatically refresh a dashboard:

1. Click the Schedule button at the top right of the dashboard. The scheduling dialog appears.

2.In the Refresh every drop-down, select a period.

3.In the SQL Warehouse drop-down, optionally select a SQL warehouse to use for all the queries. If you don’t select a warehouse, the queries execute on the last used SQL warehouse.

4.Next to Subscribers, optionally enter a list of email addresses to notify when the dashboard is automatically updated.

Each email address you enter must be associated with a Azure Databricks account or configured as an alert destination.

5.Click Save. The Schedule button label changes to Scheduled.

The answer is They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL,

The query pane view in Databricks SQL workspace provides the ability to add or edit and schedule individual queries to run.

You can use scheduled query executions to keep your dashboards updated or to enable routine alerts. By default, your queries do not have a schedule.

Note

If your query is used by an alert, the alert runs on its own refresh schedule and does not use the query schedule.

To set the schedule:

1.Click the query info tab.

2.Click the link to the right of Refresh Schedule to open a picker with schedule intervals.

3.Set the schedule.

The picker scrolls and allows you to choose:

• An interval: 1-30 minutes, 1-12 hours, 1 or 30 days, 1 or 2 weeks
• A time. The time selector displays in the picker only when the interval is greater than 1 day and the day selection is greater than 1 week. When you schedule a specific time, Databricks SQL takes input in your computer’s timezone and converts it to UTC. If you want a query to run at a certain time in UTC, you must adjust the picker by your local offset. For example, if you want a query to execute at 00:00 UTC each day, but your current timezone is PDT (UTC-7), you should select 17:00 in the picker:

The answer is, They can set up an Alert for the query to notify them if the returned value is greater than 60.

The important thing to note here is that alert can only be setup on query not on the dashboard, query can return a value, which is used if alert can be triggered.