Which data access technology should you use?
You are designing a Windows application by using Microsoft .NET Framework 4, Microsoft
Visual Studio 2010, and Microsoft SQL Server 2008. You need to design a data access
strategy that meets the following requirements: Automatically tracks changes Maps the
database data model to the object model Which data access technology should you use?
What are two possible code segments that you can use to achieve this goal?
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities. The application includes selftracking entities as shown in the following diagram.
There is a Person entity named person1 that has Track Changes turned on. You need to delete all email addresses that are associated with person1 by using an ObjectContext named context. What
are two possible code segments that you can use to achieve this goal? (Each correct answer presents
a complete solution. Choose two).
Which approach should you recommend?
You are designing an internal Web application. You have the following requirements: Use
an existing data layer built on the Entity Framework Ensure that additional Entity Framework
entities can be supported without additional coding. You need to design the Web application
so that users can add, edit, and delete data. Which approach should you recommend?
Which size should you specify for the VM?
###BeginCaseStudy###
Case Study: 4
File Tax-Related Document
Background
You are developing an Azure solution that individuals and small businesses will use to
prepare and file tax-related documents.
Business Requirements
General
The solution must provide a way for customers to enter personal and demographic
information. Customers must be able to upload income documents and related documents to
the solution. The solution must provide reports and summary documents for customers in
PDF format.
Scope and Device Accessibility
The solution must support two operational modes: On-Peak and Off-Peak. On-Peak is
defined as the first quarter of a year. Off-Peak is defined as the other three quarters of a year.
Customers must be able to access the solution by using desktop computers, laptop computers,
mobile devices, and tablets.
High Availability and Business Continuity
The solution must be available at all times. When the solution transitions between Off-Peak
mode and On-Peak mode, solution availability must not be affected. Disaster recovery must
be established for the customers’ stored data.
Diagnostics
The solution must log relevant diagnostic data that can be used to troubleshoot the cloud
service.
Scalability
The solution must scale out while transitioning from Off-Peak mode to On-Peak mode.
Cost
The solution must use cloud resources optimally to minimize operating costs.
Storage and Security
The solution must be secure to prevent any anonymous access (including read access) to the
customers’ tax documents.
Cross-Premises Networking
The solution must extend the developers’ on-premises network into Azure.
Technical Requirements
The logical design for the solution is shown in the following exhibit.
Platform-as-a-Service (PaaS)
The solution must have two roles: a web role and worker role. The web interface of the
solution uses a web role to accept and send user input and any related documents. The worker
role must access the stored data and prepare the tax documents in the background.
Compute
The solution must support a minimum of 10 role instances. When the solution is in On-Peak
mode, each role instance must be allocated at least 6 GB of memory. The memory can be
scaled down to 3 GB when the solution is in Off-Peak mode.
The solution must cache documents locally. The cache does not need to be refreshed during
the lifecycle of the worker role.
Role instances that are running should not be affected by topology changes such as an
increase in instance count.
Storage
The web role must store documents in blob storage. A SQL database is used to store
customer information. The worker role must use queues to process the final tax documents.
Performance and Scalability
When the solution is in Off-Peak mode, it must support at least 150 concurrent database
sessions, and the maximum size of the database is 50 GB. When the solution is in On-Peak
mode, it must support 750 concurrent database sessions, and the maximum size of the
database is 300 GB. Geo-replication must be enabled and must be configurable by using the
Azure management portal.
Software Prerequisites
The solution must install the software that is necessary to generate PDF documents on the
server. The software will be provided as a Windows Installer package.
Debugging
Solution errors and warnings that occur in a web role must be logged. The worker role must
log any crash dump files. Detailed information about errors and their context must be
collected so that the environment in which errors occurred can be simulated locally.
Security
At the time that a customer’s tax information and documents are accepted, the solution must
send an email to the customer. The email contains a secure hyperlink that the customer can
use to upload any additional necessary documents. The customer is asked to upload these
documents within 48 hours. If the customer does not upload the documents within 48 hours,
the solution should not issue a new hyperlink. The solution must send an email to the
customer to remind the customer to use the original hyperlink to upload any additional
necessary documents.
Network Services
The solution must use a cross-premises secure network. The network must be configurable by
using the Azuremanagement portal.
Social Structure
Relevant portions of the solution files are shown in the following code segments. Line
numbers in the code segments are included for reference only and include a two-character
prefix that denotes the specific file to which they belong.
###EndCaseStudy###
You need to configure role instances.
Which size should you specify for the VM?
You need to associate the Order entity with the Customer entity
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application uses the ADO.NET Entity Framework to manage customer and related order records. You
add a new order for an existing customer. You need to associate the Order entity with the Customer
entity. What should you do?
Which SQL Database configuration should you use?
###BeginCaseStudy###
Case Study: 4
File Tax-Related Document
Background
You are developing an Azure solution that individuals and small businesses will use to
prepare and file tax-related documents.
Business Requirements
General
The solution must provide a way for customers to enter personal and demographic
information. Customers must be able to upload income documents and related documents to
the solution. The solution must provide reports and summary documents for customers in
PDF format.
Scope and Device Accessibility
The solution must support two operational modes: On-Peak and Off-Peak. On-Peak is
defined as the first quarter of a year. Off-Peak is defined as the other three quarters of a year.
Customers must be able to access the solution by using desktop computers, laptop computers,
mobile devices, and tablets.
High Availability and Business Continuity
The solution must be available at all times. When the solution transitions between Off-Peak
mode and On-Peak mode, solution availability must not be affected. Disaster recovery must
be established for the customers’ stored data.
Diagnostics
The solution must log relevant diagnostic data that can be used to troubleshoot the cloud
service.
Scalability
The solution must scale out while transitioning from Off-Peak mode to On-Peak mode.
Cost
The solution must use cloud resources optimally to minimize operating costs.
Storage and Security
The solution must be secure to prevent any anonymous access (including read access) to the
customers’ tax documents.
Cross-Premises Networking
The solution must extend the developers’ on-premises network into Azure.
Technical Requirements
The logical design for the solution is shown in the following exhibit.
Platform-as-a-Service (PaaS)
The solution must have two roles: a web role and worker role. The web interface of the
solution uses a web role to accept and send user input and any related documents. The worker
role must access the stored data and prepare the tax documents in the background.
Compute
The solution must support a minimum of 10 role instances. When the solution is in On-Peak
mode, each role instance must be allocated at least 6 GB of memory. The memory can be
scaled down to 3 GB when the solution is in Off-Peak mode.
The solution must cache documents locally. The cache does not need to be refreshed during
the lifecycle of the worker role.
Role instances that are running should not be affected by topology changes such as an
increase in instance count.
Storage
The web role must store documents in blob storage. A SQL database is used to store
customer information. The worker role must use queues to process the final tax documents.
Performance and Scalability
When the solution is in Off-Peak mode, it must support at least 150 concurrent database
sessions, and the maximum size of the database is 50 GB. When the solution is in On-Peak
mode, it must support 750 concurrent database sessions, and the maximum size of the
database is 300 GB. Geo-replication must be enabled and must be configurable by using the
Azure management portal.
Software Prerequisites
The solution must install the software that is necessary to generate PDF documents on the
server. The software will be provided as a Windows Installer package.
Debugging
Solution errors and warnings that occur in a web role must be logged. The worker role must
log any crash dump files. Detailed information about errors and their context must be
collected so that the environment in which errors occurred can be simulated locally.
Security
At the time that a customer’s tax information and documents are accepted, the solution must
send an email to the customer. The email contains a secure hyperlink that the customer can
use to upload any additional necessary documents. The customer is asked to upload these
documents within 48 hours. If the customer does not upload the documents within 48 hours,
the solution should not issue a new hyperlink. The solution must send an email to the
customer to remind the customer to use the original hyperlink to upload any additional
necessary documents.
Network Services
The solution must use a cross-premises secure network. The network must be configurable by
using the Azuremanagement portal.
Social Structure
Relevant portions of the solution files are shown in the following code segments. Line
numbers in the code segments are included for reference only and include a two-character
prefix that denotes the specific file to which they belong.
###EndCaseStudy###
You need to meet the performance and scalability requirements.
Which SQL Database configuration should you use?
Which approach should you recommend?
You are designing a SharePoint 2010 solution that stores employee information in a list
named Employees and company information in a list named Company. Each company has
one or more employees. You need to recommend that a developer add a new column so
that a one-to-many relationship is created between the Company list and Employees list.
Which approach should you recommend?
You need to ensure that the server can communicate with all segments on the IPv6 network
Your company has an IPv6 network that has 25 segments. You deploy a server on the IPv6 network.
You need to ensure that the server can communicate with all segments on the IPv6 network. What
should you do?
Which code segment should you use?
You use Microsoft .NET Framework 4 to develop an application that uses the Entity Framework. The
application has an entity model with a Person entity. A Person instance named person1 and an
ObjectContext instance named model exist. You need to delete the person1 instance. Which code
segment should you use?
You need to ensure that changes made to the WCF service data contract do not require the application to be rec
You are developing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. The application will consume a Windows Communication
Foundation (WCF) service. The WCF service will provide data to the application. You plan
to use the ADO.NET Entity Framework to create a data model that will be used by the
application. Another development team makes changes to the WCF service data contract.
You need to ensure that changes made to the WCF service data contract do not require the
application to be recompiled. What should you do?