You are a professional level SQL Sever 2008 Database Administrator. The security
requirements should be designed for a new database application, and the application will be
deployed to the instance. A table is consisted by the new database, and the table is created
by utilizing the following code segment: TABLE EmpBonusPlan Since you are the technical
support, you should utilize the maximum secure method to protect the BonusPlan column
from the access of unauthorized users. Which action will you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator. A mission-critical
database is shared by the five sites. According to the business requirements, the users at
each site should be enabled to access and change data on all sites with minimal latency. In
addition, data loss should be minimized if a server fails. A high-availability solution should
be designed, and the business requirements should be satisfied. Which action should be
included in your solution?

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 corporate backup and
recovery strategy that has to be validated is designed. You are required to make sure that
any single database can be restored successfully from a severe failure, and during the
restoration, a backup data center should not be required in a different location. Which three
actions should be contained by your solution? (Choose more than one)

You are a professional level SQL Sever 2008 Database Administrator. A new database
should be deployed, and the capacity requirements listed below should be satisfied. There
should be 275 GB for the database data file, while there should be 50 GB for the transaction
log file. There are six 100- GB disk drives which are accessible for the database in the
storage array. The six disks are attached to a redundant array of independent disks (RAID)
controller, and the controller supports RAID levels 0, 1, 5, and 10. Since you are the
technical support, you are required to maximize the write performance of the transaction
log. In addition, you should protect the database and transaction log files, when a drive fails.
The storage system should be designed. From the following four storage configuration,
which one should you utilize?

You are a professional level SQL Sever 2008 Database Administrator. Two SQL Server
2008 instances are contained by the site. One is an Enterprise Edition server, and it is on a

server that has a redundant array of independent disks (RAID) 10 disk system The other is
a Standard Edition server, and it is on a server that has a RAID 5 disk system. A single
application is hosted by each instance. A high availability solution should be recommended
for the site to satisfy the business requirements listed below: First, the solution can be
implemented on the current systems. Secondly, the database is available with least
downtime. Thirdly, Data loss should be cut to the least. Fourthly, the existing system should
be with least impact. Which solutions should be utilized to finish the task? (Choose more
than one)

You are a professional level SQL Sever 2008 Database Administrator in an international
corporation named Wiikigo. There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a
shared project by a team of application developers. A fixed cache file is required by one of
the packages. The company will deploy the packages to the production server on
completion of development. The production server is available only to the database
administrators. Since you are the technical support, you need to confirm that the project can
be deployed successfully to the production server by the application developers. Which
action will you perform to achieve the goal?

You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance and the database is configured by utilizing high-safety mirroring operation
mode along with a witness server. A memory failure is experienced by the witness server;
therefore the server will be offline for five hours. The mirroring strategy should be reset to
cut the risk of database unavailability to the least level. Which action should you perform to
finish the task?

You are a professional level SQL Sever 2008 Database Administrator. A large financial
database is hosted by the instance. The backup strategies listed below are contained by the
database: First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day. Thirdly, the
performance of a transaction log backup is implemented every hour. An end-of-year batch
process should be implemented, and the process takes two hours to run. About five percent
of data within the database will be changed by the batch process. Since you are the
technical support, you are required to make sure that the batch operation can be rolled back
in the shortest time, if the batch process is not approved by the Finance department. What
should you do first before start the batch process?

You are a professional level SQL Sever 2008 Database Administrator. A database is hosted
by the instance, and sensitive data is included in the database. A database backup strategy
will be implemented for the database. You need to have all backups of the database
encrypted. The backups should not be accessed by unauthorized users. Which action will
you perform?

You are a professional level SQL Sever 2008 Database Administrator. A large database is
hosted by the instance. The company utilizes the following backup strategy for the
database. First, the performance of a full database backup is implemented at 02:00 hr every
Monday. Secondly, the performance of a differential backup is implemented at 23:00 hr
every day. Thirdly, the performance of a transaction log backup is implemented on an hourly
basis. A reboot is caused on the SQL Server 2008 server by a power failure at 09:15 hr,
Thursday. Fifteen minutes after the reboot of the server, it is reported that certain queries
that access customer data cannot be executed. You find that the customer data remains
unvaried after the power failure. When the DBCC CHECKDB command is executed on the
database, the following error message is received. Object ID 2814307832, index ID 2,
partition ID 83127819437122157, alloc unit ID 82134587923221126 (type In-row data):
Page (3421:169) could not be processed. See other errors for details. Table error: Object ID
2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data), page (3421:169). Test (IS_OFF (BUF_IOERR,
pBUF->bstat)) failed. Values are 16928422 and -8.CHECKDB found 0 allocation errors and
2 consistency errors in table ‘tbl_Customer’ (object ID 2814307832). When the sp_help
‘tbl_customer’ stored procedure is executed, the following result set is received:
index_name index_description ————————————————————————- PK

clustered located on PRIMARY NCIX nonclustered located on PRIMARY Since you are the
technical support, you are required to make sure that the data should be accessible in the
shortest time. And the impact on users should be cut to the least. Which action will you
perform to finish the task?