CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free DP-300 Exam Braindumps (page: 5)

Page 5 of 76
PDF with 352 Questions

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.

Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.

You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.

What should you include in the recommendation?

  1. Azure Backup
  2. Azure Information Protection
  3. Windows Server Failover Cluster
  4. Azure Site Recovery

Answer(s): D

Explanation:

You can use Azure Site Recovery to test failover.
You run a test failover to validate your replication and disaster recovery strategy, without any data loss or downtime. A test failover doesn't impact ongoing replication, or your production environment. You can run a test failover on a specific virtual machine (VM), or on a recovery plan containing multiple VMs.


Reference:

https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure



HOTSPOT (Drag and Drop is not supported)
You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
-Support user-initiated backups.
-Support multiple automatically replicated instances across Azure regions.
-Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Azure SQL Managed Instance
Managed Instance will support native BACKUP like SQL Server.

COPY_ONLY Backup
Once you create a credential, you can backup any database using standard BACKUP T-SQL command:

BACKUP DATABASE tpcc2501
TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak'

WITH COPY_ONLY
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.

Box 2: Auto-failover group
For geographic failover of instances of SQL Managed Instance, use Auto-failover groups.
The auto-failover groups feature allows you to manage the replication and failover of some or all databases on a logical server to another region.
Incorrect:
Not Active geo-replication: Active geo-replication is not supported by Azure SQL Managed Instance.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db



HOTSPOT (Drag and Drop is not supported)
You configure a long-term retention policy for an Azure SQL database as shown in the exhibit. (Click the Exhibit tab.)

The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly backups are:

-January 4, 2020
-January 11, 2020
-January 18, 2020
-January 25, 2020
-February 1, 2020
-February 8, 2020
-February 15, 2020
-February 22, 2020
-February 29, 2020
-March 7, 2020

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: 12 months
The January 4, 2020 backup is the first backup of the month, and it will keep for 12 months.

Box 2: 10 years.
The January 11, 2020 backup is the Week 2 backup. This backup will be the yearly backup, and it will be retained for 10 years.
Note: Long-term backup retention (LTR) leverages the full database backups that are automatically created to enable point in time restore (PITR). If an LTR policy is configured, these backups are copied to different blobs for long-term storage. The copy is a background job that has no performance impact on the database workload. The LTR policy for each database in SQL Database can also specify how frequently the LTR backups are created.
To enable LTR, you can define a policy using a combination of four parameters: weekly backup retention (W), monthly backup retention (M), yearly backup retention (Y), and week of year (WeekOfYear). If you specify W, one backup every week will be copied to the long-term storage. If you specify M, the first backup of each month will be copied to the long-term storage. If you specify Y, one backup during the week specified by WeekOfYear will be copied to the long-term storage. If the specified WeekOfYear is in the past when the policy is configured, the first LTR backup will be created in the following year. Each backup will be kept in the long-term storage according to the policy parameters that are configured when the LTR backup is created.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql



You have a new Azure subscription.
You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.
You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. From the properties of DB1, configure geo-replication.
  2. From the properties of Server1, add a failover group.
  3. Create a new Azure SQL Database server named Server2.
  4. From the properties of Server1, configure retention for DB1.
  5. Create a new Azure SQL Database instance named DB2.

Answer(s): B,C

Explanation:

B: The auto-failover groups feature allows you to manage the replication and failover of some or all databases on a logical server to another region.
C: The auto-failover group must be configured on the primary server and will connect it to the secondary server in a different Azure region. T


Incorrect:
Not A: Geo-replication failovers require client applications to change their connection strings.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#best-practices-for-sql-database https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-single-database-tutorial?tabs=azure-portal



Page 5 of 76



Post your Comments and Discuss Microsoft DP-300 exam with other Community members:

laks commented on December 26, 2024
so far seems good
UNITED STATES
upvote

Jack commented on October 24, 2024
Muito bom as perguntas
Anonymous
upvote

TheUser commented on October 23, 2024
So far seems good
Anonymous
upvote

anonymus commented on October 23, 2024
master database differential backup is not supported in sql server
EUROPEAN UNION
upvote

Ntombi commented on October 17, 2024
i find the questions helpful for my exam preparation
Anonymous
upvote

Ntombi commented on October 17, 2024
The questions help me to see if I understood what I have learned
Anonymous
upvote

ntombi commented on October 17, 2024
writing exam at the end of the month
Anonymous
upvote

Raby commented on August 13, 2024
Wonderful work guys. The PDF version helped me pass. Thank you
EUROPEAN UNION
upvote