A. Compress the log file backups.

B. Alter the AdventureWorks database to use the Simple recovery mode.

C. Alter the AdventureWorks database to use the Full recovery mode.

D. Change the job to drop the indexes, and then recreate the indexes.

A. open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Properties.
Browse to the Advanced tab.
Configure the Filestream Access Level option to Full access enabled.

B. Open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Facets.
Choose the Server Configuration facet.
Configure the AweEnabled property to True.

C. Open Microsoft SQL Server Management Studio and connect to the server.
Right-click the server and select Properties.
Browse to the Advanced tab.
Configure the CLRIntegration property to True.

D. Run the following statement: EXEC sp_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp_configure 'clr enabled', 1 RECONFIGURE GO

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. You should reserve the Log Transaction for the database.

B. You should rebuild the whole SQL Server Web Service for the database.

C. You should reserve the model and master databases for the database.

D. You should rebuild the whole table schema for the database.

A. Create an Alert that will be raised when the job completes. This Alert will run another job to delete the maintenance job.

B. Create a job that is assigned to the Database Maintenance category.

C. Create a job that is scheduled to run once.

D. Create a job that uses the automatically delete job option.

A. sys.dm_tran_active_transactions

B. sys.dm_os_waiting_tasks

C. sys.dm_exec_requests

D. sys.dm_os_wait_stats

A. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.

B. Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.

C. Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.

D. Examine the msdb..suspect_pagestable.

E. Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.

F. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.

G. Execute sp_helpfile.

H. Restore the database from the most recent full backup. Apply any differential and log backups.

I. Execute DBCC CHECKD