You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table that is stored as a heap. You perform page-level
compression on the table. When data is added to the table by using BULK INSERT, the new
pages are not compressed. You need to ensure page-level compression for all data pages
when they are allocated to the table. Which query hint should you use?

A.
PAG LOCK

B.
NOLOCK

C.
NOWAIT

D.
TABLOCK