Online Access Free 070-516 Practice Test

How do you call a model-defined function as static method on a custom class?

• A.Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts ICollection argument and returns the results of the Execute method that is returned by the Provider property.
• B.Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts and returns the results of the Execute method that is returned by the Provider property.
• C.Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts IEntityWithRelationships argument and returns the results of the Execute method that is returned by the Provider property.
• D.Add a class to your application with a static method that does the following: Apply an EdmFunctionAttribute to the method and ensure it accepts an IQueryable argument and returns the results of the Execute method that is returned by the Provider property.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a stored procedure to insert a new record in the Categories table according to following code
segment.
CREATE PROCEDURE dbo.InsertCategory @CategoryName navrchar(15),
@Identity int OUT
AS INSERT INTO Categories(CategoryName) VALUES (@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You add the following code fragment. (Line numbers are included for reference only.)
01 private static void ReturnIdentity(string connectionString)
02 {
03 using(SqlConnection connection = new SqlConnection(connectionString))
04 {
05 SqlDataAdpater adapter = new SqlDataAdapter("SELECT CategoryID,
CategoryName FROM dbo.Categories", connection);
06 adapter.InsertCommand = new SqlCommand("InsertCategory", connection);
07 adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
08 SqlParameter rowcountParameter = adapter.InsertCommand.Parameters.Add
("@RowCount", SqlDbType.Int);
09 ...
10 adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.NChar,
15, "CategoryName");
11 SqlParameter identityParameter = adapter.InsertCommand.Parameters.Add
("@Identity", SqlDbType.Int, 0, "CategoryID");
12 ...
13 DataTable categories = new DataTable();
14 adapter.Fill(categories);
15 DataRow ctegoryRow = categories.NewRow();
16 categoryRow["CategoryName"] = "New beverages";
17 categories.Rows.Add(categoryRow);
18 adapter.Update(categories);
19 Int32 rowCount = (Int32)adapter.InsertCommand.Parameters
["@RowCount"].Value;
20 }
21 }
Which code elements needs to be added in the empty lines?

• A.Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.ReturnValue;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.Output;
• B.Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.ReturnValue;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.ReturnValue;
• C.Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.Output;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.Output;
• D.Insert the following code segment at line 09:
  rowcountParameter.Direction = ParameterDirection.Output;
  Insert the following code segment at line 12:
  identityParameter.Direction = ParameterDirection.ReturnValue;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. A file named books.xml contains the following XML.
<bib>
<book title="Programming in Unix" year="1992">
<author>Author1</author>
<author>Author2</author>
<author> Author 3 </author>
</book> </bib>
The application must generate an XML result that contains an XML element named BookTitle for each
book. The text content of the element must contain the title of the book.
You need to create a query that generates the new XML result. What should you do?

• A.XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XText("BookTitle" + node.ToString());
• B.XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle").Value = node.FirstAttribute.Value;
• C.XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle", node.FirstAttribute.Value);
• D.XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XElement("BookTitle", node.ToString());

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Data Model for the fallowing database tables.

You need to ensure that the entity that is mapped to the ContectTypeDerived table derives from the entity that is mapped to the ContentTypeBase table. What should you do?

• A.Create a complect type for each entity.
• B.Use a Table-Per-Hierarchy mapping method.
• C.Create a function import for each entity.
• D.Use a Table-Per-Type mapping method.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

• A.using (SchoolEntities context = new SchoolEntities())
  {
  var id = context.InsertDepartment("Department 1", null);
  Console.WriteLine(id);
  }
• B.using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", null));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• C.using (SchoolEntities context = new SchoolEntities())
  {
  ObjectParameter id = null;
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• D.using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", typeof(int));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }