70-447 試験問題を無料オンラインアクセス

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for a SQL Server 2005 computer named SQL01. There are five databases in the company. All of them run on a single SQL Server 2005 instance. In order to minimize the amount of time required and the amount of space used in the user databases when creating and rebuilding indexes, all indexes are created with the use of the SORT_IN_TEMPDB option. You are asked to design the tempdb database for optimal performance. What action should you perform?

• A.The tempdb database needs to be placed on a different RAID-0 volume from the user databases.
• B.The tempdb database needs to be placed on a different RAID-5 volume from the user databases.
• C.The tempdb database needs to be placed on the same RAID-0 volume as the user databases.
• D.The tempdb database needs to be placed on the same RAID-5 volume as the user databases.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You are in charge of managing 10 SQL Server 2005 computers in the company. Microsoft Windows Server 2003, Enterprise Edition is run by all the ten computers. All Group Policy object (GPO) deployments are handled by Microsoft Active Directory administrators of the company. A security template named SQL05_Security.inf has been deployed by the Active Directory administrators. The template has the appropriate settings to meet the security policy of the company. In order to make sure that the security policy is met, you have to identify the existing configuration of each SQL Server 2005 computer. What action should you perform?

• A.You should analyze the SQL05_Security.inf security template by using the Security Template snap-in.
• B.For the Network Interface performance object, counter logs should be created by using the Performance Logs and Alerts snap-in.
• C.You should capture a detailed report of the types of network traffic on the local network adapter by using Network Monitor on each SQL Server 2005 computer.
• D.You should find out discrepancies between system settings and database settings by using the Security Configuration and Analysis tool on each SQL Server 2005 computer.

You are adding functionality for the MarketingAnalysis database, and the functionality has the results of a query in an e-mail message sent to the marketing supervisors when new sales data has been entered. A method should be implemented to satify this requirement, and the security risks should be cut to the least. Which method should be utilized to achieve the goal?

• A.To achieve the goal, a command line program that is called by xp_cmdshell should be utilized.
• B.To achieve the goal, a managed stored procedure should be utilized.
• C.To achieve the goal, SQL Mail should be utilized.
• D.To achieve the goal, Database Mail should be utilized.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You receive report from users saying that a SQL Server 2005 application makes no response for several seconds at a time during the day. This problem happens at random throughout the day and many users are affected at once. You check at the time that the problem happens. You find that both CPU utilization and disk utilization on the SQL Server 2005 computer are low, but that the network is operating normally. Therefore, you have to examine additional information that is related to the problem. What action should you perform?

• A.You have to check the sys.dm_tran_locks dynamic management view (DMV).
• B.You have to check the total number of lock requests on the SQL Server 2005 computer.
• C.You have to check the output of the DBCC SQLPERF(IOSTATS) command.
• D.You have to check the total number of index and table scans on the SQL Server 2005 computer.
• E.You have to check the output of the DBCC SHOWCONTIG command.

After check, you find that because of a careless deletion at 11:45, all inserts and updates in the internet_rentals database from the last two days were lost. Now it is 11:58.
In order to recover the data that are lost, you have to perform a point-in-point restore. After you complete the restore, you intend to limit the amount of data loss. Your database, transaction log, and all backups can be accessed. After you take the database offline, what action should you perform?
(Choose the appropriate actions and put them in the correct order.)
1.Perform the back up of the active portion of the transaction log.
2.Restore the latest full backup, and the WITH NORECOVER option should be used.
3.Restore the latest differential backup, and the WITH NORECOVER option should be used.
4.Restore the final transaction log backup, and the WITH RECOVERY and STOPAT options should be used.
5.Restore all but the final transaction log backups that have occurred since the latest full backup, and the WITH NORECOVER option should be used.
6.Restore all but the final transaction log backups that have occurred since the latest different backup, and the WITH NORECOVER option should be used.

• A.4, 2, 6, 3
• B.2, 5, 1. 6
• C.5, 4, 3, 1
• D.6, 3, 5, 4
• E.5, 1, 6, 4