DP-300 Exam Questions
462 real DP-300 exam questions with expert-verified answers and explanations. Page 9 of 10.
- Question #412Implement and manage a relational database infrastructure in Azure - specifically configuring automatic tuning features to optimize database performance at the server level
SIMULATION You need to ensure that indexes are created automatically for all the databases on sql12345678. You may need to use SQL Server Management Studio and the Azure portal. An...
Azure SQL DatabaseAutomatic TuningIndex ManagementAzure Portal Administration - Question #413
Hotspot Question You have an Azure subscription. You plan to provision a logical SQL server for Azure SQL Database by using a Bicep template. You need to configure the resource sec...
- Question #415
You have 50 Azure SQL databases. You need to automate Transact-SQL queries to run periodically against each database. The solution must minimize administrative effort. What should...
- Question #416Implement a secure environment for database solutions - specifically configuring SQL Server Agent proxies and credentials to control job step execution security contexts on SQL Server running on Azure Virtual Machines.
Drag and Drop Question You have an Azure subscription that contains a SQL Server on Azure virtual Machines instance named SQLVM1. You need to ensure that SQL Server Agent jobs on S...
SQL Server AgentProxy AccountsT-SQL AdministrationAzure SQL on VMs - Question #418
Hotspot Question You have an Azure subscription. You need to provision a logical server for Azure SQL Database by using a Bicep template. How should you complete the template? To a...
- Question #419
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server1 contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1. You cr...
- Question #420
Hotspot Question You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that contains two databases named DB1 and DB2. The database and log files for DB1 and DB2 are...
- Question #421
You have an Azure subscription. The subscription contains three virtual machines that run Red Hat Enterprise Linux (RHEL). You plan to implement a highly available deployment of Mi...
- Question #422
You have an Azure subscription that contains two Azure SQL servers named Server1 and Server2. Server1 is in the East US Azure region and hosts a database named DB1. Server2 is in t...
- Question #423Implement and manage an Azure SQL environment - specifically managing database mobility and migration between SQL Managed Instances using PowerShell cmdlets (Move-AzSqlInstanceDatabase).
Hotspot Question You have two resource groups named RG1 and RG2. RG1 contains an Azure SQL managed instance named MI1 that hosts a database named DB1. RG2 contains a SQL managed in...
Azure SQL Managed InstanceDatabase Move OperationsPowerShell Az ModuleHigh Availability and Migration - Question #424
You have four Azure virtual machines hosted in different availability zones in the same Azure region. You plan to deploy a Microsoft SQL Server Always On failover cluster instance...
- Question #425
You have an Azure subscription that contains a Microsoft SQL Server 2022 on Windows Server 2022 virtual machine named Server1. Server1 contains a database named DB1. You need to ba...
- Question #426
You have an Azure subscription that contains an Azure SQL managed instance named Server1. You need to ensure the availaibility of Server1 if an Azure region fails. What should you...
- Question #427Plan and configure a high availability and disaster recovery (HA/DR) environment
Hotspot Question You are working on two projects that will use Azure SQL databases. The projects have the disaster recovery requirements shown in the following table. You need to r...
Azure SQL DatabaseDisaster RecoveryRPO RTOHigh Availability - Question #428Implement a disaster recovery strategy for Azure SQL Database using active geo-replication to achieve business continuity and cross-region redundancy - aligns with the 'Implement High Availability and Disaster Recovery' domain in DP-300 (Administering Microsoft Azure SQL Solutions) certification.
SIMULATION You need to implement a disaster recovery solution by using active geo-replication for an Azure Azure SQL database named db1. The replica must be in the East US Azure re...
Active Geo-ReplicationAzure SQL DatabaseDisaster RecoveryHigh Availability - Question #429Implement a Secure Environment / Monitor and Optimize Operational Resources in Azure SQL - specifically configuring automated backup policies and differential backup frequency for Azure SQL Database managed services.
SIMULATION You need to configure differential backups for the db1 Azure SQL database to be once a day instead of twice day. You may need to use SQL Server Management Studio and the...
Azure SQL DatabaseBackup and RecoveryShort-Term Retention PolicyPITR Configuration - Question #430
You have an Azure subscription that contains a Standard SKU Azure SQL database named DB1. You need to enable point-in-time recovery (PITR) backups for DB1. The solution must maximi...
- Question #431
You have an Azure subscription that contains a Basic SKU Azure SQL database named DB1. You need to configure the long-term retention of backups for DB1. The solution must maximize...
- Question #432Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription. You plan to create an instance of SQL Server on Azure Virtual Machines. You need to ensure that the instance is resilient against datacenter failure...
Azure Site RecoveryDisaster RecoveryAzure Virtual MachinesSQL Server - Question #433
You have an Azure SQL managed instance named SQL1. You need to configure a backup solution for SQL1. The solution must ensure that database backups can be retained for up to 10 yea...
- Question #434
You have an on-premises Microsoft SQL Server 2022 instance named SQL1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1. You need to configur...
- Question #435Implement a high availability and disaster recovery environment - specifically querying and interpreting Always On AG replica states using DMVs such as sys.dm_hadr_database_replica_states and sys.availability_databases_cluster
Hotspot Question You have an Azure subscription that contains an Always On availability group named AG1. AG1 contains three replicas named Server1, Server2, and Server3. You execut...
Always On Availability GroupsDynamic Management ViewsSQL Server High AvailabilityT-SQL System Catalog - Question #436Plan and configure a high availability and disaster recovery (HA/DR) environment
Hotspot Question You have an Azure subscription. The subscription contains an Azure Storage account named storage1, a container named Container1, and an Azure SQL managed instance...
Azure SQL Managed InstanceDatabase BackupAzure Blob StorageT-SQL - Question #437Plan and implement a HADR environment
Hotspot Question You have an Azure SQL database named DB1 that is hosted on a SQL server named Server1. You need to restore DB1. The solution must only restore data that is older t...
Azure SQL DatabasePowerShellPoint-in-time RestoreDisaster Recovery - Question #438Configure high availability and disaster recovery for SQL Server on Azure Virtual Machines, specifically implementing domain-independent (workgroup) availability groups using certificate-based endpoint authentication.
Drag and Drop Question You have an Azure subscription that contains a virtual network named VNet1 and two SQL Server on Azure Virtual Machines instances named SQLVM1 and SQLVM2. SQ...
Always On Availability GroupsDomain-Independent Availability GroupsSQL Server on Azure VMsCertificate-Based Authentication - Question #439
You have an Azure subscription that contains an Azure SQL database named DB1. You configure a new data sync group as shown in the exhibit. (Click the Exhibit tab.) You need to mini...
- Question #440Plan and implement data platform resources
Hotspot Question You have an on-premises Microsoft SQL Server instance named SQLSVR1 that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL data...
SQL Server ReplicationAzure SQL Database MigrationTransactional ReplicationPerformance Optimization - Question #441
You have eight on-premises servers that have Microsoft SQL Server 2022 installed. Each server contains multiple databases. You plan to migrate the on-premises databases to Azure. Y...
- Question #442Plan and implement data platform resources
Drag and Drop Question You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed. You have an Azure subscription that contains an Azure SQL managed...
Azure SQL Managed InstanceDatabase BackupDatabase RestoreData Migration - Question #443Plan and implement data platform resources
You have an Azure subscription that contains an Azure SQL managed instance named SQLMl1. You need to configure SQLMl1 to use the Business Critical service tier. Which PowerShell cm...
- Question #444Deploy and Configure Azure Infrastructure / SQL Server on Linux (Azure Database Administration or Azure Solutions Architect)
Drag and Drop Question You have an Azure virtual machine named VM1 that runs Red Hat Enterprise Linux (RHEL). You need to install and configure Microsoft SQL Server 2022 Standard o...
SQL Server on LinuxRHEL AdministrationAzure Virtual MachinesPackage Management - Question #445Design Data Storage Solutions - Recommend appropriate Azure database services based on workload requirements, security constraints, and administrative overhead considerations (AZ-305 / Azure Solutions Architect)
Hotspot Question You have the projects shown in the following table. You need to recommend an Azure database solution for each project. The solution must meet the following require...
Azure SQL Managed InstanceAzure Cosmos DBSQL Server on Azure VMPaaS vs IaaS - Question #446Plan and implement data platform resources
You have an Azure subscription. You need to deploy an Azure SQL database by using a BACPAC file. Which command should you run?
- Question #447Deploy and manage Azure compute resources / Implement and manage infrastructure as code using Bicep and ARM templates (AZ-104 / AZ-305)
Hotspot Question You have an Azure subscription. You deploy resources by using the following Bicep template. For each of the following statements, select Yes if the statement is tr...
Azure SQL DatabaseBicep TemplatesAzure SQL AuthenticationAzure Resource Types - Question #448Monitor, configure, and optimize database resources
Hotspot Question You have two Azure SQL databases named SQLDB1 and SQLDB2 in the Hyperscale service tier. SQLDB1 was set to the Hyperscale service tier when the database was create...
Azure SQL DatabaseService Tier ChangeHyperscaleBusiness Critical - Question #449Plan and implement data platform resources
You have five on-premises servers that have Microsoft SQL Server 2022 Enterprise installed. Each server contains multiple database that store data for web apps and are backed up by...
- Question #450Monitor, configure, and optimize database resources
You have an Azure SQL database. The database contains a table of analytical data that must be retained. You need to implement a data compression solution that maximizes a reduction...
- Question #451Implement a secure environment
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1 and a managed identity. You need to create a user in DB1 that will be used by the mana...
Azure SQL DatabaseManaged IdentityAzure AD AuthenticationT-SQL - Question #452Plan and implement data platform resources
You have an Azure subscription. You plan to deploy an Azure SQL managed instance named Server1. You need to recommend a scaling solution for Server1. The solution must ensure that...
- Question #453Perform administration by using T-SQL
You have a Microsoft SQL Server 2022 instance. You need to troubleshoot failing SQL Agent Jobs. Which command should you run?
- Question #454Monitor, configure, and optimize database resources
Hotspot Question You have an on-premises server named Server1 that has Microsoft SQL Server 2022 installed. You need to define an extended event to track user connections to Server...
Extended EventsSQL Server MonitoringUser ConnectionsT-SQL - Question #455Monitor and optimize Azure resources - specifically monitoring Azure SQL Database query performance using Query Performance Insight to identify resource-intensive and least performant queries, which aligns with the Azure Administrator (AZ-104) or Azure DBA (DP-300) monitoring and optimization domain.
Hotspot Question You have an Azure subscription that contains an app named App and an Azure SQL database named DB1. App1 queries DB1. You use Query Performance Insight to get query...
Azure SQL DatabaseQuery Performance InsightDatabase MonitoringPerformance Tuning - Question #456Implement and manage database security - Configure auditing for Azure SQL Managed Instance using T-SQL and Azure Storage
Drag and Drop Question You have an Azure subscription that contains an Azure SQL managed instance named Server1. You need to enable auditing for Server1. The solution must minimize...
Azure SQL Managed InstanceAuditingT-SQL SecurityAzure Storage - Question #457Monitor, configure, and optimize database resources
Hotspot Question You have an Azure SQL database named SQL1. You need to monitor the resource usage of SQL1 by using a dynamic management view. The solution must return the average...
Azure SQL DatabaseDMVResource MonitoringT-SQL - Question #458Configure and manage automation of tasks
You have an Azure subscription that contains multiple Azure SQL databases. You plan to deploy automation tasks that will be controlled by using elastic jobs. You need to ensure tha...
- Question #459Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription that contains an Azure SQL database named DB1. You need to recommend a high availability, disaster recovery (HA/DR) solution for DB1. The solution mu...
- Question #460Plan and implement data platform resources
You have an on-premises server that has Microsoft SQL Server 2022 installed. The server contains multiple databases. You have an Azure subscription that contains multiple Azure SQL...
- Question #461Configure and manage SQL Server high availability and disaster recovery solutions, specifically managing SQL Server failover cluster instances (FCI) in an on-premises environment.
Drag and Drop Question You have an on-premises Microsoft SQL Server failover cluster that contains three nodes. You need to rename a SQL Server instance in the cluster. The solutio...
SQL Server Failover ClusterSQL Server Instance ManagementHigh AvailabilitySQL Server Administration - Question #462Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription. You plan to deploy four SQL Server on Azure Virtual Machines instances to two Azure regions. Two instances will be deployed to each region. Each reg...
- Question #463Plan and configure a high availability and disaster recovery (HA/DR) environment
You have an Azure subscription that contains an Azure SQL database named SQLDB1 in the Hyperscale service tier. SQLDB1 has zone-redundant storage (ZRS) enabled. You need to create...