nerdexam
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)
  • A
    8% (5)
  • B
    5% (3)
  • C
    84% (51)
  • D
    3% (2)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice