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 remoteMicrosoft 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.)
Hot Area:
Answer: 
See MSDN ‘Walkthrough: Deploying a Web Application Project Using a Web Deployment Package (Part 1 of 4)’ :https://msdn.microsoft.com/en-us/library/dd483479(v=vs.100)
select – all files in this project folder
check – exclude generated debug symbols
check – precompile this application before publishing
I think exclude files from the App_Data folder should not be checked
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.