You are designing a financial transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will have a clustered columnstore index and will include the following columns:
✑ TransactionType: 40 million rows per transaction type
✑ CustomerSegment: 4 million per customer segment
✑ TransactionMonth: 65 million rows per month
AccountType: 500 million per account type
You have the following query requirements:
✑ Analysts will most commonly analyze transactions for a given month.
✑ Transactions analysis will typically summarize transactions by transaction type, customer segment, and/or account type
You need to recommend a partition strategy for the table to minimize query times.
On which column should you recommend partitioning the table?
SinSS
Highly Voted 11 months agoRob77
2 years, 2 months agosemauni
2 years agogf2tw
Highly Voted 3 years, 8 months agoemna2022
3 years agoJolyboy
Most Recent 4 months, 3 weeks agos1852
8 months agoEmnCours
8 months, 3 weeks agoibardonr
9 months, 4 weeks agodgerok
11 months ago_Ahan_
1 year, 3 months agootapi
11 months agoroopansh.gupta2
12 months agojppdks
1 year, 4 months agoKhadija10
1 year, 6 months agoBakhtiyor
1 year, 5 months agoDooperMan
1 year, 9 months agoellala
1 year, 10 months agomav2000
1 year, 11 months agohassexat
1 year, 11 months agokkk5566
1 year, 11 months agoakhil5432
2 years agoShanks111
2 years, 2 months ago