You need to create the CustomerAccess table to support the reporting and performance requirements.
Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
Select and Place:
Correct Answer:
Explanation/Reference:
Note:
* Scenario: During your investigation, you discover that the sales force reports are causing significant contention.
* Step 1: add filegroup
* Step 2: add file
* Step 3: create table on filegroup
/ CREATE TABLE ON { <partition_scheme> | filegroup | "default" }
Specifies the partition scheme or filegroup on which the table is stored.
ALTER DATABASE File and Filegroup Options (Transact-SQL)
CREATE TABLE (SQL Server)