Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 71:

  You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which is down.

  You operate a restore by using the following Transact-SQL script. RESTORE DATABASE ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY After the restore, the SQL Server logs

  show errors in some page restores.

  What you should do is to repair the database pages, which are down, and facilitates repair by using the fastest method.

  Which is the correct answer?

  A. You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
  B. You should add code: ALTER DATABASE Contracts SET TORN_PAGE_DETECTION ON
  C. You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH TABLOCK
  D. You should add code: ALTER DATABASE Contracts SET TRUSTWORTHY ON
  C. You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH TABLOCK

• Question 72:

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

  A SQL Server login named SalesAppLogin maps to a database user named SalesAppUser in the Sales database.

  You need to ensure that the database user can perform only the following tasks:

  What should you do?

  A. Add SalesAppUser to the appropriate fixed database roles.
  B. Grant the appropriate object-level permissions to SalesAppUser.
  C. Grant the appropriate server-level permissions to SalesAppLogin.
  D. Grant the appropriate database-level permissions to SalesAppUser.
  D. Grant the appropriate database-level permissions to SalesAppUser.

• Question 73:

  You administer a SQL Server 2008 instance. The instance contains an On-Line Analytical Processing (OLAP) database along with a dimension table named Customers. The data of the Customers table is updated every thirty minutes.

  The Customers table contains redundant data.

  You need to conserve the disk space used to store the Customers table.

  What should you do?

  A. Implement row compression.
  B. Implement page compression.
  C. Compress the hard disk that contains the instance.
  D. Defragment the hard disk that contains the instance.
  B. Implement page compression.

• Question 74:

  You migrate an application named App1 from Microsoft SQL Server 2000 to SQL Server 2008.

  You plan to monitor the SQL Server instance.

  You need to capture the use of features that will be discontinued.

  What should you do?

  A. Run the SQL Server 2008 Upgrade Advisor.
  B. Run the SQL Server Profiler and capture the Exception event class.
  C. Create a Data Collector Set that captures the Microsoft-Windows-COMRuntime event trace provider.
  D. Create a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.
  D. Create a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.

• Question 75:

  You maintain a SQL Server 2008 instance that contains a database named Finance. The most recent full backup was taken at 13:00 horns, a differential backup was taken at

  15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at

  17:02 hours.

  You need to restore the Finance database by ensuring minimal data loss.

  What should you do?

  A. Restore the full backup.
  B. Restore the database snapshot from 16:00 hours.
  C. Restore the database snapshot from 17:00 hours.
  D. Restore the full backup and the differential backup.
  D. Restore the full backup and the differential backup.

• Question 76:

  You maintain a SQL Server 2008 instance.

  You have an existing database maintenance plan that performs the following tasks:

  You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.

  What should you modify?

  A. The instance.
  B. The SQL Server service.
  C. The SQL Server Agent job.
  D. The database maintenance plan.
  C. The SQL Server Agent job.

• Question 77:

  You administer a SQL Server 2008 instance. You use an internal application based on SQL Server 2008. The application uses Analysis Services and Reporting Services. Company security policy requires that the surface area for all the deployed components of SQL Server 2008 be configured.

  You need to implement the security policy and devise a method to evaluate the security policy against other database servers. What should you do?

  A. Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
  B. Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.
  C. Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
  D. Create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to rim the script against a server group that includes the database servers that need to be configured
  C. Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.

• Question 78:

  You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?

  A. Snapshot replication should be utilized. You should set the trg_Coupon trigger on the server in every store to utilize the NOT FOR REPLICATION option.
  B. You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.
  C. You should utilize transactions log between the server in each retail store and the central server in the main office.
  D. You should build multiple merge publications, one at every store and one in the main office.
  B. You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.

• Question 79:

  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.

  What should you do?

  A. Configure the SQL Server service.
  B. Configure the SQL Server Full Text service.
  C. Modify the Volume Shadow Copy settings.
  D. Modify the Background Intelligent Transfer Service settings.
  A. Configure the SQL Server service.

• Question 80:

  You maintain several SQL Server 2008 instances. You need to ensure that the names of all user-defined stored procedures contain the prefix usp_ on all instances.

  You also need to ensure that you cannot create stored procedures that do not contain this prefix.

  What should you do?

  A. Create a policy that targets the name of the stored procedure that is evaluated on change.
  B. Create a policy that targets the name of the stored procedure that is evaluated on demand.
  C. Create a condition that targets the name of stored procedure that is evaluated on demand.
  D. Create a condition that targets the name of the stored procedure that is evaluated on change.
  A. Create a policy that targets the name of the stored procedure that is evaluated on change.