Online Access Free 070-523 Exam Questions

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application has two DataTable objects that
reference the Customers and Orders tables in the database. The application contains the following code
segment. (Line numbers are included for reference only.
01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have
related Order records. Which code segment should you insert at line 06?

• A.ordersFK.DeleteRule = Rule.SetNull;
• B.ordersFK.DeleteRule = Rule.SetDefault;
• C.ordersFK.DeleteRule = Rule.None;
• D.ordersFK.DeleteRule = Rule.Cascade;

You are designing the user interface for an ASP.NET Web application. The Web application allows several departments to personalize the style of their sections of the Web application.
All departmental section styles derive from the core styles of the Web application and can only append to
the Web application's core styles. The departmental master pages inherit from the Web application's
master page.
You need to ensure that core CSS styles appear in all pages of the Web application.
Which approach should you recommend?

• A.Add a master.css file containing the CSS styles to the Web application.
• B.Add a ContentPlaceHolder containing the CSS styles to the Web application's master page.
• C.Link from the Web application's master page to a .css file containing the CSS styles.
• D.Link from the Web application's master page to a css.ascx file containing the CSS styles.

Windows Communication Foundation (WCF) application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do?

• A.Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.
• B.Set the Emit Default Value property of each data member to false.
• C.Set the IsRequired property of each data member to true.
• D.Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet Information Services (IIS) 6.0 Web server.
The application works correctly in the development environment. However, when you connect to the service on the production server, attempting to update or delete an entity results in an error. You need to ensure that you can update and delete entities on the production server. What should you do?

• A.Configure IIS to allow the PUT and DELETE verbs for the .svc Application Extension.
• B.Add the following line of code to the InitializeService method of the service. config.SetEntitySetAccessRule ("*",EntitySetRights.WriteDelete | EntitySetRights.WriteInsert);
• C.Configure IIS to allow the POST and DELETE verbs for the .svc Application Extension.
• D.Add the following line of code to the InitializeService method of the service. config.SetEntitySetAccessRule ("*",EntitySetRights.WriteDelete | EntitySetRights.WriteMerge);

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