Home » Microsoft » 70-487 v.2 » Which publishing method should you use?
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. Web Deploy
D. Robocopy
Correct Answer: C
Explanation/Reference:
Web Deploy is an extensible client-server tool for syncing content and configuration to IIS. Web Deploy is used primarily in two scenarios:
Developers use it to sync (aka ‘publish’) a compiled web applications (ASP .Net, PHP etc) from developer tools (Visual Studio, WebMatrix, etc) to IIS IT professionals use it to migrate websites & applications
Web Deploy is often compared to technologies like FTP, XCOPY or RoboCopy. While these technologies are useful, Web Deploy offers several benefits:
Web Deploy can publish databases. Web Deploy has out-of-box support for scripting out SQL Server, MySQL Server, Sqlite and SQL Server Compact databases and applying the resulting script during the sync. This can be very handy if your app needs a database to function.
Incorrect Answers:
A: When you need to export a database for archiving or for moving to another platform, you can export the database schema and data to a BACPAC file.
D: DACPAC is a single file which contains database model i.e. all files represent database objects. It’s a binary representation of database project compatible with SSDT.
References:
https://docs.microsoft.com/en-us/iis/publish/using-web-deploy/introduction-to-web-deploy