DP-300 practice questions 151–160

1. Question 151 · 354 in bank

   You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do?

   • ADouble the value of Data Flush interval
   • BDecrease by half the value of Data Flush Interval
   • CDouble the value of Statistics Collection Interval
   • DDecrease by half the value of Statistics Collection interval

   Show answer

   Answer: B

   Explanation

   From my point of view, the correct answer is C. (Double the value of Statistics Collection Interval). To avoid Query Store transitioning to read-only state, the runtime statistics for the Last Stale Query Threshold days must fit in the defined Max Size (MB). If the Statistics Collection Interval is increased then less space will be used for the persisted runtime statistics and there will be more free space for new data. The Data Flush Interval can delay the transitioning to read-only state, but not minimize the possibility it occurs.

   Source: Adapted from community discussion — miguelmol

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 152 · 354 in bank

   A company plans to use Apache Spark analytics to analyze intrusion detection data. You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts. What should you recommend?

   • AAzure Data Lake Storage
   • BAzure Databricks
   • CAzure HDInsight
   • DAzure Data Factory

   Show answer

   Answer: B

   Explanation

   Check this out Azure HDInsight offers pre-made, monitoring dashboards in the form of solutions that can be used to monitor the workloads running on your clusters. There are solutions for Apache Spark, Hadoop, Apache Kafka, live long and process (LLAP), Apache HBase, and Apache Storm available in the Azure Marketplace. Please see our documentation to learn how to install a monitoring solution. These solutions are workload-specific, allowing you to monitor metrics like central processing unit (CPU) time, available YARN memory, and logical disk writes across multiple clusters of a given type. Selecting a graph takes you to the query used to generate it, shown in the logs view.

   Source: Adapted from community discussion — VinayakBudapanahalli

   References

   • azure.microsoft.com documentation

   Next question

3. Question 153 · 354 in bank

   DRAG DROP - Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks. You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order. Select and Place:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Send application metrics using Dropwizard. Spark uses a configurable metrics system based on the Dropwizard Metrics Library. To send application metrics from Azure Databricks application code to Azure Monitor, follow these steps: Step 1: Configure your Azure Databricks cluster to use the Databricksmonitoring library. Prerequisite: Configure your Azure Databricks cluster to use the monitoring library. Step 2: Build the spark-listeners-loganalytics-1.0-SNAPSHOT.jar JAR file Step 3: Create Dropwizard counters in your application code Create Dropwizard gauges or counters in your application code Reference: https://docs.microsoft.com/en-us/azure/architecture/databricks-monitoring/application-logs

   Source: Adapted from community discussion — reachmymind

   References

   • Microsoft Learn

   

   Next question

4. Question 154 · 354 in bank

   You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1. Several users execute adhoc queries to DW1 concurrently. You regularly perform automated data loads to DW1. You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run. What should you do?

   • AAssign a smaller resource class to the automated data load queries.
   • BCreate sampled statistics to every column in each table of DW1.
   • CAssign a larger resource class to the automated data load queries.
   • DHash distribute the large fact tables in DW1 before performing the automated data loads.

   Show answer

   Answer: C

   Explanation

   The performance capacity of a query is determined by the user's resource class. Smaller resource classes reduce the maximum memory per query, but increase concurrency. Larger resource classes increase the maximum memory per query, but reduce concurrency. Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workload-management

   Next question

5. Question 155 · 354 in bank

   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?

   • ARemove any named consumer groups from the connection and use $default.
   • BChange the compatibility level of the Stream Analytics job.
   • CCreate an additional output stream for the existing input stream.
   • DIncrease the number of streaming units (SUs).

   Show answer

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

   Next question

6. Question 156 · 354 in bank

   Select 2

   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.

   • ALate Input Events
   • BOut of order Events
   • CBacklogged Input Events
   • DWatermark Delay
   • EFunction Events

   Show answer

   Answer: CD

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 157 · 354 in bank

   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?

   • Aclusters
   • Bjobs
   • CDBFS
   • DSSH
   • Eworkspace

   Show answer

   Answer: A

   Next question

8. Question 158 · 354 in bank

   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?

   • AInput Deserialization Errors
   • BLate Input Events
   • CEarly Input Events
   • DWatermark delay

   Show answer

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

   Next question

9. Question 159 · 354 in bank

   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?

   • ALocal tempdb percentage
   • BDWU percentage
   • CData Warehouse Units (DWU) used
   • DCache hit percentage

   Show answer

   Answer: D

   Explanation

   Could be low cache hit ratio, because infrequent queries were already slower, so they don't notice any difference, but regular queries do now. Could also be tempdb as suggested, but then infrequent queries would also be affected depending on the query. Out of the options and unknowns, I would choose cache hit ratio.

   Source: Adapted from community discussion — CaptainJameson

   References

   • Microsoft Learn

   Next question

10. Question 160 · 354 in bank

    You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table. You need to identify the extent of the data skew in Table1. What should you do in Synapse Studio?

    • AConnect to Pool1 and query sys.dm_pdw_nodes_db_partition_stats.
    • BConnect to the built-in pool and run DBCC CHECKALLOC.
    • CConnect to Pool1 and run DBCC CHECKALLOC.
    • DConnect to the built-in pool and query sys.dm_pdw_nodes_db_partition_stats.

    Show answer

    Answer: A

    Explanation

    I think the correct answer is A, not D. Don't we have to connect to the dedicated pool to query the stats. DB1 is in a dedicated pool

    Source: Adapted from community discussion — Silus

    References

    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-300 practice, question 151. 354 questions available.