Microsoft 070-523 Actual Free Exam Questions & Community Discussion

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses the following object query
to load a product from the database. (Line numbers are included for reference only.)
01using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities())
02{
03ObjectQuery <Product> productQuery = advWorksContext.Product.Where("it.ProductID = 900");
04
05}
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

You are creating a Windows Communication Foundation (WCF) service. You do not want to expose the internal implementation at the service layer. You need to expose the following class as a service named Arithmetic with an operation named Sum. public class Calculator {
public int Add(int x, int y)
{
}
}
Which code segment should you use?

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 application uses DataContexts to query the database. You create a function that meets the following requirements: "Updates the Customer table on the database when a customer is marked as deleted. "Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted. "Prevents consumer code from setting the Deleted column's value directly. You need to ensure that the function verifies that customers have no outstanding orders before they are marked as deleted. You also need to ensure that existing applications can use the update function without requiring changes in the code. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. The application stores encrypted credit card numbers in the database. You need to ensure that credit card numbers can be extracted from the database. Which cryptography provider should you use?

You are creating a Windows Communication Foundation (WCF) service to process orders.
The data contract for the order is defined as follows.
[DataContract]
public class Order {
[DataMember] public string CardHolderName { get; set; [DataMember]
public string CreditCardNumber { get; set; }
}
You have the following requirements:
"Enable the transmission of the contents of Order from the clients to the service.
"Ensure that the contents of CreditCardNumber are not sent across the network in clear text.
"Ensure that the contents of CreditCardNumber are accessible by the service to process the order.
You need to implement the service to meet these requirements.
What should you do?

You are creating an ASP.NET Web site. The site contains pages that are available to anonymous users.
The site also contains a page named Premium.aspx that provides premium content to only members of a
group named Subscribers.
You need to modify the web.config file to ensure that Premium.aspx can be accessed by only members of
the Subscribers group.
Which configuration should you use?

You are implementing an ASP.NET AJAX page that contains two div elements. You need to ensure that the
content of each div element can be refreshed individually, without requiring a page refresh.
What should you do?

You are testing an existing ASP.NET page. The page includes a text You are able to execute malicious JavaScript code by typing it in the text box and submitting. You need to configure the page to prevent JavaScript code from being submitted by the text box. In the @ Page directive, which attribute should you set to true?

You are building a client for a Windows Communication Foundation (WCF) service.
You need to create a proxy to consume this service.
Which class should you use?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use the ADO.NET Entity Data Model (EDM) to define a Customer entity. You need to add a new Customer to the data store without setting all the customer's properties. What should you do?