nerdexam
Salesforce

ADM-211 · Question #201

Contact records need to be retrieved that meet the following criteria: all contacts with a mailing address in the state of California or whose last name is equal to Smith. Only the first and last…

The correct answer is B. Select first name. last name. where last name="Smith" OR state=" CA". See the full explanation below for the reasoning.

Question

Contact records need to be retrieved that meet the following criteria: all contacts with a mailing address in the state of California or whose last name is equal to Smith. Only the first and last names are needed. An administrator decided to use the Data Loader to retrieve these records using the Export feature. What Sales force Object query language (SOQL) statement could be used to retrieve the desired records?

Options

  • ASelect " California " or " Smith " where last name=
  • BSelect first name. last name. where last name="Smith" OR state=" CA"

How the community answered

(30 responses)
  • A
    27% (8)
  • B
    73% (22)

Community Discussion

No community discussion yet for this question.

Full ADM-211 Practice