DP-300 Exam Questions
461 real DP-300 exam questions with expert-verified answers and explanations. Page 8 of 10.
- Question #358Implement and manage an Azure SQL environment / Configure and optimize database performance including storage and index compression in Azure SQL Database
SIMULATION In an Azure SQL database named db1, you need to enable page compression on the PK_SalesOrderHeader_SalesOrderID clustered index of the SalesLT.SalesOrderHeader table. To...
Azure SQL DatabaseIndex CompressionT-SQLPerformance Optimization - Question #359Database Administration – Managing and Optimizing Database Objects and Performance (Azure SQL / SQL Server index management)
SIMULATION You need to rebuild the index for PK_Address_AddressID in the SalesLT.Address table in db1. The solution must meet the following requirements: - Ensure that 30 percent o...
Index MaintenanceFILLFACTORSQL ServerPage Splits - Question #360Plan and configure a high availability and disaster recovery environment
Hotspot Question 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 fol...
Always On Availability GroupsSQL Server on Azure VMHigh availabilityMulti-instance management - Question #361Configure and manage automation of tasks
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. B...
- Question #362Configure and manage automation of tasks
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...
Azure AutomationDesired State Configuration (DSC)SQL Server AgentService management - Question #363Implement and manage an Azure SQL Database environment, including configuring automatic tuning features to optimize database performance and maintain index health.
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...
Azure SQL DatabaseAutomatic TuningIndex ManagementAzure Portal Administration - Question #364Monitor, configure, and optimize database resources
SIMULATION You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average. To complete this task, sign in to the virtual ma...
Azure MonitorMetric AlertsDynamic ThresholdsSQL Database Monitoring - Question #365Plan and configure a high availability and disaster recovery (HA/DR) 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...
- Question #366Plan and configure a high availability and disaster recovery (HA/DR) environment
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...
- Question #367Perform administration by using T-SQL
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 backupT-SQLshared access signature - Question #369Plan and configure a high availability and disaster recovery (HA/DR) environment
Hotspot Question 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 f...
SQL Server FCIcloud witnessAzure Storage Accountreplication - Question #370Plan and configure a high availability and disaster recovery (HA/DR) environment
Drag and Drop Question 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...
SQL Server BackupSnapshot BackupT-SQLHigh Availability / Disaster Recovery (HA/DR) - Question #371Design and Implement a High Availability and Disaster Recovery Solution for Azure SQL Database - ensuring business continuity through geo-redundancy and connection string transparency during regional failover events.
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 mus...
Azure SQL DatabaseActive Geo-ReplicationDisaster RecoveryFailover Groups - Question #372Design and Implement High Availability and Disaster Recovery Solutions for Azure SQL Database - typically aligned with Microsoft certifications such as DP-300 (Azure Database Administrator Associate) under the domain 'Monitor and Optimize Operational Resources / Configure High Availability'
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 connectio...
Azure SQL DatabaseActive Geo-ReplicationHigh AvailabilityDisaster Recovery - Question #373Plan and implement data platform resources
SIMULATION You need to configure a monthly backup of db2. The monthly backups must be retained for five years, and then deleted. To complete this task, sign in to the virtual machi...
- Question #374Implement a secure environment
SIMULATION You need to provide a user named user2-12345678 with the ability to back up and restore databases and change the compute setting of the databases located on a server nam...
- Question #375Implement a secure environment
Hotspot Question You have an on-premises Microsoft SQL Server database named DB1. You have an Azure subscription. You need to migrate DB1 to an Azure SQL service that meets the fol...
Azure SQL DatabaseAlways Encryptedsecure enclavesMicrosoft Azure Attestation - Question #376Implement and manage data synchronization using Azure SQL Data Sync - typically covered under 'Deploy and Manage Azure SQL' or 'Implement a Relational Database in Azure' in certifications such as DP-300 (Azure Database Administrator Associate).
Drag and Drop Question You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2. You have an Azure subscription. You need to sync a subset of tables between the...
SQL Data SyncAzure SQL DatabaseHybrid ConnectivityData Synchronization - Question #377Plan and implement data platform resources
You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1. You plan to migrate DB1 to Azure. You need to recommend a hosting solut...
- Question #378Plan and implement data platform resources
You have an Azure subscription. You plan to provision a single Azure SQL database. You need to ensure that the database supports the autoscaling of compute resources. Which service...
- Question #379Plan and implement data platform resources
Hotspot Question You plan to deploy an instance of SQL Server on Linux Azure Virtual Machines. The instance will run Microsoft SQL Server 2022 and use the SQL Server IaaS Agent ext...
SQL Server on Linux VMAzure IaaS Agent ExtensionLinux operating systemsautomated backup - Question #380Implement and manage storage in Azure / Configure and manage Azure Virtual Machine disks and storage options
Drag and Drop Question You have a burstable Azure virtual machine named VM1 that hosts an instance of Microsoft SQL Server. You need to attach an Azure ultra disk to VM1. The solut...
Azure Virtual MachinesUltra DiskVM StorageAzure Compute - Question #381Implement a secure environment
You have an Azure subscription that contains an Azure SQL database named DB1. You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution...
- Question #382Plan and implement data platform resources
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 q...
- Question #383
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 q...
- Question #384
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 q...
- Question #386
Hotspot Question You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure SQL Server named Server1 in the West US Azure region. You need to en...
- Question #387
Hotspot Question You have an Azure virtual machine named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1. You have a logical SQL server named...
- Question #388
Hotspot Question You have an Azure SQL managed instance named Server1 and an Azure Blob Storage account named storage1 that contains Microsoft SQL Server database backup files. You...
- Question #389
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...
- Question #390Implement and manage data storage - specifically configuring and understanding SQL Server/Azure SQL compression techniques including ROW, PAGE, and DICTIONARY compression, and knowing which data types support compression.
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. You execute the following T-SQL statements against DB1. For each of the following sta...
Azure SQL DatabaseData CompressionPAGE CompressionT-SQL - Question #392
Your on-premises network contains a server that hosts a 60-TB database named DB1. The network has a 10-Mbps internet connection. You need to migrate DB1 to Azure. The solution must...
- Question #394
You have an on-premises Microsoft SQL Server database named DB1. You plan to migrate DB1 to an Azure SQL database named DB2 by using the Data Migration Assistant (DMA). What will b...
- Question #395
You have an on-premises Microsoft SQL Server instance named SQL1 that hosts multiple databases. You have an Azure subscription that contains an Azure SQL managed instance named SQL...
- Question #396
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 q...
- Question #397Implement a secure environment
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 q...
Azure SQL DatabaseFirewall RulesAccess ControlSecurity - Question #398Implement a secure environment
You have an Azure virtual machine that hosts a Microsoft SQL Server 2022 database named DB1. You need to enable Transparent Data Encryption (TDE) for DB1. What should you create fi...
TDEData EncryptionSQL Server SecurityDatabase Master Key - Question #399Manage Azure identities and governance - specifically implementing and managing Azure resource locks to protect resources from accidental modification or deletion (AZ-104 Domain: Manage Azure Resources)
SIMULATION You need to prevent users from accidentally deleting db1 from the Azure portal. You may need to use SQL Server Management Studio and the Azure portal. Answer: To protect...
Azure Resource LocksAzure SQL DatabaseResource ManagementAzure Governance - Question #400Implement security for data at rest and in transit - specifically configuring Always Encrypted to protect sensitive column data in Azure SQL Database / SQL Server, aligning with Azure certification objectives around data security and compliance (e.g., DP-300, AZ-900, or SC-900 database security domains).
SIMULATION You need to encrypt the LastName column of the SalesLT.Customer table in db1 by using Always Encrypted. You must use the Windows Certificate Store. You may need to use S...
Always EncryptedAzure SQL Database SecurityColumn-Level EncryptionWindows Certificate Store - Question #401Implement and manage virtual networking - Configure private access to Azure services using Private Endpoints (Microsoft Azure Administrator AZ-104 / Azure Database Administrator DP-300)
SIMULATION You need to ensure that you can connect to db1 by using a private IP address on a virtual network named VNET1. You may need to use SQL Server Management Studio and the A...
Azure Private EndpointAzure SQL DatabaseVirtual Network ConnectivityAzure Networking - Question #402Implement a secure environment
SIMULATION You need to ensure that when non-administrative users query the SalesLT.Customer table in db1, email addresses are obscured. For example, an email address of alice@conto...
Dynamic Data MaskingData SecurityAzure SQL DatabaseData Privacy - Question #403
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 hosts a database named DB1. You initiate a copy operation of DB1 to SQL...
- Question #404
You have an Azure subscription that contains a SQL Server on Linux Azure Virtual Machines instance named VM1. VM1 contains a database named DB1. You need to create operational perf...
- Question #405Monitor and Optimize Operational Resources / Configure alerts, notifications, and automated responses in SQL Server on Azure Virtual Machines
Hotspot Question You have an Azure subscription that contains a SQL Server instance on a virtual machine named Server1. You execute the following T-SQL statement on Server1. For ea...
SQL Server AgentAlerts and NotificationsT-SQL AdministrationAzure SQL on VM - Question #406
Hotspot Question You have a logical server for Azure SQL Database named Server1 that has an elastic pool named Pool1. You have a database watcher named Watcher1. You run the follow...
- Question #407Monitor and optimize Azure resources - specifically interpreting Query Performance Insight metrics for Azure SQL Database within the Azure Administrator (AZ-104) or Azure Database Administrator (DP-300) certification domain.
Hotspot Question You have an Azure subscription that contains an Azure SQL database named DB1. You have the Query Performance Insight analysis shown in the following exhibit. For e...
Azure SQL DatabaseQuery Performance InsightDTU MonitoringDatabase Performance Analysis - Question #408
Hotspot Question You have an Azure subscription. You need to deploy two virtual machines named VM1 and VM2 that will host Microsoft SQL Server instances. The solution must meet the...
- Question #409Monitor and optimize operational resources in Azure / Configure monitoring for Azure SQL Database - typically aligned with certifications such as DP-300 (Administering Relational Databases on Microsoft Azure) under the 'Monitor and Optimize Operational Resources' domain or AZ-104 under 'Monitor and Back up Azure Resources'.
SIMULATION You need to generate an email alert for db1 if the average CPU percentage utilization is greater than 50 percent for five minutes sampled at one-minute intervals. The al...
Azure Monitor AlertsAzure SQL DatabaseMetric Alert RulesAction Groups - Question #410Monitor, configure, and optimize database resources
SIMULATION You need to capture the following information for all the databases on sq12345678: - Queries to the databases - Users that executed the queries The captured information...
Extended EventsDatabase MonitoringSQL Query TrackingAzure Storage Integration - Question #411Implement and Monitor Database Infrastructure - specifically configuring and managing Query Store settings to support query performance monitoring and optimization in Azure SQL Database environments.
SIMULATION You need to increase the maximum storage size of the query store on db1 to 4,000 MB. You may need to use SQL Server Management Studio and the Azure portal. Answer: How t...
Query StoreAzure SQL DatabaseALTER DATABASEPerformance Monitoring