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:

PassGuide Cisco Exams Questions & Training Materials

1. Free CBT Nuggets – Exam-Pack 70-431 SQL Server 2005 Implementation and Maintenance
2. Free CBT Nuggets SQL Server 2005 Implementation and Maintenance Exam-Pack 70-431
3. Free MCSE: Windows Server 2003 Active Directory Planning, Implementation, and Maintenance Study Guide (70-294)
4. Free MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide (Paperback)
5. Free MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442
6. Free MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (All-in-One) (Hardcover)
7. Free MCSA/MCSE: Windows Server 2003 Environment Management and Maintenance Study Guide (70-290)
8. Free CBT Nuggets Exam-Pack 70-443: Designing a Database Server Infrastructure Using Microsoft SQL Server 2005
9. Free Microsoft SQL Server 2005: Changing the Paradigm
10. Free MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
11. Free Microsoft Dynamics CRM 4.0 Implementation Guide (IG) 4.2.0 Available
12. Free AppDev Microsoft SQL Server 2005 .20 CDS