You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

• A. Transparent data encryption
• B. Asymmetric key encryption
• C. Certificate-based encryption
• D. Symmetric key encryption

說明：（僅 Fast2test 成員可見）

You deploy a new database application to a SQL Server 2008 instance on a server that has 4 processor
cores and 64 GB of RAM. The application uses partitioned tables.
During testing, deadlocks occasionally occur on queries that are attempting to read data.
You find out that the deadlocks are related to the table partitions.
You need to ensure that the application executes without deadlocks for the read queries.
You also need to ensure that dirty reads do not occur.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Disable partition-level lock escalation.
• B. Move each partitioned table to its own filegroup.
• C. Move the clustered indexes for the partitioned tables to a separate filegroup.
• D. Add additional database files to each partitioned table.

說明：（僅 Fast2test 成員可見）

You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests.
The sales team uses portable computers to update data frequently in a local database. When the portable computers connect to the central site, the local database must be synchronized with a database named Sales.
You plan to create a replication model to replicate the local database to the Sales database.
The replication model must meet the following requirements:
Data conflicts are handled when multiple users update the same data independently.
The sales team cannot update sensitive data such as product price.
The sales team can synchronize data at scheduled times and on demand also.
You need to identify the best model to replicate data by using minimum development efforts.
What should you do?

• A. Use snapshot replication along with each portable computer that is set up as a subscriber.
• B. Use merge replication along with each portable computer that is set up as a subscriber.
• C. Use SQL Server Integration Services (SSIS) to push data changes and pull updates to the Sales database along with the SSIS packages, on demand.
• D. Use transactional replication along with each portable computer that is set up as a publisher.

說明：（僅 Fast2test 成員可見）

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

• A. You should utilize snapshot duplication along with each portable computer that is set up as a subscriber.
• B. You should utilize transactional duplication along with each portable computer that is set up as a publisher.
• C. You should utilize merge duplication along with each portable computer that is set up as a subscriber.
• D. You should utilize SQL Server Integration Services (SSIS) to promote the date modification and pull updates to the Sales database along with the SSIS packages, on demand.

說明：（僅 Fast2test 成員可見）

You administer a SQL Server 2008 instance that hosts a large database.
The following backup strategy is used for the database:
A full database backup is performed at 02:00 hr every Monday.
A differential backup is performed at 23:00 hr every day.
A transaction log backup is performed on an hourly basis.
A power failure on Thursday causes the SQL Server 2008 server to restart at 09:15 hr.
Fifteen minutes after the server restarts, the users report that they are unable to execute certain queries
that access
customer data. You discover that the customer data is unmodified after the power failure.
When you execute the DBCC CHECKDB command on the database, you receive the following error
message:
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 d etails.
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 allocatio n errors and 2 consistency errors in table 'tbl_Customer' (object ID
2814307832).
When you execute the sp_help 'tbl_customer' stored procedure you receive the following result set:
index_name index_description
PK clustered located on PRIMARY
NCIX nonclustered located on PRIMARY
You need to ensure that the data is available as quickly as possible with minimal effect on users.
What should you do?

• A. Drop and recreate the NCIX index.
• B. Restore the latest full database backup. Restore the latest differential backup. Restore all transaction log backups from the latest differential backup.
• C. Drop and recreate the PK index.
• D. Restore the latest full database backup. Restore all transaction log backups from the latest full database backup.

說明：（僅 Fast2test 成員可見）