You are asked to set up an alert to notify in an email every time a KPI indicater increases beyond a threshold value, team also asked you to include the actual value in the alert email notification.

• A.Use notebook and python code to run every minute, using python variables to capture send the information in an email
• B.Setup an alert but use the default template to notify the message in email's subject
• C.Setup an alert but use the custom template to notify the message in email's subject
• D.Use the webhook destination instead so alert message can be customized
• E.Use custom email hook to customize the message

Correct Answer: C

Explanation
Alerts support custom template supports using variables to customize the default message, set up the query to compare the KPI current value to the threshold and use the variable QUE-RY_RESULT_VALUE to display the value in the email notification.
here is a simple alert, that uses variables in the custom template to present these values in the email notification message, when the alert is fired these variables get replaced with actual values.
Alert with custom template
Graphical user interface, application Description automatically generated

When you enable preview you can see how the alert looks when you substitute the variables.
Graphical user interface, text, application, email Description automatically generated

Below are additional template variables available to you with the custom template.
Alerts | Databricks on AWS
Graphical user interface, text, application, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

Which of the following data workloads will utilize a silver table as its source?

• A.A job that enriches data by parsing its timestamps into a human-readable format
• B.A job that queries aggregated data that already feeds into a dashboard
• C.A job that ingests raw data from a streaming source into the Lakehouse
• D.A job that aggregates cleaned data to create standard summary statistics
• E.A job that cleans data by removing malformatted records

Comment: *

Name: *

Email: *

Verification: *

A data engineer is testing a collection of mathematical functions, one of which calculates the area under a curve as described by another function.

Which kind of the test does the above line exemplify?

• A.Integration
• B.Unit
• C.Manual
• D.functional

Comment: *

Name: *

Email: *

Verification: *

Which REST API call can be used to review the notebooks configured to run as tasks in a multi-task job?

• A./jobs/runs/list
• B./jobs/runs/get-output
• C./jobs/runs/get
• D./jobs/get
• E./jobs/list

Comment: *

Name: *

Email: *

Verification: *

Which of the following Structured Streaming queries successfully performs a hop from a Silver to Gold table?

• A.1.(spark.table("sales")
  2..groupBy("store")
  3..agg(sum("sales"))
  4..writeStream
  5..option("checkpointLocation", checkpointPath)
  6..outputMode("complete")
  7..table("aggregatedSales") )
  (Correct)
• B.1.(spark.table("sales")
  2..writeStream
  3..option("checkpointLocation", checkpointPath)
  4..outputMode("complete")
  5..table("sales") )
• C.1.(spark.table("sales")
  2..withColumn("avgPrice", col("sales") / col("units"))
  3..writeStream
  4..option("checkpointLocation", checkpointPath)
  5..outputMode("append")
  6..table("cleanedSales") )
• D.1.(spark.readStream.load(rawSalesLocation)
  2..writeStream
  3..option("checkpointLocation", checkpointPath)
  4..outputMode("append")
  5..table("uncleanedSales") )
• E.1.(spark.read.load(rawSalesLocation)
  2. .writeStream
  3. .option("checkpointLocation", checkpointPath)
  4. .outputMode("append")
  5. .table("uncleanedSales") )

Correct Answer: A

Explanation
The answer is
1.(spark.table("sales")
2..groupBy("store")
3..agg(sum("sales"))
4..writeStream
5..option("checkpointLocation", checkpointPath)
6..outputMode("complete")
7..table("aggregatedSales") )
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.
Sorry I had to add the watermark some people in Udemy are copying my content.
A diagram of a house Description automatically generated with low confidence

Comment: *

Name: *

Email: *

Verification: *