70-516 Exam Questions
260 real 70-516 exam questions with expert-verified answers and explanations. Page 5 of 6.
- Question #204
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...
- Question #205
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...
- Question #206
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...
- Question #207
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...
- Question #208
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...
- Question #209
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...
- Question #210
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...
- Question #211
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...
- Question #212
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:...
- Question #213
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...
- Question #214
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...
- Question #215
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...
- Question #216
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...
- Question #217
You need to ensure that an exception is thrown when color names are set to less than two characters. What should you do?
- Question #219
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...
- Question #220
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....
- Question #221
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...
- Question #222
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...
- Question #223
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...
- Question #225
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...
- Question #227
Ensure that SSDL can be modified without rebuilding application.
- Question #228
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...
- Question #229
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...
- Question #230
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...
- Question #231
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...
- Question #233
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...
- Question #234
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...
- Question #235
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...
- Question #237
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...
- Question #238
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...
- Question #239
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...
- Question #240
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...
- Question #241
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...
- Question #242
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...
- Question #245
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...
- Question #246
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...
- Question #247
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...
- Question #250
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...
- Question #251
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...
- Question #252
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...
- Question #253
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...
- Question #255
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...
- Question #256
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...
- Question #257
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....
- Question #258
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...
- Question #259
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...
- Question #261
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...
- Question #262
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...
- Question #264
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...
- Question #266
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...