Certified Platform App Builder Exam QuestionsBrowse all questions from this exam

Certified Platform App Builder Exam - Question 426


Universal Containers has a new custom object for Invoices that includes an Invoice Number field. Before the Invoice object can be used, invoices will be migrated from an external system maintaining their current Invoice Number. After the migration, each new Invoice created in Salesforce must have a unique Invoice Number.

How should the app builder configure the Invoice Number field?

Show Answer
Correct Answer: D

To address the requirement of maintaining the current Invoice Numbers during migration and ensuring each new Invoice has a unique Invoice Number generated by Salesforce afterwards, the best approach is to use two fields: a Text field for the original Invoice Numbers and an AutoNumber field for the new Invoice Numbers. This strategy preserves the existing data and meets the uniqueness requirement for new entries.

Discussion

6 comments
Sign in to comment
sfreeswayOption: A
Jun 6, 2023

Answer is A https://developer.salesforce.com/forums/?id=906F0000000DCbOIAW 'If you convert an auto-number field into a text field, the data in that field remains unchanged. Also, you can safely convert a text custom field into an auto-number field without losing your data. Converting an auto-number field into any other data type results in data loss. Auto-number fields can contain a maximum of 30 characters. Before converting a text custom field into an auto-number field, change any records that contain more than 30 characters in that field.'

[Removed]Option: C
Mar 13, 2023

C. Create a Text field and mark it as a unique external ID field. All other answers don't make sense.

[Removed]Option: C
Mar 26, 2023

In the case of answer A, I think that changing from text type to automatic numbering type will cause data loss

Odonke2Option: A
May 12, 2023

A "Also, you can safely convert a text custom field into an auto-number field without losing your data."

wlthornOption: A
Feb 1, 2023

A. Create a Text field, then change it to AutoNumber after the migration. This option allows the app builder to first migrate the existing Invoice Numbers from the external system, which would be stored in a text field, and then change the field type to an AutoNumber after the migration. This ensures that the existing Invoice Numbers are preserved, and that each new Invoice created in Salesforce will have a unique Invoice Number generated by the AutoNumber field.

Kiki711Option: A
Jul 21, 2024

It should be A, coz it clearly states in the question 'After the migration, each new Invoice created in Salesforce must have a unique Invoice Number.' whereas unique external id won't populate automatically and mainly used for matching.