Pass with professional 070-523 actual quiz materials

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 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 EnlistDurable method of the Transaction class.
• B. Call the RecoveryComplete method of the TransactionManager class.
• C. Call the Reenlist method of the TransactionManager class.
• D. Call the EnlistVolatile method of the Transaction class.

You are dynamically adding controls to an ASP.NET page in the Page_Load event handler. The page will
have text boxes that correspond to the columns in a database table. Each text box will be preceded by a
label that displays the name of the corresponding column.
You need to create the form so that when the user clicks the label, the corresponding text box is selected
for input.
What should you do?

• A. For each column, create an asp:Label control and set the AssociatedControlID to the ID of the corresponding asp:Textbox control.
• B. For each column, create an asp:Label control and a corresponding asp:TextBox that have the same ID.
• C. For each column, output the following HTML, where COL is replaced by the name of the column. <label AssociatedControlID="COL">COL</label> <input name="COL" type="text" id="COL" />
• D. For each column, output the following HTML, where COL is replaced by the name of the column. <label>COL</label> <input name="COL" type="text" id="COL" />

You are implementing an ASP.NET page. Client-side script requires data. Your application includes a class
named Person with a Name property of type string. The code-behind file of the page includes the following
code segment.
public string JsonValue;
List<Person> people = GetPeopleList();
JavaScriptSerializer json = new JavaScriptSerializer();
You need to use the JavaScriptSerializer class to serialize only the Name property of each item in the
people list.
Which code segment should you use?

• A. JsonValue = json.Serialize(people.SelectMany( p => Name.AsEnumerable())); var names = from person in people select person; JsonValue = json.Serialize(names);
• B. JsonValue = json.Serialize(people.Select(p => p.Name)); var names = from person in people select person; JsonValue = "{" + json.Serialize(names) + "}";

You create a page in an ASP.NET Web application. The page retrieves and displays data from a Microsoft SQL Server database. You need to create a data source that can connect to the database. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

• A. Use an XmlDataSource control together with an Xml control that represents the database.
• B. Use a SqlDataSource control and configure its ConnectionString in the web.config file.
• C. Use an ObjectDataSource control and set its TypeName property to System.Data.SqlClient. SqlConnection.
• D. Use a LinqDataSource control with entity classes that represent the elements in the database.

You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4 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.)
01SyncTable customerSyncTable = new SyncTable("Customer");
02customerSyncTable.CreationOption = TableCreationOption. UploadExistingOrCreateNewTable;
03
04customerSyncTable.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.UploadOnly;
• C. customerSyncTable.SyncDirection = SyncDirection.Bidirectional;
• D. customerSyncTable.SyncDirection = SyncDirection.Snapshot;