Online Access Free 070-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 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 309576141 and the index_id 1 should be utilized.
• B.To finish the task, the object_id 869578136 and the index_id 5 should be utilized.
• C.To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
• D.To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
• E.To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.

According to the performance and availability requirements of the company, you are asked to implement the new read-only copy of the internet_rentals database on SQL02. What should you do?

• A.On SQL02, a new database should be created. Between internet_rentals and the new database, transactional replication should be configured.
• B.On SQL02, a new instance of SQL Server 2005 should be installed. A new database should be created. Between internet_rentals and the new database, transactional replication should be configured.
• C.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, snapshot replication should be configured.
• D.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, transactional replication should be configured.
• E.A new SQL Server 2005 computer should be installed. Then a new database should be created on that server. Between internet_rentals and the new database, merge replication should be configured.

The DeliveryVans, AirlinePreferences, and SeasonalContractors databases should be removed into the data center. Which action should be performed?

• A.A SQL Server database should be created for each of the databases in a single instance of SQL Server 2005.
• B.A separate instance of SQL Server 2005 should be installed for each of the databases on a single server.
• C.A default instance of SQL Server 2005 should be installed on three separate servers. And then, one server should be utilized for each of the databases.
• D.The data should be imported from each of the databases into a single database in an instance of SQL Server 2005.

According to the company business and technical requirements, the changes to the existing firewall configuration settings should be specified. And the settings are required by the HTTP endpoint, and the HTTP endpoint will be utilized by the goldengenius_projects database. Which action should be performed?

• A.A Web publishing rule should be created on ISA1, and the rule permits HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.
• B.A Web publishing rule should be created on ISA2, and the rule permits HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
• C.A Web publishing rule should be created on ISA1, and the rule permits HTTP traffic on port 5017 from IIS1 to the SQL Server computer.
• D.A Web publishing rule should be created on ISA2, and the rule permits HTTPS traffic on port 5017 from IIS1 to the SQL Server computer.

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 output of the DBCC SQLPERF(IOSTATS) command.
• C.You have to check the total number of lock requests on the SQL Server 2005 computer.
• 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.