Microsoft 70-516 Value Pack (Frequently Bought Together)

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.
"Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=secret;"
You need to ensure that the database credentials are secure. Which is the correct Property to insert?

• A. Integrated Security=SSPI;
• B. Persist Security Info=true;
• C. Integrated Security=false;
• D. Persist Security Info=false;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code
accesses the POCO entities directly.
You need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObjectContext method should you call?

• A. ApplyPropertyChanges
• B. Refresh
• C. SaveChanges
• D. DetectChanges

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered. What should you do?

• A. Call the RecoveryComplete method of the TransactionManager class.
• B. Call the EnlistDurable method of the Transaction class.
• C. Call the EnlistVolatile method of the Transaction class.
• D. Call the Reenlist method of the TransactionManager class.

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. The application uses the ADO.NET Entity
Framework to model entities.
The database includes objects based on the exhibit (click the Exhibit button).
The application includes the following code segment. (Line numbers are included for reference only.)
01 using(AdventureWorksEntities context = new AdventureWorksEntities())
02 {
03 ...
04 foreach (SalesOrderHeader order in customer.SalesOrderHeader)
05 {
06 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
07 foreach (SalesOrderDetail item in order.SalesOrderDetail)
08 {
09 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
10 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
11 }
12 }
13 }
You want to list all the orders for a specific customer. You need to ensure that the list contains following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert in line 03?

• A. Contact customer = (from contact in context.Contact.Include
  ("SalesOrderHeader.SalesOrderDetail")
  select contact).FirstOrDefault();
• B. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First();
• C. Contact customer = (from contact in context.Contact.Include
  ("SalesOrderHeader")
  select contact).FirstOrDefault();
• D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("@customerId", customerId)).First();

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="true" />
• 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="false" />
• 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" />