Which statement accurately describes the dbo,FactInternetSales table?

You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED (dbo,FactInternetSales’); and get the results shown in the following table. Which statement accurately describes the dbo,FactInternetSales table?A . The table contains less than 1,000 rows.B . All distribution contain data.C . The table is skewed.D . The table uses round-robin distribution. View...

Continue reading

Approximately how many rows will there be for each combination of distribution and partition?

You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contains approximately 60 million rows per month and will be partitioned by month. The table will use a clustered column store index and round-robin distribution. Approximately how many rows will there be for each combination of...

Continue reading