Which TransactSQL statement should you use?

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?

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);



Leave a Reply 0

Your email address will not be published. Required fields are marked *