IT인증자격증을 취득하는 것은 IT업계에서 자신의 경쟁율을 높이는 유력한 수단입니다. 경쟁에서 밀리지 않으려면 자격증을 많이 취득하는 편이 안전합니다.하지만 IT자격증취득은 생각보다 많이 어려운 일입니다. Microsoft 070-547 (Designing and Developing Web-Based) 시험은 인기자격증을 취득하는데 필요한 시험과목입니다. Pass4Test는 여러분이 자격증을 취득하는 길에서의 없어서는 안될 동반자입니다. Pass4Test의 Microsoft 070-547 (Designing and Developing Web-Based)덤프로 자격증을 편하게 취득하는게 어떨가요?

 

 

NO.1 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. The design of applications

forms part of your responsibilities at operates as a company that provides financial, investment and

accounting services to its customers. You are currently developing a Web-based application for This

application will be used to maintain the investment account information for the customers. This investment

account information is sent as Extensible Markup Language (XML) documents from the Microsoft SQL

Server 2005 database. Each XML document should contain customer feedback information. You want this

application to allow you to contact the customers regarding the given feedback. Following are the

requirements that should be met:

1. The Web-based application must retrieve each customer's contact details such as name,address, and

e-mail address from the XML document.

2. You must be allowed to determine which geographical area has the most customer complaints.

3. The customer data should remain in XML format.

4. You must maximize performance of the query.

You thus need to make a decision as to which approach you can use to query the SQL Server

data to meet these requirements.

What should you do?

A. Query the SQL Server data using a SELECT statement with the FOR XML clause.

B. Query the SQL Server data using a SELECT statement that calls the DataType.Xml method.

C. Query the SQL Server data using a SELECT statement with an OPENXML function.

D. Query the SQL Server data using a SELECT statement with the OPENROWSET function.

Answer: C

 

NO.2 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. The design of applications forms

part of your responsibilities at operates as an online-retailer.

You are currently developing a Web-based application for This application will server as an order

fulfillment application. Upon completion this application will allow the users to enter a zip code into a

TextBox control where they will be able to find all the packages that have been shipped to a particular

geographical area. The application will take the TextBox value and construct a query similar to the one

illustrated in the Exhibit below: Exhibit: SELECT * FROM Orders WHERE zip = '21006';

You now need to make sure that you mitigate the possibility of malicious code

being inserted into the query strings passed to the SQL Server for parsing and execution. What should

you do?

A. You should use a RequiredFieldValidator control on the TextBox.

B. You should validate user input using stored procedures.

C. You should build Transact-SQL statements directly from the TextBox input.

D. You should concatenate user input from the TextBox.

Answer: B

 

NO.3 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their application

development platform. You use a Microsoft Windows XP Professional client computer named Certkiller

-WS547 as your development computer. Internet Information Services (IIS) is installed on Certkiller

-WS547. You are developing a Web-based client application for the Web site. The Web site sells

subscriptions to courseware material. The Web application must allow users to browse subscription

options, to purchase subscriptions, to add subscriptions to a wish list, to store bank account details, and

to review products online. You must implement a standardized layout according to the company's

branding on each page. The pages must also implement a daily advertisement above the main menu. The

advertisement must be replaced every morning.

You want to reduce the effort required to maintain the Web application. What should you do?

A. Add an AdRotator control to each Web page and place the daily advertisement in the Advertisement

file.

B. Include the daily advertisement in a Master Page and set the masterPageFile

attribute in the Web.config file.

C. Create a User Control for the daily advertisement and add the User Control to each Web page.

D. Include the daily advertisement in a Template Page and bind each Web page to the Template Page.

Answer: B

 

NO.4 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their application

development platform. You use a Microsoft Windows XP Professional client computer named Certkiller

-WS547 as your development computer. Internet Information Services (IIS) is installed on Certkiller

-WS547. You are developing a Web-based client application for You want users of the Web application

to input a date on the Web form regardless of their local date format. You add three DropDownList

controls named Year, Month and Day to the Web application. You want the date entered through these

DropDownList controls will be displayed on subsequent pages in the user's local date format. What

should you do?

A. Instantiate a DateTime object using the values from the DropDownList controls.

B. Instantiate a DateTime object using the values from the GetDate method.

C. Let the users select their location and set the CurrentCulture property of the executing thread to

the associated CultureInfo object.

D. Set the enableClientBasedCulture attribute in the Web.config file to true.

Answer: A,C

 

NO.5 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their

application development platform. You use a Microsoft Windows XP Professional client computer named

Certkiller -WS547 as your development computer. Internet Information Services (IIS) is installed on

Certkiller -WS547. You are developing a Web-based client application for the Web site. The Web site sells

subscriptions to courseware material. Customers must be able to specify the term of subscription by

specifying the start and end dates of their subscriptions in TextBox controls, and must specify their

location in a DropDownList control. You must ensure that the values entered into the TextBox controls are

dates that have not yet passed. You must also ensure that the start date is no more than 3 months in

advance and that the end date is at least two weeks after the start date. Customers who want an

open-ended subscription do not need to specify an end date.

You decide to use RequiredFieldValidator controls to verify the start date TextBox control and the

DropDownList control, and a RangeValidator control to verify the start date TextBox control. Does

your solution satisfy the requirements for this project?

A. Yes.

B. No, a RangeValidator does not verify the validity of a date.

C. No, a CompareValidator is required to verify the validity of the end date.

D. No, a CompareValidator is required to verify that the start date has not

already passed.

E. No, a RequiredFieldValidator is required for the end date TextBox control.

Answer: C

 

NO.6 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their application

development platform. You use a Microsoft Windows XP Professional client computer named Certkiller

-WS547 as your development computer.

Internet Information Services (IIS) is installed on Certkiller -WS547. has it headquarters in Washington

and branch offices in Miami, Dallas and San Francisco. The network contains a SQL Server 2005

database server named Certkiller -DB01 that is located at headquarters. Certkiller -DB01 hosts a

database named CK_Sales that stores sales information for the company. You are developing a

Web-based client application for The Web application connects all branch offices to the CK_Sales

database. You need to develop a user interface that allows Sales personnel at each branch office to enter

data regarding Returned goods. The Returned Goods data includes the customer's name, the product

code, and the invoice number. You need to implement the appropriate user interface controls for entry of

Returned Goods data. What should you do?

A. Use a TextBox control for the customer's name, a TextBox control for the invoice number and a

TextBox control for the product code.

B. Use a DropDownList control for the customer's name, a DropDownList control for the invoice

number and a DropDownList control for the product code.

C. Use a DropDownList control for the customer's name, a TextBox control for the

invoice number and a DropDownList control for the product code.

D. Use a TextBox control for the customer's name, a TextBox control for the

invoice number and a DropDownList control for the product code.

Answer: C

 

NO.7 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. The design of applications forms

part of your responsibilities at operates as an examination Web site. You are developing a Web-based

application for This application, upon completion, should allow users to take various online examinations.

Every time a user takes on online test, you want the following business rules to be met:

1. Display a congratulatory message when a user passes a test.

 

NO.8 Display a motivational message when a user fails a test.

 

NO.9 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their application

development platform. You use a Microsoft Windows XP Professional client computer named Certkiller

-WS547 as your development computer. Internet Information Services (IIS) is installed on Certkiller

-WS547. You are developing a Web-based client application for the Web site.

The Web site sells subscriptions to courseware material. The Web application must allow users to browse

subscription options, to purchase subscriptions, to add subscriptions to a wish list, to store bank account

details, and to review products online. You must implement a standardized layout on each page. You must

also ensure that all controls maintain a consistent appearance according to the company's branding.

What should you do?

A. Implement Themes and Master Pages.

B. Implement Web Parts and User Controls.

C. Implement User Controls and Profile properties.

D. Implement Web Parts and Master Pages.

Answer: A

 

NO.10 You work as an ASP.NET developer at uses the Microsoft Visual Studio.NET 2005 as their

application development platform. runs all its Web applications on a Windows Server 2003 Web server

named Certkiller -SR24. All Web applications on Certkiller -SR24 are hosted in Internet Information

Services (IIS). IIS 6.0 is installed on Certkiller -SR24. You use a Microsoft Windows XP Professional client

computer named Certkiller -WS547 as your development computer. IIS 5.0 is installed on Certkiller

-WS547. You are developing a Web-based client application for the Web site.

The Web site sells subscriptions to courseware material. The courseware

that is available from includes recently developed instructional videos.

Your Web application must make these videos available to subscribers. The Web application

must include a multimedia delivery mechanism must support all bandwidths, including dial-up.

Subscribers must also be able to watch portion of the video without downloading it completely. You

want to ensure that download speeds are as close to real-time as possible and that the download

process has a minimal impact on the overall performance of the Web application. What should you

do?

A. Use Internet Information Services (IIS) to stream each video as requested by

the subscriber. B. Cut the videos into smaller files. Use Internet Information Services (IIS) to

download each file completely and play that file before downloading the next file.

C. Use Microsoft Windows Media Services to stream each video as requested by the

subscriber.

D. Cut the videos into smaller files. Use Microsoft Windows Media Services to download each file

completely and play that file before downloading the next file.

Answer: C

 

NO.11 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. Your responsibilities at include the

design and development of applications. operates as retailer. You are currently developing an application

for This application, upon completion will be used to process, validate, and approve credit card purchases.

This application will make use of an unmanaged COM component. You now need to ensure that the

application will release the COM component resources as soon as the client application is finished using it.

To this end you need to make implement the appropriate interface.

What should you do?

A. Implement the IContainer interface.

B. Implement the IBindingList interface.

C. Implement the IComponent interface.

D. Implement the IDisposable interface.

Answer: D

 

NO.12 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. Your responsibilities at include the

design and development of applications. operates as an online-retailer.

You are currently developing a component for CertK ign.com. This component will be used to log the raw

HTTP request and response for a Web application. You need to ensure that the component will (1) be

modular and (2) provide extensibility to log other information in future. You need to make a decision as to

which design pattern you should use to meet the requirements of this component.

What should you do?

A. Use an Observer

B. Use a Front Controller

C. Use an Intercepting Filter

D. Use a Page Controller

Answer: C

 

NO.13 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. Your responsibilities at include the

design and development of applications. offers its customers financial and accounting services.

You are developing a Web-based application for This application will allow the employees to manage

their investments and retirement benefits. With this application employees will be able to investigate

various hypothetical scenarios to determine the best investments options. The calculation used in this

application is rather complex and based on a common calculation algorithm. To this end you decided to

provide other developers with a component to encapsulate the algorithm and basic user interface

elements. Following are the requirements that your component should meet:

1. The component must display two TextBox Web server controls.

2. The component must display one Button Web server controls.

3. The component must be available only to your application for security reasons.

4. The component must be available in the Visual Studio designer.

You thus decide to design the component to implement the IComponent interface.

And now you need to make a decision as to whether the solution will meet the requirements.

What conclusion can you draw?

A. All the requirements will be met.

B. None of the requirements will be met.

C. Only the requirement stating that the component should be available in the Visual Studio designer will

be met.

D. Only the requirements stating that the component must display two TextBox-, and

one Button Web server control, will be met.

Answer: C

 

NO.14 Display a different message when a user meets the minimum requirements for a test.

The following Exhibit illustrates the pseudo-code that you wrote to meet these

requirements:

Exhibit: if pass display congratulatory message else if meeting minimum requirements display different

message else display motivational message

What conclusion can you draw?

A. None of the requirements will be met.

B. All the requirements will be met.

C. All requirements, except the display of a different message when the user meets

the minimum requirements, will be met.

D. All the requirements, except the display of the motivational message when a

user fails a test, will be met.

Answer: B

2.You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. The design of applications forms

part of your responsibilities at You are currently developing Web-based applications for One of these

applications that you developed is destined to allow the user to displaymultiple lines in a TextBox control.

Each of the lines in the TestBox control is concatenated into a single string. Each message in the TextBox

control will consist of more than five lines. You now need to configure this Web-based application to meet

these requirements. What should you do?

A. You should include calling the Concat method in the application using a String instance.

B. You should include calling the Append method in the application using a String instance.

C. You should include calling the Add method in the application using a StringBuilder instance.

D. You should include calling the Append method in the application using a StringBuilder instance.

Answer: D

3.You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run Windows Server 2003. There is only one Web server at The

design of applications forms part of yourresponsibilities at operates as a manufacturing company.

You are currently developing Web-based applications for All the departments at will have its own Web

application for custom content and functionality that is department-specific. All these Web applications

make use of third party.NET 1.1 components.

These components are all shared by other Web applications within

You must meet the following requirements in your development of these Web-based applications:

1. The Web-based applications must require the shared components.

2. The Web-based applications must also require ASP.NET 2.0 features.

You should develop these applications with the least amount of developer effort

and time. To thisend you need to take a decision on how you will meet these requirements in your

solution.What should you do?

A. You should upgrade the shared components to.NET 2.0

B. You should enable directory browsing on the Web Server to access the shared

components.

C. You should place the shared components in the same directory as the main Web

application.

D. Since ASP.NET 2.0 Web applications are compatible with.NET 1.1 components you

should notdo anything.

Answer: D

 

NO.15 You work as the Enterprise application developer at The network consists of a single Active Directory

domain named All servers in the domain run

Windows Server 2003. Your responsibilities at include the design and development of applications.

operates as a construction company that specializes in erecting and maintaining projects.

You are currently creating an ASP.NET Web-Based application for This application will be used to view

current and historical information regarding each project.

This application accesses project information that is stored on a table within a relational database.

You design the Project class to represent the commercial construction project.

Each project is tracked by means of a unique project identifier. This identifier is also assigned

to projects prior to the commencement of a project and prior to resources being assigned to it. You now

need to design the interface of the Project class in such a way as to ensure that the project identifier is

assigned.

What should you do?

A. Randomly generate a unique project identifier in the default constructor.

B. Randomly generate a unique project identifier in the default constructor.

Accept the project identifier as a parameter in an overloaded constructor.

C. Call a stored procedure to increment the unique project identifier in the default constructor.

D. Call a stored procedure to increment the unique project identifier in the

default constructor.

Accept the project identifier as a parameter in an overloaded constructor.

Answer: D