You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.The application contains a DataSet object that has a table. The DataSet object is
as shown in the following exhibit.
You need to ensure that the application meets the following requirements without creating another table:
The DataSet can be extended by using the designer.
The application displays all product records.
The product records can be filtered by ProductID.
What should you do?

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework
version 3.5.You create a custom-templated server control.You need to ensure that the child
controls of the server control are uniquely identified within the control hierarchy of the page.
Which interface should you implement?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.The application contains a DataSet class. The DataSet class contains two tables
named Order and OrderDetail as shown in the following exhibit.OrderDetail as shown in the
following exhibit.
You add a DataColumn class named OrderTotal to the Order table.You need to ensure that
the OrderTotal column stores the sum of the values in the LineTotal column of the
OrderDetail table.Which expression string should you use to set the Expression property of
the OrderTotal column?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET. The application connects to a Microsoft SQL Server 2005 database. The
application contains the following objects:
A SqlDataReader object named reader
A SqlCommand object named cmdRecords
A SqlCommand object named cmdUpdate
A SqlConnection object named conn
The SqlConnection object has the following ConnectionString property.”Server=Prod;
Database=Wingtip; Integrated Security=SSPI”
The reader object is obtained from the cmdRecords object. The conn object is shared by the
cmdRecords and the cmdUpdate objects.You need to ensure that for each record in the
reader object, the application calls the ExecuteNonQuery method of the cmdUpdate object.
What should you do?

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework
version 3.5.The application has a Web form file named MovieReviews.aspx.The
MovieReviews.aspx file connects to a LinqDataSource DataSource named LinqDataSource1
that has a primary key named MovieID.The application has a DetailsView control named
DetailsView1. The MovieReviews.aspx file contains the following code fragment. (Line
numbers are included for reference only.)
01 <asp:DetailsView ID=”DetailsView1″ runat=”server”
02 DataSourceID=”LinqDataSource1″
03
04 />
05 <Fields>
06 <asp:BoundField DataField=”MovieID” HeaderText=”MovieID”
07 InsertVisible=”False”
08 ReadOnly=”True” SortExpression=”MovieID” />
09 <asp:BoundField DataField=”Title” HeaderText=”Title”
10 SortExpression=”Title” />
11 <asp:BoundField DataField=”Theater” HeaderText=”Theater”
12 SortExpression=”Theater” />
13 <asp:CommandField ShowDeleteButton=”false”
14 ShowEditButton=”True” ShowInsertButton=”True” />
15 </Fields>
16 </asp:DetailsView>
You need to ensure that the users can insert and update content in the DetailsView1 control.
You also need to prevent duplication of the link button controls for the Edit and New
operations. Which code segment should you insert at line 03?

You create a Microsoft ASP.NETWeb application by using the Microsoft .NET Framework
version 3.5.The application uses ASP.NET AJAX, and you plan to deploy it in a Web farm
environment.You need to configure SessionState for the application. Which code fragment
should you use?

You are creating a Windows Forms application by using the .NET Framework 3.5. You
create a new form in your application.You add 100 controls at run time in the Load event
handler of the form. Users report that the form takes a long time to get displayed.You need
to improve the performance of the form. What should you do?

You create a Microsoft ASP.NETWeb application by using the Microsoft .NET Framework
version 3.5.You plan to set up authentication for the Web application. The application must
support users from untrusted domains.You need to ensure that anonymous users cannot
access the application. Which code fragment should you add to the Web.config file?

You create a Microsoft ASP.NETWeb application by using the Microsoft .NET Framework
version 3.5.You use Windows Authentication for the application. You set up NTFS file
system permissions for the Sales group to access a particular file. You discover that all the
users are able to access the file. You need to ensure that only the Sales group users can
access the file.What additional step should you perform?

You create an application for an online store by using the Microsoft .NET Framework 3.5
and Microsoft ADO.NET.You write the following code segment. (Line numbers are
included for reference only.)
01 DataTable dtProducts = new DataTable();
02 dtProducts.Columns.Add(“ProductID”);
03 dtProducts.Columns.Add(“ProductName”);
04 dtProducts.Columns.Add(“CategoryID”);
05 dtProducts.Rows.Add(1, “Milk”, 1);
06 dtProducts.Rows.Add(2, “Beef”, 2);
07 dtProducts.Rows.Add(3, “Butter”, 1);
08 dtProducts.Rows.Add(4, “Sausage”, 2);
09 DataTable dtCategories = new DataTable();
10 dtCategories.Columns.Add(“CategoryID”);
11 dtCategories.Columns.Add(“CategoryName”);
12 dtCategories.Rows.Add(1, “Dairy products”);
13 dtCategories.Rows.Add(2, “Meat”);
14 var products = dtProducts.AsEnumerable();
15 var categories = dtCategories.AsEnumerable();
16
17 foreach (var element in result) {
18 Console.WriteLine(element);
19 }
When the dtProducts DataTable has the same value in the CategoryID column as the
dtCategories DataTable, the DataTables are related.You need to display for each product,
the product information and the product category. Which code segment should you insert at line 16?