Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 191:

  You maintain multiple SQL Server 2008 instances.

  You develop a failure recovery strategy.

  You need to find out the edition and the build of SQL Server that is deployed in your environment.

  What should you use to find the required information?

  A. SELECT @@VERSION
  B. SELECT * FROM sys.dm_os_sys_info
  C. DBCC HELP
  D. EXEC xp_msver
  A. SELECT @@VERSION

• Question 192:

  You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use?

  A. BACKUP DATABASE FINANCE TO DISK =
  B. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:
  C. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH DIFFERENTIAL:
  D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION- DIFFERENTIAL;
  B. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:

• Question 193:

  You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges.

  You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

  A. Under the context of the local system account
  B. Under the context of the local service account
  C. Under the context of the domain user account
  D. Under the context of the local Administrator account
  C. Under the context of the domain user account

• Question 194:

  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. Server
  B. SQL Server Agent
  C. SQL Server Browser
  D. SQL Active Directory Helper
  C. SQL Server Browser

• Question 195:

  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 request_max_cpu_time_sec column of the sys.resource_governor_workload_groups catalog view.
  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 sys.dm_resource_governor_workload_groups dynamic management view to monitor the CPU usage 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.

• Question 196:

  You administer a SQL Server 2008 instance.

  You need to find out the number of users who access the SQL Server instance by using Windows System Monitor.

  Which performance object should you capture?

  A. SQLServer:Exec Statistics
  B. SQLServenBuffer Manager
  C. SQLServer:Access Methods
  D. SQLServer:General Statistics
  D. SQLServer:General Statistics

• Question 197:

  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:

  What should you do?

  A. 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.
  B. 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.
  C. 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.
  D. 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. 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.

• Question 198:

  You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.

  The database is backed up by using the weekly scheduled SQL Server Agent jobs.

  The backup schedule is shown in the following table:

  

  A drive fails and the CustomerOrders database goes into suspect mode on Thursday at

  17:00

  hours.

  You need to restore the backup.

  What should you do?

  A. Restore the backup taken on Sunday only.
  B. Restore the backups taken on Sunday and Monday.
  C. Restore the backup taken on Wednesday only.
  D. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at 18:00 hours.
  E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.
  F. Restore the backups taken on Wednesday, Thursday, and Friday.
  G. Restore the backups taken on Wednesday and Friday.
  H. Restore the backups taken Wednesday, Friday, and Saturday.
  E. Restore the backups taken on Wednesday and Thursday at 09:00 hours.

• Question 199:

  You administer a database for an online ordering system.

  You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools.

  You need to ensure that the transaction log backup schedule meets the following requirements:

  What should you do?

  A. Create two SQL Server Integration Services (SSIS) packages by using a single schedule.
  B. Insert a new row to dm_os_schedulers.
  C. Create a database maintenance plan by using the Database Maintenance Wizard.
  D. Create two SQL Agent jobs by using a single schedule.
  B. Insert a new row to dm_os_schedulers.