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.)

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 of your company is managed by you.
New SQL Server 2008 Integration Services (SSIS) packages will be deployed, and the packages are created by the SQL Server Import and Export Wizard.
The packages will utilize stored user names and passwords to connect to external data sources.
Since you are the technical support of your company, you are required to confirm that unauthorized users can not get access to the user names and passwords.
Which action will you perform?

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 infrastructure is managed by you.
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?

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. And a large database is hosted by the instance.
The company utilizes the following backup strategy for the database.
First, the performance of full database backups is implemented weekly.
Secondly, the performance of differential backups is implemented daily.
Thirdly, the performance of transaction log backups is implemented hourly.
According to the restoring plan, an unscheduled full backup should be performed.
A full database backup should be performed, and the scheduled backup strategy should not be interrupted.
Form the following four options, which one should be utilized to finish 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 managed by you. And it is on a four-processor, quad-core server.
CPU pressure is regularly experienced by the server.
An extremely large mission-critical database is consisted by the instance, and it is utilized constantly.
The online index rebuilds should not occupy all available CPU cycles.
From the following four configurations, which one should you utilize?

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 infrastructure is managed by you. The capacity planning information is required by your company.
A long-term infrastructure monitoring strategy should be implemented.
Which two actions should be contained in the strategy? (Choose more than one)

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.
And a database is hosted by the instance.
You can see the backup strategy utilized by the database from table listed below.
A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr.
And you find that the batch process takes no effect because certain data is modified some data by a user at 21:05 hr on the
same day. The database should be recovered to its state at the start of the batch process in the shortest
time. Which action will you perform?