DP-300 practice questions 181–190

1. Question 181 · 354 in bank

   You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?

   • AUse The REST API to call the patch operation and modify the AutomaticTuningServerMode property.
   • BFrom the Azure portal, configure automatic tuning.
   • CUse Transact-SQL to enable the FORCE_LAST_GOOD_PLAN option.

   Show answer

   Answer: C

   Explanation

   C is the correct answer, force_last_good_plan for SQL managed instance. For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL. The Azure portal based configuration and automatic index tuning options described in this article do not apply to Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable?view=azuresql#enable-automatic-tuning-on-an-individual-database

   Source: Adapted from community discussion — bsk1983

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 182 · 354 in bank

   Select 2

   You have an Azure subscription that contains an Azure SQL database named db1. You need to implement SQL insights for db1. Which two resources should you create first? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • Aa storage account
   • Ba virtual machine
   • Can Azure logic app
   • Dan Azure function
   • Ea Log Analytics workspace

   Show answer

   Answer: BE

   Explanation

   BE based off this: There's no direct cost for SQL Insights (preview). All costs are incurred by the virtual machines that gather the data, the Log Analytics workspaces that store the data, and any alert rules configured on the data. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-overview?view=azuresql#pricing

   Source: Adapted from community discussion — JJJR

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 183 · 354 in bank

   You have an Azure subscription that contains the resources shown in the following table.

   

   App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do?

   • AEnable automatic tuning for db1.
   • BIncrease the number of vCores allocated to db1.
   • CDecrease the auto-pause delay for db1.
   • DDisable auto-pause delay for db1.

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

4. Question 184 · 354 in bank

   You have 50 Azure SQL databases. You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. What should you do?

   • ACreate a diagnostic setting for the activity log that has the Security log enabled.
   • BFor the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.
   • CCreate an alert rule that uses a Metric signal type.
   • DCreate an alert rule that uses an Activity Log signal type.

   Show answer

   Answer: D

   Explanation

   Activity log events - An alert can trigger on every event, or, only when a certain number of events occur. The activity log of a database logs the change for the SKU (Stock-keeping-Unit) change. Incorrect Answers: C: Metric values - The alert triggers when the value of a specified metric crosses a threshold you assign in either direction. That is, it triggers both when the condition is first met and then afterwards when that condition is no longer being met. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

   Source: Adapted from community discussion — raavilam

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 185 · 354 in bank

   HOTSPOT - You have an Azure SQL database named DB1 that contains a table named Table1. You run a query to load data into Table1. The performance metrics of Table1 during the load operation are shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

   

   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

   You are loading data into Table1, which means there is some inserts going on. Note that insert statements is also considered a query. Not sure why the first answer is perform query tuning. It should be scale resource in order to reduce the time insert data into Table1.

   Source: Adapted from community discussion — Gocsan

   

   Next question

6. Question 186 · 354 in bank

   DRAG DROP - You have a database named db1. The log for db1 contains the following entry.

   

   You need to ensure that db1 can process transactions. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   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

   my take would be: 1.remove db1 from ag, 2. backup t.log , 3 re-add db1 to ag . shrinking log shouldn't be necessary since log backup will reduce its size

   Source: Adapted from community discussion — amazonalex

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 187 · 354 in bank

   You have the following resources: • 15 SQL Server on Azure Virtual Machines instances • 20 Azure SQL databases You need to recommend a solution to centrally monitor the resources for security vulnerabilities. What should you include in the recommendation?

   • Adatabase audits
   • BMicrosoft Defender
   • CSQL insights
   • DAzure SQL Auditing

   Show answer

   Answer: B

   Explanation

   I think the answer is D. Azure SQL Auditing can centrally monitor the resources for security vulnerabilities. Microsoft Defender is not specifically designed to centrally monitor SQL Server on Azure Virtual Machines instances and Azure SQL databases for security vulnerabilities. SQL insights is a feature that provides performance monitoring and tuning for SQL Server running on Azure Virtual Machines.

   Source: Adapted from community discussion — U_C

   References

   • Microsoft Learn

   Next question

8. Question 188 · 354 in bank

   HOTSPOT - You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1. You need to ensure that User1 can perform the following tasks on DB1: • Create jobs. • View all jobs. • Modify, delete, and disable the jobs the user created. The solution must use the principle of least privilege. Which built-in database role should you assign to User1, and where is the role defined? To answer, select the appropriate options in the answer area.

   

   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

   Location: msdb Role: SQLAgentOperatorRole • Create jobs. • View all jobs. • Modify, delete, and disable the jobs the user created.

   Source: Adapted from community discussion — Daemon69

   References

   • Microsoft Learn

   

   Next question

9. Question 189 · 354 in bank

   You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace. What should you do first?

   • ACreate a private endpoint connection on SQLMI1.
   • BConfigure Azure SQL Analytics to use Workspace1.
   • CModify the Compute + storage settings for SQLMI1.
   • DModify the diagnostic settings for SQLMI1.

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

10. Question 190 · 354 in bank

    HOTSPOT - You have an Azure SQL database named DB1 in the General Purpose service tier. You need to monitor DB1 by using SQL Insights. What should you include in the solution? To answer, select the appropriate options in the answer area.

    

    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

    getting to the bottom of it: https://learn.microsoft.com/en-us/azure/azure-monitor/agents/agents-overview - "Azure Monitor Agent (AMA) collects monitoring data from the guest operating system of Azure and hybrid virtual machines". So indeed the answer is Log Analytics and a VM, as this definitely is related to SQL Insights.

    Source: Adapted from community discussion — testdumps2017

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

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

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