Learn with Microsoft : 70-516 training material for 100% pass

Microsoft 70-516 Exam Overview:

Microsoft 70-516 Exam Syllabus Topics:

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

1. The database contains a table named Categories. The Categories table has a primary key identity column
named CategoryID.
The application inserts new records by using the following stored procedure.
CREATE PROCEDURE dbo.InsertCategory @CategoryName nvarchar(15), @Identity int OUT
AS INSERT INTO Categories (CategoryName) VALUES(@CategoryName) SET @Identity = SCOPE_IDENTITY() RETURN @@ROWCOUNT
You write the following code segment.
SqlDataAdapter adapter = new SqlDataAdapter("SELECT categoryID, CategoryName
FROM dbo.Categories",connection);
adapter.InsertCommand = new SqlCommand("dbo.InsertCategory", connection);
adapter.InsertCommand.CommandType = commandType.StoredProcedure;
adapter.InsertCommand.Parameters.Add(new SqlParameter("@CategoryName",
SqlDbType.NVarChar, 15,"CategoryName"));
You need to retrieve the identity value for the newly created record. Which code segment should you add?

A) SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
B) SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@CategoryName", SqlDbType.Int); parameter.Direction = ParameterDirection.Output; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.ReturnValue;
C) SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int); parameter.Direction = ParameterDirection.ReturnValue; parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID"); parameter.Direction = ParameterDirection.Output;
D) SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@RowCount", SqlDbType.Int);
parameter.Direction = ParameterDirection.Output;
parameter = adapter.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "CategoryID");
parameter.Direction = ParameterDirection.ReturnValue;

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model using model-first development.
The database has the following requirements:
-each table must have a datetime column named time_modified
-each table requires a trigger that updates the value of the time_modified column when a row is inserted or updated
You need to ensure that the database script that is created by using the Generate Database From Model
option meets the requirements.
What should you do?

A) Add a DateTime property named time_modified to each entity in the model and set the property's StoreGeneratedPattern to Computed.
B) Create a new Windows Workflow Foundation workflow, and set Database Generation Workflow to the name of the new workflow.
C) Create a new T4 template, and set the DDL Generation template to the name of the new template.
D) Add a new entity named time_modified to the model, and modify each existing entity so that it inherits from the new entity.

3. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application defines the following Entity Data Model.

Within the .edmx file, the following function is defined:
<Function Name="Round" ReturnType="Decimal"> <Parameter Name="val" Type="Decimal" /> <DefiningExpression>
CAST(val as Edm.Int32) </DefiningExpression> </Function>
The application includes the following LINQ query.
var query = from detail in context.SalesOrderDetails select detail.LineTotal.Round();
You need to ensure that the Round function executes on the database server when the query is executed. Which code segment should you use?

A) public static class DecimalHelper
{
[EdmFunction("Edm", "Round")]
public static Decimal Round(this Decimal Amt)
{
throw new NotSupportedException();
}
}
B) public static class DecimalHelper
{
public static Decimal Round(this Decimal input)
{
return (Decimal)(Int32)input;
}
}
C) public static class DecimalHelper
{
[EdmFunction("SqlServer", "Round")]
public static Decimal Round(this Decimal Amt)
{
throw new NotSupportedException();
}
}
D) public static class DecimalHelper
{
public static SqlDecimal Round(this Decimal input)
{
return SqlDecimal.Round(input, 0);
}
}

4. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
You create an Entity Data Model (EDM) named Model. You need to ensure that the Storage Schema
Definition Language (SSDL)
of the EDM can be modified without rebuilding the application. What should you do?

A) Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string="& "
B) Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string ="& "
C) Set the Metadata Artifact Processing property to Copy to Output Directory and use the following connection string: metadata=res://*/Model.csdl| res://*/Model.ssdl| res://*/Model.msl; provider=System.Data.SqlClient; provider connection string ="& "
D) Set the Metadata Artifact Processing property to Embed in Output Assembly and use the following connection string: metadata=.\Model.csdl| .\Model.ssdl| .\Model.msl; provider=System.Data.SqlClient; provider connection string="& "

5. 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 define a Category class by writing the following code segment. (Line numbers are included for
reference only.)
01 public class Category
02 {
03 public int CategoryID { get; set; }
04 public string CategoryName { get; set; }
05 public string Description { get; set; }
06 public byte[] Picture { get; set; }
07 ...
08 }
You need to add a collection named Products to the Category class. You also need to ensure that the
collection supports deferred loading.
Which code segment should you insert at line 07?

A) public abstract List <Product> Products { get; set; }
B) public static List <Product> Products { get; set; }
C) protected List <Product> Products { get; set; }
D) public virtual List <Product> Products { get; set; }

Solutions: