Free Microsoft 070-447 Exam Dumps Questions & Answers

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. Your job is to manage a SQL Server 2005 database, and there are several indexes in the SQL Server 2005. A stored procedure should be written, and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements, which one should be utilized achieve the goal.

• A.  To achieve the goal, SELECT * FROM sys.indexes should be utilized.
• B.  To achieve the goal, DBCC INDEXDEFRAG should be utilized.
• C.  To achieve the goal, SELECT * FROM sys.dm_db_index_physical_stats should be utilized.
• D.  To achieve the goal, DBCC DBREINDEX should be utilized.

The code is being reviewed, and the code is utilized to retrieve order data in the ASP.NET Web application. The application should be updated to satisfy the security requirements. Which action should you perform?

• A.  A SQL Server login that has a complex password should be created, and the ASP.NET code should be changed to connect by utilizing the SQL Server login.
• B.  An HTTP endpoint that has BATCHES enabled should be created, and the ASP.NET code should be changed to connect to the HTTP endpoint.
• C.  A view should be created to retrieve the order data, and then, the table name should be replaced with the view name in the ASP.NET code.
• D.  A stored procedure should be created to retrieve the order data, and the ASP.NET code should be changed to call the stored procedure by utilizing parameters.

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 a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator, you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition, you need to make sure that this data is replicated securely. Which action should be performed?

• A.  Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.
• B.  Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for a standard subscription.
• C.  Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for an updateable subscription.
• D.  Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.

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, the msdb database should be backed up.
• B.  To finish the task, your server should be set to utilize the full recovery model.
• C.  To finish the task, your server should be set to utilize the bulk-logged recovery model.
• D.  To finish the task, the Products database should be backed up.

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. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly.
SELECT * FROM Orders WHERE OrderStatus = 'InProgress'
This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least.
Which action should be performed to finish the task?

• A.  To finish the task, an indexed view of the Orders table should be viewed.
• B.  To finish the task, the index should be recreated to have all of the columns in the table included.
• C.  To finish the task, the index should be built by utilizing a FILLFACTOR of 10 percent.
• D.  To finish the task, the statistics should be updated on the index.