Multiple choice technology databases Which scenario below indicates HIGH cardinality column? Scenario 1 : Distinct values for TableA.ColumnA = 10 Total no. of rows for TableA = 100 Scenario 2 : Distinct values for TableA.ColumnB = 20 Total no. of rows for TableA = 100 Scenario 3 : Distinct values for TableA.ColumnC = 30 Total no. of rows for TableA = 100 Distinct values have no corelation to cardinality Reveal answer Fill a bubble to check yourself C Correct answer Explanation Cardinality refers to the number of unique values in a table column relative to the total rows. Scenario 3 has the highest ratio of unique values (30 distinct values out of 100 rows) compared to Scenario 1 (10%) and Scenario 2 (20%).