TS: Accessing Data with Microsoft .NET Framework 4: 70-516 Exam Premium File as PDF & Test Engine

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that connects to a MS SQL server 2008 database by User Authentication. The application contains the following connection string:
SERVER=DBSERVER-01; DATABASE=pubs; uid=sa; pwd=secret;
You need to ensure that the password value in the connection string property of a SqlConnection object
does not exist after is called.
What should you add to the connection string?

• A. Trusted_Connection = False
• B. Persist Security Info = True
• C. Trusted_Connection = True
• D. Persist Security Info = False

How do you define a WCF Data Service query to grab the first 10 records. Options are something like:

• A. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$filter", "10");
• B. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$select", "10");
• C. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$expand", "10");
• D. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$top", "10");

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 named INSTA on a server named SQL01.
You need to configure the application to connect to the database. Which connection string should you add
to the .config file?

• A. Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;
• B. Data Source=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;
• C. Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;
• D. Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;

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 following store procedure
to the database.
CREATE PROCEDURE GetSalesPeople AS BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone FROM SalesPeople END
You write the following code segment. (Line numbers are included for reference only.)
01 SqlConnection connection = new SqlConnection("...");
02 SqlCommand command = new SqlCommand("GetSalesPeople", connection);
03 command.CommandType = CommandType.StoredProcedure;
04 ...
You need to retreive all of the results from the stored procedure. Which code segment should you insert at line 04?

• A. var res = command.ExecuteScalar();
• B. var res = command.ExecuteXmlReader();
• C. var res = command.ExecuteNonQuery();
• D. var res = command.ExecuteReader();