070-450 무료 덤프문제 온라인 액세스

You administer a SQL Server 2008 infrastructure.
An instance hosts a business-critical database that must be continuously available to the users without data loss. The database includes Filestream data.
You need to implement a high-availability solution for the site.
Which solution should you use?

• A.Asynchronous database mirroring
• B.Synchronous database mirroring with a witness server
• C.Database snapshot
• D.Failover clustering

You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?

• A.To accomplish the goal, the Windows System Resource Manager should be configured.
• B.To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.
• C.To accomplish the goal, the Resource Governor should be configured.
• D.To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.

You are a professional level SQL Sever 2008 Database Administrator.
A business-critical database is hosted by the instance, and the database must be constantly available to the users with no data loss. Filestream data is contained by the database.
A high-availability solution should be designed for the site.
Which solution should be utilized?

• A.Database snapshot should be utilized.
• B.Asynchronous database mirroring should be utilized.
• C.Synchronous database mirroring with a witness server should be utilized.
• D.Failover clustering should be utilized.

You administer a SQL Server 2008 infrastructure.
Humongous Insurance has 20 branch offices that store customer data in SQL Server 2008 databases. Customer data that is stored across multiple database instances has to be security compliant.
You plan to design a strategy for custom policies by using the Policy-Based Management feature. Custom policies are in XML format.
The strategy must meet the following requirements:
Custom policies are distributed to all instances.
The policies are enforced on all instances.
You need to implement the strategy by using the least amount of administrative effort.
What should you do?

• A.Distribute the policies by using the Active Directory directory service
• B.Use a configuration server.
• C.Distribute the policies by using Group Policy Objects.
• D.Use the Distributed File System Replication service.

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 Resource Governor.
• B.To finish the task, you should utilize Performance Monitor (SYSMON).
• C.To finish the task, you should utilize Extended Events.
• D.To finish the task, you should utilize Database Engine Tuning Advisor.