Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev - 070-523 FREE EXAM DUMPS QUESTIONS & ANSWERS

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 use Entity SQL of the ADO.NE Entity Framework to retrieve data from the database. You need to define a custom function in the conceptual model. You also need to ensure that the function calculates a value based on properties of the object. Which two XML element types should you use? (Each correct answer presents part of the solution. Choose two.)

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

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?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to several SQL Server databases. You create a function that modifies customer records that are stored in multiple databases. All updates for a given record are performed in a single transaction. You need to ensure that all transactions can be recovered. What should you do?

You are implementing an ASP.NET application. The application includes a Person class with property Age. You add a page in which you get a list of Person objects and display the objects in a GridView control. You need to add code so that the GridView row is highlighted in red if the age of the person is less than 18. Which GridView event should you handle?

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. You create classes by using LINQ to SQL based on the records shown in the exhibit. (Click the Exhibit button.) You need to create a LINQ query to retrieve a list of objects that contains the OrderID and CustomerID properties. You need to retrieve the total price amount of each Order record. What are two possible ways to achieve this goal (Each correct answer presents a complete solution. Choose two.)

You are implementing an ASP.NET page in an e-commerce application. Code in a btnAddToCart_Click
event handler adds a product to the shopping cart.
The page should check the status of the shopping cart and always show a cart icon when one or more
items are in the shopping cart. The page should hide the icon when the shopping cart has no items. You
need to add an event handler to implement this requirement.
Which event handler should you add?

You are designing an ASP.NET Web application for content management.
You have the following requirements:
*Support multiple languages.
*Support dynamic changes to site content.
*Provide the ability to add content to the site without making changes to files within the application directory.
You need to recommend the application's source for retrieving content.
Which source should you recommend?

You are designing an ASP.NET Web Forms application.
You have the following requirements:
*Make use of exclusive features in a newly released Web browser.
*Do not change existing code files.
You need to design the application to meet the requirements.
Which approach should you recommend?