Try Microsoft : 70-516 valid & accurate questions and answers

Microsoft 70-516 Exam Overview:

Microsoft 70-516 Exam Syllabus Topics:

Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.
string prodQuery = "select value p from Products as p where
p.ProductCategory.Name = @p0";
You need to execute the query. Which code segment should you use?

A) var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
B) var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
C) var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
D) var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

2. 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 retrieve an entity from an object context.
A different application updates the database. You need to update the entity instance to reflect updated
values in the database.
Which line of code should you use?

A) context.AcceptAllChanges();
B) context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);
C) context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);
D) context.Refresh(RefreshMode.StoreWins, entity);

3. 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 add the following table to the database.
CREATE TABLE ObjectCache ( Id INT IDENTITY PRIMARY KEY, SerializedObjectData XML)
You write the following code segment to retreive records from the ObjectCache table. (Line numbers are included for reference only.)
01 string s = GetConnectionStringFromConfigFile("xmldb");
02 using (SqlConnection conn = new SqlConnection(s))
03 using (SqlCommand cmd = new SqlCommand("select * from ObjectCache",
conn))
04 {
05 conn.Open();
06 SqlDataReader rdr = cmd.ExecuteReader();
07 while(rdr.Read())
08 {
09 ...
10 DeserializeObject(obj);
11 }
12 }
You need to retreive the data from the SerializedObjectData column and pass it to a method named
DeserializeObject.
Which line of code should you insert at line 09?

A) SByte obj = (SByte)rdr[1];
B) String obj = (String)rdr[1];
C) XmlReader obj = (XmlReader)rdr[1];
D) Type obj = (Type)rdr[1];

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use a TableAdapter object to load a DataTable object.
The DataTable object is used as the data source for a GridView control to display a table of customer
information on a Web page.
You need to ensure that the application meets the following requirements:
-Load only new customer records each time the page refreshes.
-Preserve existing customer records. What should you do?

A) Set the ClearBeforeFill property of the TableAdapter to false. Use the Fill method of the TableAdapter.
B) Set the ClearBeforeFill property of the TableAdapter to true. Use the GetData method of the TableAdapter to create a new DataTable.
C) Set the ClearBeforeFill property of the TableAdapter to true. Use the Fill method of the TableAdapter to load additional customers.
D) Set the ClearBeforeFill property of the TableAdapter to false. Use the GetData method of the TableAdapter to create a new DataTable.

5. You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server
2008 database.
The database contains a ClassStudent table that contains the StudentID for students who are enrolled in
the classes.
You add the following stored procedure to the database.
CREATE PROCEDURE [dbo].[GetNumEnrolled] @ClassID INT, @NumEnrolled INT OUTPUT
AS BEGIN SET NOCOUNT ON SELECT @NumEnrolled = COUNT(StudentID)
FROM ClassStudent
WHERE (ClassID = @ClassID)
END
You write the following code. (Line numbers are included for reference only.)
01 private int GetNumberEnrolled(string classID)
02 {
03 using (SqlConnection conn = new SqlConnection(GetConnectionString())
04 {
05 SqlCommand cmd = new SqlCommand("GetNumEnrolled", conn);
06 cmd.CommandType = CommandType.StoredProcedure;
07 SqlParameter parClass = cmd.Parameters.Add("@ClassID", SqlDbType.Int,
4, "classID");
08 SqlParameter parNum = cmd.Parameters.Add("@NumEnrolled",
SqlDbType.Int);
09 ...
10 conn.Open()
11 ...
12 }
13 }
You need to ensure that the GetNumberEnrolled method returns the number of students who are enrolled
for a specific class.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Insert the following code at line 09.
parNum.Direction = ParameterDirection.Input;
B) Insert the following code at line 11.
int numEnrolled = 0;
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
numEnrolled = numEnrolled + (int)cmd.Parameters["@NumEnrolled"].Value; } return numEnrolled;
C) Insert the following code at line 09.
parNum.Direction = ParameterDirection.Output;
D) Insert the following code at line 11.
cmd.ExecuteNonQuery();
return (int)parNum.Value;

Solutions: