Microsoft AZ-305 Data Backup and Recovery Practice Test

 

Topic 14 focuses on Backup and Recovery for Databases and Unstructured Data for the Microsoft Certified: Azure Solutions Architect Expert certification and the AZ-305 exam, using Microsoft Azure solution-architecture scenarios. For broader exam preparation, review the Microsoft Azure Solutions Architect Expert AZ-305 Exam Dumps page. Each question includes a concise explanation of the correct answer and the technical reason the other choices are incorrect.

Question 1

To centrally manage file share protection and retention, which Azure design option should be selected?

1. Blob versioning and soft delete
2. Azure Backup for Azure Files
3. Azure SQL Managed Instance point-in-time restore
4. Azure SQL Database point-in-time restore

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure Backup for Azure Files is designed to centrally manage file share protection and retention. Azure Backup for Azure Files orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.

Incorrect Answers

Answer A is incorrect because Blob versioning and soft delete can be useful in Azure architectures, but its primary role is to recover objects quickly after accidental overwrite or deletion; it is not the best match for the stated priority.

Answer C is incorrect because Azure SQL Managed Instance point-in-time restore can be useful in Azure architectures, but its primary role is to recover a managed instance database from logical data loss; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database point-in-time restore can be useful in Azure architectures, but its primary role is to recover from logical corruption or accidental changes in a managed SQL database; it is not the best match for the stated priority.

 

Question 2

Which Azure capability prevents protected blob data from being modified or deleted during retention?

1. Azure Backup for Azure Database for PostgreSQL Flexible Server
2. Immutable storage retention
3. Azure SQL Database point-in-time restore
4. Azure SQL Managed Instance point-in-time restore

Correct Answer: B

 

Correct Answer

Answer B is correct because Immutable storage retention matches the described capability and is intended to preserve regulated or ransomware-resistant object data.

Incorrect Answers

Answer A is incorrect because Azure Backup for Azure Database for PostgreSQL Flexible Server is intended to manage database protection through Azure Backup policies and vaults, which is a different architectural function.

Answer C is incorrect because Azure SQL Database point-in-time restore is intended to recover from logical corruption or accidental changes in a managed SQL database, which is a different architectural function.

Answer D is incorrect because Azure SQL Managed Instance point-in-time restore is intended to recover a managed instance database from logical data loss, which is a different architectural function.

 

Question 3

To protect object data with centrally managed backup policies, which Azure design option should be selected?

1. Azure SQL Database point-in-time restore
2. Blob versioning and soft delete
3. Azure Files snapshots
4. Azure Backup for Azure Blobs

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure Backup for Azure Blobs is designed to protect object data with centrally managed backup policies. Azure Backup for Azure Blobs provides operational or vaulted backup capabilities for supported Blob Storage scenarios.

Incorrect Answers

Answer A is incorrect because Azure SQL Database point-in-time restore can be useful in Azure architectures, but its primary role is to recover from logical corruption or accidental changes in a managed SQL database; it is not the best match for the stated priority.

Answer B is incorrect because Blob versioning and soft delete can be useful in Azure architectures, but its primary role is to recover objects quickly after accidental overwrite or deletion; it is not the best match for the stated priority.

Answer C is incorrect because Azure Files snapshots can be useful in Azure architectures, but its primary role is to provide fast point-in-time recovery for Azure file shares; it is not the best match for the stated priority.

 

Question 4

For Azure Files snapshots, which statement is accurate?

1. Prevents protected blob data from being modified or deleted during retention.
2. Orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.
3. Retains selected full backups for months or years according to configured LTR policies.
4. Create share-level point-in-time copies that can be used to recover files or directories.

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure Files snapshots create share-level point-in-time copies that can be used to recover files or directories.

Incorrect Answers

Answer A is incorrect because that description belongs to Immutable storage retention, whose purpose is to preserve regulated or ransomware-resistant object data.

Answer B is incorrect because that description belongs to Azure Backup for Azure Files, whose purpose is to centrally manage file share protection and retention.

Answer C is incorrect because that description belongs to Azure SQL Database long-term retention, whose purpose is to meet extended database retention requirements.

 

Question 5

Which Azure capability retains selected full backups for months or years according to configured LTR policies?

1. Azure Files snapshots
2. Azure SQL Managed Instance point-in-time restore
3. Azure SQL Database long-term retention
4. Azure Backup for Azure Database for PostgreSQL Flexible Server

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database long-term retention matches the described capability and is intended to meet extended database retention requirements.

Incorrect Answers

Answer A is incorrect because Azure Files snapshots is intended to provide fast point-in-time recovery for Azure file shares, which is a different architectural function.

Answer B is incorrect because Azure SQL Managed Instance point-in-time restore is intended to recover a managed instance database from logical data loss, which is a different architectural function.

Answer D is incorrect because Azure Backup for Azure Database for PostgreSQL Flexible Server is intended to manage database protection through Azure Backup policies and vaults, which is a different architectural function.

 

Question 6

Which Azure capability provide managed backups and point-in-time recovery within the configured retention period?

1. PostgreSQL Flexible Server automated backups
2. Azure Backup for Azure Database for PostgreSQL Flexible Server
3. Blob versioning and soft delete
4. Azure Files snapshots

Correct Answer: A

 

Correct Answer

Answer A is correct because PostgreSQL Flexible Server automated backups matches the described capability and is intended to recover managed PostgreSQL data without maintaining a separate backup infrastructure.

Incorrect Answers

Answer B is incorrect because Azure Backup for Azure Database for PostgreSQL Flexible Server is intended to manage database protection through Azure Backup policies and vaults, which is a different architectural function.

Answer C is incorrect because Blob versioning and soft delete is intended to recover objects quickly after accidental overwrite or deletion, which is a different architectural function.

Answer D is incorrect because Azure Files snapshots is intended to provide fast point-in-time recovery for Azure file shares, which is a different architectural function.

 

Question 7

When considering Azure Backup for Azure Blobs, which requirement supports that choice?

1. To provide fast point-in-time recovery for Azure file shares.
2. To recover objects quickly after accidental overwrite or deletion.
3. To recover from logical corruption or accidental changes in a managed SQL database.
4. To protect object data with centrally managed backup policies.

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure Backup for Azure Blobs provides operational or vaulted backup capabilities for supported Blob Storage scenarios.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure Files snapshots, not Azure Backup for Azure Blobs.

Answer B is incorrect because that outcome is more directly associated with Blob versioning and soft delete, not Azure Backup for Azure Blobs.

Answer C is incorrect because that outcome is more directly associated with Azure SQL Database point-in-time restore, not Azure Backup for Azure Blobs.

 

Question 8

Which Azure capability create share-level point-in-time copies that can be used to recover files or directories?

1. Immutable storage retention
2. Azure Backup for Azure Files
3. Azure SQL Database long-term retention
4. Azure Files snapshots

Correct Answer: D

 

Correct Answer

Answer D is correct because Azure Files snapshots matches the described capability and is intended to provide fast point-in-time recovery for Azure file shares.

Incorrect Answers

Answer A is incorrect because Immutable storage retention is intended to preserve regulated or ransomware-resistant object data, which is a different architectural function.

Answer B is incorrect because Azure Backup for Azure Files is intended to centrally manage file share protection and retention, which is a different architectural function.

Answer C is incorrect because Azure SQL Database long-term retention is intended to meet extended database retention requirements, which is a different architectural function.

 

Question 9

To recover from logical corruption or accidental changes in a managed SQL database, which Azure design option should be selected?

1. Azure Backup for Azure Blobs
2. PostgreSQL Flexible Server automated backups
3. Azure SQL Database point-in-time restore
4. Azure SQL Database long-term retention

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database point-in-time restore uses automated backups to restore a database to a selected time within the configured retention window. It directly meets the requirement to recover from logical corruption or accidental changes in a managed SQL database.

Incorrect Answers

Answer A is incorrect because Azure Backup for Azure Blobs is used to protect object data with centrally managed backup policies; that does not directly satisfy the requirement in this scenario.

Answer B is incorrect because PostgreSQL Flexible Server automated backups is used to recover managed PostgreSQL data without maintaining a separate backup infrastructure; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure SQL Database long-term retention is used to meet extended database retention requirements; that does not directly satisfy the requirement in this scenario.

 

Question 10

For Azure Backup for Azure Files, which statement is accurate?

1. Preserve previous and deleted blob states for operational recovery.
2. Restores a managed instance database to a previous point within the retention period using automated backups.
3. Orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.
4. Uses automated backups to restore a database to a selected time within the configured retention window.

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure Backup for Azure Files orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.

Incorrect Answers

Answer A is incorrect because that description belongs to Blob versioning and soft delete, whose purpose is to recover objects quickly after accidental overwrite or deletion.

Answer B is incorrect because that description belongs to Azure SQL Managed Instance point-in-time restore, whose purpose is to recover a managed instance database from logical data loss.

Answer D is incorrect because that description belongs to Azure SQL Database point-in-time restore, whose purpose is to recover from logical corruption or accidental changes in a managed SQL database.

 

Question 11

Several Azure file shares need centrally managed protection policies and retention. Which backup offering is designed for these shares?

1. Azure Backup for Azure Files
2. Azure SQL Database point-in-time restore
3. Azure SQL Managed Instance point-in-time restore
4. Blob versioning and soft delete

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Backup for Azure Files orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios. It directly meets the requirement to centrally manage file share protection and retention.

Incorrect Answers

Answer B is incorrect because Azure SQL Database point-in-time restore is used to recover from logical corruption or accidental changes in a managed SQL database; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Managed Instance point-in-time restore is used to recover a managed instance database from logical data loss; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Blob versioning and soft delete is used to recover objects quickly after accidental overwrite or deletion; that does not directly satisfy the requirement in this scenario.

 

Question 12

Which Azure capability uses automated backups to restore a database to a selected time within the configured retention window?

1. Azure SQL Database long-term retention
2. Azure SQL Database point-in-time restore
3. Azure Backup for Azure Blobs
4. PostgreSQL Flexible Server automated backups

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure SQL Database point-in-time restore matches the described capability and is intended to recover from logical corruption or accidental changes in a managed SQL database.

Incorrect Answers

Answer A is incorrect because Azure SQL Database long-term retention is intended to meet extended database retention requirements, which is a different architectural function.

Answer C is incorrect because Azure Backup for Azure Blobs is intended to protect object data with centrally managed backup policies, which is a different architectural function.

Answer D is incorrect because PostgreSQL Flexible Server automated backups is intended to recover managed PostgreSQL data without maintaining a separate backup infrastructure, which is a different architectural function.

 

Question 13

To preserve regulated or ransomware-resistant object data, which Azure design option should be selected?

1. Azure SQL Managed Instance point-in-time restore
2. Azure SQL Database point-in-time restore
3. Immutable storage retention
4. Azure Backup for Azure Database for PostgreSQL Flexible Server

Correct Answer: C

 

Correct Answer

Answer C is correct because Immutable storage retention is designed to preserve regulated or ransomware-resistant object data. Immutable storage retention prevents protected blob data from being modified or deleted during retention.

Incorrect Answers

Answer A is incorrect because Azure SQL Managed Instance point-in-time restore can be useful in Azure architectures, but its primary role is to recover a managed instance database from logical data loss; it is not the best match for the stated priority.

Answer B is incorrect because Azure SQL Database point-in-time restore can be useful in Azure architectures, but its primary role is to recover from logical corruption or accidental changes in a managed SQL database; it is not the best match for the stated priority.

Answer D is incorrect because Azure Backup for Azure Database for PostgreSQL Flexible Server can be useful in Azure architectures, but its primary role is to manage database protection through Azure Backup policies and vaults; it is not the best match for the stated priority.

 

Question 14

To provide fast point-in-time recovery for Azure file shares, which Azure design option should be selected?

1. Azure Files snapshots
2. Immutable storage retention
3. Azure Backup for Azure Files
4. Azure SQL Database long-term retention

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Files snapshots is designed to provide fast point-in-time recovery for Azure file shares. Azure Files snapshots create share-level point-in-time copies that can be used to recover files or directories.

Incorrect Answers

Answer B is incorrect because Immutable storage retention can be useful in Azure architectures, but its primary role is to preserve regulated or ransomware-resistant object data; it is not the best match for the stated priority.

Answer C is incorrect because Azure Backup for Azure Files can be useful in Azure architectures, but its primary role is to centrally manage file share protection and retention; it is not the best match for the stated priority.

Answer D is incorrect because Azure SQL Database long-term retention can be useful in Azure architectures, but its primary role is to meet extended database retention requirements; it is not the best match for the stated priority.

 

Question 15

A database recovery plan must retain selected full backups after the ordinary short-term recovery window has expired. Which requirement is addressed by Azure SQL Database long-term retention?

1. To provide fast point-in-time recovery for Azure file shares.
2. To recover a managed instance database from logical data loss.
3. To meet extended database retention requirements.
4. To manage database protection through Azure Backup policies and vaults.

Correct Answer: C

 

Correct Answer

Answer C is correct because Azure SQL Database long-term retention retains selected full backups for months or years according to configured LTR policies.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure Files snapshots, not Azure SQL Database long-term retention.

Answer B is incorrect because that outcome is more directly associated with Azure SQL Managed Instance point-in-time restore, not Azure SQL Database long-term retention.

Answer D is incorrect because that outcome is more directly associated with Azure Backup for Azure Database for PostgreSQL Flexible Server, not Azure SQL Database long-term retention.

 

Question 16

A blob recovery design must preserve earlier versions as well as recover accidentally deleted blobs during a retention period. Which combination provides these complementary protections?

1. PostgreSQL Flexible Server automated backups
2. Blob versioning and soft delete
3. Azure SQL Database long-term retention
4. Immutable storage retention

Correct Answer: B

 

Correct Answer

Answer B is correct because Blob versioning and soft delete preserve previous and deleted blob states for operational recovery. It directly meets the requirement to recover objects quickly after accidental overwrite or deletion.

Incorrect Answers

Answer A is incorrect because PostgreSQL Flexible Server automated backups is used to recover managed PostgreSQL data without maintaining a separate backup infrastructure; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database long-term retention is used to meet extended database retention requirements; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Immutable storage retention is used to preserve regulated or ransomware-resistant object data; that does not directly satisfy the requirement in this scenario.

 

Question 17

For Immutable storage retention, which statement is accurate?

1. Restores a managed instance database to a previous point within the retention period using automated backups.
2. Provides vault-based backup for supported PostgreSQL Flexible Server configurations.
3. Uses automated backups to restore a database to a selected time within the configured retention window.
4. Prevents protected blob data from being modified or deleted during retention.

Correct Answer: D

 

Correct Answer

Answer D is correct because Immutable storage retention prevents protected blob data from being modified or deleted during retention.

Incorrect Answers

Answer A is incorrect because that description belongs to Azure SQL Managed Instance point-in-time restore, whose purpose is to recover a managed instance database from logical data loss.

Answer B is incorrect because that description belongs to Azure Backup for Azure Database for PostgreSQL Flexible Server, whose purpose is to manage database protection through Azure Backup policies and vaults.

Answer C is incorrect because that description belongs to Azure SQL Database point-in-time restore, whose purpose is to recover from logical corruption or accidental changes in a managed SQL database.

 

Question 18

A storage team needs backup policies that govern protection of Azure blob data. Which listed service is specifically intended for this object-storage protection?

1. Blob versioning and soft delete
2. Azure Backup for Azure Blobs
3. Azure SQL Database point-in-time restore
4. Azure Files snapshots

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure Backup for Azure Blobs provides operational or vaulted backup capabilities for supported Blob Storage scenarios. It directly meets the requirement to protect object data with centrally managed backup policies.

Incorrect Answers

Answer A is incorrect because Blob versioning and soft delete is used to recover objects quickly after accidental overwrite or deletion; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Database point-in-time restore is used to recover from logical corruption or accidental changes in a managed SQL database; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Files snapshots is used to provide fast point-in-time recovery for Azure file shares; that does not directly satisfy the requirement in this scenario.

 

Question 19

When considering Blob versioning and soft delete, which requirement supports that choice?

1. To preserve regulated or ransomware-resistant object data.
2. To meet extended database retention requirements.
3. To recover objects quickly after accidental overwrite or deletion.
4. To recover managed PostgreSQL data without maintaining a separate backup infrastructure.

Correct Answer: C

 

Correct Answer

Answer C is correct because Blob versioning and soft delete preserve previous and deleted blob states for operational recovery.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Immutable storage retention, not Blob versioning and soft delete.

Answer B is incorrect because that outcome is more directly associated with Azure SQL Database long-term retention, not Blob versioning and soft delete.

Answer D is incorrect because that outcome is more directly associated with PostgreSQL Flexible Server automated backups, not Blob versioning and soft delete.

 

Question 20

To recover a managed instance database from logical data loss, which Azure design option should be selected?

1. Azure SQL Managed Instance point-in-time restore
2. PostgreSQL Flexible Server automated backups
3. Azure Backup for Azure Blobs
4. Azure Backup for Azure Files

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Managed Instance point-in-time restore restores a managed instance database to a previous point within the retention period using automated backups. It directly meets the requirement to recover a managed instance database from logical data loss.

Incorrect Answers

Answer B is incorrect because PostgreSQL Flexible Server automated backups is used to recover managed PostgreSQL data without maintaining a separate backup infrastructure; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure Backup for Azure Blobs is used to protect object data with centrally managed backup policies; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Backup for Azure Files is used to centrally manage file share protection and retention; that does not directly satisfy the requirement in this scenario.

 

Question 21

An organization wants to manage database protection through Azure Backup policies and vaults. Which design choice most directly meets the requirement?

1. Azure Backup for Azure Database for PostgreSQL Flexible Server
2. Immutable storage retention
3. Azure Backup for Azure Files
4. Azure Backup for Azure Blobs

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Backup for Azure Database for PostgreSQL Flexible Server provides vault-based backup for supported PostgreSQL Flexible Server configurations. It directly meets the requirement to manage database protection through Azure Backup policies and vaults.

Incorrect Answers

Answer B is incorrect because Immutable storage retention is used to preserve regulated or ransomware-resistant object data; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure Backup for Azure Files is used to centrally manage file share protection and retention; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Backup for Azure Blobs is used to protect object data with centrally managed backup policies; that does not directly satisfy the requirement in this scenario.

 

Question 22

An enterprise architect needs to meet extended database retention requirements. Which Azure service or capability is the best fit?

1. Azure SQL Database long-term retention
2. Azure Backup for Azure Database for PostgreSQL Flexible Server
3. Azure SQL Managed Instance point-in-time restore
4. Azure Files snapshots

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure SQL Database long-term retention retains selected full backups for months or years according to configured LTR policies. It directly meets the requirement to meet extended database retention requirements.

Incorrect Answers

Answer B is incorrect because Azure Backup for Azure Database for PostgreSQL Flexible Server is used to manage database protection through Azure Backup policies and vaults; that does not directly satisfy the requirement in this scenario.

Answer C is incorrect because Azure SQL Managed Instance point-in-time restore is used to recover a managed instance database from logical data loss; that does not directly satisfy the requirement in this scenario.

Answer D is incorrect because Azure Files snapshots is used to provide fast point-in-time recovery for Azure file shares; that does not directly satisfy the requirement in this scenario.

 

Question 23

When considering Azure Backup for Azure Files, which requirement supports that choice?

1. To recover from logical corruption or accidental changes in a managed SQL database.
2. To centrally manage file share protection and retention.
3. To recover objects quickly after accidental overwrite or deletion.
4. To recover a managed instance database from logical data loss.

Correct Answer: B

 

Correct Answer

Answer B is correct because Azure Backup for Azure Files orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.

Incorrect Answers

Answer A is incorrect because that outcome is more directly associated with Azure SQL Database point-in-time restore, not Azure Backup for Azure Files.

Answer C is incorrect because that outcome is more directly associated with Blob versioning and soft delete, not Azure Backup for Azure Files.

Answer D is incorrect because that outcome is more directly associated with Azure SQL Managed Instance point-in-time restore, not Azure Backup for Azure Files.

 

Question 24

Users sometimes overwrite or delete blobs accidentally and need a quick way to recover previous object content. Which combination of object-level protection features fits this requirement?

1. Azure SQL Database long-term retention
2. PostgreSQL Flexible Server automated backups
3. Immutable storage retention
4. Blob versioning and soft delete

Correct Answer: D

 

Correct Answer

Answer D is correct because Blob versioning and soft delete is designed to recover objects quickly after accidental overwrite or deletion. Blob versioning and soft delete preserve previous and deleted blob states for operational recovery.

Incorrect Answers

Answer A is incorrect because Azure SQL Database long-term retention can be useful in Azure architectures, but its primary role is to meet extended database retention requirements; it is not the best match for the stated priority.

Answer B is incorrect because PostgreSQL Flexible Server automated backups can be useful in Azure architectures, but its primary role is to recover managed PostgreSQL data without maintaining a separate backup infrastructure; it is not the best match for the stated priority.

Answer C is incorrect because Immutable storage retention can be useful in Azure architectures, but its primary role is to preserve regulated or ransomware-resistant object data; it is not the best match for the stated priority.

 

Question 25

For Azure Backup for Azure Database for PostgreSQL Flexible Server, which statement is accurate?

1. Provides vault-based backup for supported PostgreSQL Flexible Server configurations.
2. Provides operational or vaulted backup capabilities for supported Blob Storage scenarios.
3. Orchestrates file share snapshots and retention through a Recovery Services vault for supported scenarios.
4. Prevents protected blob data from being modified or deleted during retention.

Correct Answer: A

 

Correct Answer

Answer A is correct because Azure Backup for Azure Database for PostgreSQL Flexible Server provides vault-based backup for supported PostgreSQL Flexible Server configurations.

Incorrect Answers

Answer B is incorrect because that description belongs to Azure Backup for Azure Blobs, whose purpose is to protect object data with centrally managed backup policies.

Answer C is incorrect because that description belongs to Azure Backup for Azure Files, whose purpose is to centrally manage file share protection and retention.

Answer D is incorrect because that description belongs to Immutable storage retention, whose purpose is to preserve regulated or ransomware-resistant object data.