Which type of index should you use to minimize the query times of each index?

DRAG DROP
You are designing an indexing strategy for a data warehouse. The data warehouse contains a table named Table1. Data is bulk inserted into Table1.

You plan to create the indexes configured as shown in the following table.
Which type of index should you use to minimize the query times of each index? To answer, drag the appropriate index types to the correct indexes. Each index type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Correct Answer:

Explanation/Reference:
Explanation:
Box 1: Clustered columnstore
A clustered columnstore index is the physical storage for the entire table.
With columnstore index, SQL Server processes aggregate in BatchMode thereby delivering order of magnitude better performance when compared to rowstore.
SQL Server 2016 takes the aggregate performance to the next level by pushing aggregate computations to the SCAN node.
Box 2: Nonclustered columnstore
A nonclustered columnstore index and a clustered columnstore index function the same. The difference is that a nonclustered index is a secondary index that’s created on a rowstore table, but a clustered columnstore index is the primary storage for the entire table.
The nonclustered index contains a copy of part or all of the rows and columns in the underlying table. The index is defined as one or more columns of the table and has an optional condition that filters the rows.
References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview