DP-300 Exam Questions
461 real DP-300 exam questions with expert-verified answers and explanations. Page 7 of 10.
- Question #307Plan and configure a high availability and disaster recovery (HA/DR) environment
You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enter...
- Question #308Deploy and manage Azure compute resources / Implement high availability and disaster recovery for Azure SQL services
Drag and Drop Question You have an Azure subscription. You need to deploy an Azure SQL managed instance by using an Azure Resource Manager (ARM) template. The solution must meet th...
Azure SQL Managed InstanceARM TemplatesManaged IdentityHigh Availability / Zone Redundancy - Question #309Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 contains a database named DB1 and a user named User1. User1 drops DB1....
- Question #310Plan and configure a high availability and disaster recovery (HA/DR) environment
You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a...
- Question #311Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure SQL database named SQL1. You need to implement a disaster recovery solution for SQL1. The solution must minimize the following: - The recovery point objective (RP...
- Question #312Plan and configure a high availability and disaster recovery (HA/DR) environment
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements: - Support real-time data rep...
Disaster RecoverySQL Server ReplicationAzure SQL Managed InstanceOn-premises to Azure DR - Question #313Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription. You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability...
- Question #314Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure SQL database. You need to implement a disaster recovery solution that meets the following requirements: - Minimizes how long it takes to recover the database if a...
Disaster RecoveryAzure SQL DatabaseAuto-failover groupsRecovery Time Objective (RTO) - Question #315Plan and configure a high availability and disaster recovery environment
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. Whi...
High AvailabilityDisaster RecoveryAzure SQL DatabaseService TiersCost Optimization - Question #316Plan and configure a high availability and disaster recovery (HA/DR) environment
You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1. You need to ensure the maximum in-transit time...
Azure SQL Managed InstanceFailover GroupsDisaster RecoveryGrace Period - Question #317Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines. You plan to implement a disaster recovery solution. You need to be able to per...
Azure Site RecoveryDisaster RecoverySQL Server on Azure VMTest Failover - Question #318Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: - Returns the solu...
- Question #319Plan and configure a high availability and disaster recovery (HA/DR) environment
You plan to deploy an Azure SQL managed instance. You need to restore database backups across regions. Which type of storage account should you use?
Azure StorageGeo-redundancyDisaster RecoverySQL Managed Instance - Question #320Configure and manage automation of tasks
Hotspot Question You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQ1. You need to us...
SQL Server on Azure VMsPowerShellautomated patchingSQL IaaS Agent Extension - Question #321Implement a secure environment
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL1 to use mixed mode au...
- Question #322Implement a secure environment for database services - specifically configuring SQL Server Agent job step security using credentials and proxies in an Azure IaaS SQL Server deployment.
Drag and Drop Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs W...
SQL Server AgentProxies and CredentialsAzure SQL on VMsLeast Privilege Security - Question #323Plan and implement data platform resources
You have an Azure subscription. You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements: - Custom performance conf...
- Question #324Plan and implement data platform resources
You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database. You plan to create an Azure SQL managed instance and migrate the on-premises database to the...
- Question #325Implement Security and Encryption for Azure SQL workloads / Configure data security features in SQL Server on Azure VMs
Drag and Drop Question You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1. You need to enable Transparent Data Encryption (...
Transparent Data EncryptionSQL Server SecurityAzure Virtual MachinesDatabase Encryption - Question #326Monitor, configure, and optimize database resources
You have an Azure SQL managed instance named SQLMI1 that has the following settings: - vCores: 4 - Service tier: General Purpose - Hardware generation: Standard-series (Gen5) You d...
- Question #327Configure and manage automation of tasks
Hotspot Question You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to use an Azure Automation runbook to initiate a SQL Server database backup on VM1...
Azure AutomationrunbooksSQL Server backupPowerShell - Question #328Plan and implement a HADR environment
Hotspot Question You have an Azure subscription that contains a storage account named databasebackups. You have an Azure SQL managed instance named DB1. You need to back up DB1 to...
Azure SQL Managed Instancedatabase backupAzure Blob StorageShared Access Signature - Question #330Configure and manage automation of tasks
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Azure SQL DatabaseElastic JobsDatabase-scoped credentialsAutomation - Question #331Plan and implement data platform resources
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
database migrationAzure SQL Managed InstanceLog Replay Servicenetwork connectivity - Question #332Plan and configure a high availability and disaster recovery (HA/DR) environment
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Azure SQL Databaseservice tiersread replicasfailover groupshigh availability - Question #333Implement and manage identity and access in Azure - specifically configuring Microsoft Entra hybrid identity synchronization and enabling managed identities for secure, credential-free authentication of Azure resources (aligns with AZ-104/SC-300 identity management objectives).
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Managed IdentityMicrosoft Entra Cloud SyncHybrid IdentityService Principal - Question #334Implement a secure environment
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
- Question #335Implement a secure environment
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Change Data Capture (CDC)AuditingData SecurityCompliance - Question #336Monitor, configure, and optimize database resources
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Resource GovernorPerformance OptimizationWorkload ManagementAzure SQL Database - Question #337Monitor, configure, and optimize database resources
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Azure SQL DatabaseExtended EventsMonitoringAzure Blob Storage - Question #338Plan and configure a high availability and disaster recovery (HA/DR) environment
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
- Question #339Plan and configure a high availability and disaster recovery (HA/DR) environment
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Azure SQL DatabaseAuto-failover groupsVirtual Network Service EndpointsNetwork connectivity - Question #340Incomplete question - likely maps to Microsoft Azure Administrator (AZ-104) or Azure Database Administrator (DP-300) domains covering hybrid connectivity, identity integration, and database workload migration with Software Assurance licensing benefits.
Case Study 5 - ADatum Corporation Overview ADatum Corporation is a financial services company that has a main office in New York City. Existing Environment Licensing Agreement ADat...
Hybrid IdentityAzure SQL / SQL Server MigrationAzure Networking (S2S VPN)Microsoft Entra ID (Azure AD) - Question #341Implement and manage Azure SQL Database compute and scaling options, including configuring Serverless tier features such as auto-pause for cost optimization.
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 Mana...
Azure SQL DatabaseServerless Compute TierAuto-pause ConfigurationElastic Pools - Question #342Optimize query performance
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 v...
Query OptimizerDatabase Scoped ConfigurationPerformance OptimizationSQL Server Administration - Question #343Implement and manage identities and access - specifically configuring Microsoft Entra authentication for Azure SQL Managed Instance to enable Azure AD-based database user provisioning, aligning with the AZ-104 or DP-300 certification domain on securing data services.
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 ne...
Microsoft Entra ID (Azure AD)Azure SQL Managed InstanceDatabase SecurityIdentity and Access Management - Question #344Optimize query performance and manage database configuration in Azure SQL Database / SQL Server - specifically controlling Automatic Tuning features to maintain stable execution plans for performance testing scenarios.
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 mach...
Azure SQL DatabaseAutomatic TuningQuery Plan ManagementT-SQL ALTER DATABASE - Question #345Implement and Manage Databases - specifically configuring database properties such as compatibility level to support application requirements in SQL Server or Azure SQL environments (commonly tested in AZ-900, DP-300, or SQL Server certification exams).
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 compa...
Database Compatibility LevelSQL Server Management Studio (SSMS)Azure SQL DatabaseLegacy Application Support - Question #346Implement a secure environment
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 mo...
- Question #347Configure and manage Azure SQL Database compute and storage resources, including selecting appropriate service tiers and hardware configurations to meet minimum and maximum vCore and storage requirements.
SIMULATION You need to ensure that db1 supports a minimum of one vCore, a maximum of four vCores, and a database of up to 45 GB. To complete this task, sign in to the virtual machi...
Azure SQL DatabasevCore purchasing modelServerless tierDatabase scaling - Question #348Configure and manage automation of tasks
You have an Azure subscription that contains the resources shown in the following table. You plan to use SQLDB11 as an elastic job database to run jobs on SQLDB11 and SQLDB22. What...
- Question #349Implement and manage identity and access for Azure SQL resources, including configuring Microsoft Entra authentication and assigning administrative roles to user accounts for Azure SQL Managed Instance.
SIMULATION You need to configure your user account as the Microsoft Entra admin for the server named sql12345678. To complete this task, sign in to the virtual machine. You may nee...
Microsoft Entra IDAzure SQL Managed InstanceAzure Active Directory AdminAzure Portal Configuration - Question #350Implement database security and manage access control by creating roles and assigning granular table-level permissions in Azure SQL / SQL Server databases.
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 vi...
Database RolesSQL Server PermissionsGRANT StatementSQL Server Management Studio - Question #351Implement Data Security and Compliance - specifically configuring data sensitivity classifications and information protection labels on Azure SQL / SQL Server databases to meet regulatory and governance requirements.
SIMULATION You need to classify the StandardCost and ListPrice columns of the SalesLT.Product table in db1. The columns must have the following configurations: - An information typ...
Data ClassificationSQL Server Management StudioAzure SQL SecurityMicrosoft Purview Information Protection - Question #352Implement and manage data security in Azure - specifically configuring threat protection mechanisms for Azure SQL Database to defend against common attack vectors including SQL injection, aligning with the AZ-500 (Azure Security Engineer) or DP-300 (Azure Database Administrator) certification objectives under 'Secure Azure SQL Database and Azure SQL Managed Instance'.
SIMULATION You need to protect all the databases on sql12345678 from SQL injection attacks. To complete this task, sign in to the virtual machine. You may need to use SQL Server Ma...
Microsoft Defender for SQLAdvanced Threat ProtectionSQL Injection PreventionAzure SQL Database Security - Question #353Monitor and optimize resources
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 g...
- Question #354Monitor, configure, and optimize database resources
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...
- Question #355Monitor, configure, and optimize database resources
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 Ma...
- Question #356Monitor and optimize SQL Server performance - specifically configuring the Query Store to capture query execution data for performance analysis and troubleshooting (maps to DP-300: Administering Relational Databases on Microsoft Azure or equivalent SQL Server administration certification).
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...
Query StoreSQL Server Performance MonitoringDatabase ConfigurationSSMS Administration - Question #357Plan and implement data platform resources
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 Azu...