Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 91:

  You maintain a SQL Server 2008 instance.

  The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during startup.

  You need to ensure that your failure recovery plan backs up the use of the trace flags.

  What should you do?

  A. Backup the default.trc file.
  B. Backup the master database.
  C. Backup the resource database.
  D. Backup the SQL Server registry hive.
  D. Backup the SQL Server registry hive.

• Question 92:

  You administer three SQL Server 2008 instances named Instance 1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance 1 and Instance2. Instances acts

  as the witness.

  Instance 1 currently acts as the Principal.

  You plan to apply a patch to both servers. The patch requires a restart of the server.

  You need to find out the sequence of steps necessary to ensure that the following requirements are met:

  What should you do?

  A. Apply the patch to the server that runs Instance2. Apply the patch to the server that runs Instance1.
  B. Apply the patch to the server that runs Instance2. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.
  C. Remove the mirroring session. Apply the patch to the server that runs Instance2. Apply the patch to the server that runs Instance1. Re-establish the mirroring session.
  D. Suspend the mirroring session. Apply the patch to the server that rims Instance2. Resume the mirroring session. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.
  D. Suspend the mirroring session. Apply the patch to the server that rims Instance2. Resume the mirroring session. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.

• Question 93:

  You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by using transactional replication. A full backup of

  each database is performed every night. Transaction log backups are performed every hour.

  Replication latency is typically less than two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted.

  You are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You need to return the Sales database on SQLTEST1 to normal operation as quickly as possible.

  You must ensure a minimum loss of data and minimal impact to users of either server.

  What should you do?

  A. You should reserve the most recent full database backup and the whole transaction logs made since the past backup could be made.
  B. You should reserve only the newest transaction log backup.
  C. You should detach the Sales database on SQL2. Copy the database file to SQL1, and link the database on both servers.
  D. You should reserve a full database backup on SQL2. Reserve the backup to SQL1.
  D. You should reserve a full database backup on SQL2. Reserve the backup to SQL1.

• Question 94:

  You administer a SQL Server 2008 instance. You need to allow users on instance to query remote data sources by using the OPENROWSET() sp_configure configuration option should you configure?

  A. Agent XPs
  B. remote access
  C. remote proc trans
  D. Ad Hoc Distributed Queries
  D. Ad Hoc Distributed Queries

• Question 95:

  You administer a Microsoft SQL Server 2008 R2 database instance.

  You need to identify queries or stored procedures that are consuming server resources. You also need to view the query plan that is being used by each of these queries or procedures.

  Which Dynamic Management Views (DMVs) should you use to find details about specific queries? (Choose all that apply.)

  A. dm_io_virtual_file_stats
  B. dm_exec_sql_text
  C. dm_exec_query_stats
  D. dm_exec_connections
  E. dm_exec_query_plan
  A. dm_io_virtual_file_stats
  B. dm_exec_sql_text
  D. dm_exec_connections

• Question 96:

  You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns

  The most common queries are listed below Transact-SQL statements. --QUERY 1SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE [ProductLine] = 'T' --QUERY 2SELECT * FROM [Production].

  [Product] ORDER BY [Name]

  When you are minimizing the space required for the indexes.

  You should select the best indexes to maintain the most common searched to the Production. Product tableWhich is the correct answer?

  A. You should develop a clustered index on the Name column.
  B. You should develop a nonclustered index on the Name column.
  C. You should develop a clustered index on the ProductLine, ListPrice, Class and Style columns.
  D. You should develop a nonclustered index on the ProductLine, ListPrice columns.
  A. You should develop a clustered index on the Name column.

• Question 97:

  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 Friday 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.
  D. Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at 18:00 hours.

• Question 98:

  You are mastering the company database; there is the transaction information which is for company's Web-based order system in the database of the company.

  The database is set to utilize the full recovery model. Between the hours of 20:00 and

  04:00, you get the few orders; one hour should be accepted for the risk when the system is runningDatabase backups should be run as quickly as possible. You should create the solution to avoid this kind of risk. What should you do?

  A. You should set a Back up Database job to run the whole backup of the database every hour. Set a Check Database Integrity task to run every day in order to
  B. You should set a Back up Database job to do the whole backup of the database every day at 20:00. Set a second Back up Database task to run differential
  C. Set a third Back up Database job to run transaction log backups every hour.
  D. You should set a Back up Database task to do the whole backup of the database every day at 20:00. Configure a second Back up Database job to run differential E. Configure a Check Database Integrity task to run every hour.
  F. You should set a Back up Database job to run the whole backup at 09:00 and 14:00. Set a second Back up Database task to do transaction log backups every
  B. You should set a Back up Database job to do the whole backup of the database every day at 20:00. Set a second Back up Database task to run differential

• Question 99:

  You administer a SQL Server 2008 instance.

  You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports during business hours.

  The reports to the manager take a long time to be delivered.

  You need to ensure that the reports to the manager are sent as quickly as possible.

  What should you do?

  A. Modify the SMTP relay settings.
  B. Create a separate Database Mail profile for the reports.
  C. Configure the security settings of the Database Mail system.
  D. Modify the parameters of the email that contains the reports.
  B. Create a separate Database Mail profile for the reports.

• Question 100:

  You maintain a SQL Server 2008 instance.

  You discover that the database named CityPowerLightDB presents data integrity problems.

  You perform a full database backup at 22:00 hours. The SQL Server instance experiences a power failure at 05:59 hours. No data modifications have occurred after the backup.

  When the database is online, you discover that some table data pages are corrupt.

  You need to completely repair the database in the minimum amount of time. What should you do?

  A. Restore the corrupt pages from the full database backup.
  B. Restore the database from the full database backup.
  C. Use the DBCC CHECKTABLE command along with the PHYSICAL_ONLY option.
  D. Use the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option.
  A. Restore the corrupt pages from the full database backup.