Study with 070-523 most valid questions & verified answers

You are implementing an ASP.NET page. Client-side script requires data. Your application includes a class
named Person with a Name property of type string. The code-behind file of the page includes the following
code segment.
public string JsonValue;
List<Person> people = GetPeopleList();
JavaScriptSerializer json = new JavaScriptSerializer();
You need to use the JavaScriptSerializer class to serialize only the Name property of each item in the
people list.
Which code segment should you use?

• A. JsonValue = json.Serialize(people.SelectMany( p => Name.AsEnumerable())); var names = from person in people select person; JsonValue = json.Serialize(names);
• B. JsonValue = json.Serialize(people.Select(p => p.Name)); var names = from person in people select person; JsonValue = "{" + json.Serialize(names) + "}";

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

• A. Use the ASP.NET Ajax Library.
• B. Use Microsoft Silverlight.
• C. Use jQuery.
• D. Use Microsoft Visual Basic Scripting Edition (VBScript).

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?

• A. Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult <TElement> method to obtain an enumerator of the correct type.
• B. Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.
• C. Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.
• D. Apply the ParameterAttribute to the stored procedure function. Use the GetResult <TElement> method to obtain an enumerator of the correct type.

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_Delete
• B. Order_Update
• C. Product_Delete
• D. Product_Update

You are consuming a Windows Communication Foundation (WCF) service in an ASP.NET Web application. The service interface is defined as follows. [ServiceContract] public interface ICatalog {
[OperationContract]
[WebGet(UriTemplate = "/Catalog/Items/{id}",
ResponseFormat = WebMessageFormat.Json)]
string RetrieveItemDescription(int id); } The service is hosted at /Catalog.svc. You need to call the service using jQuery to retrieve the description of an item as indicated by a variable named itemId. Which code segment should you use?

• A. $.get(String.format("/Catalog.svc/Catalog/Items/{0}", itemId), null, function (data) {
  ...
  },
  "xml");
• B. $.get(String.format("/Catalog.svc/Catalog/Items/id={0}", itemId),
  null,
  function (data) {
  ...
  },
  "json");
• C. $.get(String.format("/Catalog.svc/Catalog/Items/{0}", itemId), null, function (data) {
  ...
  },
  "json");
• D. $.get(String.format("/Catalog.svc/Catalog/Items/?id={0}", itemId) null, function (data) {
  ...
  },
  "javascript");