There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
PassGuideApp connects to a MS SQL Server database PassGuideDB.
To obtain data from PassGuideDB ADO.NET LINQ is used.
There is a function PassGuidef.

PassGuidef is defined with the ADO.NET LINQ entities conceptual model.
PassGuidef needs to be called.
What action do you need to take? Select two.

Signature exhibit:
”CREATE procedure [dbo].[Job_Insert](@employeeId ,int, @quality int)
”CREATE procedure [dbo].[Job_Update](@id int. @quality int, @originalTimestamptimestamp)
”CREATE procedure [dbo].[Job_Delete](@id int)
”CREATE procedure [dbo].[Employee_Insert](@name varchar(20).@salary float)
”CREATE procedure [dbo].[Employee_Update](@id int, @ id int, @name varchar(20),@salary
float)
”CREATE procedure [dbo].[Employee_Delete](@id int)
There is MS Visual Studio 2010 and MS .NET Framework 4 application PassGuideApp.
There is an MS ADO.NET EDM (Entity Data Model) for the Employee and Order tables.

There is 1 to many relation between the ID column in the Employee Table and the
EmployeeID column in the Job table. The Employee and Jobs entities might need to be
mapped to the stored procedures, being displayed in the signature exhibit.
To which, if any, procedures should this mapping be applied? Select all that applies.

You work as Web Developer in PassGuide.com. The company uses Microsoft .NET Framework 4
as its application development platform. You write a LINQ query that uses groupby operator. You
want to use the Include() method to eagerly load additional entities. What are the rules that should
be followed when using Include()?
Each correct answer represents a complete solution. Choose three.

You work as an Application Developer in PassGuide.com. The company uses Microsoft .NET

Framework 4. Which of the following modes will you use in EdmGen.exe command-line tool to
create a source code file that contains the views generated from the .csdl, .ssdl, and .msl files?

You work as a Web Developer in PassGuide.com. The company uses Microsoft .NET Framework
4 as its application development platform. You are using LINQ to SQL. You write the following
code segment:
public class Customer
{
public string Custid;
public string Name;
}
You want to designate the Customer class as an entity class that is associated with a database
table. Which of the following actions will you perform to accomplish the task?

You work as a Web developer in PassGuide.com. The company uses Microsoft .NET Framework

4. You want to designate a method as representing a stored procedure in LINQ to SQL attributebased mapping. Which of the following actions will you take to accomplish the task?

You work as a Web Developer in PassGuide.com. The company uses Microsoft .NET Framework
4 as its application development platform. You write a query that uses Include() method. However,
an ArgumentException is thrown by this method. What could be the reason for this exception?

You work as an Application Developer in PassGuide.com. The company uses Microsoft .NET
Framework 4. Which of the following Entity Data Model Tools will you use to generate a
conceptual model from an existing database?

You work as a Web Developer in PassGuide.com. The company uses Microsoft .NET Framework
4 as its application development platform. You generate an .edmx file using the Entity Data Model
Wizard.
Which of the following properties are conceptual model properties defined in the .edmx file? Each
correct answer represents a complete solution. Choose all that apply.

You work as Web Developer in PassGuide.com. The company uses Microsoft .NET Framework 4
as its application development platform. You are using plain old CLR objects and you want to
enable lazy loading. Which of the following actions you can take to accomplish the task?
Each correct answer represents a complete solution. Choose two.