(Continued from previous part...)

You are designing a new server that will hold 2 instances of SQL Server 2005 in a consolidation project. One of the existing servers has 4GB of RAM and the other has 2GB. You do not want either instance to feel memory pressure, so you specify a new server with 8GB of RAM. What else should you configure on these instances?

Min and Max memory for each instance
Explanation
If you are designing multiple instances, you will want to specify the amount of RAM that each has access to. If you do not do this, performance can vary dramatically as the servers compete for memory.

You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?

All of the above are valid

Explanation
On a Windows XP host, the password policy is not enforced because the appropriate API call is not available on the operating system.

A certificate is which type of security mechanism?

Asymmetric Key
Explanation
A certificate is an asymmetric key that provides encryption in addition to authentication of an entity.

Which of the following services is instance-aware?

Analysis Services
Explanation
Of these, only Analysis services is instance-aware.

What What does the term ACID refer to?

An acronym that describes concurrency support in a database
Explanation
The answer is an acronym that describes concurrency support in a database. ACID is an acronym for the following four terms: * Atomicity - Every operation within a transaction is treated as a singular operation; either all of its data modifications are performed, or none of them is performed.
* Consistency - Once the transaction is completed, the system must be left in a consistent state.
* Isolation - It means that the operations within a transaction must be suitably isolated from other transactions. In other words, no other transactions should see data in the intermediate state, within the transaction, until it is finalized. This is done by using locks.
* Durability - Once a transaction is competed, all changes must be persisted as requested. The modifications should persist in total even in the event of a system failure.

(Continued on next part...)