Which connection string should you add to the Web.config file?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Microsoft
ASP.NET application. You want to connect the application to a Microsoft SQL Server Express 2008
database named MyDatabase. The primary database file is named MyDatabase.mdf and it is stored
in the App_Data folder. You need to define the connection string. Which connection string should
you add to the Web.config file?
You need to ensure that when you deploy the Feature, a file named Form1.xsn is deployed to the Feature folder
You are developing a custom Feature by using Microsoft Visual Studio 2010. You need to ensure
that when you deploy the Feature, a file named Form1.xsn is deployed to the Feature folder. You
must achieve this goal by using the minimum amount of development effort. What should you do?
Which three actions should you take?
###BeginCaseStudy###
Case Study: 3
Mortgage Loan
Background
A company is developing a website that supports mortgage loan processing. You use the
Azure management portal to create a website. You initially configure the website to use the
Basic hosting plan. You register a custom domain for the website with a valid registrar.
Customers complete mortgage applications and upload supporting documents to the website.
A custom executable named FileProcessor.exe processes all of the information received. An
on-premises server that runs Windows Server hosts the executable.
You create a virtual hard disk (VHD) image of the on-premises server. You plan to use this
VHD to replace the on-premises server with a new virtual machine (VM) that is hosted in
Azure.
Business Requirements
Business stakeholders have identified the following requirements for the mortgage loan
processing website:
• The website must provide a secure mortgage application process for the customer.
• Business users must validate new versions of the website before you publish them to
the production site. You must be able to revert to the previous version easily when issues
arise.
• The website must remain available to users while new features and bug fixes are
deployed.
• Network traffic must be monitored on all ports that the website uses.
Technical Requirements
General:
• You must develop the website by using Microsoft Visual Studio 2013.
• The website must be stateless. Subsequent requests from a user might or might not be
routed back to the website instance that the user initially connected to.
Security:
You must secure the custom domain and all subdomains by using SSL.
Storage:
• The custom executable must use native file system APIs to share data between
different parts of the website.
• The custom executable must continue to use a network file share to access files.
Monitoring:
The website must use port 6000 with UDP to submit information to another process. This
port must be actively monitored by using the same external port number.
Deployment:
• You must deploy the VM and the associated VHD. You will need to move this VM to
a different Azure subscription after deployment.
• You must establish a continuous deployment process that uses staged publishing.
• The custom domain must handle requests for multiple subdomains.
• The custom domain must use a www CNAME record that points to the domain’s @ A
record.
• The custom executable must run continuously and must be deployed as an Azure web
job named FileProcessor
• Application Request Routing (ARRJ affinity must be disabled for the website.
Solution Structure
The solution structure for the website is shown in the following exhibit.
###EndCaseStudy###
You need to debug the website remotely.
Which three actions should you take? Each correct answer presents part of the solution.
Which technology should you use?
You are designing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. The application is used mostly in a disconnected scenario. The
application requires offline data from a Microsoft SQL Server 2008 database. When the
application connects to the network, data will be modified and synchronized. You need to
ensure that the application does not access the database server directly to synchronize data
when online. Which technology should you use?
Which code segment should you insert at line 04?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line
numbers are included for reference only.)
01 AdventureWorks Entities context = new AdventureWorksEntities (
02 ” http://localhost:1234/AdventureWorks.svc “
03 );
04
05 var q = from c in context.Customers
06 where c.City == “London”
07 orderby c.CompanyName
08 select c;
You need to ensure that the application meets the following requirements:
• Compares the current values of unmodified properties with values returned from the data source.
• Marks the property as modified when the properties are not the same
Which code segment should you insert at line 04?
You need to move the VM
###BeginCaseStudy###
Case Study: 3
Mortgage Loan
Background
A company is developing a website that supports mortgage loan processing. You use the
Azure management portal to create a website. You initially configure the website to use the
Basic hosting plan. You register a custom domain for the website with a valid registrar.
Customers complete mortgage applications and upload supporting documents to the website.
A custom executable named FileProcessor.exe processes all of the information received. An
on-premises server that runs Windows Server hosts the executable.
You create a virtual hard disk (VHD) image of the on-premises server. You plan to use this
VHD to replace the on-premises server with a new virtual machine (VM) that is hosted in
Azure.
Business Requirements
Business stakeholders have identified the following requirements for the mortgage loan
processing website:
• The website must provide a secure mortgage application process for the customer.
• Business users must validate new versions of the website before you publish them to
the production site. You must be able to revert to the previous version easily when issues
arise.
• The website must remain available to users while new features and bug fixes are
deployed.
• Network traffic must be monitored on all ports that the website uses.
Technical Requirements
General:
• You must develop the website by using Microsoft Visual Studio 2013.
• The website must be stateless. Subsequent requests from a user might or might not be
routed back to the website instance that the user initially connected to.
Security:
You must secure the custom domain and all subdomains by using SSL.
Storage:
• The custom executable must use native file system APIs to share data between
different parts of the website.
• The custom executable must continue to use a network file share to access files.
Monitoring:
The website must use port 6000 with UDP to submit information to another process. This
port must be actively monitored by using the same external port number.
Deployment:
• You must deploy the VM and the associated VHD. You will need to move this VM to
a different Azure subscription after deployment.
• You must establish a continuous deployment process that uses staged publishing.
• The custom domain must handle requests for multiple subdomains.
• The custom domain must use a www CNAME record that points to the domain’s @ A
record.
• The custom executable must run continuously and must be deployed as an Azure web
job named FileProcessor
• Application Request Routing (ARRJ affinity must be disabled for the website.
Solution Structure
The solution structure for the website is shown in the following exhibit.
###EndCaseStudy###
You need to move the VM.
What should you do?
You need to view all inbound VPN packets
Your network contains a server named Server1 that runs Windows Server 2008 R2. Server1 has the
Routing and Remote Access service (RRAS) role service installed. You need to view all inbound VPN
packets. The solution must minimize the amount of data collected. What should you do?
Which line of code should you use?
You use Microsoft .NET Framework 4 to develop an application. The configuration file contains the
following code segment.
<configuration>
<connectionStrings>
<add name=”AdventureWorksLT”
connectionString=”Data Source=SQL01;
Initial Catalog=AdventureWorksLT;
Integrated Security=True;”
providerName=”System.Data.SqlClient”/>
</connectionStrings>
</configuration>
You need to retrieve the connection string named AdventureWorksLT from the configuration file.
Which line of code should you use?
Which two actions will achieve the goal?
###BeginCaseStudy###
Case Study: 3
Mortgage Loan
Background
A company is developing a website that supports mortgage loan processing. You use the
Azure management portal to create a website. You initially configure the website to use the
Basic hosting plan. You register a custom domain for the website with a valid registrar.
Customers complete mortgage applications and upload supporting documents to the website.
A custom executable named FileProcessor.exe processes all of the information received. An
on-premises server that runs Windows Server hosts the executable.
You create a virtual hard disk (VHD) image of the on-premises server. You plan to use this
VHD to replace the on-premises server with a new virtual machine (VM) that is hosted in
Azure.
Business Requirements
Business stakeholders have identified the following requirements for the mortgage loan
processing website:
• The website must provide a secure mortgage application process for the customer.
• Business users must validate new versions of the website before you publish them to
the production site. You must be able to revert to the previous version easily when issues
arise.
• The website must remain available to users while new features and bug fixes are
deployed.
• Network traffic must be monitored on all ports that the website uses.
Technical Requirements
General:
• You must develop the website by using Microsoft Visual Studio 2013.
• The website must be stateless. Subsequent requests from a user might or might not be
routed back to the website instance that the user initially connected to.
Security:
You must secure the custom domain and all subdomains by using SSL.
Storage:
• The custom executable must use native file system APIs to share data between
different parts of the website.
• The custom executable must continue to use a network file share to access files.
Monitoring:
The website must use port 6000 with UDP to submit information to another process. This
port must be actively monitored by using the same external port number.
Deployment:
• You must deploy the VM and the associated VHD. You will need to move this VM to
a different Azure subscription after deployment.
• You must establish a continuous deployment process that uses staged publishing.
• The custom domain must handle requests for multiple subdomains.
• The custom domain must use a www CNAME record that points to the domain’s @ A
record.
• The custom executable must run continuously and must be deployed as an Azure web
job named FileProcessor
• Application Request Routing (ARRJ affinity must be disabled for the website.
Solution Structure
The solution structure for the website is shown in the following exhibit.
###EndCaseStudy###
You need to configure session affinity for the website.
Which two actions will achieve the goal? Each correct answer presents a complete solution.
Which code segment should you use?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application
that connects to a Microsoft SQL Server 2008 database. The application includes a SqlConnection
named conn and a SqlCommand named cmd. You need to create a transaction so that database
changes will be reverted in the event that an exception is thrown. Which code segment should you
use?