Lesson Review Tqa
The following questions are intended to reinforce key information presented in this lesson. The questions are also available on the companion CD if you prefer to review them in electronic form.
NOTE Answers
Answers to these questions and explanations of why each choice is right or wrong are located in the "Answers" section at the end of this book.
1. What is the connection string's key/value pair for using Windows Authentication in SQL Server 2000 and SQL Server 2005? (Choose all that apply.)
A. Integrated security = yes
B. Integrated Security =SSPI
C. Integrated Security = True
D. Trusted_Connection = Yes
2. If you must use a user name and password to connect to a database, where should you store the sensitive information?
A. Compiled in the application
B. In an encrypted application configuration file
C. In a resource file deployed with the application
D. In the registry
3. What is the recommended method for securing sensitive connection string information?
A. Encrypting the data in the application configuration file
B. Using a code obfuscator
C. Using integrated security (Windows Authentication)
D. Querying the user for his or her credentials at run time
Post a comment