Which code segment should you use?
You use Microsoft .NET Framework 4 to develop an application that uses LINQ to SQL. You create a
data model named AdvWorksDataContext, and you add the Product table to the data model. The
Product table contains a decimal column named ListPrice and a string column named Color. You
need to update the ListPrice column where the product color is Black or Red. Which code segment
should you use?
Which approach should you recommend?
You are designing a user input form that is part of an ASP.NET Web Forms application. You
need to ensure that users cannot attack the Web server by submitting invalid data. Which
approach should you recommend?
Which attribute should you set in the Web Part?
You create a custom Web Part. You need to ensure that a custom property is visible in Edit mode.
Which attribute should you set in the Web Part?
Which code segment should you insert at line 02?
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 a DataTable named
OrderDetailTable that has the following columns:
• ID
• OrderID
• ProductID
• Quantity
• LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the
following code segment. (Line numbers are included for reference only.)
01DataColumn column = new DataColumn(“UnitPrice”, typeof(double));
02
03OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object. You also
need to ensure that UnitPrice is set to 0 when it cannot be calculated. Which code segment should
you insert at line 02?
You need to ensure that after a resource failure, you can manage unresolved transactions
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application updates several Microsoft SQL Server databases within a single transaction. You need to
ensure that after a resource failure, you can manage unresolved transactions. What should you do?
Which technology should you use?
You are designing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. The application retrieves data from multiple heterogeneous
data sources. The retrieved data is aggregated into a single record set You need to ensure
that the application takes advantage of new multi-core server processors. Which technology
should you use?
You need to ensure that the database script that is created by using the Generate Database From Model option m
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application.
You use the Entity Framework Designer to create an Entity Data Model using model-first
development. The database has the following requirements:
• Each table must have a datetime column named time_modified.
• Each table requires a trigger that updates the value of the time_modified column when a
row is inserted or updated.
You need to ensure that the database script that is created by using the Generate Database From
Model option meets the requirements. What should you do?
You need to ensure that the Products Web Part sends Productid to the ProductDetails Web Part
You plan to create two Web Parts named Products and ProductDetails. You create an interface
that contains the following code segment. Public interface Interface1 { String ProductId { get; } }
You need to ensure that the Products Web Part sends Productid to the ProductDetails Web Part.
You must achieve this goal by using the ASP.NET Web Part connection framework. What should
you do?
Which command should you run on WKS1?
Your company has an IPv4 Ethernet network. A router named R1 connects your segment to the
Internet. A router named R2 joins your subnet with a segment named Private1. The Private1
segment has a network address of 10.128.4.0/26. Your computer named WKS1 requires access to
servers on the Private1 network. The WKS1 computer configuration is as shown in the following
table.
WKS1 is unable to connect to the Private1 network by using the current configuration. You need to
add a persistent route for the Private1 network to the routing table on WKS1. Which command
should you run on WKS1?
Which ObjectContext method should you call after changes are made to the entities?
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 use the ADO.NET Entity
Framework to model your entities. You use ADO.NET selftracking entities. You need to ensure that
the change-tracking information for the selttracking entities can be used to update the database.
Which ObjectContext method should you call after changes are made to the entities?