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
Isn’t it C. Msdeploy? Since you’d want to deploy changes to the application code and the changes to the db schema..
Yes, it’s msdeploy. BACPAC contains only changes to the db schema and data.
its bacpac.
Answer should be Msdeploy. Because with BACPAC we only have the db changes. Question asks both db and application changes deployment.
yes, it is msdeploy. application changes and sql changes.
I have latest questions and answer
[email protected]