Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 161:

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

  You suspect that three large tables in the Finance database are corrupt. You plan to execute the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime.

  You need to set the database option to prevent users from accessing the database during the execution of the statement.

  Which database option should you turn on?

  A. OFFLINE
  B. READ_ONLY
  C. RESTRICTED_USER
  D. SINGLE_USER
  D. SINGLE_USER

• Question 162:

  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 163:

  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.
  A. Restore the backup taken on Sunday only.

• Question 164:

  You are managing a SQL Server 2008 instance which includes a database called TesterDB for Home.com. The data file and the transaction log file which are located on the D: drive that owns only 10 percent useful space. You should make sure that you move both files to the G: drive.

  Which is the correct answer?

  A. You should implement the statement below: ALTER DATABASE Finance SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and
  B. Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY FILE(NAME = Finance_Data, FILENAME =
  C. mdf'); ALTER DATABASE Finance SET MULTI_USER;
  D. You should utilize the following Transact-SQL statement.
  E. ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;
  F. ALTER DATABASE TesterDB
  G. mdf'); ldf'); ALTER DATABASE TesterDB SET ONLINE;
  B. Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY FILE(NAME = Finance_Data, FILENAME =

• Question 165:

  You administer a SQL Server 2008 instance.

  A database developer named User1 needs to view the definitions of all database objects in a database and read data from all user-defined tables, views, and table-valued functions.

  You need to set the required permissions for User1.

  Which Transact-SQL statements should you execute?

  

  A. B. C. D.
  B

• Question 166:

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

  You plan to use data compression to conserve disk space. You compress a table named VeryLarge that has a clustered index named Index1 and a non-clustered index named Index2. Both indexes are partitioned.

  You execute the following Transact-SQL statement.

  ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW); You need to ensure that all the indexes of the VeryLarge table are compressed by using row-level compression.

  You need to accomplish this goal by using minimum resources.

  Which Transact-SQL statement should you execute?

  A. ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH (DATA_COMPRESSION = ROW);
  B. ALTER INDEX ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
  C. ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
  D. ALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);
  C. ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);

• Question 167:

  You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.

  The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable.

  You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements.

  What should you do?

  A. Perform a full database backup once daily.
  B. Perform a full database backup once daily. Perform a differential backup every two horns during business hours.
  C. Perform a full database backup once daily. Perform a transaction log backup every two hours during business hours.
  D. Perform a full database backup once every week. Perform a differential backup once daily. Perform a transaction log backup every two hours during business hours.
  B. Perform a full database backup once daily. Perform a differential backup every two horns during business hours.

• Question 168:

  You administer a Microsoft SQL Server 2008 R2 database instance.

  You need to identify the purpose of each Dynamic Management Views (DMVs).

  What should you do? (To answer, drag the appropriate purpose to the correct DMV in the answer area. Each purpose may be used once, more than once, or not at all. Each DMV may be used once or not at all. Additionally, you may need to

  drag the split bar between panes or scroll to view content.)

  Select and Place:

  

  

• Question 169:

  You administer a Microsoft SQL Server 2008 R2 instance.

  You need to configure mirroring between two servers in high-performance mode.

  What should you do?

  A. Create mirroring endpoints on both partner servers. Use Microsoft SQL Server Management Studio on both partner servers to select the High Performance option, and start mirroring.
  B. Create mirroring endpoints on both partner servers. On the principal server, use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause.
  C. Create mirroring endpoints on both partner servers. Execute the following stored procedure: Sp_configure 'Lightweight Pooling', 1
  D. Create mirroring endpoints on both partner servers. Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.
  A. Create mirroring endpoints on both partner servers. Use Microsoft SQL Server Management Studio on both partner servers to select the High Performance option, and start mirroring.

• Question 170:

  You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a Windows PowerShell job step.

  The PowerShell job step uses the SQLCmd utility to transfer data between servers.

  You need to ensue that an operator named ResponseTeam is notified by an e-mail message if the job fails.

  What should you do?

  A. Enable Notifications. Create the ResponseTeam operator. Direct the Notification to the ResponseTeam operator on job failure.
  B. Enable Notifications. Create the ResponseTeam operator. Direct the Notification to the ResponseTeam operator on failure of the Powershell job step.
  C. Create the ResponseTeam operator. Assign the ResponseTeam operator as the failCsafe operator. Enable the job.
  D. Create the ResponseTeam operator. Configure the job step proxy account to use the ResponseTeam operator account. Select the proxy account for the e-mail profile.
  A. Enable Notifications. Create the ResponseTeam operator. Direct the Notification to the ResponseTeam operator on job failure.