Online Access Free 70-447 Exam Questions

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 administer a SQL Server 2005 computer named SQL01.A database named AssetTrack is hosted on SQL01. The company CIO assigns a task to you. You have to work out a strategy to quickly perform point-in-time and page-level restores of the AssetTrack database. What should you do? (Choose more than one.)

• A.A backup strategy should be designed. This strategy should involve full and differential backups.
• B.A backup strategy should be designed. This strategy should involve full and transaction log backups.
• C.The Recovery model database option should be configured as Simple.
• D.The Restrict access database option should be configured as Restricted.
• E.The Recovery model database option should be configured as Full.

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. There is a SQL Server 2005 database on a server named S1. According to the company requirement, you are configuring this database to use a CLR user-defined type. The CLR user-defined type needs to access a configuration file on a server named S2. You use the default permission set to create a CLR assembly. But the assembly returns a security error is returned by the assembly at the time that the CLR user-defined type is called on S1. You have to correct the problem. So what action should you perform to achieve the goal?

• A.The assembly should be changed to use the UNCHECKED DATA option.
• B.The assembly should be changed to use the SAFE permission set.
• C.The assembly should be changed to use the VISIBILITY = ON option.
• D.The assembly should be changed to use the EXTERNAL_ACCESS permission set.

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 administrator of a SQL Server 2005 computer. And recently the server performs gradually slowly. The indexing environment is troubleshooted by you. The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The most frequently accessed nonclustered index will be optimized by you. The sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the results from the table listed below.

When the entire index is not read, the nonclustered index which is being utilized the most frequently should be identified. From the following four object_id and index_id combinations, which one should be utilized to finish the task?

• A.To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
• B.To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
• C.To finish the task, the object_id 869578136 and the index_id 5 should be utilized.
• D.To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
• E.To finish the task, the object_id 309576141 and the index_id 1 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 administrator of a SQL Server 2005 computer, and the computer is named SQL1. The company has backups of all system databases performed every Saturday night, and have backups of all user databases performed every Sunday night. And the company has all backups stored in an off-site facility. Because of the power outage, SQL1 accidentally turns off. And after bringing SQL1 back online, the users cannot start the SQL Server service. You can see the SQL Server error log from the exhibit below. SQL1 should be returned to working order in the shortest time. Which action should be performed first?

• A.All of the user databases should be restored from backup.
• B.All of the system databases should be restored.
• C.Setup.exe should be run from a command line and a rebuild of the master database should be specified.
• D.The SQL Server 2005 installation CD should be inserted and the setup utility should be run to have the default instance reinstalled.

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 are a database administrator for your company. The company's manufacturing floor has three automated testing areas for finished items. Each testing area uses SQL Server 2005 to store test results. You need to develop a replication strategy to ensure that test results flow continuously from the testing areas to the central SQL Server as quickly as possible. The test results are used for reporting. What should you do?

• A.At each of the testing areas, a separate snapshot publication should be created for the test results. On the central server, a pull subscription should be created to each of the testing area publications.
• B.At each of the testing areas, a separate snapshot publication should be created for the test results. On each distributor, a merge subscription should be created to the central server.
• C.At each of the testing areas, a separate transactional publication should be created for the test results. On each of the testing areas, push subscriptions should be created to the central server.
• D.At each of the testing areas, a separate transactional publication should be created at each of the testing areas for the test results. On each distributor, a merge subscription should be created to the central server.