QUESTION NO:1
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 the ADO.NET LINQ to SQL model to retrieve data from the database.
The application contains the Category and Product entities, as shown 
in the following exhibit.
You need to ensure that LINQ to SQL executes only a single SQL 
statement against the database.
You also need to ensure that the query returns the list of categories 
and the list of products.
Which code segment should you use?
A.	using (NorthwindDataContext dc = new NorthwindDataContext())
{
dc.ObjectTrackingEnabled = false;
var categories = from c in dc.Categories select c;
For each (var category in categories)
{Console.WriteLine("{0} has {1} products", category.CategoryName, 
category.Products.Count);}
}
B.	using (NorthwindDataContext dc = new NorthwindDataContext()) {
dc.DeferredLoadingEnabled = false;
DataLoadOptions dIOptions = new DataLoadOptions();
dIOptions.LoadWith (c => c.Products); dc.LoadOptions = dIOptions;
var categories = from c in dc.Categories select c;
foreach (var category in categories)
{Console.WriteLine("{0} has {1} products", category.CategoryName, 
category.Products.Count);
}}
C.	using (NorthwindDataContext dc = new NorthwindDataContext()) {
dc.DeferredLoadingEnabled = false;
var categories = from c in dc.Categories select c; foreach 
(var category in categories)
{
Console.WriteLine("{0} has {1} products", 
category.CategoryName, category.Products.Count);}}
D.	using (NorthwindDataContext dc = new NorthwindDataContext()) {
dc.DeferredLoadingEnabled = false;
DataLoadOptions dIOptions = new DataLoadOptionsQ;

C.	using (NorthwindDataContext dc = new NorthwindDataContext()) {
dc.DeferredLoadingEnabled = false;
var categories = from c in dc.Categories select c; foreach 
(var category in categories)
{
Console.WriteLine("{0} has {1} products
", category.CategoryName, category.Products.Count);}}
D.	using (NorthwindDataContext dc = new NorthwindDataContext()) {
dc.DeferredLoadingEnabled = false;
DataLoadOptions dIOptions = new Datal_oadOptions(); 
dIOptions.AssociateWith (c => c.Products); 
dc.LoadOptions = dIOptions; 
var categories = from c in dc.Categories select c; 
foreach (var category in categories)
{
Console.WriteLine("{0} has {1} products", 
category.CategoryName, category.Products.Count);}}

Answer:B

QUESTION NO:2
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 the ADO.NET LINQ to SQL model to retrieve data from the 
database. The application contains the Category and Product 
entities, as shown in the following exhibit. You need to ensure 
that LINQ to SQL executes only a single SQL statement against 
the database. You also need to ensure that the query returns 
the list of categories and the list of products. Which code 
segment should you use?
A.	Using dc As New NorthwindDataContext() 
dc.ObjectTrackingEnabled = False
Dim categories As var = From c In dc.Categories _
Select c
For Each category As var In categories
Console.WriteLine("{0} has {1} products", category.CategoryName, 
category.Products.Count) Next
End Using
B.	Using dc As New NorthwindDataContext() 
dc.DeferredLoadingEnabled = False
Dim dIOptions As New DataLoadOptions()
dlOptions.LoadWith(Of CategoryXFunction(c As ) 
c.Products) dc.LoadOptions = dIOptions
Dim categories As var = From c In dc.Categories _ Select c
For Each category As var In categories
Console.WriteLine("{0} has {1} products", 
category.CategoryName, category.Products.Count) Next
End Using
C.	Using dc As New NorthwindDataContext() 
dc.DefferredLoadingEnabled = False
Dim categories As var = From c In dc.Categories _
Select c
For Each category As var In categories
Console.WriteLine("{0} has {1} products", 
category.CategoryName, category.Products.Count) Next
End Using
D.	Using dc As New NorthwindDataContext() 
dc.DeferredLoadingEnabled = False
Dim dIOptions As New Datal_oadOptions()
dlOptions.AssociateWith(Of Category)(Function(c As ) 
c.Products) dc.LoadOptions = dIOptions
Dim categories As var = From c In dc.Categories _
Select c
For Each category As var In categories
Console.Writel_ine("{0} has {1} products", 
category.CategoryName, category.Products.Count) Next
End Using
 
Answer:B

QUESTION NO:3
You use Microsoft Visual Studio 2010 and Microsoft .NET 
Framework 4 to create an application. The application 
uses the ADO.NET Entity Framework to model entities.
You define a Category class by writing the following 
code segment. (Line numbers are included for reference only.)
public class Category
{
public int CategorylD {get; set;}
public string CategoryName {get; set;}
public string Description {get; set;}
public byteQ Picture {get; set;}
}
You need to add a collection named Products to the 
Category class. You also need to ensure that the 
collection supports deferred loading.
Which code segment should you insert at line 07?
A.	public static List  Products {get; set;}
B.	public virtual List  Products {get; set;}
C.	public abstract List  Products {get; set;}
D.	protected List  Products {get; set;}
Answer:B

QUESTION NO:4
You use Microsoft Visual Studio 2010 and Microsoft .NET 
Framework 4 to create an application. The application 
uses the ADO.NET Entity Framework to model entities.
You define a Category class by writing the following 
code segment. (Line numbers are included for reference only.)
Public Class Category
Public Property CategorylD() As Integer
Get
End Get
Set
End Set
End Property
Public Property CategoryName() As String
Get
End Get
Set
End Set
End Property
Public Property Description() As String
Get
End Get
Set
End Set
End Property Public Property Picture() As Byte()
Get
End Get
Set
End Set
End Property
You need to add a collection named Products to the Category class. 
You also need to ensure that the collection supports deferred loading.
Which code segment should you insert at line 25?

A.	Public Shared Property Products() As List(Of Product) Get
End Get
Set
End Set End Property
B.	Public Overridable Property Products() As List(Of Product) Get
End Get
Set
End Set End Property
C.	Public MustOverride Property Products() As List(Of Product)
D.	Protected Property Products() As List(Of Product) Get
End Get
Set
End Set 
End Property
Answer:B
QUESTION NO:5
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 
to create an application. The application uses the ADO.NET Entity 
Framework to model entities. The model includes the entity shown 
in the following exhibit.
You need to add a function that returns the number of years since 
a person was hired. You also need to ensure that the function can 
be used within LINQ to Entities queries. What should you do?
A.	Add the following code fragment to the .edmx file.




Year(CurrentDateTimeO) - Year(date) 

Add the following function to the entity class definition.
[EdmFunction("SchoolModel", "YearsSinceNow")]
public static int YearsSinceNow(DateTime date)
{throw new NotSupportedException("Direct calls are not supported.");}
C.	Add the following code fragment to the .edmx file.



Add the following function to the entity class definition.
[EdmFunction("SchoolModel", "YearsSinceNow")]
public static int YearsSinceNow(DateTime date) {
return Year(CurrentDateTime()) - Year(date));}
D�� Use the Entity Data Model Designer to create a complex property 
named YearsSinceNow that can be accessed through the LINQ to Entities query at a later time.
 
Answer:B

QUESTION NO:6
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 
4 to create an application. The application uses the ADO.NET Entity 
Framework to model entities.
The model includes the entity shown in the following exhibit.
You need to add a function that returns the number of years since 
a person was hired. You also need to ensure that the function 
can be used within LINQ to Entities queries.
What should you do?
A.	Add the following code fragment to the .edmx file.



Year(CurrentDateTime()) - Year(date) 

Add the following function to the entity class definition.
 _
Public Shared Function YearsSinceNow([date] As DateTime) As 
Integer Throw New NotSupportedException
("Direct calls are not supported")
End Function
B.	Add the following code fragment to the .edmx file.



Year(CurrentDateTime()) - Year(date) 

Add the following function to the entity class definition.
 _
Public Shared Function YearsSinceNow([date]As DateTime) As 
Integer Throw New NotSupportedException("Direct calls are not supported.")
End Function
C.	Add the following code fragment to the edmx file.



Add the following function to the entity class definition.
 _
Public Shared Function YearsSinceNow([date] As DateTime) 
As Integer Return Year(CurrentDateTime() - Year([date]))
End Function
D.	Use the Entity Data Model Designer to create a 
complex property named YearsSinceNow that can be accessed 
through the LINQ to Entities query at a later time.

Answer: B

QUESTION NO:7
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 
4 to create an application. You use Plain Old CLR objects (POCO)
 to model your entities. The application communicates with a 
Windows Communication Foundation (WCF) Data Services service. 
You need to ensure that entities can be sent to the service as XML. What should you do?
A.	Apply the virtual keyword to the entity properties.
B.	Apply the [Serializable] attribute to the entities.
C.	Apply the [DataContract(lsReference = true)] attribute to the entities.
D.	Apply the [DataContract(lsReference = false)] attribute to the entities.
Answer:C

QUESTION NO:8
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 
to create an application. The application uses the ADO.NET Entity
 Framework to manage Plain Old CLR Objects (POCO) entities.
You create a new POCO class.
You need to ensure that the class meets the following requirements:
"It can be used by an ObjectContext.
"It is enabled for change-tracking proxies.
Which two actions should you perform? (Each correct answer presents 
part of the solution. Choose two.)
A.	Modify each mapped property to contain sealed and protected accessors.
B.	Modify each mapped property to contain non-sealed, public, 
and virtual accessors.
C.	Configure the navigation property to return a type that 
implements the ICollection interface.
D.	Configure the navigation property to return a type that 
implements the IQueryable interface.
E.	Configure the navigation property to return a type that 
implements the lEntityWithRelationships interface.
Answer:BC

QUESTION NO:9
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 
4 to create an application. The application uses the ADO.NET Entity 
Framework to model entities. You need to create a database 
from your model. What should you do?
A.	Run the edmgen.exe tool in FullGeneration mode.
B.	Run the edmgen.exe tool in FromSSDLGeneration mode.
C.	Use the Update Model Wizard in Visual Studio.
D.	Use the Generate Database Wizard in Visual Studio. 
Run the resulting script against a Microsoft SQL Server database.
Answer: D

QUESTION NO: 10
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 Data Definition Language (DDL) script of the database 
contains the following code segment.
CREATE TABLE [Sales].[SalesOrderHeader](
[SalesOrderlD] [int] IDENTITY(1,1) NOT NULL,
[BillToAddressID] [int] NOT NULL,
... CONSTRAINT [PK_SalesOrderHeader_SalesOrderlD]
PRIMARY KEY CLUSTERED ([SalesOrderlD] ASC)
) ALTER TABLE [Sales].[SalesOrderHeader]
WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address]
FOREIGN KEY([BillToAddresslD])
REFERENCES [Person].[Address] ([AddressID])
You create an ADO.NET Entity Framework model.
You need to ensure that the entities of the model correctly 
map to the DDL of the database.
What should your model contain?
 
Answer: The First pictures