Which code segment should you include in the helper method?
You have a helper method named CreateSiteColumn that contains the following code segment.
static void CreateSiteColumn ( SPWeb web, string columnName ) {} You need to add a new site
column of type Choice to a SharePoint site by using the helper method. Which code segment
should you include in the helper method?
You need to ensure that the following requirements are met: • The control is reusable in multiple forms
You are designing a Windows application by using Microsoft .NET Framework 4 and
Microsoft Visual Studio 2010. You plan to implement control caching to improve the loading
time of a control. It is not required to refresh the content of the control after the application
loads. The application will be compiled by using the .NET 4 client profile. You need to
ensure that the following requirements are met: • The control is reusable in multiple forms. •
Data in the control is cached when the application is loaded. What should you do?
Which two attributes should you add to the AppDb connection string entry in the Web.staging.config file?
You are designing the deployment strategy for an ASP.NET Web application. The database
configuration string varies depending on the target environment. You have the following
requirements: • Deploy the application by using Web Deploy. • Replace the connection
string named AppDb with appropriate value for each environment You need to recommend
an approach for updating the AppDb connection string when deploying the application to the
staging environment. Which two attributes should you add to the AppDb connection string
entry in the Web.staging.config file? (Each correct answer presents part of the solution.
Choose two.)
Which query expression should you use?
###BeginCaseStudy###
Case Study: 1
Background
You are updating an existing Microsoft .NET Framework 4 application that includes a data
layer built with ADO.NET Entity Framework 4. The application communicates with a
Microsoft SQL Server 2008 instance named INST01 on a server named SQL01. The
application stores data in a database named Contoso in the INST01 instance.
You need to update the existing technology and develop new functionality by using
Microsoft Visual Studio 2010.
Application and Database Storage
The application tracks bicycle parts as they pass through a factory. Parts are represented by
the abstract Part entity and its associated partial classes. Each part has a name stored in the
Name field and a unique identifier stored in the Id field.
Parts are either component s (represented by the Component class) such as chains, wheels,
and frames, or finished product s (represented by the Product class) such as completed
bicycles. The Component class and the Product class derive from the Part class and may
contain additional class-specific properties.
Parts may have a color (represented by the Color class), but not all parts have a color, Parts
may be composed of other parts, and those parts may in turn be composed of other parts ; any
p art represents a tree of the parts that are used to build it, The lowest level of the tree consists
of c omponents that do not contain other component s.
A p roduct is a p art that has been completed and is ready to leave the factory. A p roduct
typically consists of many c omponents (forming a tree of child p arts) but can also be
constructed by combining other p roducts and/or c omponents to form a bundled p roduct,
such as a bicycle and a helmet that are sold together.
C omponents and p roducts are stored in a database table named Parts by using a table-perhierarchy (TPH) mapping. Components have a null ProductType field and a non-null
PartType field. Products have a non-null ProductType field and a null PartType field.
The following diagram illustrates the complete Entity data model diagram (EDMX diagram),
The following graphic illustrates detail s of the Part-Color Association.
The following code segments show relevant portions of the files referenced by the case study
items. (Line numbers in the samples below are included for reference only and include a twocharacter prefix that denotes the specific file to which they belong.)
Extension Methods.vb
Model.edmx
Model/Color.vb
Model/Component.vb
ModelContosoEntities.vb
Model IName.vb
Model Part.vb
Model Product.vb
sp_FindObsolete
###EndCaseStudy###
You are developing a new feature in the application to display a list of all bundled products. You
need to write a LINQ query that will return a list of all bundled products. Which query expression
should you use?
You need to ensure that the DHCP server can respond to DHCP clients
Your network contains a DHCP server that is configured as shown in the exhibit. (Click the Exhibit
button.)
You need to ensure that the DHCP server can respond to DHCP clients. What should you do?
You need to provide a method named FormattedName() to format part names and color names throughout the applica
###BeginCaseStudy###
Case Study: 1
Background
You are updating an existing Microsoft .NET Framework 4 application that includes a data
layer built with ADO.NET Entity Framework 4. The application communicates with a
Microsoft SQL Server 2008 instance named INST01 on a server named SQL01. The
application stores data in a database named Contoso in the INST01 instance.
You need to update the existing technology and develop new functionality by using
Microsoft Visual Studio 2010.
Application and Database Storage
The application tracks bicycle parts as they pass through a factory. Parts are represented by
the abstract Part entity and its associated partial classes. Each part has a name stored in the
Name field and a unique identifier stored in the Id field.
Parts are either component s (represented by the Component class) such as chains, wheels,
and frames, or finished product s (represented by the Product class) such as completed
bicycles. The Component class and the Product class derive from the Part class and may
contain additional class-specific properties.
Parts may have a color (represented by the Color class), but not all parts have a color, Parts
may be composed of other parts, and those parts may in turn be composed of other parts ; any
p art represents a tree of the parts that are used to build it, The lowest level of the tree consists
of c omponents that do not contain other component s.
A p roduct is a p art that has been completed and is ready to leave the factory. A p roduct
typically consists of many c omponents (forming a tree of child p arts) but can also be
constructed by combining other p roducts and/or c omponents to form a bundled p roduct,
such as a bicycle and a helmet that are sold together.
C omponents and p roducts are stored in a database table named Parts by using a table-perhierarchy (TPH) mapping. Components have a null ProductType field and a non-null
PartType field. Products have a non-null ProductType field and a null PartType field.
The following diagram illustrates the complete Entity data model diagram (EDMX diagram),
The following graphic illustrates detail s of the Part-Color Association.
The following code segments show relevant portions of the files referenced by the case study
items. (Line numbers in the samples below are included for reference only and include a twocharacter prefix that denotes the specific file to which they belong.)
Extension Methods.vb
Model.edmx
Model/Color.vb
Model/Component.vb
ModelContosoEntities.vb
Model IName.vb
Model Part.vb
Model Product.vb
sp_FindObsolete
###EndCaseStudy###
The application user interface displays part names or color names in many places as ‘## Name ##’.
You need to provide a method named FormattedName() to format part names and color names
throughout the application. What should you do?
What should you design?
You are designing an application by using Microsoft .NET Framework 4 and Microsoft
Visual Studio 2010. You plan to design an instrumentation strategy for the application. You
need to ensure that the strategy meets the following requirements: • Captures detailed
performance information. • Enables or disables diagnostic messages by using an
application configuration option without requiring the application to restart. What should you
design?
Which code segment should you use?
###BeginCaseStudy###
Case Study: 1
Background
You are updating an existing Microsoft .NET Framework 4 application that includes a data
layer built with ADO.NET Entity Framework 4. The application communicates with a
Microsoft SQL Server 2008 instance named INST01 on a server named SQL01. The
application stores data in a database named Contoso in the INST01 instance.
You need to update the existing technology and develop new functionality by using
Microsoft Visual Studio 2010.
Application and Database Storage
The application tracks bicycle parts as they pass through a factory. Parts are represented by
the abstract Part entity and its associated partial classes. Each part has a name stored in the
Name field and a unique identifier stored in the Id field.
Parts are either component s (represented by the Component class) such as chains, wheels,
and frames, or finished product s (represented by the Product class) such as completed
bicycles. The Component class and the Product class derive from the Part class and may
contain additional class-specific properties.
Parts may have a color (represented by the Color class), but not all parts have a color, Parts
may be composed of other parts, and those parts may in turn be composed of other parts ; any
p art represents a tree of the parts that are used to build it, The lowest level of the tree consists
of c omponents that do not contain other component s.
A p roduct is a p art that has been completed and is ready to leave the factory. A p roduct
typically consists of many c omponents (forming a tree of child p arts) but can also be
constructed by combining other p roducts and/or c omponents to form a bundled p roduct,
such as a bicycle and a helmet that are sold together.
C omponents and p roducts are stored in a database table named Parts by using a table-perhierarchy (TPH) mapping. Components have a null ProductType field and a non-null
PartType field. Products have a non-null ProductType field and a null PartType field.
The following diagram illustrates the complete Entity data model diagram (EDMX diagram),
The following graphic illustrates detail s of the Part-Color Association.
The following code segments show relevant portions of the files referenced by the case study
items. (Line numbers in the samples below are included for reference only and include a twocharacter prefix that denotes the specific file to which they belong.)
Extension Methods.vb
Model.edmx
Model/Color.vb
Model/Component.vb
ModelContosoEntities.vb
Model IName.vb
Model Part.vb
Model Product.vb
sp_FindObsolete
###EndCaseStudy###
A performance issue exists in the application. The following code segment is causing a performance
bottleneck:
Dim colors = context.Parts.GetColors()
You need to improve application performance by reducing the number of database calls.
Which code segment should you use?
Which code segment should you use?
You have a custom user profile property named MyProperty. You need to create a Web Part that
displays the value of MyProperty for the current user. Which code segment should you use?
You need to resolve the exception without negatively impacting the rest of the application
###BeginCaseStudy###
Case Study: 1
Background
You are updating an existing Microsoft .NET Framework 4 application that includes a data
layer built with ADO.NET Entity Framework 4. The application communicates with a
Microsoft SQL Server 2008 instance named INST01 on a server named SQL01. The
application stores data in a database named Contoso in the INST01 instance.
You need to update the existing technology and develop new functionality by using
Microsoft Visual Studio 2010.
Application and Database Storage
The application tracks bicycle parts as they pass through a factory. Parts are represented by
the abstract Part entity and its associated partial classes. Each part has a name stored in the
Name field and a unique identifier stored in the Id field.
Parts are either component s (represented by the Component class) such as chains, wheels,
and frames, or finished product s (represented by the Product class) such as completed
bicycles. The Component class and the Product class derive from the Part class and may
contain additional class-specific properties.
Parts may have a color (represented by the Color class), but not all parts have a color, Parts
may be composed of other parts, and those parts may in turn be composed of other parts ; any
p art represents a tree of the parts that are used to build it, The lowest level of the tree consists
of c omponents that do not contain other component s.
A p roduct is a p art that has been completed and is ready to leave the factory. A p roduct
typically consists of many c omponents (forming a tree of child p arts) but can also be
constructed by combining other p roducts and/or c omponents to form a bundled p roduct,
such as a bicycle and a helmet that are sold together.
C omponents and p roducts are stored in a database table named Parts by using a table-perhierarchy (TPH) mapping. Components have a null ProductType field and a non-null
PartType field. Products have a non-null ProductType field and a null PartType field.
The following diagram illustrates the complete Entity data model diagram (EDMX diagram),
The following graphic illustrates detail s of the Part-Color Association.
The following code segments show relevant portions of the files referenced by the case study
items. (Line numbers in the samples below are included for reference only and include a twocharacter prefix that denotes the specific file to which they belong.)
Extension Methods.vb
Model.edmx
Model/Color.vb
Model/Component.vb
ModelContosoEntities.vb
Model IName.vb
Model Part.vb
Model Product.vb
sp_FindObsolete
###EndCaseStudy###
You have a ContosoEntities context object named context and a Color object stored in a variable
named color.
You write the following code:
context.Colors.DeleteObject(color)
context.SaveChanges()
When the code runs, it generates the following exception:
System.Data.UpdateException:
An error occurred while updating the entries. See the inner exception for details. —>
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE
constraint “FK_PartColor”. The conflict occurred in database “Contoso”, table “dbo.Parts”, column
‘ColorId’.
You need to resolve the exception without negatively impacting the rest of the application.
What should you do?