PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you conclude?

You are an enterprise application developer. You are evaluating a database design for a human resource application. The existing database schema meets the following criteria:

The database has an Employee table.
The Employee table has an Employee ID field and several other fields.

You must accommodate the following new requirements:

Employees are either supervisors or line workers.
A supervisor will supervise zero or more line workers. An employee will be supervised by only one supervisor.

A database administrator suggests creating a table named Supervisor and copying the supervisor data from the Employee table to the new table. The database administrator also wants to create a foreign key in the Supervisor table to reference the Employee table. You need to evaluate the suggested change to ensure that there is minimal impact on the existing database schema. What should you conclude?

What should you do?

You create Web-based client applications. You are creating an ASP.NET intranet site. The site permits individual departments to post content without involving the Central Information Technology resources. The site also permits Central Information Technology to maintain control over the intranet as a whole. Each department wants complete control over the appearance and behavior of their departmental content. However, Information Technology directives require every page on the intranet to maintain a consistent appearance and behavior. You need to develop the Web page on the intranet site so that it meets the requirements. What should you do?

What should you conclude?

You are an enterprise application developer. You are evaluating a component that monitors a Web-based application.
The component stores monitoring information in a database and performs the following functions:

Retrieves the number of orders placed per second.
Tracks the data for peak usage of the application and displays the data in a tabular form.

Subsequently, monitoring requirements change in the following manner:

Users must be able to view data graphically.
Users must be able to analyze data in real time.
Users must be able to correlate the number of orders placed per second with the memory usage in the Web server.

You need to evaluate whether the component meets the new requirements and propose a solution, if required. What should you conclude?

Which two technologies should you choose?

You create Web-based client applications. You create an application that will be used by customers to browse the product catalog of an Internet-based store and buy products.

The application must meet the following requirements:

Permit registered customers of the store to change display settings and personal information. Store the updated information and associate the information with the logged-on customer.

You need to choose appropriate technologies to meet these requirements. Which two technologies should you choose? (Each correct answer presents part of the solution. Choose two.)

Which two dependencies should you identify?

You are an enterprise application developer.
You create an application that has three layers:

Layer 1 contains the Microsoft Windows client and the input validation logic. Layer 2 contains business entities, business workflows, and business rules. Layer 3 contains the data access classes and stored procedures.

You need to analyze the layers and identify dependencies that exist between these layers. Which two dependencies should you identify? (Each correct answer presents part of the solution.
Choose two.)

Which method should you use?

You create Web-based client applications. You are creating a Web-based discussion forum. The discussion forum will permit users to post and reply to discussion threads after logging on. You create the authentication mechanisms of your Web site. Microsoft SQL Server 2005 and the Active Directory directory service will continue to be used interchangeably for authentication. You need to provide a method for the users of the discussion forum to register. You also need to maintain the capability to use multiple authentication methods when the users register. Which method should you use?