You create Microsoft Windows-based applications. You create a Microsoft Windows-based application that stores information in a Microsoft SQL Server 2005 database. Your company requires that all database access is done by using stored procedures.

The stored procedures must meet the following requirements:

The procedures return data that can be used in any data-bound control in the application. The procedures return data in the most compact format available.

No complex logic is needed in the procedures. You need to implement the most appropriate technology to write stored procedures that meet these requirements. You also need to ensure that the stored procedures can be easily updated as application requirements change. What should you do?

You create Microsoft Windows-based applications. You create a banking application that will be used by the account managers of the bank.

You identify a method to simulate the deposit functionality of a savings account. The method will calculate the final balance when monthly deposit, number of months, and quarterly rate are given. The application requirements state that the following criteria must be used to calculate the balance amount:

Apply the quarterly interest rate to the balance amount of the account every three months. Apply the quarterly interest rate before the monthly deposit is calculated for the third month.

You translate the outlined specification into pseudo code. You write the following lines of code. (Line
numbers are included for reference only.)

Method
public static decimal SimulateSavings

Input parameters

int months
decimal monthlyPayment
decimal quarterlyRate

Pseudo code

01 Declare balance variable, initialize it to zero
03 Return balance

You need to insert the appropriate code in line 02. Which code segment should you insert?

You create Microsoft Windows-based applications. You are creating an application to be used by the employees of a multinational company.

The application must meet the following requirements:

Employees from any location can retrieve the latest price quotes from the companys Microsoft SQL Server database.
Employees can submit orders online.
The companys business partners can submit orders by using the software that they design themselves. The company cannot restrict the business partners choice of platform.

You need to ensure that the application and the server communicate as effectively as possible. Which technology should you use?

You create Microsoft Windows-based applications. You are creating an application that will monitor sales data.

The application must meet the following requirements:

Users must be able to customize display settings and the amount of data to monitor. Users must be able to log on to any computer on the network to use the application. User settings must be retrieved based on the logged-on user from any computer on the network.

You need to decide where to store the user settings. What should you do?

You create Microsoft Windows-based applications. You create a purchase order application. Sales personnel use the application to place orders for customers. Sales personnel need to connect to the network to use the application. The application saves data to a database server on the network. Multiple sales personnel use the application simultaneously.

The purchase order application requires a logging mechanism to permit auditing of sales. The logging mechanism must meet the following requirements:

Log entry is created for every sales order created, saved, or deleted.
Log data is available only to administrators.
Log entries for all sales are stored together.
Current log data can be read while the application is running.

You need to decide on a storage mechanism for the logged data. Which storage mechanism should you choose?

You create Microsoft Windows-based applications. You are creating an internal application. The application requirements are that you can audit the application to discover when users logged on and when they logged off from the application. Logon and logoff events must be stored in a centralized location. The application is designed to use the security credentials of the logged on Windows user. The auditing logon and logoff events policy is enabled for all computers on the
network. Because of these settings, the application does not log any data that is related to logon and logoff events. You need to evaluate the design to find if the application meets the auditing requirements. What should you conclude?

You create Microsoft Windows-based applications. Two of your Windows-based applications require the use of graphical progress indicators. These indicators are based on bitmap files. Such a component is not available in the .NET Framework.

To facilitate the search for a component, you identify the following requirements:

The component exposes methods to increment and decrement the progress bar, along with a method or a property to manually change the value of the progress bar. The component permits the use of different types of progress indicators, such as a regular progress bar or a circular progress bar.
The component represents multiple progress indicators, permitting the developers to dynamically change the number of indicators.

You research three third party components and find a component that matches the first two criteria. The component you find represents a single progress indicator. The component also exposes extra methods and properties that the developers must not use. You need to implement a strategy to use the third party component. You want to achieve this goal by using the minimum amount of programming effort. What should you do?

You create Microsoft Windows-based applications. You are responsible for maintaining your companys application framework. You analyze the requirements for some of the applications that your company develops. You identify a common functionality. The functionality includes user interface elements as well as data-binding logic and display logic. You need to implement the functionality in such a way that other applications can reuse it. Which type of component should you implement?

You create Microsoft Windows-based applications. You are creating a component. The component performs statistical computations by using sets of data from a large, complex database. According to the design specification, the component performs a full set of calculations in not more than 5 seconds. Currently, the component takes more than 20 seconds to perform the required calculations. The project is almost complete and you must resolve the performance issues quickly. You need to identify the major processing performance issues in the component. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create Microsoft Windows-based applications.
You are designing a class to be used by multiple client applications. This class will be used to generate unique account numbers. Your company guidelines state that unique number generating components must comply with the following design pattern:

Classes must be designed so that they cannot be instantiated directly by client applications. Only a single instance of the class must be used by all the client applications. Instance methods and properties for these classes must be accessible to client applications.

You need to define how this class will implement the design pattern. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)