Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 51:

  You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

  

  Currently, the table is partitioned by year with each year in its own filegroup.

  You need to add a new partition for the upcoming year.

  What should you do?

  A. Remove the clustered index from the table.
  B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
  C. Use the ALTER TABLEstatement to remove the COLLATEoption.
  D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
  E. Create a new filegroup. Create a new database file. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use ALTER INDEX REORGANIZE statement.
  F. Create a new Filegroup. Create a new database File. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
  G. Create a new table. Use the ALTER TABLE statement along with the SWITCH PARTITION clause. Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
  H. Create a new partition function. Create a new partition scheme. Add a clustered index to place the data onto the partition scheme.
  I. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG ALL TO (SECONDARY);
  J. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= `PartltionByYear'; @OptionValue= 'true';
  F. Create a new Filegroup. Create a new database File. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.

• Question 52:

  You administer a Microsoft SQL Server 2008 R2 database instance.

  You plan to automate maintenance tasks.

  What task types are included in a SQL Maintenance Plan? (Choose all that apply.)

  A. Back up databases
  B. Defrag hard disks
  C. Rebuild indexes
  D. Copy databases between servers
  E. Update database statistics
  B. Defrag hard disks
  C. Rebuild indexes
  E. Update database statistics

• Question 53:

  You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance.

  The recovery model of the Finance database is set to Full. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4

  hours.

  You plan to perform a full backup of the Finance database at 11:00 hours.

  You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence.

  Which Transact-SQL statement should you use?

  A. BACKUP LOG FINANCE TO DISK = 't:\backups\finance.trn';
  B. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH NOUNLOAD;
  C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:
  D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH DIFFERENTIAL;
  C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:

• Question 54:

  You are a database administrator for your company. There are four automated testing areas for finished items in the company's manufacturing floor. SQL Server 2008 is used to reserve testing results for every testing area. You should create a replication method to make sure that test results flow from the testing areas to the SQL Server quickly. The results of testing will be used on reporting. Which is the correct answer?

  A. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a pull subscription on each distributor to the
  B. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a merge subscription on each distributor to the
  C. You should develop a separate transactional publication at each of the testing areas for the test results. Develop push subscriptions on each of the testing areas
  D. You should develop a separate transactional publication at each of the testing areas for the test results. Develop a merge subscription on each distributor to the
  C. You should develop a separate transactional publication at each of the testing areas for the test results. Develop push subscriptions on each of the testing areas

• Question 55:

  You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.

  You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The application instantiates ActiveX objects from stored procedures in the database by using sp_OACreate.

  You need to configure SQL Server 2008 R2 to allow command-line calls from this database.

  Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 56:

  You administer a Microsoft SQL Server 2008 R2 database instance.

  Occasionally, the following problems occur:

  You need to be able to diagnose each of these problems.

  Which tool or tools should you use? (To answer, drag the appropriate problem to the correct tool in the answer area. Each problem may be used once, more than once, or not at all. Each tool 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 57:

  You administer a Microsoft SQL Server 2008 R2 instance by using a database named AdventureWorks2008R2.

  You need to implement transparent data encryption for a database hosted by the server.

  Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 58:

  You administer a SQL Server 2008 instance that contains a very large database named FinanceDB.

  You plan to create a maintenance plan that meets the following objectives for the FinanceDB database:

  You need to ensure that the maintenance plan is executed in the minimum amount of time.

  Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

  A. Use the Reorganize Index task.
  B. Use the Update Statistics task.
  C. Use the Shrink Database task.
  D. Use the Check Database Integrity task.
  E. Use the Rebuild index task.
  A. Use the Reorganize Index task.
  E. Use the Rebuild index task.

• Question 59:

  You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

  

  Currently, the table is partitioned by Quarter. You need to make the table unpartitioned.

  What should you do?

  A. Remove the clustered index from the table.
  B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
  C. Use the ALTER TABLEstatement to remove the COLLATEoption.
  D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
  E. Create a new filegroup. Create a new database file. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use ALTER INDEX REORGANIZE statement.
  F. Create a new Filegroup. Create a new database File. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
  G. Create a new table. Use the ALTER TABLE statement along with the SWITCH PARTITION clause. Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
  H. Create a new partition function. Create a new partition scheme. Add a clustered index to place the data onto the partition scheme.
  I. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG ALL TO (SECONDARY);
  J. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= `PartltionByYear'; @OptionValue= 'true';
  A. Remove the clustered index from the table.

• Question 60:

  Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS). Which is correct?

  A. You should create the package by using DTS Designer.
  B. You should create the package by using the Package Migration Wizard.
  C. You should create the package by using the Microsoft SQL Server Import and Export Wizard.
  D. On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, you should click the Create Package submenu.
  C. You should create the package by using the Microsoft SQL Server Import and Export Wizard.