Study with 070-432 Actual Test Questions

You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?

• A. Use the SQL Server 2008 Upgrade Advisor.
• B. Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event classes.
• C. Use a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.
• D. Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes.

You maintain a SQL Server 2008 instance that contains a database named Finance. In your absence, a user with a login named Rob will maintain the database snapshots. You need to giant the appropriate permissions to the user to delete the database
snapshots for the Finance database. Which database permission should you giant?

• A. DROP DATABASE
• B. ALTER ANY DATASPACE
• C. CONTROL
• D. DELETE

You are mastering the company database; a new SQL Server 2008 computer named TesterDB should be set by yourself. Reporting Services will work in TesterDB. It should be set to run database backups and other maintenance job automatically. In the network environment, the company has no other SQL Server computers. The whole approach SQL2 will be made by using SQL1s DNS name. You should enable any necessary devices on SQL2. Which is the correct answer?(select more than one)

• A. You should utilize SQL Server Browser technology
• B. You should utilize Internet Information Services technology
• C. You should utilize SQL Server Web Service technology
• D. You should utilize Microsoft Distributed Transaction Coordinator technology

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

The following DDL has been run on the database:
CREATE PARTITION FUNCTION FUNC_FG (INT)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
You need to create a partition scheme that will place all data to the SECONDARY filegroup.
What should you do?

• A. Remove the clustered index from the table.
• B. Use the ALTER TABLEstatement to remove the COLLATEoption.
• C. Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);
• D. 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.
• E. 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.
• F. Run the following statement:
  EXECUTE sp_tableoption
  @TableNamePattern ='OrderItem3',
  @OptionName= 'PartltionByYear';
  @OptionValue= 'true';
• G. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• H. 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.
• I. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• J. Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.

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. Option D
• B. Option B
• C. Option A
• D. Option C