Microsoft 070-516 Value Pack (Frequently Bought Together)

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
The application contains the following model. You write the following code. (Line numbers are included for
reference only.)
01 static void Insert()
02 {
03 NorthwindDataContext dc = new NorthwindDataContext();
04 Customer newCustomer = new Customer();
05 newCustomer.Firstname = "Todd";
06 newCustomer.Lastname = "Meadows";
07 newCustomer.Email = "[email protected]";
08 .....
09 dc.SubmitChanges();
10 }

A product named Bike Tire exists in the Products table. The new customer orders the Bike Tire product.
You need to ensure that the correct product is added to the order and that the order is associated with the
new customer.
Which code segment should you insert at line 08?

• A. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order (); newOrder.Product = newProduct; newCustomer.Orders.Add(newOrder) ;
• B. Product newProduct = new Product(); newProduct.ProductName = "Bike Tire"; Order newOrder = new Order(); newOrder.Product = newProduct;
• C. Order newOrder = new Order();
  newOrder.Product = (from p in dc.Products
  where p.ProductName == "Bike Tire"
  select p).First();
  newCustomer.Orders.Add(newOrder) ;
• D. Order newOrder = new Order();
  newOrder.Product = (from p in dc.Products
  where p.ProductName == "Bike Tire"
  select p) .First();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
WCF Data Services uses an authentication scheme that requires an HTTP request that has the following
header format:
GET /Odata.svc/Products(1)
Authorization: WRAP access_token="123456789"
The application includes the following code. (Line numbers are included for reference only.)
01 public class program
02 {
03 Public void GetProducts()
04 {
05 var proxy = new MyDataServiceContext("...");
06 ...
07 }
08 }
You need to ensure that the correct authentication header is present when requests are made by using
MyDataServiceContext.
What should you do?

• A. Insert the following code segment at line 06:
  Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
  (proxy_SendingRequest);
  Insert the following code segment at line 09:
  void proxy_SendingRequest(object sender, SendingRequestEventArgs e){ e.RequestsHeaders.Add("Authorization","WRAP access_token", "123456789"); }
• B. Insert the following code segmen at line 06:
  Proxy.Credentials = new NetworkCredential("WRAP access_token", "123456789");
• C. Insert the following code segment at line 06:
  Proxy.Credentials = new NetworkCredential("Authorization", "WRAP
  access_token=\"123456789"\"");
• D. Insert the following code segmen at line 06:
  Proxy.SendingRequest += new EventHandler<SendingRequestEventArgs>
  (proxy_SendingRequest);
  Insert the following code segmen at line 09:
  void proxy_SendingRequest(object sender, SendingRequestEventArgs e){
  e.RequestsHeaders.Add("WRAP access_token", "123456789");
  }

You use Microsoft .NET framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database named AdventureWorksLT.
The database resides on an instance named INSTA on a server named SQL01.
You need to configure the application to connect to the database. Which connection string should you add
to the .config file?

• A. Data Source=AdventureWorksLT; Initial Catalog=SQL01\INSTA; Integrated Security=true;
• B. Data Source=SQL01\INSTA; Initial Catalog=AdventureWorksLT; Integrated Security=true;
• C. Data Source=SQL01; Initial Catalog=INSTA; Integrated Security=true; Application Name=AdventureWorksLT;
• D. Data Source=SQL01; Initial Catalog=AdventureWorksLT; Integrated Security=true; Application Name=INSTA;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application updates several Microsoft SQL Server databases within a single transaction.
You need to ensure that after a resource failure, you can manage unresolved transactions. What should
you do?

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

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.Refresh(RefreshMode.StoreWins, entity);
• B. context.AcceptAllChanges() ;
• C. context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);
• D. context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);