Municipal traffic-event facts grow rapidly and analysts filter almost always by event date and district. At architecture pattern depth, what physical-design awareness helps performance?
Select an answer to reveal the explanation.
Short Explanation
If everyone asks “what happened last Tuesday in District 4,” slicing the big table that way is just good manners. Partitioning along real filters keeps analytics from scanning the whole planet.
Full Explanation
Physical design choices such as partitioning and clustering are architecture-relevant when they shape platform patterns and performance envelopes. Aligning partitions to dominant filter predicates (for example date and district) reduces scan cost for large fact-like event tables. Architecture should set expectations and standards without requiring deep DBA-only memorization of every vendor syntax.