Which code segment should you insert at line 05?
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 and contains a LINQ to SQL data model.
The data model contains a function named createCustomer that calls a stored procedure.
The stored procedure is also named createCustomer. The createCustomer function has the following signature.
createCustomer (Guid customerID, String customerName, String address1)
The application contains the following code segment. (Line numbers are included for reference only.)
01 CustomDataContext context = new CustomDataContext();
02 Guid userID = Guid.NewGuid();
03 String address1 = “1 Main Steet”;
04 String name = “Marc”;
05 …
You need to use the createCustomer stored procedure to add a customer to the database.
Which code segment should you insert at line 05?
Which 2 actions should you perform?
You are developing a Windows Application.
New features that require changes to be made to the database schema are added to the application every week.
You need to ensure that the changes made to the database schema do not require the application to be recompiled.
Which 2 actions should you perform?
Which approach should you recommend?
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?
What should you do?
You are using tracing to diagnose run-time issues.When you look at the traces for the service in SvcTraceViewer.exe,
you see what is shown in the exhibit:
The exception trace is selected in SvcTraceViewer.exe. You need to interpret the trace results to determine where the error occurred and what to do next.
What should you do?
Which code segment should you insert at line 02?
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.
The application uses a DataTable named OrderDetailTable that has the following columns:
* ID
* OrderID
* ProductID
* Quantity
* LineTotal
Some records contain a null value in the LineTotal field and 0 in the Quantity field.
You write the following code segment. (Line numbers are included for reference only.)
01 DataColumn column = new DataColumn(“UnitPrice”, typeof(double));
02 …
03 OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object.
You also need to ensure that UnitPrice is set to 0 when it cannot be calculated.
Which code segment should you insert at line 02?
Which technology should you use?
You are designing an application in the .net framework 4.0 The application is used mostly in a disconnected scenario. The application requires offline data from a Microsoft Sql Server 2008 database. When the application connects to the network, data will be modified and synchronized. You need to ensure that the application does not access the database server directly to synchronize data when online.
Which technology should you use?
Which configuration should you recommend?
You need to design a solution for accessing the shopping cart controls by using JavaScript.
Which configuration should you recommend?
Which XML segment should you add to the system.diagnostics configuration element in the client and server appl
You want to debug the Windows Communication Foundation (WCF) client and server interaction through message and application tracing.
You need to correlate traces generated on the client and the server.
Which XML segment should you add to the system.diagnostics configuration element in the client and server application configuration file?
Which code segment should you insert at line 06?
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.
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.)
01 DataSet customerOrders = new DataSet();
02 customerOrders.EnforceConstraints = true;
03 ForeignKeyConstraint ordersFK = new ForeignKeyConstraint(“ordersFK”,
04 customerOrders.Tables[“Customers”].Columns[“CustomerID”],
05 customerOrders.Tables[“Orders”].Columns[“CustomerID”]);
06 …
07 customerOrders.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?
Which local data storage technology should you use?
You are developing a Windows application.
The application will process data that is stored on the user’s computer.
You plan to design a data storage strategy.
You need to ensure that the following requirements are met:
+ Local data can be accessed ony by the application
+ Local data can be encrypted and compressed
+ Local data can be shared between multiple users by sending them the data file by email
+ Users must be able to open the data file directly from the email message
Which local data storage technology should you use?