You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server
2008 database.
You add the following stored procedure to the database.
CREATE PROCEDURE [dbo].[InsertTag] @Name nvarchar (15)
AS INSERT INTO [dbo].[Tags] (Name) VALUES(@Name) RETURN @@ROWCOUNT
You need to invoke the stored procedure by using an open SqlConnection named conn. Which code segment should you use?

• A. SqlCommand cmd = new SqlCommand("EXEC InsertTag", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• B. SqlCommand cmd = new SqlCommand("EXEC InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• C. SqlCommand cmd = new SqlCommand("InsertTag", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• D. SqlCommand cmd = new SqlCommand("InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();

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 ensure that the model and mapping files are not deployed as application resources. What
should you do?

• A. Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.
• B. Set the value of the .edmx file's Build Action property to Copy to Output.
• C. Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.
• D. Modify the connection string in the application's .config file to refer to the absolute physical path to the .edmx file.

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 the Customers table
into a DataSet object named dataset.
You need to retrieve the value of the City field from the first and last records in the Customers table.
Which code segment should you use?

• A. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• B. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count]["City"].ToString();
• C. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• D. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count - 1]["City"].ToString();

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 a connection string.
Which of the following is the correct connection string?

• A. string connectionString = ConfigurationManager.AppSettings["connectionString"];
• B. string connectionString = ConfigurationManager.ConnectionStrings ["connectionString"].ConnectionString;
• C. string connectionString = ConfigurationSettings.AppSettings["connectionString"];
• D. string connectionString = ApplicationManager.ConnectionStrings["connectionString"];