최신 70-432 무료덤프 - Microsoft TS:MS SQL Server 2008,Implementation and Maintenance

문제1

You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
- Enable FILESTREAM for file I/O streaming access.
- Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
What should you do?

A. Configure the SQL Server service.

B. Configure the SQL Server Full Text service.

C. Modify the Background Intelligent Transfer Service settings.

D. Modify the Volume Shadow Copy settings.

정답: A

문제2

You administer a SQL Server 2008 cluster. You plan to test the failover response of the cluster.
You need to implement a manual failover on the cluster.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)

A. Use Encrypting File System (EFS) to encrypt the contents of a shared folder on the active node.

B. Remove the shared array from the active node.

C. Unplug the network cable(s) from the active node.

D. Restore a backup to the active node.

정답: B,C

문제3

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 SQL Profiler to recapture the workload to a trace file.

B. Use the data collector to recapture the workload.

C. Enable the XP_MSVER stored procedure on the local server.

D. Enable the XP_MSVER stored procedure on the remote server.

정답: A

문제4

You are a database administrator for your company. There are four automated testing
areas for finished items in the company's manufacturing floor. SQL Server 2008 is used to reserve testing results for every testing area. You should create a replication method to make sure that test results flow from the testing areas to the SQL Server quickly. The results of testing will be used on reporting. Which is the correct answer?

A. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a pull subscription on each distributor to the

B. You should develop a separate transactional publication at each of the testing areas for the test results. Develop push subscriptions on each of the testing areas

C. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a merge subscription on each distributor to the

D. You should develop a separate transactional publication at each of the testing areas for the test results. Develop a merge subscription on each distributor to the

정답: B

문제5

You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to a custom workload group named MyApp.
You need to monitor processor resources.
What should you do?

A. Use the sys.dm_resource_governor_workload_groups dynamic management view to monitor the CPU usage for the default workload group.

B. Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the MyApp workload group.

C. Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the default workload group.

D. Use the request_max_cpu_time_sec column of the sys.resource_governor_workload_groups catalog view.

정답: B

문제6

You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
---
It checks database integrity.
It rebuilds indexes.
It writes a report to a text file.
You need to modify the SQL Server instance such that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
What should you do?

A. Enable a fail-safe operator for the SQL Server Agent.

B. Modify the SQL Server Agent job that executes the database maintenance plan to notify the appropriate operators.

C. Modify the database maintenance plan to include a Notify Operator task that e-mails the appropriate operators.

D. Modify the database maintenance plan to e-mail a report to the appropriate operators.

정답: B

문제7

You administer a Microsoft SQL Server 2008 R2 instance.
A disk drive that contains the files for the database is lost. The drive has been replaced, but the data files have been irrevocably lost.
You need to restore the database.
What should you do?

A. Execute DBCC CHECKD

B. Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.

C. Examine the msdb..suspect_pagestable.

D. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.

E. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.

F. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.

G. Execute sp_helpfile.

H. Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.

I. Restore the database from the most recent full backup. Apply any differential and log backups.

정답: I

문제8

You administer a SQL Server 2008 instance that contains a database named Sales.
A SQL Server login named SalesAppLogin maps to a database user named SalesAppUser in the Sales database.
You need to ensure that the database user can perform only the following tasks:
- Execute all stored procedures that currently exist in the Sales database. - Execute all stored procedures that will be created in the Sales database.
What should you do?

A. Grant the appropriate database-level permissions to SalesAppUser.

B. Add SalesAppUser to the appropriate fixed database roles.

C. Grant the appropriate object-level permissions to SalesAppUser.

D. Grant the appropriate server-level permissions to SalesAppLogin.

정답: A

문제9

You administer a SQL Server 2008 instance.
You configure a single Database Mail profile that is used to send reports to all the
employees of your organization. The sp_send_dbmail stored procedure is used to send a
large volume of reports during business hours.
The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?

A. Create a separate Database Mail profile for the reports.

B. Configure the security settings of the Database Mail system.

C. Modify the SMTP relay settings.

D. Modify the parameters of the email that contains the reports.

정답: A

문제10

You administer a SQL Server 2008 instance. The server contains a very large database that is used by an application that is constantly available.
Users report that the server performance has degraded.
You need to use the Database Engine Tuning Advisor to improve the performance of the application.
You also need to ensure that the performance of the production server is unaffected while analyzing the workload.
What should you do?

A. Use the dta.exe utility on the production server along with an XML input file.

B. Enable the XP_MSVER stored procedure on the local server.

C. Configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file.

D. Enable the XP_MSVER stored procedure on the remote server.

정답: C

최신 70-432 무료덤프 - Microsoft TS:MS SQL Server 2008,Implementation and Maintenance

우리와 연락하기

유용한 링크

최신 업데이트