Question 42:
In Azure Synapse, the data is distributed in three different ways: Round-Robin, Hashing, and Replication. Which distribution type to be used depends upon the scenario and the requirements. Which of the following statement(s) is/are true about these distribution types? (Select all that are applicable)
Answer options:
A.Choose Hash distribution when you can’t identify a single key for distributing your data. B.Choose Round Robin distribution when you can’t identify a single key for distributing your data. C.Choose Round Robin distribution if the table is having temporary data. D.Choose Replicated distribution if the table is having temporary data. E.Choose Hash distribution if the table is having temporary data. F.Hash distribution is ideal for dimension tables that are very frequently joined with other big tables.