Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 101:

  You configure a SQL Server 2008 instance that contains a database named AdventureWorks.

  The AdventureWorks database experiences deadlock problems.

  You need to capture the deadlock information to the SQL Server error log.

  What should you do?

  A. Enable Server Auditing for the AdventureWorks database.
  B. Configure the data collector to capture the deadlock graphs.
  C. Configure a SQL Profiler trace to capture the deadlock graphs.
  D. Set the appropriate trace flags as a startup parameter and restart the SQL Server instance.
  D. Set the appropriate trace flags as a startup parameter and restart the SQL Server instance.

• Question 102:

  You troubleshoot the performance of a SQL Server 2008 instance.

  You need to identify the longest-running common language runtime (CLR) queries.

  Which dynamic management view should you use?

  A. sys.dm_os_wait_stats
  B. sys.dm_exec_requests
  C. sys.dm_exec_sessions
  D. sys.dm_exec_query_stats
  D. sys.dm_exec_query_stats

• Question 103:

  You administer a SQL Server 2008 cluster in a high security environment.

  You plan to configure and use encrypted connections for the clustered virtual SQL Server.

  You need to install the certificate that will be used for encryption.

  What should you do?

  A. Install the encryption certificate in the cluster group.
  B. Install the encryption certificate on each individual node.
  C. Install the encryption certificate in the cluster quorum drive.
  D. Install the encryption certificate in the SQL Server shared disk.
  B. Install the encryption certificate on each individual node.

• Question 104:

  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 Tuesday at

  09: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.
  B. Restore the backups taken on Sunday and Monday.

• Question 105:

  You administer a SQL Server 2008 instance.

  You need to identify the network protocol used by the current connection.

  What should you do?

  A. View the SQL error log.
  B. Use a Dynamic Management View.
  C. Set a trace flag.
  D. Use the T-SQL template in Profiler.
  B. Use a Dynamic Management View.

• Question 106:

  You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities.

  You plan to implement database mirroring between the two instances.

  You need to set up the mirroring session to support the high volume of write transactions to the database.

  You do not want small errors to impact the principal server.

  What should you do?

  A. Configure the mirroring session with the SAFETY option set to OFF and the WITNESS option set to OFF.
  B. Configure the mirroring session with the SAFETY option set to FULL and the WITNESS option set to OFF.
  C. Configure the mirroring session to add a witness.
  D. Configure the mirroring session for high-safety mode with automatic failover.
  A. Configure the mirroring session with the SAFETY option set to OFF and the WITNESS option set to OFF.

• Question 107:

  You administer a SQL Server 2008 instance.

  The security policy permits members of a Windows group named CONTOSO\Sales to establish new connections to the SQL Server instance only during business horns between

  07:00 horns and 19:00 hours. Other users may connect to the SQL Server instance any time. You write the following Transact-SQL statements.

  

  You need to implement the company security policy that is stored in the RestrictedLogonHours table. What should you do?

  A. Create a logon trigger that denies the connection to the CONTOSO\Sales group during non-business hours.
  B. Create a SQL Server Agent job that causes the SQL Server Windows service to pause during non-business hours.
  C. Create a SQL Server Agent job that periodically looks for and kills connections made by the CONTOSO\Sales group during non-business hours.
  D. Create a policy that uses a condition based on the Server Audit facet. Use the policy to deny the connection to the CONTOSO\Sales group during non-business hours.
  A. Create a logon trigger that denies the connection to the CONTOSO\Sales group during non-business hours.

• Question 108:

  You maintain a SQL Server 2008 instance that contains a database named Finance. A small percentage of data in the database is modified daily. You need to create a read-only copy of the database for reporting purposes at the beginning of each day by ensuring that minimal disk space is used.

  Which strategy should you use?

  A. Use database snapshots.
  B. Use database backup and restore.
  C. Use database backup and restore along with compression.
  D. Use schema-bound views in a read-only database that resides on the same instance.
  A. Use database snapshots.

• Question 109:

  You are mastering the company database called Testing; you should back up the Testing database fully. You do transaction log once every two hours from 08:00 to 17:00.You should run database snapshots for the Testing database. You should develop database snapshot every day at 07:00. At 8:30 the user removes the whole information on the Testing database which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the database. It is now

  11:45

  and many other changes have happened in the database. You should find solution to solve this problem .Which is the correct answer?

  A. You should utilize the SELECT subquery in the INSERT statement to move the deleted rows from this morning's database snapshot to the CurrentSpeaker table.
  B. You should utilize the Delete subquery in the INSERT statement to transfer the deleted rows from yesterday mornings database snapshot to the CurrentSpeaker
  C. You should reserve last nights Full Backup and all transaction log backups until the 10:00 backup. Use the STOP AT statement on the some restores to prevent
  D. You should reserve last nights Full Backup and all transaction log backups until the 10:00 backup. Utilize the STOP AT statement on the last restore to prevent
  A. You should utilize the SELECT subquery in the INSERT statement to move the deleted rows from this morning's database snapshot to the CurrentSpeaker table.

• Question 110:

  You administer a Microsoft SQL Server 2008 R2 instance.

  A disk drive that contains the files for the database is lost. The drive has been replaced, but the data files have been irrevocably lost.

  You need to restore the database.

  What should you do?

  A. Execute sp_helpfile.
  B. Execute DBCC CHECKDB.
  C. Examine the msdb..suspect_pagestable.
  D. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
  E. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
  F. Restore the database from the most recent full backup. Apply any differential and log backups.
  G. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
  H. Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.
  I. Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.
  F. Restore the database from the most recent full backup. Apply any differential and log backups.