MCTS: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431

With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005

Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam.

Get a great start in your certification process today with this comprehensive guide which includes:

• Hundreds of challenging practice questions plus two bonus exams
• Leading-edge exam preparation software, including a test engine

Authoritative coverage of all key exam objectives, including:

• Installing and Configuring SQL Server 2005
• Implementing High Availability and Disaster Recovery
• Supporting Data Consumers
• Maintaining Databases
• Monitoring and Troubleshooting SQL Server Performance
• Creating and Implementing Database Objects

QUESTION 1
You create a reporting application for Certkiller ’s Travel. You create several reports, each of which
resides in its own folder under the Report folder. Each subfolder has the appropriate security rights sets
for Microsoft Windows users.
You write a function named ListReports that generate a list of available reports. You want to configure
the application and the ListReports function to find out which reports are available to the current user.
If a user is logged in by using Windows authentication, you want ListReports to apply that user’s rights.
If the user is not logged in by using Windows authentication, you want ListReports to use the rights
granted to the Certkiller travel\ReportingAccount user account. The password for this user accounts is
“p1 CertK i32″
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

Actualtests.org – The Power of Knowing
A. Add the following element to the Web.config file:

B. Add the following element to the Web.config file.

C. Add the following element to the Web.config file:
userName="margiestravel\ReportingAccount"
password=" p1 CertK i32">
D. Add the following element to the Web.config file:



E. Add code to the ListReports function to create and use a WindowsPrincipal object based on the
Certkiller travel\ReportingAccount user account only if no user is authenticated.
F. Add code to the ListReports function to always create and use a WindowsPrincipal object based on the
Certkiller stravel\ReportingAccount user account.
Answer: B, E
Explanation:
B: We use the impersonate attribute of the identity element to specify that client impersonation is used on
each request. We should use the value true.
E: If no user is authentication then we run the ListReports function in the security context of the
Certkiller travel\ReportingAccount user account.
Reference: Designing Distributed Applications with Visual Studio .NET, ASP.NET Impersonation
Incorrect Answers
A: We should specify that impersonation is used. The value should be set to true, not to false.
C: This enables the entire application to run as Certkiller travel\ReportingAccount, regardless of the identity
of the request, so long as the password is correct.
D: This enables the Certkiller travel\ReportingAccount user account to run the application. This is not
required.
F: We only want to use impersonation if the user is not logged on.
QUESTION 2
You are a Web developer for a museum. The museum has a Microsoft SQL Server database that contains
information about science experiments. The database currently contains information on 5,000
experiments. The information is updated monthly.
You are creating an ASP.NET application for users to find information about specific experiments. The
application will run on a server that is connected to the database by a low-bandwidth leases line.
You want to accomplish the following two goals:
• Minimize the number of times the application accesses the database.
• Minimize the time required for each page of the application to load.
What should you do?

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Actualtests.org – The Power of Knowing
A. Initialize the DataSet object in the Page.Load event handler when the IsPostBack property is false.
Store the DataSet object in an XML file on the user’s computer.
B. Create a Cache object for the application and add the DataSet object to the cache.
C. Use the view state to maintain the DataSet object during postback events to the server.
D. Create a Cache object for the session and add the DataSet object to the cache.
Answer: B
Explanation: The database is only updated monthly. Therefore we can store the dataset in the Application
Cache with out the need for that extra over head of reading and writing into the XML file client computer for
every session (not A).
QUESTION 3
You create an ASP.NET application for a hotel. The application contains a page that displays current
weather conditions for the city in which the hotel is located. The application calls an XML Web service
every 10 minutes to update the current weather conditions. A new page is then displayed for subsequent
requests.
You want the same page to be cached and retrieved from the cache during the time between calls to the
XML Web service. You decide to use a Page directive to accomplish this goal.
Which page directive should you use?
A. < %@ Cache Seconds="600" VaryByParam="page" %>
B. < %@ OutputCache Time="600" %>
C. < %@ OutputCache Duration="600" VaryByParam="None" %>
D. < %@ OutputCache Duration="600" %>
Answer: C
Explanation: To set output-cache expirations for a page declaratively include an @ OutputCache directive in
the page (.aspx file) that you want to output cache. The directive must include a Duration attribute, with a
positive numeric value, and a VaryByParam attribute. The following @ OutputCache directive sets the page’s
expiration to 10 minutes (600 seconds).
< %@ OutputCache Duration="600" VaryByParam="None" %>
Reference: .NET Framework Developer’s Guide, Setting Expirations for Page Caching [C#]
Incorrect Answers
A, B: We should use the Duration attribute, not the Seconds or the Time attribute, to specify the output-cache
expiration for a page.
D: We must use a VaryByParam attribute-
Free download:pass4sure Microsoft 70-431
Free download:testking Microsoft 70-431

password:www.certbible.org

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.Contact Us:Sales@PassGuide.com

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
PDF	All Certbible 's Exam Dumps	597	1 days ago	Available

PassGuide Training Materials & Practice Tests

• 70-686
• 70-685
• Microsoft Certified IT Professional (MCITP)
• preplogic microsoft
• testout microsoft mcitp
• 70-454
• Microsoft Certifications Exams
• pass4sure microsoft mcitp 70-649 value pack
• pass4sure microsoft mcitp 70-647 Value Pack
• Microsoft Certifications for IT Professionals mcitp