You administer a SQL Server 2008 infrastructure.
You implement log shipping for several databases on three SQL Server instances. The logs are shipped to
a fourth SQL Server instance.
You plan a manual failover.
You need to ensure that the database applications use the secondary server after failover. You also need
to ensure that users can access the most recent data.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You administer a SQL Server 2008 infrastructure.
The infrastructure contains SQL Server 2008 servers across four sites. All sites are connected via a WAN
link. All sites use the same database application.
Your company has the following business requirements:
All sites maintain data related to their site.
Each site has access to data related to other sites.
In the event of any site failure, database activity is redirected to another site.
You need to implement a replication topology that meets the business requirements.
Which solution should you implement?

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?

You administer SQL Server 2008 instances at three sites.
All sites share a mission-critical database. The business requirements specify that users at each site must
be able to perform the following tasks:
Access and modify data on all sites with minimal latency.
Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements.
Which solution should you implement?

You administer SQL Server 2008 servers on a single site.
The site contains the following two SQL Server 2008 instances:
An Enterprise Edition server on a server that has a redundant array of independent disks (RAID) 10
disk system
A Standard Edition server on a server that has a RAID 5 disk system
Each instance hosts a single application.
You need to recommend a high-availability solution for the site to meet the following business
requirements:
The solution can be implemented on the existing systems.
The database is available with minimal downtime.
Data loss is minimal.
There is minimal effect on the existing system.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.

You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000
transactions every minute.
A table in the database contains a column that is used only by the application.
This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

You administer a SQL Server 2008 infrastructure.
You plan to upgrade a Microsoft SQL Server 2005 instance to SQL Server 2008 by using an in-place
upgrade. All user databases use the simple recovery model and have the PAGE_VERIFY option turned
off.
You need to ensure that the database engine can identify I/O path errors and memory corruptions for the
data in tables.
Which two actions should you perform before the upgrade?
(Each correct answer presents part of the solution. Choose two.)

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 instance should be managed. A
monitoring solution should be designed for the instance to have object utilization statistics monitored. A list
of first 10 objects should be identified by the solution for each of the following two components:
most frequently executed stored procedures and functions and long running Transact-SQL statements
The monitoring solution should be implemented with minimum performance effect, and the least amount of
administrative effort should be utilized.
Which action will you perform to accomplish the task?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization. A SQL Server 2008 instance is utilized by you. A new
database named Engineering is deployed. Large documents are managed by the Engineering database,
and the documents will be revised occasionally. A table structure should be designed to permit fast read
access. The storage space requirements should be cut to the least.What will you do to achieve the goal?
(Choose more than one.)