Salesforce Data Cloud Consultant Practice Exams
Last updated on Sep 13,2026- Exam Code: Data Cloud Consultant
- Exam Name: Salesforce Certified Data Cloud Consultant
- Certification Provider: Salesforce
- Latest update: Sep 13,2026
Question #171
Every day, Northern Trail Outfitters uploads a summary of the last 24 hours of store transactions to a new file in an Amazon S3 bucket, and files older than seven days are automatically deleted. Each file contains a timestamp in a standardized naming convention.
Which two options should a consultant configure when ingesting this data stream? Choose 2 answers
- A . Ensure that deletion of old files is enabled.
- B . Ensure the refresh mode is set to "Upsert".
- C . Ensure the filename contains a wildcard to a accommodate the timestamp.
- D . Ensure the refresh mode is set to "Full Refresh.’’
Correct Answer: B, C
B, C
Explanation:
When ingesting data from an Amazon S3 bucket, the consultant should configure the following options:
The refresh mode should be set to “Upsert”, which means that new and updated records will be added or updated in Data Cloud, while existing records will be preserved. This ensures that the data is always up to date and consistent with the source.
The filename should contain a wildcard to accommodate the timestamp, which means that the file name pattern should include a variable part that matches the timestamp format. For example, if the file name is store_transactions_2023-12-18.csv, the wildcard could be store_transactions_*.csv. This ensures that the ingestion process can identify and process the correct file every day. The other options are not necessary or relevant for this scenario:
Deletion of old files is a feature of the Amazon S3 bucket, not the Data Cloud ingestion process. Data Cloud does not delete any files from the source, nor does it require the source files to be deleted after ingestion.
Full Refresh is a refresh mode that deletes all existing records in Data Cloud and replaces them with the records from the source file. This is not suitable for this scenario, as it would result in data loss and inconsistency, especially if the source file only contains the summary of the last 24 hours of transactions.
Reference: Ingest Data from Amazon S3, Refresh Modes
B, C
Explanation:
When ingesting data from an Amazon S3 bucket, the consultant should configure the following options:
The refresh mode should be set to “Upsert”, which means that new and updated records will be added or updated in Data Cloud, while existing records will be preserved. This ensures that the data is always up to date and consistent with the source.
The filename should contain a wildcard to accommodate the timestamp, which means that the file name pattern should include a variable part that matches the timestamp format. For example, if the file name is store_transactions_2023-12-18.csv, the wildcard could be store_transactions_*.csv. This ensures that the ingestion process can identify and process the correct file every day. The other options are not necessary or relevant for this scenario:
Deletion of old files is a feature of the Amazon S3 bucket, not the Data Cloud ingestion process. Data Cloud does not delete any files from the source, nor does it require the source files to be deleted after ingestion.
Full Refresh is a refresh mode that deletes all existing records in Data Cloud and replaces them with the records from the source file. This is not suitable for this scenario, as it would result in data loss and inconsistency, especially if the source file only contains the summary of the last 24 hours of transactions.
Reference: Ingest Data from Amazon S3, Refresh Modes
Question #172
A company is seeking advice from a consultant on how to address the challenge of having multiple leads and contacts in Salesforce that share the same email address. The consultant wants to provide a detailed and comprehensive explanation on how Data Cloud can be leveraged to effectively solve this issue.
What should the consultant highlight to address this company’s business challenge?
- A . Data Bundles
- B . Calculated Insights
- C . Identity Resolution
- D . Identity Resolution
Correct Answer: C
C
Explanation:
Issue Overview: When multiple leads and contacts share the same email address in Salesforce, it can lead to data duplication, inaccurate customer views, and inefficient marketing and sales efforts. Data Cloud Identity Resolution: Salesforce Data Cloud offers Identity Resolution as a powerful tool to address this issue. It helps in merging and unifying data from multiple sources to create a single, comprehensive customer profile.
Process:
Data Ingestion: Import lead and contact data into Salesforce Data Cloud.
Identity Resolution Rules: Configure Identity Resolution rules to match and merge records based on key identifiers like email addresses.
Unification: The tool consolidates records that share the same email address, eliminating duplicates and ensuring a single view of each customer.
Continuous Updates: As new data comes in, Identity Resolution continuously updates and maintains the unified profiles.
Benefits:
Accurate Customer View: Reduces duplicate records and provides a complete view of each customer’s interactions and history.
Improved Efficiency: Streamlines marketing and sales efforts by targeting a unified customer profile.
Reference: Salesforce Data Cloud Identity Resolution
Salesforce Help: Identity Resolution Overview
C
Explanation:
Issue Overview: When multiple leads and contacts share the same email address in Salesforce, it can lead to data duplication, inaccurate customer views, and inefficient marketing and sales efforts. Data Cloud Identity Resolution: Salesforce Data Cloud offers Identity Resolution as a powerful tool to address this issue. It helps in merging and unifying data from multiple sources to create a single, comprehensive customer profile.
Process:
Data Ingestion: Import lead and contact data into Salesforce Data Cloud.
Identity Resolution Rules: Configure Identity Resolution rules to match and merge records based on key identifiers like email addresses.
Unification: The tool consolidates records that share the same email address, eliminating duplicates and ensuring a single view of each customer.
Continuous Updates: As new data comes in, Identity Resolution continuously updates and maintains the unified profiles.
Benefits:
Accurate Customer View: Reduces duplicate records and provides a complete view of each customer’s interactions and history.
Improved Efficiency: Streamlines marketing and sales efforts by targeting a unified customer profile.
Reference: Salesforce Data Cloud Identity Resolution
Salesforce Help: Identity Resolution Overview
Question #173
Cumulus Financial wants to create a segment of individuals based on transaction history data. This data has been mapped in the data model and is accessible via multiple container paths for segmentation.
What happens if the optimal container path for this use case is not selected?
- A . Alternate container paths will be suggested before the segment is published.
- B . The resulting segment may be smaller or larger than expected.
- C . Data Cloud segmentation will automatically select the optimal container path.
- D . The resulting segment will not be generated.
Correct Answer: B
B
Explanation:
In Salesforce Data Cloud, when segmenting individuals based on transaction history data, there may be multiple paths to the same data through different objects in the data model. If the wrong container path is selected:
The segment may pull in too many or too few individuals because different container paths may define relationships differently.
Some records may be unintentionally excluded or duplicated, affecting segmentation accuracy.
Identity resolution and relationships between objects might not behave as expected.
Why Not A? Data Cloud does not suggest alternate container paths automatically. The user must choose the correct path.
Why Not C? Data Cloud does not automatically select the optimal path; it relies on the user’s selection.
Why Not D? The segment will still be generated but may have inaccurate results.
Salesforce Data Cloud
Reference: Salesforce Help Documentation C Data Model and Segmentation Best Practices Trailhead Module: Segmentation in Data Cloud
Salesforce Knowledge Base C Using Container Paths for Segmentation
B
Explanation:
In Salesforce Data Cloud, when segmenting individuals based on transaction history data, there may be multiple paths to the same data through different objects in the data model. If the wrong container path is selected:
The segment may pull in too many or too few individuals because different container paths may define relationships differently.
Some records may be unintentionally excluded or duplicated, affecting segmentation accuracy.
Identity resolution and relationships between objects might not behave as expected.
Why Not A? Data Cloud does not suggest alternate container paths automatically. The user must choose the correct path.
Why Not C? Data Cloud does not automatically select the optimal path; it relies on the user’s selection.
Why Not D? The segment will still be generated but may have inaccurate results.
Salesforce Data Cloud
Reference: Salesforce Help Documentation C Data Model and Segmentation Best Practices Trailhead Module: Segmentation in Data Cloud
Salesforce Knowledge Base C Using Container Paths for Segmentation
Question #174
When performing segmentation or activation, which time zone is used to publish and refresh data?
- A . Time zone specified on the activity at the time of creation
- B . Time zone of the user creating the activity
- C . Time zone of the Data Cloud Admin user
- D . Time zone set by the Salesforce Data Cloud org
Correct Answer: D
D
Explanation:
The time zone that is used to publish and refresh data when performing segmentation or activation is
D. Time zone set by the Salesforce Data Cloud org. This time zone is the one that is configured in the org settings when Data Cloud is provisioned, and it applies to all users and activities in Data Cloud. This time zone determines when the segments are scheduled to refresh and when the activations are scheduled to publish. Therefore, it is important to consider the time zone difference between the Data Cloud org and the destination systems or channels when planning the segmentation and activation strategies.
Reference: Salesforce Data Cloud Consultant Exam Guide, Segmentation, Activation
D
Explanation:
The time zone that is used to publish and refresh data when performing segmentation or activation is
D. Time zone set by the Salesforce Data Cloud org. This time zone is the one that is configured in the org settings when Data Cloud is provisioned, and it applies to all users and activities in Data Cloud. This time zone determines when the segments are scheduled to refresh and when the activations are scheduled to publish. Therefore, it is important to consider the time zone difference between the Data Cloud org and the destination systems or channels when planning the segmentation and activation strategies.
Reference: Salesforce Data Cloud Consultant Exam Guide, Segmentation, Activation
Question #175
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.
- 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.
- D . Remove duplicates from the data source and then select a primary key.
Correct Answer: B
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.
Reference: Salesforce Primary Key Documentation
Challenges with Missing Primary Keys:
Some data sources may lack a natural primary key, making it difficult to uniquely identify records.
Reference: Salesforce Data Integration Guide
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.
Reference: Salesforce Composite Key Creation Guide
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.
Reference: Salesforce Formula Field Documentation
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.
Reference: Salesforce Primary Key Documentation
Challenges with Missing Primary Keys:
Some data sources may lack a natural primary key, making it difficult to uniquely identify records.
Reference: Salesforce Data Integration Guide
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.
Reference: Salesforce Composite Key Creation Guide
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.
Reference: Salesforce Formula Field Documentation
Question #176
During discovery, which feature should a consultant highlight for a customer who has multiple data sources and needs to match and reconcile data about individuals into a single unified profile?
- A . Harmonization
- B . Data Cleansing
- C . Data Consolidation
- D . Identity Resolution
Correct Answer: D
D
Explanation:
The feature that the consultant should highlight for a customer who has multiple data sources and needs to match and reconcile data about individuals into a single unified profile is D. Identity Resolution. Identity Resolution is the process of identifying, matching, and reconciling data about individuals across different data sources and creating a unified profile that represents a single view of the customer. Identity Resolution uses various methods and rules to determine the best match and reconciliation of data, such as deterministic matching, probabilistic matching, reconciliation rules, and identity graphs. Identity Resolution enables the customer to have a complete and accurate understanding of their customers and their interactions across different channels and touchpoints.
Reference: Salesforce Data Cloud Consultant Exam Guide, Identity Resolution
D
Explanation:
The feature that the consultant should highlight for a customer who has multiple data sources and needs to match and reconcile data about individuals into a single unified profile is D. Identity Resolution. Identity Resolution is the process of identifying, matching, and reconciling data about individuals across different data sources and creating a unified profile that represents a single view of the customer. Identity Resolution uses various methods and rules to determine the best match and reconciliation of data, such as deterministic matching, probabilistic matching, reconciliation rules, and identity graphs. Identity Resolution enables the customer to have a complete and accurate understanding of their customers and their interactions across different channels and touchpoints.
Reference: Salesforce Data Cloud Consultant Exam Guide, Identity Resolution
Question #177
Where is value suggestion for attributes in segmentation enabled when creating the DMO?
- A . Data Mapping
- B . Data Transformation
- C . Segment Setup
- D . Data Stream Setup
Correct Answer: C
C
Explanation:
Value suggestion for attributes in segmentation is a feature that allows you to see and select the possible values for a text field when creating segment filters. You can enable or disable this feature for each data model object (DMO) field in the DMO record home. Value suggestion can be enabled for up to 500 attributes for your entire org. It can take up to 24 hours for suggested values to appear. To use value suggestion when creating segment filters, you need to drag the attribute onto the canvas and start typing in the Value field for an attribute. You can also select multiple values for some operators. Value suggestion is not available for attributes with more than 255 characters or for relationships that are one-to-many (1:N).
Reference: Use Value Suggestions in Segmentation, Considerations for Selecting Related Attributes
C
Explanation:
Value suggestion for attributes in segmentation is a feature that allows you to see and select the possible values for a text field when creating segment filters. You can enable or disable this feature for each data model object (DMO) field in the DMO record home. Value suggestion can be enabled for up to 500 attributes for your entire org. It can take up to 24 hours for suggested values to appear. To use value suggestion when creating segment filters, you need to drag the attribute onto the canvas and start typing in the Value field for an attribute. You can also select multiple values for some operators. Value suggestion is not available for attributes with more than 255 characters or for relationships that are one-to-many (1:N).
Reference: Use Value Suggestions in Segmentation, Considerations for Selecting Related Attributes