Online Access Free 70-450 Exam Questions

You are a professional level SQL Sever 2008 Database Administrator.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU usage, Server processes paging and Deadlocks
A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues and detailed deadlock information should be contained in the provided data.
You should utilize the least amount of administrative effort to finish the task.
Which tool will you utilize to finish the task?

• A.To finish the task, you should utilize Performance Monitor (SYSMON).
• B.To finish the task, you should utilize Extended Events.
• C.To finish the task, you should utilize Resource Governor.
• D.To finish the task, you should utilize Database Engine Tuning Advisor.

You are a professional level SQL Sever 2008 Database Administrator.
Two SQL Server 2008 instances are managed by you, and they are respectively called Ins01 and Ins02.
The Sales database is included in Ins01, while the Accounts database is contained by Ins02. A transaction
is
started by A procedure in the Sales database. And then, the Sales.dbo.Order table and the Accounts.dbo.
OrderHistory table are updated by the procedure through a linked server.
Since you are the technical support of the company, you are required to make sure that a
two-phase commit is utilized by the transaction.
Which action will you perform to finish the task?

• A.To finish the task, the linked server to utilize distributed transactions
• B.To finish the task, a Service Broker should be configured to have the proper transaction control enabled.
• C.To finish the task, the linked server should be properly configured for impersonation.
• D.To finish the task, the linked server should be properly configured for delegation.

You are a professional level SQL Sever 2008 Database Administrator.
A thirdparty database application will be deployed to the instance. Stored procedures are utilized by the application, and the procedures are developed by utilizing SQL CLR integration. You should set the application to have
the
EXTERNAL_ACCESS code access security setting enabled. Since you are the technical support of the
company,
you should deploy the application to the instance with no loss of functionality.
Which action will you perform first?

• A.The regasm.exe assembly registration tool should be utilized to have the assembly registered on the server before deployment.
• B.Read-only static fields in the code should be replaced with readwrite static fields.
• C.The peverify.exe PEVerify tool should be utilized to confirm whether the type-safety requirements are satisfied by the code.
• D.Readwrite non-static fields in the code should be replaced with static fields.

You administer a SQL Server 2008 instance. You plan to design a high-availability solution by using database mirroring.
The current application includes programming logic that will retry transactions if a failover occurs.
You need to configure a strategy that will provide the minimum amount of latency for committed transactions.
What should you do?

• A.Configure automatic failover role switching.
• B.Configure forced service role switching.
• C.Configure manual failover role switching.
• D.Pause database mirroring.

You administer a SQL Server 2008 infrastructure.
A financial application uses several instances across multiple servers. The majority of queries require distributed transactions across all servers.
The application administrator reports that the application experiences excessive deadlocks.
You need to design a data collector type that provides the appropriate information for remote servers.
What collector should you use?

• A.A custom Query collector that uses WMI
• B.Performance Counters collector
• C.T-SQL Query collector
• D.Query Activity collector