Study with 70-432 most valid questions & verified answers

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 MyApp workload group.
• C. Use the request_max_cpu_time_sec column of the sys.resource_governor_workload_groups catalog view.
• D. 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.

You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both instances run on the same computer. The SQL Server 2008 instance contains a database named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word "root" are added to the WebApplicationDB database. When the Fulltext index is queried for the word "root," an empty resultset is returned.
You need to ensure that records that contain the word "root" are returned by the query.
What should you do?

• A. Rebuild the full-text index.
• B. Add the word "root" to the stop list.
• C. Stop and restart the MSFTESQL service.
• D. Add the word "root" to the thesaurus file.

You administer a SQL Server 2008 instance that runs on a Windows Server 2003 computer. The instance uses mixed authentication mode.
You need to ensure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. You also need to ensure that the password complexity rules continue to be enforced.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Use the ALTER LOGIN ... CHECK_POLICY = ON statement to modify all logins.
• B. Create an SQL Server Agent job that runs periodically to raise an alert if a rule violation is detected.
• C. Use Policy-Based Management to create a policy that prevents any violation of these rules.
• D. Use the ALTER LOGIN ... CHECK_EXPIRATION = ON statement to modify all logins.
• E. Use the ALTER LOGIN ... HASHED statement to modify all logins.

You administer a remote SQL Server 2008 instance that contains a database named InsightDB. The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively and triggers the population of multiple tables.
Users of the application report that the application performance is poor. You suspect that the performance issues are related to blocking.
You need to monitor the state of the instance at regular intervals without affecting the application performance further.
Which tool should you use?

• A. SQL Server Profiler
• B. SQL Server Resource Governor
• C. Windows System Monitor
• D. Dynamic Management Views

You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory utilization. The network should be considered. the detailed information should be checked for the proper example of SQL Server2008.Which is the correct answer?

• A. In the databases, you should check the distribution of the statistics which are hosted
• B. You should check a statistics update command??s the output.
• C. You should check the recovery model of the master database.
• D. You should check the proper dynamic management views (DMVs).