You are a professional level SQL Sever 2008 Database Administrator. A new database will
be deployed to the instance. Regular inserts and updates should be subjected by the
database. There will be multiple schemas on the database. A great number of read-only
reference data should be contained by one of the schemas. The physical database structure
should be designed for optimal backup performance. Which action should you perform?

You are a professional level SQL Sever 2008 Database Administrator. A large database is
hosted by the instance. High volumes of queries and transactions that are processor
intensive are experienced by the database. An incremental backup strategy should be
designed for the database. In addition, backup compression will be utilized. Since you are
the technical support of the company, you are required to reduce the impact from the
backup jobs on the performance of the server to the least. Which action will you perform to
achieve the goal?

You are a professional level SQL Sever 2008 Database Administrator. A new database

application is hosted by the instance. The data security strategy should be designed for the
application. The data should be duplicated to another instance of SQL Server 2008 by
utilizing the Snapshot duplication. Since you are the technical support of the company, you
should make sure that all stored data should be encrypted, and the minimum amount of
administrative effort should be utilized. Which action will you perform?

You are a professional level SQL Sever 2008 Database Administrator. 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. 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;
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. The largest table in a
database is partitioned into four equal-sized parts. The first two partitions are seldom
queried, while the third partition is regularly queried by several reports. Meanwhile, the
fourth partition is heavily queried and regularly modified. The disk space of the table should
be cut to the least and the query performance should be with the least impact. What will you
do? (Choose more

You are a professional level SQL Sever 2008 Database Administrator. 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. 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. 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. 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.)