ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 119 - Certified Data Cloud Consultant discussion

Report
Export

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?

A.
CONCAT
Answers
A.
CONCAT
B.
COMBIN
Answers
B.
COMBIN
C.
COALE
Answers
C.
COALE
D.
CAST
Answers
D.
CAST
Suggested answer: A

Explanation:

Composite Keys in Data Streams: When working with data streams in Salesforce Data Cloud, there may be situations where a primary key is not available. In such cases, creating a composite key from multiple fields ensures unique identification of records.

Formula Functions: Salesforce provides several formula functions to manipulate and combine data fields. Among them, the CONCAT function is used to combine multiple strings into one.

Creating Composite Keys: To create a composite key using CONCAT, a consultant can combine the values of Customer Region and Customer Identifier into a single unique identifier.

Example Formula: CONCAT(Customer_Region, Customer_Identifier)

Salesforce Documentation: Formula Functions

Salesforce Data Cloud Guide

asked 23/09/2024
Ed Quinn
31 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first