MARKETING-CLOUD-ADMINISTRATOR practice question 1 of 25

Northern Trail Outfitters wants to bring subscriber data from its data warehouse into Marketing Cloud. Which 2 fields would need minimal consideration, for size/scalability related reasons, when creating a data extension to house the data? Choose 2 answers

Full set: 165 questions
Answer options
A: Text
B: Decimal
C: Number Correct answer
D: Boolean Correct answer
Correct Answer:
C. Number; D. Boolean
Explanation

When designing a data extension for optimal size and scalability, field types with fixed, minimal storage requirements are preferred. A Boolean field, storing a simple true/false value (1 or 0), is the most space-efficient. A Number field, which stores integers, also has a fixed and relatively small size (typically 4 bytes). These types require minimal consideration as their impact on database size is predictable and low per record, unlike variable-length or complex data types.

Why Incorrect

A. Text: This is a variable-length field. It requires careful consideration of its maximum length to avoid performance degradation and excessive storage allocation, especially with large datasets.
B. Decimal: This field requires specifying both total length and precision (number of decimal places), making its configuration more complex and storage size larger than a simple integer (Number).

References

1. Salesforce Help, Marketing Cloud Connect: Create a Data Extension in Marketing Cloud. The documentation outlines data types. Boolean and Number are described as simple, fixed-size types. Boolean stores True or False, and Number stores whole numbers, making them inherently more scalable and requiring less size consideration than variable types.

2. Salesforce Help, Contact Builder and Data Designer: Data Extension Best Practices. This guide recommends using the most appropriate data type and length for fields to optimize performance. Boolean and Number fields are the most efficient choices for true/false flags and integer values, respectively.

Scroll to Top