You need to create the CustomerAccess table to support the reporting and performance requirements

DRAG DROP

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.

View Answer

Answer:

Explanation:

* 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.