DP-300 Exam Questions
462 real DP-300 exam questions with expert-verified answers and explanations. Page 10 of 10.
- Question #464Perform administration by using T-SQL
Hotspot Question You have an app that distributes users geographically by using sharding. You need to identify which users where active during the last 50 days. The solution must i...
Azure SQL Databaseshardingelastic queriesT-SQL - Question #465Implement a secure environment
Hotspot Question You have an on-premises server named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1. You have an Azure subscription that co...
Azure RBACleast privilegedatabase migrationAzure DMS - Question #466Implement a secure environment
You have an Azure subscription linked to a Microsoft Entra tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2022 ins...
Microsoft Entra Domain ServicesIdentity and Access ManagementSQL Server on Azure VMsAuthentication - Question #467Plan and implement data platform resources
Hotspot Question You have an Azure subscription. You have a Bicep file named File1.bicep that deploys an Azure SQL database. You need to perform the following actions: - Create a n...
Azure CLIBicepresource deploymentresource groups - Question #468Implement a secure environment
You have an Azure subscription that contains a user named User1 and an Azure SQL database named DB1. You configure long-term retention (LTR) for DB1. You need to ensure that User1...
- Question #469Implement a secure environment
You have an Azure SQL database named DB1 that has default configurations. You review the Data Discovery & Classification blade for DB1 as shown in the following exhibit. You need t...
- Question #470Configure and manage automation of tasks
Hotspot Question You have a new Azure SQL managed instance. You plan to create a SQL Server Agent job named SalesTotal. You need to ensure that SalesTotal can send out notification...
Azure SQL Managed InstanceSQL Server AgentDatabase MailT-SQL - Question #471Optimize query performance
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. Users report that DB1 has query performance issues. You need to ensure that you can m...
Azure SQL DatabaseIn-Memory OLTPT-SQLperformance optimization - Question #472Plan and implement data platform resources
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-...
Azure SQL DatabaseAzure CLIvCore modelHyperscalehigh availability - Question #473Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure SQL Database failover group named AzFG1. You plan to run the following CLI command. How will this affect AzFG1?
- Question #474Design and implement a high availability and disaster recovery solution for Azure SQL Managed Instance, including cross-region failover group configuration and DNS zone requirements.
Drag and Drop Question You have a highly available Azure SQL Managed Instance that contains two servers named Server1 and Server2. Both servers are in the same Azure region. You ha...
Azure SQL Managed InstanceFailover GroupsHigh AvailabilityRegion Migration - Question #475Plan and configure a high availability and disaster recovery (HA/DR) environment
You have two on premises Microsoft SQL Server 2022 instances as shown in the following table. You need to configure log shipping between DB1 and DB2. What should you do first on DB...