Câu 116: DP-203: Data Engineering on Microsoft Azure

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 monthAccountType: 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 typeYou need to recommend a partition strategy for the table to minimize query times. On which column should you recommend partitioning the table?

1. A. CustomerSegment
2. B. AccountType
3. C. TransactionType
4. D. TransactionMonth — đáp án hiện tại