You are designing the storage scheme for a new SQL Server 2008 database application
The application will primarily be used to query data.
The database will be initially populated with 4 terabytes of data stored in 20 tables.
The data is distributed evenly throughout all 20 tables. Every night, between 100 GB and 300 GB of new
data will be loaded into 4 database tables.
The remaining 16 tables will remain static. The average CPU utilization of the server where the
application will reside is between 30 and 50 percent.
You need to ensure that the amount of disk space used is reduced.
You need to achieve this goal by ensuring minimum impact of performance on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Use row-level data compression on the 16 tables that remain static.
• B. Use row-level data compression on the 4 tables that are loaded every night.
• C. Use page-level data compression on the 16 tables that remain static.
• D. Use page-level data compression on the 4 tables that are loaded every night.

說明：（僅 Fast2test 成員可見）

You administer four SQL Server 2008 instances. Each instance hosts a single database application.
You plan to migrate all four instances to a new SQL Server failover cluster. The four instances are configured as shown in the following table.
Instance Name Configuration:
Instance 1 8 processors that have 16-GB RAM Instance 2 4 processors that have 8-GB RAM Instance 3 2 processors that have 16-GB RAM Instance 4 4 Processors that have 8-GB RAM
The four instances are fully optimized and have no spare CPU cycles or extra memory. The new cluster will host all four databases on a single virtual cluster IP address. You need to ensure that the new cluster is configured to handle the workload of all the database applications by using the minimum amount of hardware resources.
Which cluster configuration should you use?

• A. Four-node active/active/active/passive cluster that has each node containing a minimum of 18 processors and a 50-GB memory
• B. Two-node active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
• C. Four-node active/active/active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
• D. Two-node active/passive cluster that has each node containing a minimum of 18 processors and a 50GB memory

說明：（僅 Fast2test 成員可見）

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?

• A. You should record the time before the batch operation. And then you should perform a transaction log
• B. You should create a database snapshot.
• C. You should perform a differential backup.
• D. You should create a marked transaction. And then you should perform a transaction log backup.

說明：（僅 Fast2test 成員可見）

You administer a SQL Server 2008 Enterprise Edition instance that hosts a large database.
The database uses the simple-recovery model.
The database contains the following three additional filegroups:
FileGroupA that is read/write
FileGroupB that is read-only
FileGroupC that is read-only
FilegroupB contains less critical data than FilegroupC.
You discover that the PRIMARY filegroup and FileGroupB have failed.
You need to recover the database in the minimum possible time. You also need to ensure that
data is available as soon as possible.
What should you do?

• A. Perform a full database restore.
• B. Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupC, and then perform an online restore of FileGroupB.
• C. Perform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
• D. Perform a partial restore of the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupB, and then perform an online restore of FileGroup

說明：（僅 Fast2test 成員可見）

You administer a SQL Server 2008 instance that hosts a database.
The backup strategy used by the database is as shown in the following table: You run a batch process on Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is invalidated because a user has modified some data at 21:05 hr on the same day.

You need to restore the database to its state at the start of the batch process in the least possible time.
What should you do?

• A. Restore the full database backup that was performed on Thursday Restore all transaction logs from the time of the full backup on Thursday and stop at 21:00 hr on Saturday.
• B. Restore the full database backup that was performed on Saturday. Restore all transaction logs from the time of the full backup on Saturday and stop at 21:00 hr on Saturday.
• C. Restore the full database backup that was performed on Thursday. Restore the differential backup that was performed on Friday. Restore all transaction logs from the time of the differential backup on Friday and stop at 21:00 hr on Saturday.
• D. Restore the full database backup that was performed on Saturday.

說明：（僅 Fast2test 成員可見）