You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a
Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will
experience a predictable increase in query activity. You plan to ascertain the appropriate
time when the migration of the databases to a 64-bit SQL Server 2008 server on the same
hardware is beneficial. You need to identify a data collector type that provides the
appropriate information. Which collector should you use?

You administer a SQL Server 2008 instance. You plan to design a monitoring solution for
the instance to monitor object usage statistics. The solution must identify a list of first 10
objects for each of the following components: Most frequently executed stored
procedures and functions Long running Transact-SQL statements You need to implement
the monitoring solution to minimize performance effect by using the least amount of
administrative effort. What should you do?

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?

You administer a SQL Server 2008 infrastructure. An instance contains a database that
includes a large table named OrderDetails. The application queries only execute DML
statements on the last three months data. Administrative audits are conducted monthly on
data older than three months. You discover the following performance problems in the
database. The performance of the application queries against the OrderDetail table is poor.
The maintenance tasks against the database, including index defragmentation, take a long
time. You need to resolve the performance problems without affecting the server
performance. What should you do?

You administer a SQL Server 2008 infrastructure. Humongous Insurance has 20 branch
offices that store customer data in SQL Server 2008 databases. Customer data that is
stored across multiple database instances has to be security compliant. You plan to design
a strategy for custom policies by using the Policy-Based Management feature. Custom
policies are in XML format. The strategy must meet the following requirements: Custom
policies are distributed to all instances. The policies are enforced on all instances. You
need to implement the strategy by using the least amount of administrative effort. What
should you do?

You administer a SQL Server 2008 infrastructure. An instance contains a database that
includes a table named EmployeeData. The EmployeeData table has a column named
Profile. The column is used to store Microsoft Office Word 2003 documents. You need to
minimize the space occupied by the Profile column. You also need to maintain a reasonable
performance to retrieve the content of the column. What should you do?

You administer a SQL Server 2008 infrastructure. You partition the largest table in a
database into four equal-sized parts. The first two partitions are rarely queried. The third
partition is frequently queried by several reports. The last partition is heavily queried and
frequently modified. You need to minimize the disk space of the table and ensure that this
has minimum effect on the query performance. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 infrastructure. You plan to design a solution to obtain
hardware configurations, such as the number of processors on a computer and the
processor type of all SQL Server 2008 computers. The solution must meet the following
requirements: It is hosted on the central computer. It can verify hardware configurations
for multiple servers. You need to select a technology that meets the requirements by using
the minimum amount of development effort. What should you do?

You administer a SQL Server 2008 infrastructure. Your company wants to enforce naming
standards for the database objects. You need to design a solution to enforce naming
standards by using the minimum amount of administrative and programming efforts. What
should you do?

You administer a SQL Server 2008 instance. You plan to deploy new SQL Server 2008
Integration Services (SSIS) packages that are created by the SQL Server Import and Export
Wizard. The packages will connect to external data sources by using stored user names
and passwords. You need to ensure that the user names and passwords are protected from
access by unauthorized users. What should you do?