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("InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();
• B. SqlCommand cmd = new SqlCommand("EXEC InsertTag", conn); cmd.CommandType = CommandType.Text; 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("EXEC InsertTag", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", "New Tag 1"); cmd.ExecuteNonQuery();

Explanation: Only visible for Exam4PDF members. You can sign-up / login (it's free).

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 associate a previously deserialized entity named person1 to an object context named model
and persist changes to the database.
Which code segment should you use?

• A. model.People.ApplyChanges(person1) ; model.SaveChanges();
• B. person1.AcceptChanges(); model.SaveChanges();
• C. model.People.Attach(person1); model.SaveChanges();
• D. model.AttachTo("People", person1); model.SaveChanges();

Explanation: Only visible for Exam4PDF members. You can sign-up / login (it's free).

The Entity Data Model file (.edmx file) must be updated to support inheritance mapping for Products and Componets.
You need to add the following code to the \Model\Model.edmx file:
-the code in line EX243 that maps the Product type
-the code in line EX250 that maps the Component type
What should you do?

• A. Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="false" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="false" />
• B. Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="true" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="true" />
• C. Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="false" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="true" />
• D. Insert the following code at line EX243:
  <Condition ColumnName="ProductType" IsNull="true" />
  Insert the following code at line EX250:
  <Condition ColumnName="PartType" IsNull="false" />

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 uses a Microsoft
ADO.NET SQL Server managed provider.
When a connection fails, the application logs connection information, including the full connection string.
The information is stored as plain text in a .config file. You need to ensure that the database credentials are
secure.
Which connection string should you add to the .config file?

• A. Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=false;
• B. Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=true;
• C. Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=false;
• D. Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=true;

Explanation: Only visible for Exam4PDF members. You can sign-up / login (it's free).

The application populates a DataSet object by using a SqlDataAdapter object.
You use the DataSet object to update the Categories database table in the database. You write the
following code segment.
(Line numbers are included for reference only.)
01 SqlDataAdapter dataAdpater = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM Categories", connection);
02 SqlCommandBuilder builder = new SqlCommandBuilder(dataAdpater);
03 DataSet ds = new DataSet();
04 dataAdpater.Fill(ds);
05 foreach (DataRow categoryRow in ds.Tables[0].Rows)
06 {
07 if (string.Compare(categoryRow["CategoryName"].ToString(), searchValue,
true) == 0)
08 {
09 ...
10 }
11 }
12 dataAdpater.Update(ds);
You need to remove all the records from the Categories database table that match the value of the
searchValue variable.
Which line of code should you insert at line 09?

• A. categoryRow.Delete();
• B. ds.Tables[0].Rows.Remove(categoryRow);
• C. ds.Tables[0].Rows[categoryRow.GetHashCode()].Delete();
• D. ds.Tables[0].Rows.RemoveAt(0);

Explanation: Only visible for Exam4PDF members. You can sign-up / login (it's free).