
Ultimate access to all questions.
You are working with a dataset in Azure Synapse Analytics that exhibits significant data skew. Describe the strategies you would use to handle this skew and ensure balanced data distribution across the compute nodes. Include specific techniques or configurations that can be applied to mitigate the effects of data skew on query performance.
A
Ignore the skew as it is a common issue in large datasets.
B
Use Azure Synapse Analytics' distribution keys and partitioning strategies to evenly distribute data.
C
Manually redistribute the data across nodes.
D
Increase the number of compute nodes to handle the skew.