AZ-104 Question 189
Single answerYour company hosts a .NET web application on Azure App Service, which also uses an Azure SQL Database. You want to configure daily backups that include the site’s files and the database using the built-in backup option in the Azure Portal. Which step is required to ensure that the Azure SQL Database is included in the backup?
- A
Specify the Azure SQL Database connection string in the App Service Backup settings, then select the option to include it in the backup
- B
Reference the Azure SQL Database resource in an ARM template and upload that template under the App Service Backup configuration
- C
Create a separate Recovery Services Vault backup policy for the Azure SQL Database
- D
Upgrade to a Premium App Service Plan to automatically include the database in the backup
Show answer and explanation
Correct answer: A
Explanation
To include Azure SQL Database in an App Service backup, you need to add the database connection string under the Backup blade for the app and select the option to include that database. This ensures both the web app content and associated database are backed up together on the configured schedule.
- A. Correct.
You must provide the connection string in the App Service Backup settings and explicitly include the database if you want it captured in the App Service backup process.
- B. Incorrect.
ARM templates do not automatically configure App Service backups. You must configure backups via the App Service’s Backup blade in the Azure Portal.
- C. Incorrect.
Azure SQL Database backups can be configured independently using built-in features or Recovery Services Vault, but that is not how you include the database in an App Service-initiated backup.
- D. Incorrect.
Upgrading to Premium does not automatically include an Azure SQL Database in the backup. You still have to configure the inclusion of the database in Backup settings.