Salesforce Certified Data Cloud Consultant — Question 89

Cumulus Financial needs to create a composite key on an incoming data source that combines the fields Customer Region and Customer Identifier.

Which formula function should a consultant use to create a composite key when a primary key is not available in a data stream?

Answer options

• A. CAST
• B. CONCAT
• C. COALESCE
• D. COMBINE

Correct answer: B

Explanation

The correct answer is CONCAT, as it is specifically designed to merge multiple strings into one, making it ideal for creating a composite key. CAST is used for type conversion, COALESCE returns the first non-null value, and COMBINE is not a standard SQL function for this purpose.