DRAG DROP
You have an application that accesses a Microsoft SQL Server database.
The database contains a stored procedure named Proc1. Proc1 accesses several rows of data across
multiple tables.
You need to ensure that after Proc1 executes, the database is left in a consistent state. While Proc1
executes, no other operation can modify data already read or changed by Proc1. (Develop the
solution by selecting and ordering the required code snippets.
You may not need all of the code snippets.)

DRAG DROP
You have an application that uses paging. Each page displays 10 items from a list.
You need to display the third page. (Develop the solution by selecting and ordering the required
code snippets. You may not need all of the code snippets.)

DRAG DROP
You have a method that will evaluate a parameter of type Int32 named Status.
You need to ensure that the method meets the following requirements:
If Status is set to Active, the method must return 1.
If Status is set to Inactive, the method must return 0.
If Status is any other value, the method must return -1.
What should you do? (To answer, drag the appropriate statement to the correct location in the
answer are
a. Each statement may be used once, more than once, or not at all. You may need to drag the split
bar between panes or scroll to view content.)

You are developing an application that uses multiple asynchronous tasks to optimize performance.
You need to retrieve the result of an asynchronous task.
Which code segment should you use?

You are developing an application.
The application contains the following code:

When you compile the code, you receive the following syntax error message: “A previous catch
clause already catches all exceptions of this or a super type (‘System.Exception’).”
You need to ensure that the code can be compiled. What should you do?

You are developing an application that includes a method named SendMessage.
You need to ensure that the SendMessage() method is called with the required parameters.
Which two code segments can you use to achieve this goal? (Each correct answer presents a
complete solution. Choose two.)

You have an application that accesses a Web server named Server1.
You need to download an image named Imagel.jpg from Server1 and store the image locally as
Filel.jpg.
Which code should you use?

You are developing a C# application. The application references and calls a RESTful web service
named EmployeeService. The EmployeeService web service includes a method named GetEmployee,
which accepts an employee ID as a parameter. The web service returns the following JSON data from
the method.
{“Id”:1,”Name”:”David Jones”>
The following code segment invokes the service and stores the result:

You need to convert the returned JSON data to an Employee object for use in the application.
Which code segment should you use?

You are developing an assembly.
You plan to sign the assembly when the assembly is developed.
You need to reserve space in the assembly for the signature.
What should you do?

You have the following code (line numbers are included for reference only):

You need to ensure that if an exception occurs, the exception will be logged.
Which code should you insert at line 28?