70-516 Exam Questions
260 real 70-516 exam questions with expert-verified answers and explanations. Page 1 of 6.
- Question #1advanced WCF features
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You manually create your own Context class named AdventureWorksDB that inherits from...
ObjectContextExecuteFunctionstored procedureEntity Framework - Question #2define service contracts, data contracts, and message contracts
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 create an e...
Entity Frameworkentity trackingEDMXConcurrencyMode - Question #3
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. The service connects to a Microsoft...
- Question #4Consume WCF services
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. You discover that when an applicatio...
WCF Data ServicesX-HTTP-MethodPUT DELETE workaroundREST - Question #5advanced WCF features
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 create classes...
LINQ to SQLGroupJoinaggregationOrderID - Question #6advanced WCF features
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 following S...
LINQ to DataSetAsEnumerablenull filteringDataRow - Question #7advanced WCF features
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 to r...
Entity SQLEXISTS operatorcollection operatorsLINQ - Question #8advanced WCF features
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 to r...
Entity SQLquery plan cachingEntityCommandperformance - Question #9advanced WCF features
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 need to ensure...
table-valued parameterSqlDbType.StructuredSqlParameterstored procedure - Question #10advanced WCF features
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 need to use a...
spatial data typesSqlDbType.UdtSQL Server 2008SqlParameter - Question #11advanced WCF features
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML fragment: <ApplicationMenu> <MenuItem nam...
XPathdescendant axisattribute predicateXML navigation - Question #13Consuming 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 need to update the City property...
WCF Data ServicesHTTP MERGEpartial updateREST verbs - Question #14
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 us...
- Question #15Manipulating and Validating Data
You use Microsoft Visual Studio 2010 and the Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. The application use...
LINQ to SQLDataContextcascade deleteforeign key - Question #16Manipulating 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 Da...
DataContextSubmitChangesconflict detectionoptimistic concurrency - Question #17Manipulating and Validating Data
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a multi-tier application. You use Microsoft ADO.NET Entity Data Model (EDM) to model entities. The m...
Entity Frameworkdetached entitiesObjectContextApplyOriginalValues - Question #18Manipulating and Validating Data
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 manage customer and related ord...
Entity FrameworkEntityReferenceentity associationObjectContext - Question #19Implementing 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 database over the network. The ap...
DataSetdisconnected dataoffline storageADO.NET - Question #20Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use a TableAdapter object to load a DataTable object. The DataTable object is us...
TableAdapterClearBeforeFillincremental loadDataTable - Question #21Implementing 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 database. The application stores...
password hashingsaltRNGCryptoServiceProvidercredential security - Question #22Implementing 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 database. The application stores...
symmetric encryptionAEScryptographydata protection - Question #23Deploying and Troubleshooting Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET application. The application connects to a Microsoft SQL Server database. The ap...
SSLconnection securitydata transmissionencryption - Question #24
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...
- Question #25Manipulating and Validating Data
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 persistence-ignorant enti...
Entity Frameworkdisconnected modeObjectStateEntrySetModifiedProperty - Question #26
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 deploy an a...
- Question #27
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 ens...
- Question #28Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application updates several Microsoft SQL Server databases within a single trans...
distributed transactionstransaction recoveryReenlistTransactionManager - Question #29Implementing Data Access
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to several SQL Server databases. You create a function that...
distributed transactionsEnlistDurabledurable resourcetransaction management - Question #30Querying Data
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 model includ...
Entity Frameworkconceptual model functionLINQ to EntitiesEDM function - Question #31
Which class should you use to manage multiple tables and relationships among them?
- Question #32
You want to set up a primary key on a column. Which properties on the data column must be set? (Each correct answer presents part of a complete solution. Choose three.)
- Question #33
If you want to assign a Car object to a column called CarObject, which attribute must be on the Car class to enable saving the data table to a file?
- Question #34
You are storing custom Car objects in a data table that will be serialized to a file. After serializing to a binary file called cars.bin, you open the file with a binary editor and...
- Question #35
Which code segment will properly return the TimeSpan returned by the stopWatch variable?
- Question #36Manipulating and Validating Data
You are a tasked with performing a code review. The business rule is the following: - If INSERTs into the first table succeed, then INSERT into the second table. - However, if the...
TransactionScopenested transactionspartial rollbacksavepoint - Question #37Querying Data
Which method will return all nodes of an XDocument?
LINQ to XMLXDocumentDescendantNodesXML traversal - Question #38Implementing Data Access
Which one of these samples it the correct way to close the connection using Command Behavior?
SqlDataReaderCommandBehaviorconnection managementusing statement - Question #39
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...
- Question #40Querying Data
You have been assigned the task of writing code that executes an Entity SQL query that returns entity type objects that contain a property of a complex type. (Line numbers are incl...
Entity SQLEntityDataReadercomplex typeDbDataRecord - Question #41
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 create the classes...
- Question #42Querying Data
How do you call a model-defined function as static method on a custom class?
model-defined functionEdmFunction attributeLINQ to Entitiescustom class - Question #43
The database contains a table named Categories. The Categories table has a primary key identity column named CategoryID. The application inserts new records by using the following...
- Question #44Implementing 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 us...
connection stringPersist Security Infocredential securitySQL Server - Question #45Implementing Data Access
You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses Integrated Windows authentication. The application accesses data in a Microsoft SQL Ser...
cross-database querySqlCommandstored procedureWindows authentication - Question #46
You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to enhance and existing application use Entity Framework. The classes that represent the entites in the model are Plain...
- Question #47
You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application. You use entity Framework Designer to create an Entity Data Model from an existing database by...
- Question #48Implementing Data Access
You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Framewok. You need to execute custom logic when an entity is attached to...
Entity FrameworkObjectContextObjectStateManagerChangedentity lifecycle - Question #49
You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Data Model for the fallowing database tables. You need to ensure that the...
- Question #50Manipulating and Validating Data
You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application contains the...
SQL injectionparameterized queriesSqlCommandinput validation - Question #51
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Communication Foundation (WCF) Data Services service. WCF Data Services uses an authentica...