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?

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 solution will be implemented to have hardware configurations obtained.
The hardware configuration obtained should include the number of processors on a computer and the processor type of all SQL Server
2008 computers. The requirements listed below should be satisfied by the solution.
The solution should be hosted on the central computer. And the hardware configurations for multiple servers should be verified by
the solution.
A technology should be selected to satisfy the requirements, and the least amount of development effort should be utilized.
Which action should you perform 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 infrastructure is managed by you.
A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01.
There is a sales team in your company, and their task is to finish purchase orders for customer requests.
The sales team updates data regularly in a local database by utilizing their portable computers.
When the central site is connected by portable computers, a database named Sales will be synchronized with the local
database. A duplication model will be created to duplicate the local database to the Sales database.
The requirements listed below should be satisfied by the duplication model.
First, when the same data is updated by multiple users independently, there should be no data conflicts.Secondly, sensitive data such
as product price cannot be updated by the sales team.Thirdly, the data should be synchronized by the
sales team not only at scheduled times but also on demand.
The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least.
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. Your company wants to enforce naming standards for the database objects.
A solution should be designed by you to enforce naming standards, and the least amount of administrative and programming efforts should be utilized.
Which action should 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 database solution is managed by you, and the solution is log-shipped for high-availability purposes.
The data files of the database reside on drive D, while the transaction log files of the database reside on drive E.
A restoring test plan should be implemented to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?