Pass with professional 070-447 actual quiz materials

Microsoft 070-447 Exam Overview:

Microsoft 070-447 Exam Syllabus Topics:

Microsoft UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005 Sample Questions:

Question 1

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 a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services (SSIS) packages are utilized to export data from the Products database to a text file.
You deliver the text file to your company's trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task?

A. To finish the task, your server should be set to utilize the bulk-logged recovery model.
B. To finish the task, your server should be set to utilize the full recovery model.
C. To finish the task, the Products database should be backed up.
D. To finish the task, the msdb database should be backed up.

Question 2

Question 3

A most proper archiving strategy for the SalesData.Orders table in the Sales database should be identified. The archiving strategy should be implemented with the least amount of effect on performance. Which action should be performed?

A. First, a database snapshot of the Sales database should be created every three months, and then a DELETE statement should be utilized to remove archived data from the SalesData.Orders table.
B. First, a table named ArchivedData.Orders should be created. Second, the SalesData.Orders table and its indexes should be partitioned. At last, MERGE, SPLIT, and SWITCH functions should be utilized every three months to remove old order data into ArchivedData.Orders.
C. First, a table named ArchivedData.Orders should be created. Second, an INSERT statement will be utilized to copy data from the SalesData.Orders table into ArchivedData.Orders every three months. At last a DELETE statement should be utilized to remove archived data from SalesData.Orders.
D. First, the Sales database should be backed up to tape every three months, and then a DELETE statement should be utilized to migrate archived data from the SalesData.Orders table.

Question 4

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. A new stored procedure is created by you. You find an error when running the stored procedure. The company asks you to collect and process any error information that is generated while running the procedure. Error logging must use the least possible resources while providing the needed functionality. You have to find out what caused the error. The appropriate error functions need to be included in the new stored procedure. What action should you perform?

A. The @@error function should be used.
B. A GOTO statement should be used.
C. The XACT_ABORT command should be set to off.
D. TRY...CATCH blocks should be used.

Question 5

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. 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.
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. 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.

Solutions: