ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 108 - Certified Data Cloud Consultant discussion

Report
Export

If a data source does not have a field that can be designated as a primary key, what should the consultant do?

A.
Use the default primary key recommended by Data Cloud.
Answers
A.
Use the default primary key recommended by Data Cloud.
B.
Create a composite key by combining two or more source fields through a formula field.
Answers
B.
Create a composite key by combining two or more source fields through a formula field.
C.
Select a field as a primary key and then add a key qualifier.
Answers
C.
Select a field as a primary key and then add a key qualifier.
D.
Remove duplicates from the data source and then select a primary key.
Answers
D.
Remove duplicates from the data source and then select a primary key.
Suggested answer: B

Explanation:

Understanding Primary Keys in Salesforce Data Cloud:

A primary key is a unique identifier for records in a data source. It ensures that each record can be uniquely identified and accessed.

Challenges with Missing Primary Keys:

Some data sources may lack a natural primary key, making it difficult to uniquely identify records.

Solution: Creating a Composite Key:

Composite Key Definition: A composite key is created by combining two or more fields to generate a unique identifier.

Formula Fields: Using a formula field, different fields can be concatenated to create a unique composite key.

Example: If 'Email' and 'Phone Number' together uniquely identify a record, a formula field can concatenate these values to form a composite key.

Steps to Create a Composite Key:

Identify fields that, when combined, can uniquely identify each record.

Create a formula field that concatenates these fields.

Use this composite key as the primary key for the data source in Data Cloud.

asked 23/09/2024
Daniel Kuzmanovski
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first