Need to remove unused fields from Record type.

Question

Can anyone help me on this : -

You need to remove an unused field from an existing record type Product, which has data sync enabled and is backed by a database table. What should you do? 
 
 A. Delete the field from the record type and optionally delete the column from the database table. 
 B. Delete the field from the product Custom Data Type (CDT) and perform a full resync of the record type. 
 C. Delete the column from the database table and perform a full resync of the record type.

Stewart Burchell · Accepted Answer

What is confusing you here? You could take two approaches to answering the question: 
 
 using your knowledge of records and databases determine which is the correct answer 
 using your knowledge of records/CDTs eliminate the answers that are incorrect to find the correct answer 
 
 Using a combination of 1. and 2. should lead you to the correct answer. 
 If you don't know why the answer is A. at all then ask specific questions here and folk can try and help you understand.

Shubham Aware · Answer

Hello romav0001 
 The correct option is A. Delete the field from the record type and optionally delete the column from the database table. To remove an unused field from a data-synced record type, delete the field directly from the record type. Optionally, you can also delete the corresponding column from the database table for better database hygiene.

Abhishek Karumuru · Answer

hi, romav0001 Unused fields in a database don't directly cause performance issues since you wouldn't be writing or reading from that field we might have to think regarding efficiency in the long run. May vote for option C. That both the record type and the database schema remain synchronized. This approach eliminates the unused field from the record type and also in the database table and also has consistency in both the record and db.

Need to remove unused fields from Record type.

Top Replies