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 questionsWhen 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.
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).
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.
Keep practicing
Take the free MARKETING-CLOUD-ADMINISTRATOR practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other MARKETING-CLOUD-ADMINISTRATOR practice questions
- Question 2A Marketing Cloud admin is using the Import Wizard to import data into a non-sendable dat…
- Question 3A Marketing Cloud admin wants to create an SFTP User for the first time. Which two consid…
- Question 4A marketing Cloud admin wants to ensure sensitive information needed for email sends is N…
- Question 5An email manager was anticipating a test email to arrive in their inbox. Where in Email S…
- Question 6A user asks a Marketing Cloud admin to update and increase their session timeout setting.…
- Question 7A Marketing Cloud admin is configuring Social Studio to manage Northern Trail Outfitters …
