PrepAway - Latest Free Exam Questions & Answers

Category: 70-523

Exam 70-523: Upgrade: Transition your MCPD .NET Framework 3.5 Web Developer Skills to MCPD .NET Framework 4 Web Developer

Which code segment should you insert at line 11?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. You write the following code segment that executes two commands against the database within a transaction. (Line numbers are included for reference only.)

01using (SqlConnection connection = new SqlConnection(cnnStr)) {
02connection.Open();
03SqlTransaction sqlTran = connection.BeginTransaction();
04SqlCommand command = connection.CreateCommand();
05command.Transaction = sqlTran;
06try {
07command.CommandText = “INSERT INTO Production.ScrapReason(Name) VALUES(‘Wrong size’)”;
08command.ExecuteNonQuery();
09command.CommandText = “INSERT INTO Production.ScrapReason(Name) VALUES(‘Wrong color’)”;
10command.ExecuteNonQuery();
11
12}

You need to log error information if the transaction fails to commit or roll back.
Which code segment should you insert at line 11?

What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to model entities. The application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
Changes made to the local data store in disconnected mode are preserved.
Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data.
What should you do?

Which two approaches could you recommend?

You are designing an ASP.NET Web application by using Microsoft Visual Studio 2010. The Web application uses dynamic HTML (DHTML).
You need to ensure that the application functions properly on multiple browser platforms without requiring the installation of a client-side component.
Which two approaches could you recommend? (Each correct answer presents a complete solution. Choose two.)

Which two actions should you perform?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet Information Services (IIS) 6.0 server. You need to ensure that applications authenticate against user information stored in the database before the application is allowed to use the service. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to model entities. The application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
Changes made to the local data store in disconnected mode are preserved.
Entities that have already been loaded into the local data store, but have not been modified by the user, are updated with the latest data.
What should you do?


Page 6 of 14« First...45678...Last »