nerdexam
SAP

C_DS_42 · Question #16

How to Use a WHERE clause to select only customers in North America (North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?

The correct answer is A. In the Query editor, choose the WHERE tab B. Enter the where clause, customer.COUNTRYID in (1,2,11). See the full explanation below for the reasoning.

Question

How to Use a WHERE clause to select only customers in North America (North American countries are United States, Canada, and Mexico which have COUNTRYID values of 1, 2,and 11)?

Options

  • AIn the Query editor, choose the WHERE tab
  • BEnter the where clause, customer.COUNTRYID in (1,2,11)
  • CTo save all changes, choose OK
  • DConfirm that 22 records were loaded

How the community answered

(42 responses)
  • A
    71% (30)
  • C
    19% (8)
  • D
    10% (4)

Community Discussion

No community discussion yet for this question.

Full C_DS_42 Practice