Question 311 · 354 in bank
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?
Show answer
Answer: D
DP-300AssociateMicrosoftAll questions freePage 32 of 36
DP-300 practice questions 311–320
Administering Microsoft Azure SQL Solutions354 questions across 36 pages are complete and free, with no account or card.
Official study references
354 questions in this bank
Free access · progress saved on this device
Question 312 · 354 in bank
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?
Show answer
Answer: D
Explanation
Geo-redundant storage (GRS) is cheaper compared to read-access geo-redundant storage (RA-GRS). Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. Data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. Incorrect Answers: A: Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requiring high availability. B: RA-GRS is more expensive than GRS. Note: Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. When you enable read access to the secondary region, your data is available to be read if the primary region becomes unavailable. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS). C: Zone-redundant storage (ZRS) copies your data synchronously across three Azure availability zones in the primary region. Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
Source: Adapted from community discussion — Luke97
Question 313 · 354 in bank
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 deploy a failover cluster instance (FCI) to VM1 and VM2. The solution must eliminate the need for the following: • A distributed network name (DNN) • A load balancer What should you do?
Show answer
Answer: D
Explanation
The answer is D: Connectivity To match the on-premises experience for connecting to your availability group listener, deploy your SQL Server VMs to multiple subnets within the same virtual network. Having multiple subnets negates the need for the extra dependency on an Azure Load Balancer, or a distributed network name (DNN) to route your traffic to your listener. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql
Source: Adapted from community discussion — jtrain
Question 314 · 354 in bank
HOTSPOT - 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 databasebackups. How should you complete the commands? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
The answer is correct https://techcommunity.microsoft.com/t5/azure-sql-blog/native-database-backup-in-azure-sql-managed-instance/ba-p/386154 The only mandatory property is COPY_ONLY. Azure SQL Managed Instance owns the backup chain. This means that you cannot perform database backup that breaks the backup chain. Azure SQL Managed Instance allows you to perform only COPY_ONLY backups.
Source: Adapted from community discussion — sca88
References
Question 315 · 354 in bank
HOTSPOT - 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 for the deployment. How should you configure the storage account? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Here specifically they are not mentioning what will fail, so LRS is more than enough. If they say whole datacenter fails then as per MS use ZRS
Source: Adapted from community discussion — Sr18
References
Question 316 · 354 in bank
DRAG DROP - 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 DB2. You need to take a snapshot backup of DB1 and DB2. The backup must NOT disrupt the backup chain and must NOT affect other databases. Which three Transact-SQL commands should you run in sequence? To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Sorry just realized Snapshot back is similar like copy only backup and will not impact the exisiting log chain, , Hence answer is correct
Source: Adapted from community discussion — 04db10c
References
Question 317 · 354 in bank
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 must be in the West US 3 Azure region. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Question 318 · 354 in bank
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 connection strings. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Question 319 · 354 in bank
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 machine. You may need to use SQL Server Management Studio and the Azure portal.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Explanation
Azure logical SQL Server -> Data Management -> Backups -> Retention Policies -> Select Databases -> Configure Policies -> Monthly LTR Backups -> Keep for 5 Years
Source: Adapted from community discussion — voodoo_sh
Question 320 · 354 in bank
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 named sql12345678. User2-12345678 must be prevented from connecting to the databases and modifying database server settings. The solution must minimize administrative effort. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Show the answer figure
Answer: See figure below
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-300 practice, question 311. 354 questions available.
About this question bank
Version 1.0.0. How we source questions