PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you do?

You are creating a Windows application that processes sales orders by using the .NET Framework 3.5.
The application has the following specifications:
It connects to a Microsoft SQL Server 2008 database.
It retrieves data from a table named Products.
The product table has three columns named Name, Description, and Quantity. The application uses the
Name and Description columns as lookup fields. It updates the Quantity column when orders are placed.
You need to design a concurrency management strategy that meets the following requirements:
Data integrity is maintained during the update process.
Database locking for the lookup data is minimal.
What should you do?

What should you do?

You are an enterprise application developer. You develop an application to manage products. You plan to expose the products from the application to your business partners. The design solution must meet the following requirements: The service is accessible through firewalls.The service interoperates with client applications that are developed by using different frameworks. You need to ensure that the solution meets the requirements by using the minimum amount of development effort.
What should you do?

What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
The application has the following features:
Users access the application from their local computers.
Each user specifies the data file to be used for the current session at the start of the application.
You plan to design a strategy to enable users to share their data files with other users.
You need to implement the strategy to meet the following requirements:
Users can open the data file only by using a password.
Users can work on the data file only by using the application.
What should you do?

Which two actions should you perform?

You are an enterprise application developer. You are evaluating the physical design of a Windows Forms application. The application will be used on several computers on a corporate intranet. The application connects to different Microsoft SQL Server databases. The application relies on a series of distributed components for the business and data layers. You need to review the database connection strategy to ensure scalability and performance of the application.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

Which two actions should you perform?

You are an enterprise application developer. You are designing a monitoring mechanism for a serviced component that runs on the company server. The component will be used to execute CPU-intensive operations. When the component is deployed, administrators must be able to monitor the following measures: Number of requests for each operationTime taken for each operation to complete. You need to achieve this goal by using the minimum amount of coding effort.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

What should you do?

You are creating a Windows application by using the .NET Framework 3.5.
The application must import data from a legacy database.
A comma-delimited text file that has 10,000 rows of data is exported from the database frequently. The
data is displayed and processed by the Windows application.
The text file is not trusted and can contain invalid data. The application database must store valid data.
You need to create a strategy to optimally validate and process the application data.
What should you do?

What should you do?

You are an enterprise application developer. You develop an application by using Microsoft Visual Studio .NET 2005 and .NET Framework 2.0. You are designing a data access component for the application. You need to design the data access component to meet the following requirements:
It must be available to Windows and Web-based applications.
It must execute distributed database transactions.

What should you do?