[Download] 70-447 Microsoft download 129-144 (Mar 2016)

70-447 Royal Pack Testengine pdf

100% Actual & Verified — 100% PASS

Unlimited access to the world's largest Dumps library! Try it Free Today!

Get it now →

Product Description:
Exam Number/Code: 70-447
Exam name: UPGRADE:MCDBA Skills to MCITP DB Admin by Using MS SQL 2005
n questions with full explanations
Certification: Microsoft Certification
Last updated on Global synchronizing

Free Certification Real IT 70-447 Exam pdf Collection

Question No. 129

You are a database administrator for Exambible.com. The company uses a SQL Server 2005 computer that runs Reporting Services. The server runs reports that include only data from the previous days sales. You discover that an OLTP database application runs slowly when reports are run during business hours and that reports sometimes time out. You need to correct the problem and prevent it from recurring. What should you do?

A.

A. Use the SQL Trace stored procedures to log database creation activity.

B. Create a stored procedure. Configure the stored procedure to write the appropriate information to the Logging database.

C. Create a DDL trigger that runs when a new customer database is created. Configure the DDL trigger to write the appropriate information to the Logging database.

D. Configure Service Broker to run a stored procedure that writes the appropriate information to the Logging database.

Answer: C


Question No. 139

You are a database administrator for Exambible.com. A database on one of the company's SQL Server 2005 computers stores transaction information for the company's Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19:00 and 04:00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do?

A. Configure a Back Up Database task to do a full backup of the database every day at

19:00. Configure a second Back Up Database task to do differential backups at 09:00 and

14:00. Configure a third Back Up Database task to do transaction log backups every hour.

B. Configure a Back Up Database task to do a full backup of the database every hour.

Configure a Check Database Integrity task to run every hour.

C. Configure a Back Up Database task to do a full backup of the database every day at

19:00. Configure a second Back Up Database task to do differential backups at 09:00 and

14:00. Configure a Check Database Integrity task to run every hour.

D. Configure a Back Up Database task to do a full backup at 09:00 and 14:00. Configure a second Back Up Database task to do transaction log backups every hour.

Answer: A


Question No. 140

You are a database administrator for Exambible.com. Your company uses a different company's application that is based on SQL Server 2005 Standard Edition. The application executes a query that uses an index query hint. The index query hint is not suitable for your environment, but you cannot modify the query. You need to force the application to use a different query execution plan. What should you do?

A. Create a plan guide for the query.

B. Clear the procedure cache.

C. Create a new covering index on the columns that the query uses.

D. Update the statistics for all of the indexes that the query uses.

Answer: A


Question No. 141

You are the database administrator for Exambible.com. The company uses a SQL Server 2005 database to track online sales. Employees who run the In-Stock report experience slow performance. This performance problem is caused by the contention between the In-Stock report and high volume of data entry to the tables that are accessed in this report. The company wants the In-Stock report returned immediately even though other employees might be changing the data within their data-entry transactions. Any changes made in other transactions while the report is running must be visible to the employees who are running the In-Stock report. You need to design a solution to achieve this goal.

What should you do?

A. Change the transaction isolation level for the report transaction to snapshot.

B. Change the transaction isolation level for the report transaction to serializable.

C. Change the transaction isolation level for the report transaction to Read Uncommitted.

D. Configure the database to enable the Read Committed snapshot option.

Answer: C


Question No. 142

For the MarketingAnalysis database, you are adding functionality that sends the results of a query in an e-mail message to the marketing supervisors when new sales data has been entered. You need to implement a method that fulfills this requirement and minimizes the security risks. Which method should you use?

A. Database Mail

B. SQL Mail

C. a managed stored procedure

D. a command line program that is called by xp_cmdshell

Answer: A


Question No. 143

You need to design a stored procedure to import the registry information from AppServer1. You want to accomplish this goal without allowing the execution of unmanaged code. What should you do?

A. Use a regular stored procedure that calls xp_cmdshell.

B. Use an extended stored procedure.

C. Use a CLR stored procedure with the SAFE permission set.

D. Use a CLR stored procedure with the EXTERNAL_ACCESS permission set.

E. Use a CLR stored procedure with the UNSAFE permission set.

Answer: D


Question No. 144

You are a database administrator for Exambible.com. You discover that a SQL Server 2005 application performs slowly when you execute the following query. SELECT * FROM Orders WHERE OrderStatus = 'InProgress' The application executes this query as an ad hoc query. This query usually executes much more quickly. The OrderStatus column is indexed. Only a small number of the rows contain the value InProgress. However, the OrderStatus column index is not being used, even though the index is optimal for this query. You need to improve the performance of this query. However, you cannot modify the application that executes the query. Your solution must also minimize the impact on end users. What should you do?

A. Update the statistics on the index.

B. Rebuild the index by using a FILLFACTOR of 10 percent.

C. Recreate the index to include all of the columns in the table.

D. Create an indexed view of the Orders table.

Answer: A