Pass exam with 70-516 Top Exam Collection for sure one-shot

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 Visual Studio 2010 and .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The application contains the following
code segment.
string SQL = string.Format("SELECT * FROM Customer WHERE CompanyName LIKE '%
{0}%', companyName);
var cmd = new SqlCommand(SQL, con);
You need to reduce the vulnerability to SQL injection attacks. Which code segment should you use?

A) string SQL = "SELECT" * FROM Customer @companyName; var cmd = new sqlcommand(SQL,con); cmd.Parameters.AddWithValue("companyName", string.format("where companyName LIKE '%{0}%'", companyName));
B) string SQL = string.Format("SELECT * FROM " + " Customer Where CompanyName LIKE {0}",
new SqlCommand("@companyName", string.format("%{0}%", companyName))); var cmd = new SqlCommand(SQL, con);
C) string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); cmd.Parameters.AddWithValue("@companyName", string.Format("%{0}%", companyName));
D) string SQL = "SELECT * FROM Customer Where " + "CompanyName LIKE @companyName"; var cmd = new SqlCommand(SQL,con); var param = new SqlParameter ("@companyName", string.Format("%{0}%", companyName));

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application has an entity model that includes SalesTerritory and SalesPerson entities as shown in the
following diagram.

You need to calculate the total bonus for all sales people in each sales territory. Which code segment should you use?

A) model.SalesTerritories .GroupBy(territory => territory.SalesPersons) .SelectMany(group => group.Key) .Sum(person => person.Bonus);
B) model.SalesPersons .GroupBy(person => person.SalesTerritory) .SelectMany(group => group.Key.SalesPersons) .Sum(person => person.Bonus);
C) from person in model.SalesPersons group person by person.SalesTerritory into territoryByPerson select new {
SalesTerritory = territoryByPerson.Key,
TotalBonus = territoryByPerson.Sum(person => person.Bonus)
};
D) from territory in model.SalesTerritories group territory by territory.SalesPerson into personByTerritories select new {
SalesTerritory = personByTerritories.Key,
TotalBonus = personByTerritories.Key.Sum(person => person.Bonus)
};

3. 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 use the ADO.NET Entity Framework to manage persistence-ignorant entities. You create an
ObjectContext instance named context.
Then, you directly modify properties on several entities. You need to save the modified entity values to the
database.
Which code segment should you use?

A) context.SaveChanges();
B) context.SaveChanges(SaveOptions.DetectChangesBeforeSave);
C) context.SaveChanges(SaveOptions.None);
D) context.SaveChanges(SaveOptions.AcceptAllChangesAfterSave);

4. 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 database includes a table that
contains information about all the employees.
The database table has a field named EmployeeType that identifies whether an employee is a Contractor or
a Permanent employee.
You declare the Employee entity base type. You create a new Association entity named Contractor that
inherits the Employee base type.
You need to ensure that all Contractors are bound to the Contractor class. What should you do?

A) Use the Entity Data Model Designer to set up a referential constraint between the primary key of the Contractor class and EmployeeType.
B) Modify the .edmx file to include the following line of code: <NavigationProperty Name="Type" FromRole="EmployeeType" ToRole="Contractor" />
C) Use the Entity Data Model Designer to set up an association between the Contractor class and EmployeeType.
D) Modify the .edmx file to include the following line of code: <Condition ColumnName="EmployeeType" Value="Contractor" />

5. You use Microsoft .NET Framework 4.0 and the Entity Framework to develop an application.
You create an Entity Data Model that has an entity named Customer. You set the optimistic concurrency
option for Customer.
You load and modify an instance of Customer named loadedCustomer, which is attached to an
ObjectContext named context.
You need to ensure that if a concurrency conflict occurs during a save, the application will load up-to-date
values from
the database while preserving local changes. Which code segment should you use?

A) try {
context.SaveChanges();
}
catch(EntitySqlException ex)
{
context.Refresh(RefreshMode.ClientWins, loadedCustomer);
}
B) try {
context.SaveChanges();
}
catch(OptimisticConcurrencyException ex)
{
context.Refresh(RefreshMode.StoreWins, loadedCustomer);
}
C) try {
context.SaveChanges();
}
catch(EntitySqlException ex)
{
context.Refresh(RefreshMode.StoreWins, loadedCustomer);
}
D) try {
context.SaveChanges();
}
catch(OptimisticConcurrencyException ex)
{
context.Refresh(RefreshMode.ClientWins, loadedCustomer);
}

Solutions: