Salesforce Certified Marketing Cloud Email Specialist — Question 83

A new data extension named `Orders` contains order data. One row is recorded for each customer's order. Customers can place multiple orders. The Orders data extension relates to other data extensions and contains the following fields:
✑ OrderNumber: a unique alphanumeric order number.
✑ CustomerID: a numeric customer identification number.
✑ OrderDate: the system date and time for the order.
✑ Instructions: an optional alphanumeric string that contains customer delivery notes.
What statement accurately reflects the configuration of the Orders data extension?

Answer options

• A. The OrderNumber field will be a Number data type field.
• B. CustomerID will be used as the Primary Key.
• C. OrderNumber will be used as the Primary Key.
• D. All fields in the data extension are nullable.

Correct answer: C

Explanation

The correct answer is C because the OrderNumber is defined as a unique alphanumeric identifier for each order, making it suitable as the Primary Key. Option A is incorrect as OrderNumber is not a Number data type but alphanumeric. Option B is wrong since CustomerID does not uniquely identify each order, and option D is incorrect because while some fields may be nullable, the Primary Key field must contain a value.