QuestionQ81

VerifiedMonitor, configure, and optimize database resources

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by every fact table.

Which distribution type should you recommend to minimize data movement?

Explanation

A replicated table has a complete copy on every compute node, allowing joins to fact tables to occur without moving the dimension data between nodes. This is the recommended distribution approach for a small shared dimension table in a star schema when minimizing data movement is the goal.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!