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?
A.
BACPAC
B.
FTP
C.
Msdeploy
D.
Robocopy
Explanation:
You can deploy a .bacpac file to an Azure SQL Database using an Azure Resource Manager
Template. .bacpac contains the schema and data necessary to deploy your database.
Note: A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from a SQL
Server database. A BACPAC file can be stored in Azure blob storage or in local storage in an on-premises
location and later imported back into Azure SQL Database or into a SQL Server on-premises installation.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export