Prüfungsfragen und antworten 70-432 Microsoft

SAP ABAP,zertifizierung-portal.de,SAP Certified Associate,SAP Certified Development Associate,SAP Application Associate,SAP-Certifications,SAP Certified Application Associate,SAP Certified Application Professional,SAP Certified Development Professional, SAP Certified Technology Associate, SAP Certified Technology Professional

70-432 TS:MS SQL Server 2008,Implementation and Maintenance Die rasante Entwicklung im Bereich der Informationstechnik macht es zwingend, sich regelmäßig fortzubilden. Weisen Sie Ihr IT-Können nach, absolvieren Sie Ihre Prüfung. Bei Ihrer Zertifizierungsvorbereitung werde Ihnen zertifizierung-portal.de sehr gut helfen.

Prüfungsfragen und antworten 70-432 Microsoft

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

Prüfungsfragen und antworten 70-432 Microsoft