IBM
A2090-560 · Question #74
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
The correct answer is C. Select datasliceid, count(*) from TableA group by 1 order by 2. See the full explanation below for the reasoning.
Question
A table, TableA has one column, ColumnA. The following query can be used to determine the skew of Table A.
Options
- ASelect distinct (ColumnA) from TableA;
- BSelect distinct(datasliceid) from TableA;
- CSelect datasliceid, count(*) from TableA group by 1 order by 2;
- DSelect ColumnA, count(*) from TableA group by ColumnA order by 2;
How the community answered
(61 responses)- A8% (5)
- B5% (3)
- C84% (51)
- D3% (2)
Community Discussion
No community discussion yet for this question.