70-516 Exam Questions

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database and contains a LINQ to S...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. You use the ADO.NET Ent...

You develop a Microsoft .NET application that uses Entity Framework to store entities in a Microsft SQL Server 2008 database. While the application is disconnected from the databas...

You use Microsoft .NET framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database named AdventureWorksLT. The database resides on an instance nam...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. The application uses th...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You are creating the data layer of the application. You write the following code seg...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework. The application has an entity model that includes Sa...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You add the follow...

The Entity Data Model file (.edmx file) must be updated to support inheritance mapping for Products and Componets. You need to add the following code to the \Model\Model.edmx file:...

A performance issue exists in the application. The following code segment is causing a performance bottleneck: var colors = context.Parts.GetColors(); You need to improve applicati...

The application must be configured to run on a new development computer. You need to configure the connection string to point to the existing named instance. Which connection strin...

You have an existing ContosoEntities context object named context. Calling the SaveChanges() method on the context object generates an exception that has the following inner except...

Refer to the following lines in the case study: PA40 in \Model\Part.cs, PR16 in\Model\Product.cs, and CT14 in \Model\Component.cs The application must create XML files that detail...

You need to ensure that an exception is thrown when color names are set to less than two characters. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses the Entity Framework. The appl cat on has an entity model that contains a Sa...

You are developing a Microsoft .NET Framework 4 application. You need to collect performance data to the event log after the application is deployed to the production environment....

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You create a stored procedure to insert a new record in the Categories table according...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You create a Database Access Layer (DAL) that is database-independent. The DAL include...

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. The database include...

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database. CREATE TABLE Object...

Ensure that SSDL can be modified without rebuilding application.

You use Microsoft .NET Framework 4 to develop an application. You write the following code to update data in a Microsoft SQL Server 2008 database. (Line numbers are included for re...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. You add the following code segment. (L...

The application UI displays a list of products in alphabetical order. To display each product, the UI requires the va of the product Id field and the product Name field. You need t...

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 mod...

The database contains orphaned Color records that are no longer connected to Part records. You need to clean up the orphaned records. You have an existing ContosoEntities context o...

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 create classes b...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application that uses LINQ to SQL. The application contains the following model. Each region conta...

You are developing a new feature that displays an auto-complete list to users as they type color names. You have an existing ContosoEntities context object named context. To suppor...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You create a stored procedure to insert a new record in the Categories table according...

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 following SQL...

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...

The application must provide a component part list for any product. The component part list must give the quantity of each distinct part that is required to manufacture that produc...

You have a LINQ to SQL model. You create an entity named Employee by dragging a table from Server Explorer to a design surface named MyStore.dbml. You need to identify the class de...

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following stored procedure to the database. CREATE P...

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The apphcation connects to a Microsoft SQL Server database. The application stores use...

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following stored procedure to the database. CREATE P...

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 create the classes sh...

You have a database named DB1 that contains a table named Customers. You declare a DataSet named customersDataSet. You need to ensure that customersDataSet contains all of the reco...

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 load records from a t...

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 create a DataSet obje...

You are creating a Microsoft .NET Framework 4 application that will access data from an Oracle database named DB1. DB1 is located on a server named DBSVR. The Oracle instance requi...

You use Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. The application contains an Entity Framework model that ha...

You are developing a Microsoft .NET Framework 4 application. You need to collect performance data to the event log after the application is deployed to the production environment....

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 have a stored procedu...

The application must provide a component part list for any product. The component part lis must give the quantity of each distinct part that is required to manufacture that product...

You use Microsoft .NET Framework 4 to create a data access layer component. The component will use an existing conceptual data model named Modell. Modell does not have an underlyin...

You use Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. The application contains an Entity Framework model that ha...

You have a database named DB1 that contains a table named Customers. You declare a DataSet named customersDataSet. You need to ensure that customersDataSet contains all of the reco...

You use Microsoft Visual Studio 2010 and Microsoft NET Framework 4 to create an application. The application contains the following XML fragment. <ApplicationMenu> <Menultem name'F...