Microsoft TS:MS SQL Server 2008,Implementation and Maintenance : 070-432

You maintain multiple SQL Server 2008 instances on the same physical computer.
Users can connect to the default instance but are unable to connect to the named instances. You verify that currently all SQL Server instances run.
You need to start the service required to connect to the named instances.
Which Service should you start?

• A. SQL Server Agent
• B. Server
• C. SQL Server Browser
• D. SQL Active Directory Helper

You administer a SQL Server 2008 instance. The server hosts databases for several mission-critical applications.
You plan to use the Resource Governor to limit the effect of queries that are executed by Microsoft SQL Server Management Studio.
You need to ensure that that the following requirements are met:
- Queries initiated through SQL Server Management Studio do not exceed 20 percent of CPU utilization. - Queries initiated by the mission-critical applications are allowed to consume 100 percent of CPU utilization when required.
What should you do?

• A. Alter the default resource pool and set the MAX_CPU_PERCENT option to 80.
  Assign tins resource pool to the workload group used by SQL Server Management Studio.
• B. Create a new resource pool and set the MAX_CPU_PERCENT option to 80.
  Assign this resource pool to the workload group used by the mission-critical applications.
• C. Alter the default resource pool and set the MAX_CPU_PERCENT option to 20.
  Assign this resource pool to the workload group used by the mission-critical applications.
• D. Create a new resource pool and set the MAX_CPU_PERCENT option to 20.
  Assign this resource pool to the workload group used by SQL Server Management Studio.

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Currently, the table is partitioned by year with each year in its own filegroup.
You need to move the data from the oldest year into a new table in a different Schema to archive the data.
What should you do?

• A. Create a new Filegroup.
  Create a new database File.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
• B. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= 'PartltionByYear'; @OptionValue= 'true';
• C. Remove the clustered index from the table.
• D. Use the ALTER TABLEstatement to remove the COLLATEoption.
• E. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• F. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• G. Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);
• H. Create a new table.
  Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
  Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE
  clause.
• I. Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• J. Create a new filegroup.
  Create a new database file.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use ALTER INDEX REORGANIZE statement.

You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed which contains the Microsoft Clustering mining model. From Scalable K-Means to Non-scalable K-Means.
You should alter the attribute of the mining model. Which is the correct answer?

• A. You should change MODELLING_CARDINALITY
• B. You should change INDEXDEFRAG
• C. You should change SHRINKFILE
• D. You should change CLUSTERING_METHOD

You administer a SQL Server 2008 cluster. You plan to test the failover response of the cluster.
You need to implement a manual failover on the cluster.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)

• A. Remove the shared array from the active node.
• B. Unplug the network cable(s) from the active node.
• C. Use Encrypting File System (EFS) to encrypt the contents of a shared folder on the active node.
• D. Restore a backup to the active node.