Microsoft DP-300 Administering Relational Databases on Microsoft Azure Online Training
Microsoft DP-300 Online Training
The questions for DP-300 were last updated at Nov 23,2024.
- Exam Code: DP-300
- Exam Name: Administering Relational Databases on Microsoft Azure
- Certification Provider: Microsoft
- Latest update: Nov 23,2024
You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize
downtime during scaling operations.
What should you use?
- A . An Azure SQL Database elastic pool
- B . SQL Server on Azure virtual machines
- C . an Azure SQL Database managed instance
- D . Azure SQL databases
You have 10 Azure virtual machines that have SQL Server installed.
You need to implement a backup strategy to ensure that you can restore specific databases to other SQL
Server instances. The solution must provide centralized management of the backups.
What should you include in the backup strategy?
- A . Automated Backup in the SQL virtual machine settings
- B . Azure Backup
- C . Azure Site Recovery
- D . SQL Server Agent jobs
You need to recommend an availability strategy for an Azure SQL database.
The strategy must meet the following requirements:
✑ Support failovers that do not require client applications to change their connection strings.
✑ Replicate the database to a secondary Azure region.
✑ Support failover to the secondary region.
What should you include in the recommendation?
- A . failover groups
- B . transactional replication
- C . Availability Zones
- D . geo-replication
DRAG DROP
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.
You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands. You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.
The database fails on Wednesday at 10:00.
Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order.
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
- A . locally-redundant storage (LRS)
- B . read-access geo-redundant storage (RA-GRS)
- C . zone-redundant storage (ZRS)
- D . geo-redundant storage
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
- A . Restore with Recovery
- B . Restore with Norecovery
- C . Restore with Standby
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
- A . Restore with Recovery
- B . Restore with Norecovery
- C . Restore with Standby
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
- A . Restore with Recovery
- B . Restore with Norecovery
- C . Restore with Standby
You are planning disaster recovery for the failover group of an Azure SQL Database managed instance.
Your company’s SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs.
You set the Read/Write failover policy to Automatic.
What are two results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . In the event of a datacenter or Azure regional outage, the databases will fail over automatically.
- B . In the event of an outage, the databases in the primary instance will fail over immediately.
- C . In the event of an outage, you can selectively fail over individual databases.
- D . In the event of an outage, you can set a different grace period to fail over each database.
- E . In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.
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 Hyperscale
- B . Azure SQL Database managed instance General Purpose
- C . Azure SQL Database Premium
- D . Azure SQL Database Basic
Latest DP-300 Dumps Valid Version with 176 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
