Free Microsoft 070-516 Exam Dumps Questions & Answers

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities.
You need to ensure that the entities are self-tracking. What should you do in the ADO.NET Entity
Framework Designer?

• A.Add an ADO.NET Self-Tracking Entity Generator to the model.
• B.Change the Transform Related Text Templates On Save option to False.
• C.Change the Code Generation Strategy option from Default to None.
• D.Add an ADO.NET EntityObject Generator to the model.

You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures
to return multiple result sets.
You need to ensure that the result sets are returned as strongly typed values. What should you do?

• A.Apply the ParameterAttribute to the stored procedure function. Use the GetResult<TElement> method to obtain an enumerator of the correct type.
• B.Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult<TElement> method to obtain an enumerator of the correct type.
• C.Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.
• D.Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
The application connects to a Microsoft SQL Server database.
You need to find out whether the application is explicitly closing or disposing SQL connections. Which code
segment should you use?

• A.string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• B.string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• C.string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• D.string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
-Changes made to the local data store in disconnected mode are preserved.
-Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data. What should you do?

• A.Call the query's Execute method by using the MergeOptions.AppendOnly option.
• B.Call the query's Execute method by using the MergeOptions.OverwriteChanges option.
• C.Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.
• D.Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The LINQ to SQL
model contains the Product entity.
A stored procedure named GetActiveProducts performs a query that returns the set of active products from
the database.
You need to invoke the stored procedure to return the active products, and you must ensure that the LINQ
to SQL context can track changes to these entities. What should you do?

• A.Add a property named GetActiveProducts to the Product entity.
• B.Select the Product entity, view the entity's property window, and change the Source for the entity to GetActiveProducts.
• C.Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.
• D.Select the Product entity, view the entity's property window, and change the Name for the entity to GetActiveProducts.