Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ61

VerifiedData Modeling and Management

A developer must import a file containing transactional data into a data extension. The file contains a column named Purchase_Price, with values ranging from '$.05' to '$100'.

Which Data Type should be used to prevent data loss?

Explanation

A Text field retains the currency-formatted values exactly as supplied, including the dollar-sign character. Numeric and decimal fields require numeric input formatting and therefore do not preserve the currency symbol.

Community Discussion

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