Microsoft TS: Accessing Data with Microsoft .NET Framework 4 Sample Questions:

1. You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4.0 to
create an application.
You have a ServerSyncProvider connected to a Microsoft SQL Server database. The database is hosted on
a Web server.
Users will use the Internet to access the Customer database through the ServerSyncProvider.
You write the following code segment. (Line numbers are included for reference only.)
01 SyncTable customerSyncTable = new SyncTable("Customer");
02 customerSyncTable.CreationOption =
TableCreationOption.UploadExistingOrCreateNewTable;
03 ...
04 customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements:
-Users can modify data locally and receive changes from the server.
-Only changed rows are transferred during synchronization. Which code segment should you insert at line 03?

A) customerSyncTable.SyncDirection = SyncDirection.DownloadOnly;
B) customerSyncTable.SyncDirection = SyncDirection.Bidirectional;
C) customerSyncTable.SyncDirection = SyncDirection.Snapshot;
D) customerSyncTable.SyncDirection = SyncDirection.UploadOnly;

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that uses the Entity Framework.
The build configuration is set to Release. The application must be published by using Microsoft Visual Studio 2010, with the following requirements:
-The database schema must be created on the destination database server.
-The Entity Framework connection string must be updated so that it refers to the destination database server.
You need to configure the application to meet the requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Set Items to deploy in the Package/Publish Web tab to All files in this Project Folder for the release configuration.
B) Generate the DDL from the Entity Framework Designer and include it in the project. Set the action for the DDL to ApplicationDefinition.
C) Include the source database entry in the Package/Publish SQL tab and update the connection string for the destination database.
D) Use the web.config transform file to modify the connection string for the release configuration.

3. 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,Address
B) http://contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName,Address
C) http://contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName and Address
D) http://contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName and Address

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 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) Persist Security Info=false;
B) Integrated Security=false;
C) Persist Security Info=true;
D) Integrated Security=SSPI;

5. 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 Entity SQL to retrieve data from the
database.
You need to find out whether a collection is empty. Which entity set operator should you use?

A) IN
B) ANYELEMENT
C) EXCEPT
D) EXISTS

Solutions: