A. You should create the package by using DTS Designer.

B. 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 Package Migration Wizard.

D. You should create the package by using the Microsoft SQL Server Import and Export Wizard.

A. 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.

B. Use the ALTER TABLEstatement to remove the COLLATEoption.

C. 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.

D. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.

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. Run the following statement:
EXECUTE sp_tableoption
@TableNamePattern ='OrderItem3',
@OptionName= 'PartltionByYear';
@OptionValue= 'true';

G. Execute the DBCC CLEANTABLEcommand on the OrderItems table.

H. Run the following statement:
CREATE PARTITION SCHEME SEC_FG
AS PARTITION FUNC_FG
ALL TO (SECONDARY);

I. Remove the clustered index from the table.

J. Create a new partition function.
Create a new partition scheme.
Add a clustered index to place the data onto the partition scheme.

A. Option D

B. Option C

C. Option A

D. Option B

A. Alter the default resource pool and set the MAX_CPU_PERCENT option to 80.
Assign tins resource pool to the workload group used by SQL Server Management Studio.

B. Alter the default resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by the mission-critical applications.

C. Create a new resource pool and set the MAX_CPU_PERCENT option to 20.
Assign this resource pool to the workload group used by SQL Server Management Studio.

D. Create a new resource pool and set the MAX_CPU_PERCENT option to 80.
Assign this resource pool to the workload group used by the mission-critical applications.

A. Grant the appropriate object-level permissions to SalesAppUser.

B. Grant the appropriate server-level permissions to SalesAppLogin.

C. Grant the appropriate database-level permissions to SalesAppUser.

D. Add SalesAppUser to the appropriate fixed database roles.

A. Modify the parameters of the email that contains the reports.

B. Create a separate Database Mail profile for the reports.

C. Configure the security settings of the Database Mail system.

D. Modify the SMTP relay settings.

A. Allow failback only during business horns

B. Prevent automatic failback

C. Immediately allow failback

D. Allow failback only during non-business hours

A. You should develop a trigger which rolls back changes to the Price column which breaks company policy.

B. You should develop a view which rolls back changes to the Price column which breaks company policy.

C. You should develop a stored procedure which allows changes to the Price column which breaks company policy.

D. On the Price column, you should develop a primary key constraint to a table which includes valid prices.

A. Grant the CREATE TABLE permission and allow User1 to drop the Sales.Table1 table.

B. Insert the EXECUTE AS USER = 'dbo' statement between lines 02 and 03.

C. Grant the ALTER permission on the Sales schema to User1.

D. Insert the WITH EXECUTE AS 'dbo' clause between lines 01 and 02.