Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 151:

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

  Minimally logged operations are performed on the Finance database.

  You need to verify that the database can be restored to a specific point in time.

  What should you do?

  A. Verify that the database uses the full recovery model.
  B. Verify that the database uses the simple recovery model.
  C. Verify that the database uses the bulk-logged recovery model.
  D. Verify that the database uses the checksum page verify option.
  B. Verify that the database uses the simple recovery model.

• Question 152:

  You maintain a SQL Server 2008 instance.

  You plan to deploy an instance of SQL Server Reporting Services (SSRS) to the same machine.

  You need to ensure that by default. SSRS maintains version histories of all deployed reports.

  What should you do?

  A. Configure the SSRS database to use Native mode.
  B. Configure the SSRS database to use SharePoint integrated mode.
  C. Install the SSRS instance by using the http.sys listener.
  D. Install the SSRS instance by using the Internet Information Services default Web site.
  B. Configure the SSRS database to use SharePoint integrated mode.

• Question 153:

  You manage a SQL Server 2008 instance. You upgrade a SQL Server 7.0 database to the SQL Server instance.

  You need to ensure the early detection of suspect pages in the database.

  What should you do?

  A. Turn on the TRUSTWORTHY database option for the database.
  B. Set the database compatibility level option to 10 for the database.
  C. Set the PAGE_VERIFY database option to CHECKSUM for the database.
  D. Set the PAGE_VERIFY database option to TORN_PAGE_DETECTION for the model database.
  C. Set the PAGE_VERIFY database option to CHECKSUM for the database.

• Question 154:

  You are mastering the company database, with SQL Server 2008 computer named SQLTEST1The master database on SQLTEST1 is down. Some SQL Server Agent jobs should be included in the SQLTEST1.The whole database should be backed up every day. You rebuild and restore the master database. You should make sure that SQLTEST1 functions as it did before the database lost. Which is the correct answer?

  A. You should reserve the model and master databases for the database.
  B. You should reserve the Log Transaction for the database.
  C. You should rebuild the whole table schema for the database.
  D. You should rebuild the whole SQL Server Web Service for the database.
  A. You should reserve the model and master databases for the database.

• Question 155:

  You administer a Microsoft SQL Server 2008 R2 instance. You need to attach a database named Northwind to the server. Which Transact-SQL command should you use?

  

  A. B. C. D.
  D

• Question 156:

  You maintain a SQL Server 2008 instance that contains a database named Finance. The recovery model of the Finance database is set to Full. The backup strategy for the Finance database is as shown in the following table.

  

  The system databases, user database data, and log files are stored on separate disks. The hard disks that contain the user database data files are reported to have failed at 15:00 hours on Wednesday.

  You need to restore the Finance database from the database backups by ensuring minimal data loss in minimum possible time.

  What should you do?

  A. Restore the full backup taken on Sunday. Restore the differential backup taken on Wednesday.
  B. Back up the transaction log. Restore the full backup taken on Sunday. Restore all transaction log backups.
  C. Restore the full backup taken on Sunday. Restore the differential backup taken on Monday and Tuesday. Restore the transaction log backups taken at 08:00 hours and at 12:00 hours on Wednesday.
  D. Back up the transaction log. Restore the full backup taken on Sunday. Restore the differential backup taken on Tuesday. Restore all transaction log backups taken during Wednesday
  D. Back up the transaction log. Restore the full backup taken on Sunday. Restore the differential backup taken on Tuesday. Restore all transaction log backups taken during Wednesday

• Question 157:

  You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications. You configure the SQL Server Agent service to run by using the SERVER1\AGENT account. You create a job named MailingList that requires

  a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.

  You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.

  Which account type should you use?

  A. Domain account
  B. Local System account
  C. Local Service account
  D. Network Service account
  C. Local Service account

• Question 158:

  You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName.

  The current database collation is SQL_Latin1_General_Cp1_CI_AS.

  You need to ensure that the indexes which include the CompanyName column are case- sensitive.

  You also need to ensure that other case-insensitive queries are unaffected.

  What should you do?

  A. Use the UPPER function in the filter criteria on all queries that filter on the CompanyName column.
  B. Drop all indexes on the Sales database. Modify the database to specify SQL_Latin1_General_Cp1_CS_AS as the default collation. Rebuild all the indexes.
  C. Use the CAST function in the filter criteria on all queries that filter on the CompanyName column.
  D. Drop all indexes on the Customer table that include the CompanyName column in the index key. Modify the column to specify the SQL_Latin1_General_Cp1_CS_AS collation. Recreate the CompanyName indexes on the Customer table.
  A. Use the UPPER function in the filter criteria on all queries that filter on the CompanyName column.

• Question 159:

  You install a 64-bit version of a SQL Server 2008 instance by using the default setup and configuration settings. You receive the following error message:

  "Your SQL Server installation completed with \a: ures.1

  You close the error window before noting the location where additional information about the error is recorded.

  You need to locate the additional information.

  Where should you search?

  A. The Event Viewer Application log file
  B. The C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder
  C. The C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder
  D. The Event Viewer System log file
  B. The C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder

• Question 160:

  You are mastering the company database, On a SQL Server 2008, you find out that one of the data files computer is broken. You should reserve the database which is from the most recent configurations of backups. In order to cut the lost, you should find the method as quickly as possible. Which is the correct answer?

  A. You should run a transaction log backup for the database.
  B. You should reserve the old database backup for the database.
  C. You should reserve the most recent store produce log backup for the database.
  D. You should run the whole database backup.
  A. You should run a transaction log backup for the database.