Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 131:

  You administer a SQL Server 2008 instance that contains a database named Ad venture Works.

  You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.

  During the weekend, the primary SQL Server instance required a restart. After the weekend, you discover that log shipping has stopped working.

  You need to troubleshoot log shipping of the Adventureworks database.

  What should you do?

  A. Verify whether the SQL Server Agent is started on the primary server.
  B. Verify whether the AdventureWorks database uses the Simple recovery model.
  C. Verify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server.
  D. Execute a DBCC CHECKDB statement on the AdventureWorks database by using the EXTENDED_LOGICAL_CHECKS option.
  A. Verify whether the SQL Server Agent is started on the primary server.

• Question 132:

  You administer three SQL Server 2008 instances on separate servers named Server1, Server2, and Server3.

  The AdventureWorks database is configured for mirroring between the instances. In the mirroring session, Server1 and Server2 act as partners and Server3 as the witness.

  You have the following requirements:

  You need to ensure that automatic failover is disabled during the maintenance process.

  What should you do first?

  A. Suspend the mirroring session.
  B. Remove mirroring from the database.
  C. Configure the mirroring session with the SAFETY option set to ON.
  D. Remove the witness server from the mirroring session.
  C. Configure the mirroring session with the SAFETY option set to ON.

• Question 133:

  You maintain a SQL Server 2008 instance that contains a database named OrderEntry. The OrderEntry database contains a table named OrderDelivery.

  You add a column named DeliveryPoint to the OrderDelivery table. The DeliveryPoint column is of the Geography data type. The OrderDelivery table does not contain indexes.

  You need to create a spatial index on the DeliveryPoint column.

  What should you do first?

  A. Define a primary key for the OrderDelivery table.
  B. Create a clustered index for the OrderDelivery table.
  C. Ensure that the DeliveryPoint column does not allow NULL values.
  D. Copy the OrderDelivery data to a temporary table and truncate the existing OrderDelivery table.
  A. Define a primary key for the OrderDelivery table.

• Question 134:

  You are mastering the company database, and managing 20 SQL Server 2005 computers which are operated by other administrators that are asked to meet company service level agreements (SLAs) on querying response time.

  Some of the method on controlling query response times on the servers should be told for these administrators.

  Which is the correct answer?

  A. You should create a query that searches the sys.dm_db_partition_stats dynamic management view (DMV). Then distribute this search to the administrators.
  B. You should develop an XML schema which includes the event and column names of the query response times, which should be captured in SQL Server Profiler.
  C. You should develop SQL Server Profiler templates, which contain query start times and end times. Then distribute these templates to the database
  D. You should teach the administrators to use System Monitor Control Tool
  C. You should develop SQL Server Profiler templates, which contain query start times and end times. Then distribute these templates to the database

• Question 135:

  You administer a SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Sales.Table1.

  You need to obtain the effective permissions of a user named User1 to access the Sales.Table1 table.

  Which Transact-SQL statement(s) should you execute in the DB1 database?

  

  A. B. C. D.
  B

• Question 136:

  You administer a SQL Server 2008 instance.

  A user named Julie reports repeated failed connections because of incorrect password usage for the login name srpc8521. Julie has been able to successfully login using this account in the past. Julie then recalls the correct password.

  However, her connection is still denied.

  You need to enable the SQL Server login.

  Which Transact-SQL statement should you use?

  A. ALTER LOGIN srpc8521 ENABLE;
  B. ALTER LOGIN srpc8521 UNLOCK;
  C. ALTER LOGIN srpc8521 WITH CHECK_EXPIRATION = OFF;
  D. ALTER LOGIN srpc8521 WITH NO CREDENTIAL;
  D. ALTER LOGIN srpc8521 WITH NO CREDENTIAL;

• Question 137:

  You manage a SQL Server 2008 instance.

  You need to verify whether a database integrity check (DBCC CHECKDB) was run for a particular database.

  Which log file should you examine?

  A. log.trc
  B. default.trc
  C. ERRORLOG
  D. SQLAGENT
  C. ERRORLOG

• Question 138:

  You maintain a default SQL Server 2008 instance.

  You plan to configure FILESTREAM data to meet the following requirements:

  You need to ensure that FILESTREAM data is enabled.

  Which service should you configure?

  A. SQL Server
  B. SQL Server Full Text
  C. SQL Server VSS Write
  D. Distributed File System
  A. SQL Server

• Question 139:

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

  10: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.
  G. Restore the backups taken on Wednesday and Friday.

• Question 140:

  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:

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

  What should you do?

  A. Enable C2 auditing.
  B. Enable common criteria compliance.
  C. Create a server audit specification.
  D. Configure Change Data Capture.
  C. Create a server audit specification.