Valid DP-300 Dumps shared by PassLeader for Helping Passing DP-300 Exam! PassLeader now offer the newest DP-300 VCE dumps and DP-300 PDF dumps, the PassLeader DP-300 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader DP-300 dumps with VCE and PDF here: https://www.passleader.com/dp-300.html (374 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader DP-300 dumps from Cloud Storage: https://drive.google.com/drive/folders/16H2cctBz9qiCdjfy4xFz728Vi_0nuYBl
NEW QUESTION 351
You have five instances of SQL Server on Azure Virtual Machines. You need to monitor Microsoft SQL Server performance for all the instances by consolidating metrics into a single graphic display. The solution must minimize administrative effort. What should you use?
A. Azure Monitor
B. Log Analytics
C. SQL Insights
D. Azure SQL Analytics
Answer: A
Explanation:
The Log Analytics agent is on a deprecation path and won’t be supported after August 31, 2024. Any new data centers brought online after January 1 2024 will not support the Log Analytics agent. If you use the Log Analytics agent to ingest data to Azure Monitor, migrate to the new Azure Monitor agent prior to that date.
https://learn.microsoft.com/en-us/azure/azure-monitor/agents/log-analytics-agent
NEW QUESTION 352
You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains an Extended Events session named session1 that captures Microsoft SQL Server events. You need to correlate the session events with events captured by Event Tracing for Windows (ETW). What should you do for session1?
A. Modify the Set Session Event Filters settings.
B. Add a target.
C. Add an action.
D. Modify the Specify Session Data Storage settings.
Answer: B
NEW QUESTION 353
You have an Azure subscription that contains the following resources:
– 10 Azure SQL databases.
– Five Azure SQL managed instances.
– Five instances of SQL Server on Azure Virtual Machines.
You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?
A. Log Analytics
B. Azure SQL Analytics
C. Query Performance Insight
D. SQL Insights
Answer: D
NEW QUESTION 354
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. Choose two.)
A. On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right.
B. On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right.
C. On Server2, create a proxy account.
D. On Server1, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.
E. On Server2, set the AllowDownloadedJobsToMatchProxyName registry entry to 1.
Answer: AE
NEW QUESTION 355
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?
A. Start/Stop VM.
B. Change tracking.
C. Update management.
D. State configuration (DSC).
Answer: D
NEW QUESTION 356
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?
A. Azure SQL Database Premium
B. Azure SQL Database Basic
C. Azure SQL Database Managed Instance General Purpose
D. Azure SQL Database Hyperscale
Answer: A
NEW QUESTION 357
You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2. The solution must eliminate the need for the following:
– A distributed network name (DNN).
– A load balancer.
What should you do?
A. Deploy VM1 and VM2 to a single proximity placement group.
B. Deploy VM1 and VM2 to different proximity placement groups in the same Azure region.
C. Connect VM1 and VM2 to a single subnet.
D. Connect VM1 and VM2 to different subnets on a single virtual network.
Answer: D
Explanation:
To match the on-premises experience for connecting to your availability group listener, deploy your SQL Server VMs to multiple subnets within the same virtual network. Having multiple subnets negates the need for the extra dependency on an Azure Load Balancer, or a distributed network name (DNN) to route your traffic to your listener.
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql
NEW QUESTION 358
You have an Azure SQL database named DB1. You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?
A. Azure SQL Database Premium
B. Azure SQL Database Serverless
C. Azure SQL Database Managed Instance General Purpose
D. Azure SQL Database Hyperscale
Answer: A
NEW QUESTION 359
SIMULATION
You need to configure db1 to pause automatically after one hour of inactivity. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 360
SIMULATION
You need to ensure that any enhancements made to the Query Optimizer through patches are available to db1 and db2 on sql12345678. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 361
SIMULATION
You plan to create an automation runbook that will create database users in db1 from Azure AD identities. You need to configure sql12345678 to support the creation of new database users. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 362
SIMULATION
You plan to perform performance testing of db1. You need prevent db1 from reverting to the last known good query plan. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 363
SIMULATION
You have a legacy application written for Microsoft SQL Server 2012. The application will be the only application that accesses db1. You need to ensure that db1 is compatible with all the features and syntax of SQL Server 2012. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 364
SIMULATION
You need to add an Azure AD user named [email protected] to db1. User2-12345678 must be able to read data from all the tables in db1 without being able to modify the data. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 365
SIMULATION
You need to create a new database role named role1 that can read the contents of the SalesLT.SalesOrderDetail table only in db1. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 366
SIMULATION
You need to ensure that all queries executed against db1 are captured in the Query Store. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 367
SIMULATION
You need to enable change data capture (CDC) for db1. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 368
SIMULATION
You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 369
SIMULATION
You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 370
SIMULATION
You need to configure high availability for db1. The solution must tolerate the loss of an Azure datacenter without data loss or the need to modify application connection strings. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
NEW QUESTION 371
HotSpot
You plan to deploy an Always On failover cluster instance (FCI) on Azure virtual machines. You need to provision an Azure Storage account to host a cloud witness for the deployment. How should you configure the storage account? (To answer, select the appropriate options in the answer area.)
Answer:
NEW QUESTION 372
Drag and Drop
You have an Azure virtual machine named Server1 that contains an instance of Microsoft SQL Server 2022 named SQL1. SQL1 contains two databases named DB1 and DB2. You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases. Which three Transact-SQL commands should you run in sequence? (To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.)
Answer:
NEW QUESTION 373
……
Get the newest PassLeader DP-300 VCE dumps here: https://www.passleader.com/dp-300.html (374 Q&As Dumps)
And, DOWNLOAD the newest PassLeader DP-300 PDF dumps from Cloud Storage for free: https://drive.google.com/drive/folders/16H2cctBz9qiCdjfy4xFz728Vi_0nuYBl