Exam 70-487 All Questions

View all questions & answers for the 70-487 exam

Exam 70-487 topic 1 question 50 discussion

Actual exam question from Microsoft's 70-487

Question #: 50
Topic #: 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. BACPAC
B. FTP
C. Msdeploy
D. Robocopy
E. Transact-SQL scripts

Show Suggested Answer

Suggested Answer: A 🗳️
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.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-export

by bobtables at Nov. 26, 2019, 3:16 a.m.

Comments

Submit Cancel

dosper

Highly Voted 5 years, 6 months ago

It's C: https://docs.microsoft.com/en-us/previous-versions/dd465343(v=vs.100)?redirectedfrom=MSDN

upvoted 11 times

...

tiger25

Highly Voted 5 years, 4 months ago

Clearly C - MsDeploy. 120 is the same question, and the answer is MsDeploy there.

upvoted 6 times

...

Ptu12125

Most Recent 4 years, 5 months ago

E. Transact SQL Scripts is the correct answer. Ref: https://docs.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml

upvoted 1 times

...

this_is_sparta

5 years, 4 months ago

Even if you use MSDeploy, it seems that you need a .dacpac file as source (see https://docs.microsoft.com/en-us/sql/ssdt/using-msdeploy-with-dbsqlpackage-provider?view=sql-server-ver15). So i guess "A" is correct.

upvoted 1 times

mr_

4 years, 11 months ago

Yes, but in the end of the day you utilize MSDeploy tool to deploy both DB schema changes (incremantally) and application code changes that are mentioned in the question. BACPAC (from A answer) is not the same as DACPAC by the way but even though neither of them will provide you with possibility to deploy app code changes, so I do think that A is not correct anyway.

upvoted 2 times

...

rj001

5 years, 4 months ago

it's C. Msdeploy

upvoted 4 times

...

LeonWang

5 years, 5 months ago

Msdeploy is my choice

upvoted 5 times

...

vojche

5 years, 6 months ago

I think it's Msdeploy

upvoted 3 times

...

bobtables

5 years, 7 months ago

Is this right? It explicitly says (in addition to schema changes to the database) that you "change the application code". Bacpac can't deploy code changes.

upvoted 4 times

founderDev

5 years, 4 months ago

It's C

upvoted 7 times

Dev666

4 years, 10 months ago

agreed

upvoted 2 times

...