nerdexam
IBM

C2020-930 · Question #78

Assume you have four fields, 4, A, C and D and you wish to find the sum of the values even if there are $null$ missing values in one or more fields. Which expression would accomplish this task?

The correct answer is C. sum_n([A, B, C, D]). See the full explanation below for the reasoning.

Question

Assume you have four fields, 4, A, C and D and you wish to find the sum of the values even if there are $null$ missing values in one or more fields. Which expression would accomplish this task?

Options

  • ASum_n((ABCIJ))
  • BA+B+C+D
  • Csum_n([A, B, C, D])
  • Dto_real(A) + to_real(B) + to_real(C) + to_real(D)

How the community answered

(39 responses)
  • A
    3% (1)
  • B
    15% (6)
  • C
    74% (29)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full C2020-930 Practice