Developing Microsoft Azure and Web Services — Question 17

You have a web application that was developed by using Microsoft ASP.NET MVC. The application is deployed to an Azure web app and uses an Azure SQL
Database.
From a development environment, you use Microsoft Visual Studio to change the application code, and you modify the schema of the database.
You need to deploy the changes to Azure.
Which publishing method should you use?

Answer options

• A. BACPAC
• B. FTP
• C. Msdeploy
• D. Robocopy
• E. Transact-SQL scripts

Correct answer: A

Explanation

The correct choice is BACPAC because it is specifically designed for exporting and importing Azure SQL Database schemas and data, making it ideal for deploying database changes. The other options like FTP and Robocopy are not suitable for database schema updates, while Msdeploy is more focused on web application deployment rather than database management.