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?

• A. No sensitive data should be saved together with the packages, and then the packages should be saved in the SQL Server 2008 server.
• B. No other data should be saved together with the packages, and then files should be saved to the most secure directory.
• C. The SQL Server 2008 server should be utilized to store the packages, and administrate the security in the SQL Server 2008 server.
• D. A common password should be set to make a highest level of security for all information in the package when each package is saved.

You are configuring a new SQL Server installation.
The SQL Server instance will be used for both online analytical processing (OLAP) and relational data. The data in the server is accessed frequently. You can configure the services, startup type, and accounts used by the services that run on the server according to the following table:

You want to raise the level of security on the server. You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create three different non-administrative local user accounts and assign them to each of the services.
• B. Change the Startup type property for all the services to Disabled.
• C. Change the Startup type property for all the services to Manual.
• D. Create a single non-administrative local user account and assign it to each of the services.

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 SQL Server Integration Services (SSIS) to promote the date modification and pull updates to the Sales database along with the SSIS packages, on demand.
• D. You should utilize merge duplication along with each portable computer that is set up as a subscriber.

You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?

• A. To accomplish the goal, the Resource Governor should be configured.
• B. To accomplish the goal, the Windows System Resource Manager should be configured.
• C. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.
• D. To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.

You administer a SQL Server 2008 infrastructure.
The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports.
You plan to design a performance monitoring strategy that captures and stores the following data:
Executed Transact-SQL statements and query activity.
Blocking and deadlock information.
Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort.
What should you do?

• A. Use the System Monitor counter log trace.
• B. Use the data collector
• C. Use the dynamic management views.
• D. Use the client-side profiler trace.