• Description: Microsoft 70-441 Designing Database Solutions by Using MS SQL Serv 2005
• Passing Score: 75%
• Practice Test - Number of questions: 71 questions
• Simulation Test - Number of questions: 71 questions
• Simulation Test Duration: 41 minutes
• Has explanations: Yes

You are designing the application solution. You need to specify the base table permissions that will be granted to application users. Your solution must fulfill all business and technical requirements. What should you do?

Answer(s)

1. Specify that end users must have no permissions on base tables.
2. Specify that end users must have only read permission on base tables.
3. Specify read and write permissions on base tables for a specific user account that will be used by client applications that connect to the database.
4. Specify all permissions on base tables for a specific user account that will be used by client applications that connect to the database.

Specify that end users must have no permissions on base tables.