Correct Answer: A
This question has two main pointers which will lead to the correct answer. The first says that the table size is less than 2 GB and is 1 GB. The second one says that there is no possible join key.
Round Robin is a suggested method in scenarios where there is no obvious joining key. As per the question, we don’t have a common joining key. The following shows the places where Round Robin can be used. When there is no eligible column for hash distributing the table
When there are no common join keys
If the stable is for staging purpose
Option A is correct: It will meet the requirements.
Option B is incorrect: It is used when there is a common join key, and table size is more than 2 GB.Option C is incorrect: Its main purpose is to group into fragments, and it is not a distribution technique.
Option D is incorrect:
Option A is the right answer.
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-distribute