Exam DP-203 topic 1 question 98 discussion

Partitioned by month and with 60 nodes, means it’s 1M per combination

Answer is A. Each partition has one million rows( minimum). *A partition with 1 distribution will have 1M rows * Partition with 2 distribution will have 2M rows ----' Partition with 60 distributions will have 60M rows ....Partition with n-distribution will have n ×1M rows = n M rows So in general, if there is p-partitions and d--distributions .then the combination of P and d describes the total rows or records (Q) which can be mathematical represented below Q = 1000000 * p *d For each combination of partition and distribution, P = 1 and d = 1 Therefore , The total rows,Q = 1000000*1*1= 1M. N.B .1M rows is the minimum per partion and distribution required for a table compression and optimization in table partitioning

answer is A, as there will be 60 nodes for every distrubution

Should be A

60 nodes so 1M per distribiution and partition

1 Mio per combination

same as Blablatest123 said

Duplicate Question