The 70-516 exam has a reputation for tripping up even experienced professionals, and the 2026 blueprint is no gentler. TestSimulate breaks Microsoft TS: Accessing Data with Microsoft .NET Framework 4 down into 196 practice questions with verified answers, turning a formidable test into a series of manageable study sessions.

Microsoft 70-516 Exam Overview:

Microsoft 70-516 Exam Syllabus Topics:

Common Questions About the Microsoft 70-516 Exam

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

Question 1

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 database server by using SQL Server
authentication.
Which connection string should you use?

A. SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;
B. SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;
C. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;
D. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

Question 2

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 XML will not load external resources that are referenced in the XML.
Which code segment should you use?

A. XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; XmlReader reader = XmlReader.Create("data.xml", settings);
B. XmlReaderSettings settings = new XmlReaderSettings(); settings.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);
C. XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);
D. XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);

Question 3

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 user names and
passwords in the database.
You need to ensure that users cannot read passwords extracted from the database. What should you do?

A. Append a random salt to the password by using the RNGCryptoServiceProvider class. Encrypt stored passwords by using the RijndaelManaged class.
B. Encrypt stored passwords by using the TripleDESCryptoServiceProvider class.
C. Append a random salt to the password by using the RNGCryptoServiceProvider class. Hash stored passwords by using the SHA1CryptoServiceProvider class.
D. Encrypt stored passwords by using the RC2CryptoServiceProvider class.

Question 4

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 retrieve an entity, and you must ensure that the entity is loaded in a detached state.
Which MergeOption enumeration value should you use to retrieve the entity?

A. OverwriteChanges
B. NoTracking
C. AppendOnly
D. PreserveChanges

Question 5

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 INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

A. try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
...
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
{ .... }
......
}
}
B. try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope
(TransactionScopeOption.RequiresNew))
{ .... }
}
}
}
C. try
{ using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
...
}
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }
D. try
{
using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
{
....
try
{
.....
using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
{ .... }
}
}
}

Solutions: