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

Suppose You are validating the physical design of a data a data layer class that will return a set of time
entries from the timesheet database. This class will be used by the Web application for Team
Leads and Business Planners and, indirectly, by the new timesheet application.
The class must use connection pooling, and it must be as secure and as flexible as possible. You
need to specify a Microsoft SQL Server authentication strategy that meets these requirements.
Which strategy should you use?
A. The data class uses SQL Server authentication with an application specific SQL Server
account. The account name and password are embedded in a connection string
B. The data class uses Windows authentication when connecting to the database and
impersonates a specific account created for operations on the database
C. The data class uses Windows authentication when connecting to the database and
impersonates the application user
D. The data class uses SQL Server authentication with the SQL Server sa account

Answer:

B. The data class uses Windows authentication when connecting to the database and impersonates a specific account created for operations on the database

Download MCSD.NET - 70-300 Interview Questions And Answers PDF

Previous QuestionNext Question
Before you release the solution, you need to develop a process to validate and enforce an
appropriate level of quality. Which three statistics should you use?
(Each correct answer presents part of the solution)
A. Number of defects per component
B. Number of defects per thousand lines of source code
C. Number of defects by developer
D. Percentage of successful builds
E. Percentage of requirements tested
F. Number of defects detected to date
G. Number of defects corrected to date.
Suppose You are creating the physical design for the customer category data model. For reporting
purposes, you want to optimize access to customer category data. You define a Customer table
and a Category table. What should you do next?
A. Define three foreign key columns in the Category table, such that each column references a
different parent row in the Customer table. Define indexes on the foreign key columns.
B. Define three foreign key columns in the Customer table, such that each column references a
different parent row in the Category table. Define indexes on the foreign key columns.
C. Define a foreign key column in the Category table that references the parent row in the
Customer table. Define an index on the foreign key column.
D. Define a foreign key column in the Customer table that references the parent row in the
Category table. Define an index on the foreign key column.