MCSD.NET - 70-340 Exam Question:
Download Questions PDF

Suppose You are an application developer for Company.com. You develop a Windows Forms application
that connects to a local Microsoft SQL Server database by using the Microsoft .NET Framework
Data Provider for SQL Server. The application currently connects to the database by using an
account that is a member of the System Administrator role in SQL Server.
You need to ensure that the application can connect to the database by using the user account of
the interactive user without providing additional permissions.
What should you do?
A. Modify the application to activate a SQL Server application role.
B. Modify the application to use SQL Server integrated security.
C. Modify the application to send a security token that contains the authentication information in a
Kerberos ticket.
D. Modify the application to use a COM+ security roles.

MCSD.NET - 70-340 Exam Interview Question
MCSD.NET - 70-340 Exam Interview Question

Answer:

B. Modify the application to use SQL Server integrated security.

Download MCSD.NET - 70-340 Exam Interview Questions And Answers PDF

Previous QuestionNext Question
Suppose You are developing a three-tier application.
You enter sample data to exam the application. The following exception is caught by the data
layer before the application continues to run. Cannot set column ?Column1? to ?Text too long for
maximum length?. The value violates the MaxLength limit of this column.
You need to improve the security of the application. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two)
A. Increase the maximum length of data characters allowed in the column.
B. Validate all incoming data character lengths at the business layer.
C. Modify the data layer to process data above the maximum length.
D. Modify the user interface to prevent users from entering data above the maximum character
length.		Suppose A. Create a new application domain and set the security policy level. Run custom components in
this application domain.
B. Use permission class operations to modify the security policy.