70-548 Designing and Developing Windows-Based Applications by Using the Microsoft .NET Framework Practice Exam

Demo Question 1.

You work as the Enterprise application developer at EliteCertify.com. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. All servers in the domain run Windows Server 2003 and all client computers run Microsoft Windows XP Professional. Your responsibilities at EliteCertify.com include the deployment and support of Applications. EliteCertify.com operates as a College of Education. The EliteCertify.com development team is currently developing a Microsoft Windows Form Student application. This application is intended to help the EliteCertify.com administrations staff to allow students to register for the year of study, place them in their courses, place them with the respective lecturers teaching those courses, providing each student with a user name and password for the duration of their studies. This application will store student data in a Microsoft SQL Server 2005 database. The EliteCertify.com company policy states that user names and passwords cannot be stored in any installation program. When the application is installed, the database must be created. The installation program makes use of the Osql.exe utility to create the database. You now need to specify installation requirement of the application so that it will comply with the company policy. What should you do?

A. Specify that the user must run the installation program in the database server.
B. Specify that the user who runs the installation programs must have domain administrator rights.
C. Specify that the user who executes the installation program must have administrative access to SQL Server.
D. Specify that the application must be added to a code group that has full trust permissions.


Display Answer

Answer: C

Explanation: The user who executes the installation program must have administrative access to SQL Server. Thus you need to specify this as a requirement for the application. Incorrect answers: A. There is no need to specify that the user must run the installation program in the database server because the Osql.exe utility allows one to specify parameters such as database server name. B. There is no need to specify that the user that runs the installation program must have domain administrator rights because the user only requires administrative access to SQL Server to run the script to create the database successfully. D. There is no need to specify that the application must be added to a code group that has full trust permissions. Code access security does not affect unmanaged applications and Osql.exe utility is unmanaged.