Alan is a Data Engineer of Whizlabs Inc who is working on the development of dedicated SQL pool tables for Azure Synapse Analytics for an enterprise data warehouse project. He’s creating statistics for columns of dedicated SQL pool tables as a recommended approach. 
He issued the following t-sql statement. 
<pre class="brush:java;">CREATE STATISTICS statistics_column1 on adventureWorks_Sales_1(column1) where column1 &gt; ‘2000101’ AND column1 &lt; ‘20001241’</pre>
What’s the purpose of the statement for creating statistics in Synapse analytics dedicated SQL pool tables?

Answer options:

A.It’ll create statistics on a column, and by default, 20% of the table is sampled when creating statistics.
B.It’ll create statistics on a column specifying the sample size as 50%.
C.It’ll create multi-column statistics.
D.It’ll create column statistics on a range of values, and these values can easily be defined to match the range of values in a partition.

Correct Answer: D

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-statistics