- certification questions testcenter 70-432
certification questions testcenter 70-432
IT Exam,IT Certification,braindump,original questions, question pool,document, braindump, test questions, test question, dumps, test answers, cert24.com, preparation, pdf, certification questions, answers Certification, certification test, practice test, exam dumps, certification training, answers real questions 
70-432 TS:MS SQL Server 2008,Implementation and Maintenance We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers , Core Administration. Our practice tests Administration are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.
certification questions testcenter 70-432
QUESTION 1
You administer a remote SQL Server 2008 instance.
Users report that the performance of the application is poor.
You use SQL Profiler to capture a workload of the remote instance to a trace table on the remote SQL Server instance.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server instance by using the Database Engine Tuning Advisor.
What should you do?
A. Use the data collector to recapture the workload.
B. Use SQL Profiler to recapture the workload to a trace file.
C. Enable the XP_MSVER stored procedure on the local server.
D. Enable the XP_MSVER stored procedure on the remote server.
Answer: B
QUESTION 2
You administer a SQL Server 2008 instance.
A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked.
Which tool should you use?
A. The Windows System Monitor tool
B. The Database Engine Tuning Advisor tool
C. The Activity Monitor tool in Microsoft SQL Server Management Studio
D. The Job Activity Monitor tool in Microsoft SQL Server Management Studio
Answer: C
QUESTION 3
You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications.
You configure the SQL Server Agent service to run by using the SERVER1\AGENT account.
You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use? A. Domain account
B. Local System account
C. Local Service account
D. Network Service account
Answer: A
certification questions testcenter 70-432