Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev : 70-523

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.)

• A. Configure IIS to require Windows authentication.
• B. Configure IIS to require basic authentication.
• C. Enable the WCF Authentication Service.
• D. Modify the Data Services service to use a Microsoft ASP.NET membership provider.
• E. Configure IIS to allow anonymous access.

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?

• A. Use the Attach method of the ObjectContext to add both Order and Customer entities.
• B. Set the Value property of the EntityReference of the Order entity.
• C. Call the Add method on the EntityCollection of the Order entity.
• D. Use the AddObject method of the ObjectContext to add both Order and Customer entities.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You
create stored procedures by using the following signatures:
"CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
"CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price float)
"CREATE procedure [dbo].[Product_Delete](@id int)
"CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
"CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp timestamp)
"CREATE procedure [dbo].[Order_Delete](@id int)
You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as
shown in the exhibit. You need to map the Product and Order entities to the stored procedures. Which two
procedures should you add to the @productId parameter? (Each correct answer presents part of the
solution. Choose two.)

• A. Order_Update
• B. Order_Delete
• C. Product_Update
• D. Product_Delete

You are creating a Windows Communication Foundation (WCF) service that accepts messages from
clients when they are started.
The message is defined as follows.
[MessageContract] public class Agent {
public string CodeName { get; set; }
http://www.test4pass.com Leading the way in IT Certification Exams
public string SecretHandshake { get; set; }
}
You have the following requirements:
"The CodeName property must be sent in clear text.
The service must be able to verify that the property value was not changed after being sent by the client.
"The SecretHandshake property must not be sent in clear text and must be readable by the service. What should you do?

• A. Add a MessageBodyMember attribute to the CodeName property and set the ProtectionLevel to Sign. Add a MessageBodyMember attribute to the SecretHandshake property and set the ProtectionLevel to EncryptAndSign.
• B. Add an ImmutableObject attribute to the CodeName property and set its value property to true. Add a Browsable attribute to the SecretHandshake property and set its value to false.
• C. Add a DataProtectionPermission attribute to the each property and set the ProtectData property to true.
• D. Add an XmlText attribute to the CodeName property and set the DataType property to Signed. Add a PasswordPropertyText attribute to the SecretHandshake property and set its value to true.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. The database includes a table named dbo. Documents that contains a column with large binary dat a. You are creating the Data Access Layer (DAL). You add the following code segment to query the dbo.Documents table. (Line numbers are included for reference only.)
01public void LoadDocuments(DbConnection cnx)
02{
03var cmd = cnx.CreateCommand();
04cmd.CommandText = "SELECT * FROM dbo.Documents";
05...
06cnx.Open();
08ReadDocument(reader); }
You need to ensure that data can be read as a stream. Which code segment should you insert at line 07?

• A. var reader = cmd.ExecuteReader(CommandBehavior.Default);
• B. var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
• C. var reader = cmd.ExecuteReader(CommandBehavior.KeyInfo);
• D. var reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);