Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:

1. You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?

A) Create mirroring endpoints on both partner servers.
Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.
B) Create mirroring endpoints on both partner servers.
Execute the following stored procedure: Sp_configure 'Lightweight Pooling', 1
C) Create mirroring endpoints on both partner servers.
Use Microsoft SQL Server Management Studio on both partner servers to select the High Performance option, and start mirroring.
D) Create mirroring endpoints on both partner servers.
On the principal server, use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause.

2. You administer a SQL Server 2008 instance.
You need to find out the number of users who access the SQL Server instance by using Windows System Monitor.
Which performance object should you capture?

A) SQLServenBuffer Manager
B) SQLServer:Exec Statistics
C) SQLServer:Access Methods
D) SQLServer:General Statistics

3. You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
---
It checks database integrity.
It rebuilds indexes.
It writes a report to a text file.
You need to modify the SQL Server instance such that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
What should you do?

A) Modify the SQL Server Agent job that executes the database maintenance plan to notify the appropriate operators.
B) Enable a fail-safe operator for the SQL Server Agent.
C) Modify the database maintenance plan to e-mail a report to the appropriate operators.
D) Modify the database maintenance plan to include a Notify Operator task that e-mails the appropriate operators.

4. ----
Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS).
You should design a package, which has the following features:
The package should be transactional.
The package should be optimized for 10 tables.
The package should be stored safely in the msdb database of a server which is
remote.
Which is correct?

A) You should create the package by using the Microsoft SQL Server Import and Export Wizard.
B) You should create the package by using the Package Migration Wizard.
C) On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, you should click the Create Package submenu.
D) You should create the package by using DTS Designer.

5. You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is an Internet Information Services application. This application will use anonymous access to access the SSAS instance.
You must make sure that the application can access the SSAS instance.
What should you do?

A) The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
B) The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
C) The Security\RequireClientAuthentication server configuration should be set to True.
D) The Security\RequireClientAuthentication server configuration should be set to False

Solutions: