TS-MS-NET-Framework-3-5-ADO-NET-Application-Development-Csharp-(70-561-CSharp) - Microsoft 70-561-CSharp TS MS.NET Framework 3.5 ADO.NET Application

TS-MS-NET-Framework-3-5-ADO-NET-Application-Development-Csharp-(70-561-CSharp)

This preview shows page 1 - 4 out of 7 pages.

70-561-CSharp Microsoft TS- MS .NET Framework 3.5 ADO.NET Application Development
Answer: A QUESTION:94 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft SynchronizationServicesforMicrosoftADO.NET.TheapplicationusesaMicrosoftSQL Server 2005 (Compact Edition) database. This database contains a table named Order. Microsoft Windows Mobilebased devices synchronize data concurrently with the database server. You write the following code segment. (Line numbers are included for reference only.) 01 public class ServerSyncProvider : DbServerSyncProvider 02 { 03 public ServerSyncProvider() 04 { 05 SyncAdapter orderSyncAdapter = 06 new SyncAdapter("Order"); 07 SqlCommand ManageRows = new SqlCommand(); 08 ManageRows.CommandText = 09 "DELETE FROM dbo.Order WHERE OrderId = @OrderId " + 10 "AND ((UpdateTS <= @sync_last_received_anchor OR " + 11 "UpdateId = @sync_client_id ) OR @sync_force_write=1) " + 12 "IF (@@rowcount > 0) UPDATE Sales. Order_Tombstone SET "+ 13 "DeleteId = @sync_client_id WHERE OrderId = @OrderId"; 14 15 } 16 } You need to ensure that the application performs the following tasks: It allows bidirectional incremental data changes to the Order table.It generates the ClientUpdateServerDelete action as a conflict. Which line of code should you insert at line 14? DeleteCommand=ManageRows;.orderSyncAdapter.AB. orderSyncAdapter.UpdateCommand = ManageRows; C. orderSyncAdapter.SelectIncrementalDeletesCommand = ManageRows; D. orderSyncAdapter.SelectConflictDeletedRowsCommand = ManageRows; Answer:A QUESTION:95 You create an application by using the Microsoft .NET Framework 3.5 and Microsoft (Linenumbersare.Youwritethefollowingcodesegmentintheapplication.NET.ADOincluded for reference only.) 01 string connString = 66

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture