Certified Marketing Cloud DeveloperDemo

By Salesforce · Question Mode

QuestionQ5

Data Modeling and Management

A developer created a complex dynamic email with many data variations. Instead of manually creating test data, they want to use a subset of live data to validate the email’s dynamic aspects.

Which SQL function should be used to obtain a representative sample from a larger data set?

  • A OVER
  • B NTILE
  • C HAVING
Explanation

NTILE distributes rows in an ordered result set into a requested number of approximately equal-sized groups. Selecting a tile provides a subset of the larger data set for validation.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!