Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 21:

  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 Sunday 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.
  H. Restore the backups taken Wednesday, Friday, and Saturday.

• Question 22:

  You are reviewing and configuring the security of a SQL Server 2008 instance that contains database DB1.

  The security audit policy specifies the following requirements:

  Only successful and failed logon attempts are recorded in log files.

  The SQL Server instance is shut down if records cannot be written to the log files.

  You need to configure the SQL Server instance to comply with the security audit policy.

  Which Transact-SQL statements should you run?

  A. sp_configure 'show advanced options', l:GORECONFIGURE:GOsp_configure 'default trace enabled'. 1 ;GORECONFIGUREGO
  B. sp_configure 'show advanced options'. 1 ;GORECONFIGURE;GOsp_configure 'common criteria compliance enabled'. 1 ;GORECONFIGUREGO
  C. CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\AuditV ) WITH (ON_FAILURE = SHUTDOWN) ;GOCREATE DATABASE AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP).ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GO ALTER SERVER AUDIT SrvAucfit WITH (STATE=ON);GO
  D. CREATE SERVER AUDIT Srv_Audit TO FILE (FILEPATH =`\\MAIN_SERVER\Audit\') WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO
  D. CREATE SERVER AUDIT Srv_Audit TO FILE (FILEPATH =`\\MAIN_SERVER\Audit\') WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO

• Question 23:

  You maintain a SQL Server 2008 instance that contains a database named Finance. In your absence, a user with a login named Rob will maintain the database snapshots.

  You need to giant the appropriate permissions to the user to delete the database snapshots for the Finance database.

  Which database permission should you giant?

  A. DELETE
  B. CONTROL
  C. DROP DATABASE
  D. ALTER ANY DATASPACE
  C. DROP DATABASE

• Question 24:

  You administer a SQL Server 2008 instance. The instance contains various SQL Server Agent jobs that use seven shared schedules to run each job on each day of the week. You need to ensure that a job named Job5 no longer runs on Thursdays. What should you do?

  A. Delete the schedule for Thursday.
  B. Disable the schedule for Thursday.
  C. Remove the schedule for Thursday from Job5.
  D. Add a new Job5 schedule for Thursday and disable it.
  C. Remove the schedule for Thursday from Job5.

• Question 25:

  You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed which contains the Microsoft Clustering mining model. From Scalable K-Means to Non-scalable K-Means.

  You should alter the attribute of the mining model. Which is the correct answer?

  A. You should change MODELLING_CARDINALITY
  B. You should change CLUSTERING_METHOD
  C. You should change INDEXDEFRAG
  D. You should change SHRINKFILE
  B. You should change CLUSTERING_METHOD

• Question 26:

  You maintain a SQL Server 2008 instance. Your failure recovery plan requires you to back up the default trace.

  You need to backup the subdirectory that contains the default trace.

  Which SQL Server database engine subdirectory should you back up?

  A. LOG
  B. BINN
  C. DATA
  D. INSTALL
  A. LOG

• Question 27:

  Yon maintain a SQL Server 2008 instance that contains a database named Finance.

  The backup strategy for the Finance database specifies the following requirements:

  The Finance database is being used in single-user mode.

  At 08:40 hours, a user reports that some important data was accidentally deleted by a query that was executed at 08:23 horns.

  You need to restore the database to its original state.

  Which Transact-SQL statement(s) should you use?

  B

• Question 28:

  You need to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance.

  You need to ensure that both database instances are available for their respective certified third-party applications.

  You need to achieve this goal by complying with the following constraints:

  What should you do?

  A. Upgrade the SQL Server 2005 application to use SQL Server 2008.
  B. Upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
  C. Install SQL Server 2008 as a named instance, and configure the new application to use the new instance.
  D. Install SQL Server 2008 as the default instance, and configure the new application to use the default instance.
  C. Install SQL Server 2008 as a named instance, and configure the new application to use the new instance.

• Question 29:

  You administer a Microsoft SQL Server 2008 R2 instance.

  You need to ensure that no suspect pages have been detected in your 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.
  C. Examine the msdb..suspect_pagestable.

• Question 30:

  You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database has a table named Products that stores information about all types of products. Users frequently query the Products table based on the TelevisionSize column. The TelevisionSize column has the NULL value for all products other than Televisions. There is currently no index on the TelevisionSize column. You need to improve the query performance by ensuring that the effect on the disk space is minimized. What should you do?

  A. Create a filtered index on the TelevisionSize column.
  B. Create a clustered index on the TelevisionSize column.
  C. Create a unique clustered index on the TelevisionSize column.
  D. Create a view on the Products table by filtering on the TelevisionSize column.
  A. Create a filtered index on the TelevisionSize column.