Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu 認定 70-450 試験問題:

1. You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators.
A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server.
Only the database administrators can access the production server.
You need to ensure that the application developers can deploy the project successfully to the production server.
What should you do?

A) Create an indirect package configuration for all packages.
B) Create a deployment utility for the SSIS project.
C) Create a direct package configuration for each package.
D) Use the Import and Export Wizard to save packages.

2. You administer a SQL Server 2008 instance.
The instance is one of three servers in a peer-to-peer transactional replication topology.
The publication contains a table named Orders. The Orders table contains 200 GB of data
across multiple partitions. A batch process bulk loads 10 GB of data to the Orders table periodically.
You need to design a replication strategy to minimize latency.
What should you do?

A) Disable the Distributor agent. Use the BULK INSERT command in the Orders table. Reinitialize the publication.
B) Configure the Distributor agent to replicate transactions continually.
C) Configure the Distributor agent to change the commit batch threshold.
D) Explanation/Reference:
---Jeff---
E) Use the BULK INSERT command in multiple staging tables. Switch partitions into the Orders table.

3. 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 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.
B) Perform a partial restore of the PRIMARY filegroup and FileGroupB from a partial backup.
C) 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
D) Perform a full database restore.

4. You administer a SQL Server 2008 infrastructure.
An instance hosts a business-critical database that must be continuously available to the users without data loss. The database includes Filestream data.
You need to implement a high-availability solution for the site.
Which solution should you use?

A) Synchronous database mirroring with a witness server
B) Asynchronous database mirroring
C) Database snapshot
D) Failover clustering

5. 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?

A) To achieve the goal, an indirect package configuration should be created for all packages.
B) To achieve the goal, a direct package configuration should be created for each package.
C) To achieve the goal, a deployment utility should be created for the SSIS project.
D) To achieve the goal, the Import and Export Wizard should be utilized to save packages.

質問と回答：