pass4sure Microsoft Partner Competency exam 74-138 v2.93

Plan&Build a Msg&Collab Envir Usin MS Off Sys&Win Serv : 74-138 Exam

Exam Number/Code: 74-138
Exam Name: Plan&Build a Msg&Collab Envir Usin MS Off Sys&Win Serv
VUE Code: 74-138
Questions Type: Multiple choice,
Exam Language(s): English

“Plan&Build a Msg&Collab Envir Usin MS Off Sys&Win Serv”, also known as 74-138 exam, is a Microsoft certification.
Preparing for the 74-138 exam? Searching 74-138 Test Questions, 74-138 Practice Exam, 74-138 Dumps?

With the complete collection of questions and answers, Pass4sure has assembled to take you through 61 questions to your 74-138 Exam preparation. In the 74-138 exam resources, you will cover every field and category in Microsoft Partner Competency exam helping to ready you for your successful Microsoft Certification.

A candidate for this exam should have a minimum of one year’s experience designing, planning, managing, and building team collaboration solutions that use Microsoft Windows SharePoint Services and Microsoft Live Communications Server. A typical environment is the medium-sized organization that has 250 to 500 client computers, multiple locations, with Active Directory.
QUESTION 1
You create an ASP.NET application that is deployed on Certkiller ’s intranet. Sales representatives use
this application to connect to a database while they are speaking to customers on the telephone. Your
code is running under the security context of the user who requested the page.
The application requires each sales representative to supply a unique user name and password to access
the application. These individual user names and passwords are included in the ConnectionString
property settings that your code uses to connect to the database. All users have the same access rights to
the database.
Sales representatives report that it takes a long time to access the database. You test the application and
discover that a new connection is created each time a sales representative connects to the database.
You want to reuse connections in order to reduce the time it takes to access the database.
What should you do?
A. Modify the connection string to specify Windows Integrated authentication.
B. Modify the connection string to increase the connection timeout setting.
C. Modify the connection string so that is uses a single application user name and password for every
connection to the database.
D. Modify the connection string so that is uses a login user named that is a member of the sysadmin fixed
server role.
Answer: C
Explanation: In order to avoid the creation of a new connection we should a single application user name and
password.
Incorrect Answers
A: Windows Integrated authentication would still require a separate connection for each user.
B: Increasing the timout setting would increase the connection time. However, a new connection would still
be created for each user.
D: Running the connection in the security context of the sysadmin role would be a security risk.
QUESTION 2:
As a software developer at Certkiller you create an ASP.NET application for online ordering. You need to
store a small amount of page-specific information on pages that are submitted to the server. This
information does not need to be secured. The page must work properly for browsers that do not support
cookies. You anticipate that the volume of orders on the site will be high, and you need to conserve server
resources.
What should you do?
A. Store the information in application state variables.
B. Store the information in session state variables.
C. Store the information in a Microsoft SQL Server database.

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Actualtests.org – The Power of Knowing
D. Store the information in hidden fields on the page.
Answer: D
Explanation: The advantages of hidden fields are
• No server resources are required. Server resources will be conserved.
• Broad support. It will work on browsers that do no support cookies.
The lack of security, a drawback of hidden fields, is not a problem, since the information does not need to be
secured.
Note: State management is the process by which you maintain state and page information over multiple
requests for the same or different pages. ASP.NET provides multiple ways to maintain state between server
round trips.
Reference: Visual Basic and Visual C# Concepts, State Management Recommendations
Incorrect Answers
A: We want to conserve server resources, so we should avoid using application state variables. Application
state requires server memory, which can affect the performance of the server as well as the scalability of
the application.
B: Session state variables stay in memory until they are either removed or replaced, and therefore can
degrade server performance.
C: We do not need a complex SQL Server solution.
QUESTION 3
You are developing an ASP.NET application for Certkiller ’s intranet. Employees will use the application
to administer their employee benefits. The benefits information is stored in a Microsoft SQL Server
database named Benefits.
An employee can select benefits options from 10 different drop-down list boxes. The values for each list
are stored in separate tables in the Benefits database. The values that are available for employees to
choose can change once each year during the benefits enrollment period.
You want to minimize the number of times your application must access the Benefits database to obtain
the values for the drop-down list box.
Which two courses of action should you take? (Each correct answer presents part of the solution. Choose
two)
A. Create one stored procedure that returns the result for all 10 drop-down list boxes.
Create one DataTable object for each of the 10 drop-down list boxes.
Use a SqlDataReader object to populate 10 DataTable objects by calling the NextResult() method.
Bind the drop-down list boxes to the DataTable objects.
B. Create a stored procedure that returns the result set for all 10 drop-down list boxes.
Bind the drop-down list boxes to the DataReader object.
C. Create one DataTable object for each of the 10 drop-down list boxes.
Create a stored procedure for each of the 10 tables.
Use a SqlDataReader object to populate the 10 DataTable objects.
Bind the drop-down list boxes to the DataTable objects.
D. Store the result sets for the 10 drop-down list boxes in a DataSet object.
Add the DataSet objects to the Cache object for the application.

Actualtests.org – The Power of Knowing
E. Store the result sets for the 10 drop-down list bikes in a file on the user’s computer by using the
DataSet.WriteXml() method.
Answer: A, D
Explanation:
A: We want to use a single result set provided by a single stored procedure. We are able to use the
NextResult() method to retrieve each result in the result set.
We also need one DataTable for each drop-down list box and one SqlDataReaderObject.
Note: The SqlDataReader.NextResult method advances the data reader to the next result, when reading
the results of batch Transact-SQL statements.
D: We use a DataSet object to store the result sets for the drop-down list boxes. We cache the result by
adding the DataSet object to the Cache object.
Reference:
.NET Framework Class Library, SqlDataReader Class [C#]
.NET Framework Class Library, SqlDataReader.NextResult Method [C#]
Incorrect Answers
B: You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a
database. However, in this scenario we should use SqlDataReader.
C: It would be more effective to create a single stored procedure that returns a single result set.
E: A cache object is preferred to a file in this scenario.

Free download:pass4sure Microsoft 74-138
Free download:testking Microsoft 74-138

password:www.certbible.org

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.Contact Us:Sales@PassGuide.com

Type	Exam Bible	New Questions & Answers	Latest Updated	Download link
PDF	All Certbible 's Exam Dumps	597	1 days ago	Available

PassGuide Training Materials & Practice Tests

• Download Pass4sure Microsoft Microsoft Windows Vista, Configuring
• Pass4sure Microsoft Exam mb2-631 v2.73
• pass4sure Microsoft Business Solutions Exam MB2-632 v2.83
• Pass4sure Microsoft TS 70-649 Exam v2.85
• Microsoft Pass4Sure 70-526 v2 73 2008-04-30 by Moataz G Salama 82q.vce
• p4s microsoft 70-290 corrections
• Microsoft Pass4Sure 70-291 v2008 by Mahmoud Manchester 104q.vce
• Microsoft Pass4Sure 70-640 by Hazem hafez 84q.vce
• (offer) Pass4sure Microsoft 70-270 Ver 2.93
• Microsoft Preparation Certification for Microsoft Candidates