You have a dedicated SQL pool in Azure Synapse Analytics. Your objective here is to achieve high performance and data compression. Choose the right option about the following statements. 
Statement 1: Using column store indexes will increase the performance and compression. 
Statement 2: The default behavior of a dedicated SQL pool is to store the table as a clustered columnstore index.

Answer options:

A.Statement 1 is correct and statement 2 is incorrect.
B.Statement 1 is incorrect and statement 2 is correct.
C.Both statements are incorrect.
D.Both statements are correct.

Correct Answer: D
Columnstore indexes are basically used for improving query performance and data compression. This proves that statement 1 is correct. And by default, the SQL dedicated pool stores the table as a clustered columnstore index. This shows that the second statement is also correct. Also, in most cases, when performance-related concerns are introduced in question, look for columnstore indexing as an answer rather than clustered index and heap. Clustered indexing and heap are used very rarely for specific workloads only in Azure Synapse. Options A, B, Care incorrect: It says that at least one of the statements is wrong. But in this case, both statements are correct.
Option D is correct: Both statements are correct.
Reference: 
To know more about Distribution methods, please refer to the doc below: 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview#columnstore-indexes