070-487 Free Dumps Study Materials
Question 1: 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. Msdeploy
B. Robocopy
C. BACPAC
D. FTP
Correct Answer: C
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.
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export