Try Microsoft : 70-516 practice torrent pass for sure

The application user interface displays part names or color names in many plases as '## Name ##'.
You need to provide a method named FormattedName() to format part names and color names throughout
the
application. What should you do?

• A. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this IName entity){
  return string.Format("## {0} ##", entity.Name)
  }
• B. Add the following code segmend to the Part class in Part.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• C. Add the following code segmend to the Color class in Color.cs:
  public string FormattedName(){
  return string.Format("## {0} ##", this.Name);
  }
• D. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Part entity){
  return string.Format("## {0} ##", entity.Name)
  }
• E. Add the following code segment to the ExtensionMethods class in ExtensionMethods.cs:
  public static string FormattedName (this Color entity){
  return string.Format("## {0} ##", entity.Name)
  }

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.

Each region contains a single vendor. Customers order parts from the vendor that is located in their region.
You need to ensure that each row in the Customer table references the appropriate row from the Vendor
table.
Which code segment should you use?

• A. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.Region equals v.Region
  select new { Customer = c. Vendor = v };
  foreach (var u in query){
  u.Vendor.VendorlD = u.Customer.VendorID;
  }
  dc.SubmitChanges();
• B. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.VendorlD equals c.VendorID
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.Region = u.Vendor.Region;
  }
  dc.SubmitChanges();
• C. SalesDataContext dc = new SalesDataContext("...");
  var query = from c in dc.Customers
  join v in dc.Vendors on c.VendorlD equals v.VendorID
  select new { Customer = c, Vendor = v };
  foreach (var u in query){
  u.Vendor.Region = u.Customer.Region;
  }
  dc.SubmitChanges();
• D. SalesDataContext dc = new SalesDataContext("...");
  var query = from v in dc.Vendors
  join c in dc.Customers on v.Region equals c.Region
  select new { Vendor = v, Customer = c };
  foreach (var u in query){
  u.Customer.VendorlD = u.Vendor.VendorlD;
  }
  dc.SubmitChanges();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
The application connects to a Microsoft SQL Server database. The application is hosted on a Web server
along with other applications.
You need to secure the transmission of data between the application and the database.
You need to achieve this goal without affecting other applications. What should you do?

• A. Encrypt the connection string.
• B. Use Internet Protocol Security (IPSec) to secure the communication channel.
• C. Use encryption to store sensitive data in the database.
• D. Use Secure Sockets Layer (SSL) to establish connections to the database.

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.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• B. var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• C. var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• D. var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

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

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