DP-300 practice questions 261–270

1. Question 261 · 354 in bank

   HOTSPOT - You plan to deploy three instances of SQL Server on Azure Virtual Machines that will each contain 20 databases. You need to recommend a solution that meets the following requirements: • Ensures that the deployment is highly available • Minimizes administrative effort to manage users, logins, permissions, and SQL Server Agent jobs across the instances What should you include in the recommendation? To answer, select the appropriate options in the answer area. 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

   The minimum SQL version for SQL on Azure VM is 2016 that supports Availability Groups. There for the answer should be "Always On" and "2017"

   Source: Adapted from community discussion — pjfunner

   References

   • Microsoft Learn

   

   Next question

2. Question 262 · 354 in bank

   Select 2

   You have two Azure virtual machines named Server1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com. Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server. On Server1, you create a proxy account named contoso\sqlproxy. You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AOn Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.
   • BOn Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.
   • COn Server2, create a proxy account.
   • DOn Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.
   • EOn Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.

   Show answer

   Answer: CD

   Explanation

   C,E Distributed jobs that have steps which are associated with a proxy run under the context of the proxy account on the target server. Make sure that the following conditions are met or job steps that are associated with a proxy will not be downloaded from the master server to the target: The master server registry subkey \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ \SQL Server Agent\AllowDownloadedJobsToMatchProxyName (REG_DWORD) is set to 1 (true). By default, this subkey is set to 0 (false). A proxy account exists on the target server that has the same name as the master server proxy account under which the job step runs.

   Source: Adapted from community discussion — st1a

   References

   • Microsoft Learn

   Next question

3. Question 263 · 354 in bank

   You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account. Data to be loaded is identified by a column named LastUpdatedDate in the source table. You plan to execute the pipeline every four hours. You need to ensure that the pipeline execution meets the following requirements: ✑ Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits. ✑ Supports backfilling existing data in the table. Which type of trigger should you use?

   • Atumbling window
   • Bon-demand
   • Cevent
   • Dschedule

   Show answer

   Answer: A

   Explanation

   The Tumbling window trigger supports backfill scenarios. Pipeline runs can be scheduled for windows in the past. Incorrect Answers: D: Schedule trigger does not support backfill scenarios. Pipeline runs can be executed only on time periods from the current time and the future. Reference: https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers

   References

   • Microsoft Learn

   Next question

4. Question 264 · 354 in bank

   You have an Azure subscription. The subscription contains an instance of SQL Server on Azure Virtual Machines named SQL1 and an Azure Automation account named account1. You need to configure account1 to restart the SQL Server Agent service if the service stops. Which setting should you configure?

   • AStart/Stop VM
   • BChange tracking
   • CUpdate management
   • DState configuration (DSC)

   Show answer

   Answer: D

   Next question

5. Question 265 · 354 in bank

   You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses Transact-SQL. What should you include in the solution?

   • Aelastic jobs
   • Ban Azure Automation runbook
   • CAzure Functions
   • DAzure Logic Apps

   Show answer

   Answer: A

   Explanation

   Elastic jobs: These are specifically designed for managing multiple Azure SQL databases at scale. They allow you to run Transact-SQL scripts across multiple databases, making it easier to manage and automate tasks such as maintenance, monitoring, and updates. Elastic Jobs provide a centralized way to manage and execute jobs across your databases.

   Source: Adapted from community discussion — voodoo_sh

   Next question

6. Question 266 · 354 in bank

   You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations: • Automated patching is enabled. • The SQL Server IaaS Agent extension is installed. • The Microsoft SQL Server instance on SQLVM1 is managed by using the Azure portal. You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal. What should you do first on SQLVM1?

   • AInstall the Azure Monitor Agent.
   • BUninstall the SQL Server IaaS Agent extension.
   • CInstall the Log Analytics agent.
   • DSet Automated patching to Disable.

   Show answer

   Answer: D

   Explanation

   D - Set Automated patching to disable To automate the deployment of cumulative updates to SQL Server using Azure Update Manager, while ensuring that SQLVM1 can still be managed via the Azure portal, you should first disable Automated Patching. This is necessary because using both Automated Patching and Azure Update Manager simultaneously can lead to conflicts and unexpected behavior

   Source: Adapted from community discussion — voodoo_sh

   References

   • Microsoft Learn

   Next question

7. Question 267 · 354 in bank

   You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory. What should you add to each pipeline?

   • Aan annotation
   • Ba resource tag
   • Ca run group ID
   • Da user property
   • Ea correlation ID

   Show answer

   Answer: A

   Explanation

   Azure Data Factory annotations help you easily filter different Azure Data Factory objects based on a tag. You can define tags so you can see their performance or find errors faster. Reference: https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/

   Next question

8. Question 268 · 354 in bank

   HOTSPOT - You have an Azure data factory that has two pipelines named PipelineA and PipelineB. PipelineA has four activities as shown in the following exhibit.

   

   PipelineB has two activities as shown in the following exhibit.

   

   You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types. The metric has the following settings: ✑ Operator: Greater than ✑ Aggregation type: Total ✑ Threshold value: 2 ✑ Aggregation granularity (Period): 5 minutes ✑ Frequency of evaluation: Every 5 minutes Data Factory monitoring records the failures shown in the following table.

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot 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

   Box 1: No - Just one failure within the 5-minute interval. Box 2: No - Just two failures within the 5-minute interval. Box 3: No - Just two failures within the 5-minute interval. Reference: https://docs.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-metric-overview

   

   Next question

9. Question 269 · 354 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Data Lake Storage account that contains a staging zone. You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics. Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes mapping data flow, and then inserts the data into the data warehouse. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: B

   Explanation

   Correct solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse. Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data

   Next question

10. Question 270 · 354 in bank

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Data Lake Storage account that contains a staging zone. You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics. Solution: You schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: A

    Explanation

    Must use an Azure Data Factory, not an Azure Databricks job. Correct solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse. Reference: https://docs.microsoft.com/en-US/azure/data-factory/transform-data

    Source: Adapted from community discussion — U_C

    Next question

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

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