You are creating an ASP.NET application by using Microsoft .NET Framework 3.5.

The application is a library application that catalogs subjects and books. The application contains

“A Composite Solution With Just One Click” – Certification Guaranteed 45 Microsoft 70-564 Exam
a DataContext object named Subjects and a related line of business object named Books.

The Subjects DataContext object is queried by using the following LINQ query.

var query =
Iroro subject in Subjects
where ‘. ( subject.Books
.All(b => b.Price < = 25 && price >= 20))
select subject;

You need to find out the results that will be returned from the query.
What is the result of the query?

You are creating an ASP.NET application by using the .NET Framework 3.5.

Your application contains the following code segment. (Line numbers are included for reference only.)

01 DataTable table = new DataTable (“Produces”);

02 table.Columns.Add ( ” ProductName “, typeof (string));

03 . . .

04 table.Columns.Add (” UnitsInStock “, typeof ( int ));

05 DataSet ds – new DatoSet ();

06 ds.Tables.Add (table);

07 var productList = new[] {

08 new< ProductID = 1, ProductName = ” Chai “, Category = “Beverages”, UnitPrice – 18.0000M, UnitsInStock = 39>, new{ ProductID = 2, ProductName = “Chang”, Category = “Beverages”, UnitPrice = 19.0000M, UnitsInStock = 17), . . . )

09 foreach ( var x in productList ) {

10 table.Rows.Add (new object[]

11 { x.ProductID , x.ProductName , x.Category ,

12 x.UnitPrice , x.UnitsInStock ));

13 >

14 var products = ds.Tables [“Products”]. AsEnumerable ();

15 . . .

You need to return a list of 25 products that have a UnitsInStock value lower than 60. You also need to sort the list in ascending order by ProductName.

You need to return a list of 25 products that have a UnitsInStock value lower than 60. You also need to sort the list in ascending order by ProductName.

Which code fragment should you add at line 15?

You are creating ASP.NET applications by using the .NET Framework 3.5.

You plan to create a component that retrieves data from a Microsoft SQL Server database, a Microsoft Access database, or a variety of third-party databases.

The component must meet the following requirements:

Use minimum memory.

Prevent data from being updated or deleted.

Provide access to individual records as quickly as possible.

You need to design a data access strategy to meet the requirements.

Which data tier object should you use?

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application will reference a third-party component. The component might throw an unhandled exception from a background thread, causing the ASP.NET worker process to be terminated.

You need to ensure that any unhandled exceptions are logged before the application terminates.

What should you do?

You are creating ASP.NET applications by using the .NET Framework 3.5.

The application occasionally experiences errors that cannot be reproduced on a test environment.

You need to ensure that the application meets the following requirements:

– All unexpected errors are logged.
– Logging is configured with a minimum amount of modification to the application code.

What should you do?

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application will use multiple master pages.

Each master page will have an Image control named ImageControl1. ImageControl1 will be added directly to some master pages and through a user control to the other master pages.

You need to ensure that the content pages of the application can dynamically reference the image displayed by ImageControl1.

Which two actions should you perform? (Each correct answer presents part of the solution.
Choose two.)

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application uses the SiteMapPath control and a SiteMapProvider object.

The application contains a page named ViewArticle.aspx that displays an article. The article is retrieved from a Microsoft SQL Server 2008 database by using the Articleld value. The value is obtained as a QueryString parameter.

You need to ensure that the ViewArticle.aspx page can be used to view articles without constructing a SiteMapNode node for each article.

What should you do?

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application contains a reporting section. Pages for the reporting section are stored in the ~/Reports folder.

The Web pages in the ~/Reports folder use the same master page as pages that are not in the reporting section.

You need to modify the pages in the reporting section to meet the following requirements:

– The layout of the pages in the reporting section includes content areas that are not present on other pages in the site.
– The layout of the reporting section-specific content is visible in the Microsoft Visual Studio design mode.
– The pages in the reporting section reflects the changes if any layout changes are made to the site in future.

What should you do?

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application contains a theme named Theme1. Theme1 contains a cascading style sheet (CSS) file and skin definitions for several control types. Theme1 is specified in the themeattribute of the pages element in the Web.config file.

Several pages within the application use Calendar controls.

You need to implement a solution that meets the following requirements:

– Calendar controls are provided on four pages along with a format that differs from the Calendar skin defined in Theme1.
– The display of Calendar controls on other pages within the application is unaffected.

Which two actions should you perform? (Each correct answer presents a complete solution.
Choose two.)

You are creating an ASP.NET application by using the .NET Framework 3.5.

The application contains several ASP.NET pages that display news articles. Each ASP.NET page has server controls that display advertisements along with the article content.

You need to ensure that the printout does not include the advertisements when the user prints these pages by using the browser’s print menu command.

What should you do?