Az-104 Practice Exam 4 – Review Mode – Question 2

[Tyler L.]

The documentation states that only Azure Databases Running in SQL Server on a VM can be backed up to an RSV. The answer in the screenshot I provided is at best misleading, at worst it is incorrect. It says Azure SQL Databases can be backed up also. To me this indicated that you mean Azure Managed PaaS databases.

Also, the answer states: “After you deleted the lock and backup data, you can now delete the TD-Cebu resource group”. However, there is still a lock on the VM and the Vnet. Are you saying that you can delete the resource group with out removing those locks?

I’m finding multiple issues like this in the practice exams. I need to be able to trust that the answers and explanations are correct, otherwise what is the point of even using these practice exams? I’m getting quite annoyed with having to stop my exam prep to stop and double check answers that don’t seem correct.

[Tutorials-Dojo]

Hi Tyler,

Thank you for posting your question. For your first question, please take note that the part of the explanation that you highlighted is actually referenced from the official Microsoft Azure documentation:

You can use Recovery Services vaults to hold backup data for various Azure services such as IaaS VMs (Linux or Windows) and Azure SQL databases. Recovery Services Vaults support System Center DPM, Windows Server, Azure Backup Server, and more.

Reference:

https://learn.microsoft.com/en-us/azure/security/fundamentals/backup-plan-to-protect-against-ransomware#:~:text=You%20can%20use%20Recovery%20Services%20vaults%20to%20hold%20backup%20data%20for%20various%20Azure%20services%20such%20as%20IaaS%20VMs%20(Linux%20or%20Windows)%20and%20Azure%20SQL%20databases%20as%20well%20as%20on%2Dpremises%20assets.

The 2nd one is also supported by the official Azure documentation here:

https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/delete-resource-group?tabs=azure-powershell#:~:text=To%20delete%20a%20resource%20group%2C%20you%20must%20first%20remove%20any%20underlying%20resource%20locks%20and%20backup%20data.

Kindly check the provided links above and let us know if you need further assistance. The Tutorials Dojo team is dedicated to help you pass your AWS exam on your first try!

Regards,

Jon Bonso @ Tutorials Dojo

[Tyler L.]

Thank you for your response. Regarding my first question, above the section that you highlighted in the Microsoft documentation, it lists “SQL Server databases running on Azure VMs (Iaas)”, below in the section that you highlighted it says “Azure SQL databases”. Does this mean that both SQL Server databases running on Azure VMs and PaaS Azure Managed SQL Databases are both supported for backup to RSV? Or only “SQL Server databases running on Azure VMs”? This is where my confusion lies.