Prepare with Microsoft : 070-516 exam braindumps as your best preparation materials

You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL.
The Product entity in the LINQ to SQL model contains a field named Productlmage. The Productlmage field
holds a large amount of binary data.
You need to ensure that the Productlmage field is retrieved from the database only when it is needed by the
application. What should you do?

• A. Set the Auto-Sync property on the Productlmage property of the Product entity to Never.
• B. Set the Update Check property on the Productlmage property of the Product entity to Never.
• C. Set the Delay Loaded property on the Productlmage property of the Product entity to True.
• D. When the context is initialized, specify that the Productlmage property should not be retrieved by using DataLoadOptions

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.
You use the ADO.NET Entity Framework to model your entities. You use ADO.NET self-tracking entities.
You need to ensure that the change-tracking information for the self-tracking entities can be used to update
the database.
Which ObjectContext method should you call after changes are made to the entities?

• A. Attach
• B. ApplyChanges
• C. Refresh
• D. SaveChanges

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the service to the following URL: http://contoso.com/
Northwind.svc.
You want to query the WCF Data Services service to retrieve a list of customer objects.
You need to ensure that the query meets the following requirements:
-Only customers that match the following filter criteria are retrieved: City="Seattle" AND Level > 200.
-Data is sorted in ascending order by the ContactName and Address properties. Which URL should you use for the query?

• A. http://contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName and Address
• B. http://contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName,Address
• C. http://contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName and Address
• D. http://contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName,Address

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 EnlistVolatile method of the Transaction class.
• B. Call the Reenlist method of the TransactionManager class.
• C. Call the RecoveryComplete method of the TransactionManager class.
• D. Call the EnlistDurable method of the Transaction 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. You load records from the Customers table
into a DataSet object named dataset.
You need to retrieve the value of the City field from the first and last records in the Customers table.
Which code segment should you use?

• A. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count - 1]["City"].ToString();
• B. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• C. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• D. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count]["City"].ToString();