You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. You create a DataSet object in the
application. You add two DataTable objects named App_Products and App_Categories to the
DataSet. You add the following code segment to populate the DataSet object. (Line numbers are
included for reference only.)
01 public void Fill(SqlConnection cnx, DataSet ds) {
03 var cmd = cnx.CreateCommand();
04 cmd.CommandText = “SELECT * FROM dbo.Products; ” + “SELECT * FROM dbo.Categories”;
05 var adapter = new SqlDataAdapter(cmd);
06
07 }
You need to ensure that App_Products and App_Categories are populated from the dbo.Products
and dbo. Categories database tables. Which code segment should you insert at line 06?

You use Microsoft Visual Studio 2010 and Microsoft NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server 2008 database. You need to ensure that the
application calls a stored procedure that accepts a table-valued parameter. You create a
SqlParameter object. What should you do next?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows
Communication Foundation (WCF) Data Services service. You deploy the service to the following
URL: http://contoso.com/ Northwind.svc. You want to query the WCF Data Services service to
retrieve a list of customer objects. You need to ensure that the query meets the following
requirements:
• “Only customers that match the following filter criteria are retrieved: City=”Seattle” AND Level >
200.
• “Data is sorted in ascending order by the ContactName and Address properties.
Which URL should you use for the query?