HOTSPOT
You are developing an ASP.NET MVC application. It is ready for deployment to the production web
server.
A local SQL Express .MDF file was used by the application during development
The deployment has the following requirements:
The deployment must merge the assemblies on the local machine with
those on the host.
The deployment must publish the local database to the remote
Microsoft SQL server.
You need to configure the web package settings for deployment.
Which settings should you use? (To answer, select the appropriate setting or settings in the answer
area.)
Answer: 
>> The deployment must publish the local database to the remote
Microsoft SQL server.
So why do we check “Exclude files from App_Data folder”?
0
0
I totally agree, this checkbox doesn’t need to be checked
0
0
The options I think are correct:
* All files in this project (will only publish files that are actually used / linked in the project)
* Exclude generated debug symbols (typical production scenario)
* Exclude files from the App_Data folder (since the SQL Express MDF file will be there by default and you don’t need that in production)
* Include all databases configured in the Package/Publish SQL tab — otherwise the requirement “the deployment must publish the local database…” isn’t met.
Precompiling the application isn’t in the requirements AFAIK.
0
0