Free DP-300 Exam Braindumps
Administering Microsoft Azure SQL Solutions Questions 166–170 (page: 35)

Updated On: 10-Feb-2026

You are monitoring an Azure Stream Analytics job.

You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.

You need to ensure that the job can handle all the events.

What should you do?

  1. Remove any named consumer groups from the connection and use $default.
  2. Change the compatibility level of the Stream Analytics job.
  3. Create an additional output stream for the existing input stream.
  4. Increase the number of streaming units (SUs).

Answer(s): D

Explanation:

Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.


Reference:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring



You have an Azure Stream Analytics job.

You need to ensure that the job has enough streaming units provisioned.

You configure monitoring of the SU % Utilization metric.

Which two additional metrics should you monitor? Each correct answer presents part of the solution.

Note: Each correct selection is worth one point.

  1. Late Input Events
  2. Out of order Events
  3. Backlogged Input Events
  4. Watermark Delay
  5. Function Events

Answer(s): C,D

Explanation:

To react to increased workloads and increase streaming units, consider setting an alert of 80% on the SU Utilization metric. Also, you can use watermark delay and backlogged events metrics to see if there is an impact.
Note: Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.


Reference:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring



You have an Azure Databricks resource.

You need to log actions that relate to changes in compute for the Databricks resource.

Which Databricks services should you log?

  1. clusters
  2. jobs
  3. DBFS
  4. SSH
  5. workspace

Answer(s): A

Explanation:

Clusters logs include information regarding changes in compute.
Incorrect:
Not E: Workspace logs do not include information related to changes in compute.


Reference:

https://docs.microsoft.com/en-us/azure/databricks/administration-guide/account-settings/azure-diagnostic- logs#configure-diagnostic-log-delivery



Your company uses Azure Stream Analytics to monitor devices.

The company plans to double the number of devices that are monitored.

You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the additional load.

Which metric should you monitor?

  1. Input Deserialization Errors
  2. Late Input Events
  3. Early Input Events
  4. Watermark delay

Answer(s): D

Explanation:

The Watermark delay metric is computed as the wall clock time of the processing node minus the largest watermark it has seen so far.
The watermark delay metric can rise due to:
1. Not enough processing resources in Stream Analytics to handle the volume of input events.
2. Not enough throughput within the input event brokers, so they are throttled.
3. Output sinks are not provisioned with enough capacity, so they are throttled.


Reference:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-time-handling



You manage an enterprise data warehouse in Azure Synapse Analytics.

Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.

You need to monitor resource utilization to determine the source of the performance issues.

Which metric should you monitor?

  1. Local tempdb percentage
  2. DWU percentage
  3. Data Warehouse Units (DWU) used
  4. Cache hit percentage

Answer(s): D

Explanation:

You can use Azure Monitor to view cache metrics to troubleshoot query performance.
The key metrics for troubleshooting the cache are Cache hit percentage and Cache used percentage.
Possible scenario: Your current working data set cannot fit into the cache which causes a low cache hit percentage due to physical reads. Consider scaling up your performance level and rerun your workload to populate the cache.


Reference:

https://docs.microsoft.com/da-dk/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-how-to- monitor-cache



Viewing page 35 of 85
Viewing questions 171 - 175 out of 470 questions


Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!