Pay attention on Pass-king 070-432 Practice Materials, clear exam 100% for sure

Microsoft 070-432 Exam Syllabus Topics:

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

1. You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS.
You need to ensure that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?

A) Drop all indexes on the Sales database.
Modify the database to specify SQL_Latin1_General_Cp1_CS_AS as the default collation.
Rebuild all the indexes.
B) Use the CAST function in the filter criteria on all queries that filter on the CompanyName column.
C) Use the UPPER function in the filter criteria on all queries that filter on the CompanyName column.
D) Drop all indexes on the Customer table that include the CompanyName column in the index key.
Modify the column to specify the SQL_Latin1_General_Cp1_CS_AS collation.
Recreate the CompanyName indexes on the Customer table.

2. You maintain a SQL Server 2008 instance that contains a database named Finance. The recovery model of the Finance database is set to Full.
The backup strategy for the Finance database is as shown in the following table.

The system databases, user database data, and log files are stored on separate disks. The hard disks that contain the user database data files are reported to have failed at 15:00 hours on Wednesday.
You need to restore the Finance database from the database backups by ensuring minimal data loss in minimum possible time.
What should you do?

A) Back up the transaction log.
Restore the full backup taken on Sunday.
Restore the differential backup taken on Tuesday.
Restore all transaction log backups taken during Wednesday
B) Restore the full backup taken on Sunday.
Restore the differential backup taken on Monday and Tuesday.
Restore the transaction log backups taken at 08:00 hours and at 12:00 hours on
Wednesday.
C) Restore the full backup taken on Sunday.
Restore the differential backup taken on Wednesday.
D) Back up the transaction log.
Restore the full backup taken on Sunday. Restore all transaction log backups.

3. You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to a custom workload group named MyApp.
You need to monitor processor resources.
What should you do?

A) Use the sys.dm_resource_governor_workload_groups dynamic management view to monitor the CPU usage for the default workload group.
B) Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the default workload group.
C) Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the MyApp workload group.
D) Use the request_max_cpu_time_sec column of the sys.resource_governor_workload_groups catalog view.

4. You administer three SQL Server 2008 instances on separate servers named Server1, Server2, and Server3.
The AdventureWorks database is configured for mirroring between the instances. In the mirroring session, Server1 and Server2 act as partners and Server3 as the witness.
You have the following requirements:
- All three servers run a maintenance process that requires occasional restart of the computer. - The SQL Server service on each server is shut down only during the actual restart of the computer. - After completion of the maintenance process, re-enable automatic failover and synchronize the mirroring session in minimum possible time.
You need to ensure that automatic failover is disabled during the maintenance process.
What should you do first?

A) Configure the mirroring session with the SAFETY option set to ON.
B) Remove the witness server from the mirroring session.
C) Suspend the mirroring session.
D) Remove mirroring from the database.

5. You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3.
Which sp_configure configuration option should you set?

A) cost threshold for parallelism
B) max worker threads
C) precompute rank
D) query governor cost limit
E) priority boost

Solutions: