70-516 Exam Questions
260 real 70-516 exam questions with expert-verified answers and explanations. Page 4 of 6.
- Question #153
You are writing a WCF data service that will be included in a large project that has many other WCF data services. Your WCF data service will provide access to a SQL server using t...
- Question #154
What must you use to capture an exception that might occur when you are sending changes to the database server?
- Question #155
Which of the following are valid encryption algorithms that can be selected when encrypting the connection strings in your .config files? (Each correct answer presents a complete s...
- Question #156
Which of the following is a valid symmetric encryption algorithm?
- Question #157
You want to synchronize data between your local SQL Server Compact tables and SQL Server 2008. You want the synchronization to send changes to SQL Server 2008, and you want to rece...
- Question #158Manipulating and Validating Data
You are adding a process to the application. The process performs the following actions: 1. Opens a ContosoEntities context object named context1. 2. Loads a Part object into a var...
detached entityObjectContextdisconnected scenarioentity reattachment - Question #159
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 #160Querying Data
You are developing a new feature that displays an auto-complete list to users as the type color names. You have an existing ContosoEntities context object named contex. To support...
Entity SQLSQL injection preventionObjectParameterparameterized queries - Question #161
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 #162
You need to write a LINQ query that can be used against a ContosoEntities context object named context to find all parts that have a duplicate name. Which of the following queries...
- Question #163
You add a table to the database to track changes to part names. The table stores the following row values: - the username of the user who made the change a part ID - the new part n...
- Question #164
Drag and Drop Question The user interface requires that a paged view be displayed of all the products sorted in alphabetical order. The user interface supplies a current starting i...
- Question #165Querying Data
You are developing a new feature in the application to display a list of all bundled products. You need to write a LINQ query that will return a list of all bundled products. Which...
LINQ to EntitiesOfTypetype filteringinheritance - Question #166Implementing Data Access
You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The Product entity in the LINQ to SQL model contains a field named Productlmage. The Productlm...
LINQ to SQLdeferred loadingDelay Loadedbinary data - Question #167Querying Data
You use Microsoft .NET Framework 4.0 to develop an application that uses Entity Framework. The application includes the following Entity SQL (ESQL) query. SELECT VALUE product FROM...
Entity SQLpagingSKIPTOP - Question #168Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create the following Entity Data Model. Th...
Entity FrameworkT4 templatesEntityObject Generatorcode generation - Question #169Querying Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework. The application defines the following Entity Data Mo...
Entity SQLcustom functionsDefiningExpressionLINQ to Entities - Question #170
You use Microsoft .NET Framework 4.0 to develop an application. You write the following code to update data in a Microsoft SQL Server 2008 database. (Line numbers are included for...
- Question #171Deploying and Troubleshooting Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model (EDM). You nee...
Entity Frameworkdatabase generationEDMGenerate Database - Question #172Implementing Data Access
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You need to ensure that the application connects to the databa...
connection stringsSQL Server authenticationADO.NETsecurity - Question #173
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following stored procedure to the database. CREATE...
- Question #174Querying Data
You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework. The application defines the following Entity SQL (ESQL) query, which must be executed...
Entity SQLCreateQueryObjectContextparameterized queries - Question #175Implementing Data Access
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. The application uses nested transaction scopes. An inner trans...
TransactionScopenested transactionsRequiresNewSuppress - Question #176Implementing Data Access
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. The database inclu...
Entity Frameworktable-per-hierarchyinheritance mappingcondition mapping - Question #177Consuming and Exposing Data
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...
LINQ to SQLstored proceduresmultiple result setsResultTypeAttribute - Question #178Manipulating and Validating Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You create stored procedures by using the following signatures: CREATE procedure [db...
optimistic concurrencystored procedurestimestampLINQ to SQL - Question #179Consuming and Exposing Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use Plain Old CLR objects (POCO) to model your entities. The application communi...
WCF Data ServicesPOCODataContractXML serialization - Question #180Deploying and Troubleshooting Data Access
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. You need to cre...
Entity Frameworkdatabase generationGenerate Database Wizardedmgen.exe - Question #181Querying Data
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 Entity SQL of t...
Entity SQLcustom functionsDefiningExpressionconceptual model - Question #182Deploying and Troubleshooting Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You deploy a Windows Communication Foundation (WCF) Data Service to a production ser...
WCF Data Serviceserror handlingServiceBehaviorIIS deployment - Question #183Manipulating and Validating Data
The application populates a DataSet object by using a SqlDataAdapter object. You use the DataSet object to update the Categories database table in the database. You write the follo...
DataSetDataAdapterDataRow deletionrow state - Question #184Querying Data
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...
Entity Frameworknavigation propertiesLINQ to Entitiesentity relationships - Question #185Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following code segment. (Line numbers are included for...
connection poolingconnection lifecycleSqlConnectionADO.NET - Question #186Deploying and Troubleshooting Data Access
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. The application co...
Stopwatchperformance measurementSqlCommandtiming - Question #187Manipulating and Validating Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to two different Microsoft SQL Server 2008 database servers...
TransactionScopedistributed transactionsSqlConnectionMSDTC - Question #188
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 conceptual...
- Question #189Querying Data
You use Microsoft Visual Studio 2010 and Microsoft Entity Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. You use the ADO.NET L...
LINQ to SQLeager loadingDataLoadOptionssingle query - Question #190Implementing Data Access
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 must retrieve...
connection stringSqlConnectionconfiguration - Question #191Implementing Data Access
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. SQLConnection conn...
isolation levelsReadUncommittedSqlTransactiondirty reads - Question #192Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use the ADO.NET Entity Framework to model your entities. The application connect...
Entity FrameworkEDM connection stringembedded resourcesWindows Authentication - Question #194Deploying and Troubleshooting Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You create a Database Access Layer (DAL) that is database-independent. The DAL inclu...
DbExceptiondatabase-independent DALDbConnectionexception handling - Question #195Querying Data
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 contains a...
Entity FrameworkLINQorderingTake - Question #196
You use Microsoft .NET Framework 4.0 to develop an application that connects to two separate Microsoft SQL Server 2008 databases. The Customers database stores all the customer inf...
- Question #197Consuming and Exposing Data
You use Microsoft .NET Framework 4.0 to develop an application. You use the XmlReader class to load XML from a location that you do not control. You need to ensure that loading the...
XmlReaderXmlReaderSettingsexternal resourcessecurity - Question #198Querying Data
You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database. You add the following table to the database. CREATE TABLE Orde...
SqlDataReadertime typeTimeSpanSQL Server types - Question #199Manipulating and Validating Data
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. The model contains...
Entity Framework Designerstored procedure mappingSaveChangesentity update - Question #200Consuming and Exposing Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. You add the following code segment....
WCF Data Serviceslazy loadingLoadPropertyrelated entities - Question #201
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 load records from t...
- Question #202Manipulating and Validating Data
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 has two...
ForeignKeyConstraintDeleteRuleDataSetreferential integrity - Question #203Manipulating and Validating Data
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 a...
DataColumn expressioniif functioncomputed columnsnull handling