A developer needs to import a file into a data extension which contains transactional data.

The best Data Type to use for the Purchase_Price column, which includes values ranging from '$.05' to '$100', is Decimal(9,2) (C). This data type ensures that values are stored accurately without data loss, allowing for precision up to two decimal places.