You have a table named AccountsReceivable. The table has no indexes. There are 75,000 rows in the
table. You have a partition function named FG_AccountDat
a. The AccountsReceivable table is defined in
the following TransactSQL
statement:
CREATE TABLE AccountsReceivable (
column_a INT NOT NULL,
column_b VARCHAR(20) NULL)
ON [PRIMARY];
You need to move the AccountsReceivable table from the PRIMARY file group to FG_AccountData.
Which TransactSQL statement should you use?
A.
CREATE CLUSTERED INDEX idx_AccountsReceivable
ON AccountsReceivable(column_a)
ON [FG_AccountData];
B.
CREATE NONCLUSTERED INDEX idx_AccountsReceivable
ON AccountsReceivable(column_a)
ON [FG_AccountData];
C.
CREATE CLUSTERED INDEX idx_AccountsReceivable
ON AccountsReceivable(column_a)
ON FG_AccountData(column_a);
D.
CREATE NONCLUSTERED INDEX idx_AccountsReceivable
ON AccountsReceivable(column_a)
ON FG_AccountData(column_a);