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 #41
A healthcare client wants to make use of identity resolution, but does not want to risk unifying profiles that may share certain personally identifying information (PII).
Which matching rule criteria should a consultant recommend for the most accurate matching results?
- A . Party Identification on Patient ID
- B . Exact Last Name and Emil
- C . Email Address and Phone
- D . Fuzzy First Name, Exact Last Name, and Email
Correct Answer: A
A
Explanation:
Identity resolution is the process of linking data from different sources into a unified profile of a customer or an individual. Identity resolution uses matching rules to compare the attributes of different records and determine if they belong to the same person. Matching rules can be based on exact or fuzzy matching of various attributes, such as name, email, phone, address, or custom identifiers. A healthcare client who wants to use identity resolution, but does not want to risk unifying profiles that may share certain personally identifying information (PII), such as name or email, should use a matching rule criteria that is based on a unique and reliable identifier that is specific to the healthcare domain. One such identifier is the patient ID, which is a unique number assigned to each patient by a healthcare provider or system. By using the party identification on patient ID as a matching rule criteria, the healthcare client can ensure that only records that have the same patient ID are matched and unified, and avoid false positives or false negatives that may occur due to common or similar names or emails. The party identification on patient ID is also a secure and compliant way of handling sensitive healthcare data, as it does not expose or share any PII that may be subject to data protection regulations or standards.
Reference: Configure Identity Resolution Rulesets, A framework of identity resolution: evaluating identity attributes and methods
A
Explanation:
Identity resolution is the process of linking data from different sources into a unified profile of a customer or an individual. Identity resolution uses matching rules to compare the attributes of different records and determine if they belong to the same person. Matching rules can be based on exact or fuzzy matching of various attributes, such as name, email, phone, address, or custom identifiers. A healthcare client who wants to use identity resolution, but does not want to risk unifying profiles that may share certain personally identifying information (PII), such as name or email, should use a matching rule criteria that is based on a unique and reliable identifier that is specific to the healthcare domain. One such identifier is the patient ID, which is a unique number assigned to each patient by a healthcare provider or system. By using the party identification on patient ID as a matching rule criteria, the healthcare client can ensure that only records that have the same patient ID are matched and unified, and avoid false positives or false negatives that may occur due to common or similar names or emails. The party identification on patient ID is also a secure and compliant way of handling sensitive healthcare data, as it does not expose or share any PII that may be subject to data protection regulations or standards.
Reference: Configure Identity Resolution Rulesets, A framework of identity resolution: evaluating identity attributes and methods
Question #42
Which data model subject area defines the revenue or quantity for an opportunity by product family?
- A . Engagement
- B . Product
- C . Party
- D . Sales Order
Correct Answer: D
D
Explanation:
The Sales Order subject area defines the details of an order placed by a customer for one or more products or services. It includes information such as the order date, status, amount, quantity, currency, payment method, and delivery method. The Sales Order subject area also allows you to track the revenue or quantity for an opportunity by product family, which is a grouping of products that share common characteristics or features. For example, you can use the Sales Order Line Item DMO to associate each product in an order with its product family, and then use the Sales Order Revenue DMO to calculate the total revenue or quantity for each product family in an opportunity.
Reference: Sales Order Subject Area, Sales Order Revenue DMO Reference
D
Explanation:
The Sales Order subject area defines the details of an order placed by a customer for one or more products or services. It includes information such as the order date, status, amount, quantity, currency, payment method, and delivery method. The Sales Order subject area also allows you to track the revenue or quantity for an opportunity by product family, which is a grouping of products that share common characteristics or features. For example, you can use the Sales Order Line Item DMO to associate each product in an order with its product family, and then use the Sales Order Revenue DMO to calculate the total revenue or quantity for each product family in an opportunity.
Reference: Sales Order Subject Area, Sales Order Revenue DMO Reference
Question #42
Which data model subject area defines the revenue or quantity for an opportunity by product family?
- A . Engagement
- B . Product
- C . Party
- D . Sales Order
Correct Answer: D
D
Explanation:
The Sales Order subject area defines the details of an order placed by a customer for one or more products or services. It includes information such as the order date, status, amount, quantity, currency, payment method, and delivery method. The Sales Order subject area also allows you to track the revenue or quantity for an opportunity by product family, which is a grouping of products that share common characteristics or features. For example, you can use the Sales Order Line Item DMO to associate each product in an order with its product family, and then use the Sales Order Revenue DMO to calculate the total revenue or quantity for each product family in an opportunity.
Reference: Sales Order Subject Area, Sales Order Revenue DMO Reference
D
Explanation:
The Sales Order subject area defines the details of an order placed by a customer for one or more products or services. It includes information such as the order date, status, amount, quantity, currency, payment method, and delivery method. The Sales Order subject area also allows you to track the revenue or quantity for an opportunity by product family, which is a grouping of products that share common characteristics or features. For example, you can use the Sales Order Line Item DMO to associate each product in an order with its product family, and then use the Sales Order Revenue DMO to calculate the total revenue or quantity for each product family in an opportunity.
Reference: Sales Order Subject Area, Sales Order Revenue DMO Reference
Question #44
Northern Trail Outfitters asks its consultant to extract the runner profiles and activity logs from its Track My Run mobile app and load them into Data Cloud. The marketing department also indicates that they need the last 90 days of historical data and want all new and updated data as it becomes available on a go-forward basis.
As best practice, which sequence of actions should the consultant use to implement this request?
- A . Use bulk ingestion to first load the last 90 days of data, and also subsequently use bulk ingestion to synchronize the future data as It becomes available.
- B . Use streaming ingestion to first load the last 90 days of data, and also subsequently use streaming ingestion synchronize future data as It becomes available.
- C . Use streaming ingestion to first load the last 90 days of data, and then use bulk Ingestion to synchronize future data as It becomes available.
- D . Use bulk ingestion to first load the last 90 days of data, and then use streaming ingestion to synchronize future data as It becomes available.
Correct Answer: D
D
Explanation:
Initial Data Load: For loading large volumes of historical data, such as the last 90 days of runner profiles and activity logs, bulk ingestion is the most efficient method. It allows for high-throughput data transfer.
Bulk Ingestion: Use Salesforce Data Cloud’s bulk ingestion tools to load the historical data quickly and efficiently.
Ongoing Data Synchronization: To keep the Data Cloud updated with new and modified records as they become available in the Track My Run mobile app, streaming ingestion is appropriate. It ensures near-real-time data updates.
Streaming Ingestion: Configure streaming ingestion to continuously update the Data Cloud with new and updated data from the mobile app.
Sequence of Actions:
Step 1: Perform bulk ingestion to import the last 90 days of historical data into Data Cloud.
Step 2: Set up streaming ingestion to handle ongoing updates and new data as it becomes available. Best Practice: This approach ensures that the initial large data load is handled efficiently, and ongoing updates are processed in near real-time, providing the marketing department with the most up-to-date data.
Reference: Salesforce Data Cloud Ingestion Methods
Salesforce Bulk Data Ingestion
Salesforce Streaming Data Ingestion
D
Explanation:
Initial Data Load: For loading large volumes of historical data, such as the last 90 days of runner profiles and activity logs, bulk ingestion is the most efficient method. It allows for high-throughput data transfer.
Bulk Ingestion: Use Salesforce Data Cloud’s bulk ingestion tools to load the historical data quickly and efficiently.
Ongoing Data Synchronization: To keep the Data Cloud updated with new and modified records as they become available in the Track My Run mobile app, streaming ingestion is appropriate. It ensures near-real-time data updates.
Streaming Ingestion: Configure streaming ingestion to continuously update the Data Cloud with new and updated data from the mobile app.
Sequence of Actions:
Step 1: Perform bulk ingestion to import the last 90 days of historical data into Data Cloud.
Step 2: Set up streaming ingestion to handle ongoing updates and new data as it becomes available. Best Practice: This approach ensures that the initial large data load is handled efficiently, and ongoing updates are processed in near real-time, providing the marketing department with the most up-to-date data.
Reference: Salesforce Data Cloud Ingestion Methods
Salesforce Bulk Data Ingestion
Salesforce Streaming Data Ingestion
Question #45
A company wants to test its marketing campaigns with different target populations.
What should the consultant adjust in the Segment Canvas interface to get different populations?
- A . Direct attributes, related attributes, and population filters
- B . Segmentation filters, direct attributions, and data sources
- C . Direct attributes and related attributes
- D . Population filters and direct attributes
Correct Answer: A
A
Explanation:
Segmentation in Salesforce Data Cloud:
The Segment Canvas interface is used to define and adjust target populations for marketing campaigns.
Reference: Salesforce Segment Canvas Documentation
Elements for Adjusting Target Populations:
Direct Attributes: These are specific attributes directly related to the target entity (e.g., customer age, location).
Related Attributes: These are attributes related to other entities connected to the target entity (e.g., purchase history).
Population Filters: Filters applied to define and narrow down the segment population (e.g., active customers).
Reference: Salesforce Segmentation Guide
Steps to Adjust Populations in Segment Canvas:
Direct Attributes: Select attributes that directly describe the target population.
Related Attributes: Incorporate attributes from related entities to enrich the segment criteria.
Population Filters: Apply filters to refine and target specific subsets of the population. Example: To create a segment of "Active Customers Aged 25-35," use age as a direct attribute, purchase activity as a related attribute, and apply population filters for activity status and age range.
Reference: Salesforce Segment Canvas Tutorial
Practical Application:
Navigate to the Segment Canvas.
Adjust direct attributes and related attributes based on campaign goals.
Apply population filters to fine-tune the target audience.
Reference: Salesforce Marketing Cloud Segmentation Best Practices
A
Explanation:
Segmentation in Salesforce Data Cloud:
The Segment Canvas interface is used to define and adjust target populations for marketing campaigns.
Reference: Salesforce Segment Canvas Documentation
Elements for Adjusting Target Populations:
Direct Attributes: These are specific attributes directly related to the target entity (e.g., customer age, location).
Related Attributes: These are attributes related to other entities connected to the target entity (e.g., purchase history).
Population Filters: Filters applied to define and narrow down the segment population (e.g., active customers).
Reference: Salesforce Segmentation Guide
Steps to Adjust Populations in Segment Canvas:
Direct Attributes: Select attributes that directly describe the target population.
Related Attributes: Incorporate attributes from related entities to enrich the segment criteria.
Population Filters: Apply filters to refine and target specific subsets of the population. Example: To create a segment of "Active Customers Aged 25-35," use age as a direct attribute, purchase activity as a related attribute, and apply population filters for activity status and age range.
Reference: Salesforce Segment Canvas Tutorial
Practical Application:
Navigate to the Segment Canvas.
Adjust direct attributes and related attributes based on campaign goals.
Apply population filters to fine-tune the target audience.
Reference: Salesforce Marketing Cloud Segmentation Best Practices
Question #46
Cumulus Financial offers both business and personal loans. Records in the Contact DLO can be useful for both groups since individual customers may have both business and personal loans. However, for legal reasons, the two groups must be kept separate.
How should Cumulus Financial solve this business requirement?
- A . Duplicate the Individual DM0.
- B . Duplicate the Contact DLO.
- C . Create two identity resolution rules in the same data space.
- D . Use two data spaces.
Correct Answer: D
D
Explanation:
To address the business requirement where Cumulus Financial needs to keep business and personal loan records separate for legal reasons while still leveraging the same Contact DLO, the best solution is to use two data spaces. Here’s why and how this works: Understanding Data Spaces in Salesforce Data Cloud:
Data spaces are logical containers within Salesforce Data Cloud that allow organizations to segment their data based on specific business needs, compliance requirements, or privacy regulations. They enable isolation of data processing and identity resolution rules while still allowing access to shared data objects like the Contact DLO.
Why Two Data Spaces?
By creating two data spaces (e.g., one for business loans and another for personal loans), Cumulus Financial can maintain separation between the two groups for legal compliance.
Both data spaces can reference the same Contact DLO, ensuring that individual customer data is not duplicated but is accessible in both contexts.
Identity resolution rules can be configured independently within each data space to ensure that the
segmentation aligns with the legal requirements.
Steps to Implement This Solution:
Step 1: Navigate to the Data Spaces section in Salesforce Data Cloud.
Step 2: Create two new data spaces: one for "Business Loans" and another for "Personal Loans." Step 3: Configure the identity resolution rules separately for each data space to ensure proper segmentation.
Step 4: Link the existing Contact DLO to both data spaces. This ensures that the same contact data is available in both contexts without duplication.
Step 5: Set up activation rules and permissions to ensure that data from one data space cannot
inadvertently mix with the other.
Why Not Other Options?
D
Explanation:
To address the business requirement where Cumulus Financial needs to keep business and personal loan records separate for legal reasons while still leveraging the same Contact DLO, the best solution is to use two data spaces. Here’s why and how this works: Understanding Data Spaces in Salesforce Data Cloud:
Data spaces are logical containers within Salesforce Data Cloud that allow organizations to segment their data based on specific business needs, compliance requirements, or privacy regulations. They enable isolation of data processing and identity resolution rules while still allowing access to shared data objects like the Contact DLO.
Why Two Data Spaces?
By creating two data spaces (e.g., one for business loans and another for personal loans), Cumulus Financial can maintain separation between the two groups for legal compliance.
Both data spaces can reference the same Contact DLO, ensuring that individual customer data is not duplicated but is accessible in both contexts.
Identity resolution rules can be configured independently within each data space to ensure that the
segmentation aligns with the legal requirements.
Steps to Implement This Solution:
Step 1: Navigate to the Data Spaces section in Salesforce Data Cloud.
Step 2: Create two new data spaces: one for "Business Loans" and another for "Personal Loans." Step 3: Configure the identity resolution rules separately for each data space to ensure proper segmentation.
Step 4: Link the existing Contact DLO to both data spaces. This ensures that the same contact data is available in both contexts without duplication.
Step 5: Set up activation rules and permissions to ensure that data from one data space cannot
inadvertently mix with the other.
Why Not Other Options?
Question #47
An organization wants to enable users with the ability to identify and select text attributes from a picklist of options.
Which Data Cloud feature should help with this use case?
- A . Value suggestion
- B . Data harmonization
- C . Transformation formulas
- D . Global picklists
Correct Answer: A
A
Explanation:
Value suggestion is a Data Cloud feature that allows users to see and select the possible values for a text field when creating segment filters. Value suggestion can be enabled or disabled for each data model object (DMO) field in the DMO record home. Value suggestion can help users to identify and select text attributes from a picklist of options, without having to type or remember the exact values.
Value suggestion can also reduce errors and improve data quality by ensuring consistent and valid values for the segment filters.
Reference: Use Value Suggestions in Segmentation, Considerations for Selecting Related Attributes
A
Explanation:
Value suggestion is a Data Cloud feature that allows users to see and select the possible values for a text field when creating segment filters. Value suggestion can be enabled or disabled for each data model object (DMO) field in the DMO record home. Value suggestion can help users to identify and select text attributes from a picklist of options, without having to type or remember the exact values.
Value suggestion can also reduce errors and improve data quality by ensuring consistent and valid values for the segment filters.
Reference: Use Value Suggestions in Segmentation, Considerations for Selecting Related Attributes
Question #48
A customer creates a large segment of customers that placed orders in the last 30 days, and adds related attributes from the… to the activation. Upon checking the activation in Marketing Cloud, they notice It contains orders that are older than 30 days.
What should a consultant do to resolve this issue?
- A . use data graphs that contain only 30 days of data.
- B . Apply a data space fitter to exclude orders older than 30 days.
- C . Apply a filter to Purchase Order Date to exclude orders older than 30 days.
- D . Use SQL in Marketing Cloud Engagement to remove orders older than 30 days.
Correct Answer: C
C
Explanation:
The issue arises because the activated segment in Marketing Cloud contains orders older than 30 days, despite the segment being defined to include only recent orders. The best solution is to apply a filter to the Purchase Order Date to exclude older orders.
Here’s why:
Understanding the Issue
The segment includes related attributes from the purchase order data.
Despite filtering for orders placed in the last 30 days, older orders are appearing in the activation.
Why Apply a Filter to Purchase Order Date?
Root Cause:
The related attributes (e.g., purchase order details) may not be filtered by the same criteria as the
segment.
Without a specific filter on the Purchase Order Date, older orders may inadvertently be included.
Solution Approach:
Applying a filter directly to the Purchase Order Date ensures that only orders within the desired
timeframe are included in the activation.
Other Options Are Less Suitable:
C
Explanation:
The issue arises because the activated segment in Marketing Cloud contains orders older than 30 days, despite the segment being defined to include only recent orders. The best solution is to apply a filter to the Purchase Order Date to exclude older orders.
Here’s why:
Understanding the Issue
The segment includes related attributes from the purchase order data.
Despite filtering for orders placed in the last 30 days, older orders are appearing in the activation.
Why Apply a Filter to Purchase Order Date?
Root Cause:
The related attributes (e.g., purchase order details) may not be filtered by the same criteria as the
segment.
Without a specific filter on the Purchase Order Date, older orders may inadvertently be included.
Solution Approach:
Applying a filter directly to the Purchase Order Date ensures that only orders within the desired
timeframe are included in the activation.
Other Options Are Less Suitable:
Question #49
A customer has a calculated insight about lifetime value.
What does the consultant need to be aware of if the calculated insight. needs to be modified?
- A . New dimensions can be added.
- B . Existing dimensions can be removed.
- C . Existing measures can be removed.
- D . New measures can be added.
Correct Answer: B
B
Explanation:
A calculated insight is a multidimensional metric that is defined and calculated from data using SQL expressions. A calculated insight can include dimensions and measures. Dimensions are the fields that are used to group or filter the data, such as customer ID, product category, or region. Measures are the fields that are used to perform calculations or aggregations, such as revenue, quantity, or average order value. A calculated insight can be modified by editing the SQL expression or changing the data space. However, the consultant needs to be aware of the following limitations and considerations when modifying a calculated insight12:
Existing dimensions cannot be removed. If a dimension is removed from the SQL expression, the calculated insight will fail to run and display an error message. This is because the dimension is used to create the primary key for the calculated insight object, and removing it will cause a conflict with the existing data. Therefore, the correct answer is B.
New dimensions can be added. If a dimension is added to the SQL expression, the calculated insight will run and create a new field for the dimension in the calculated insight object. However, the consultant should be careful not to add too many dimensions, as this can affect the performance and usability of the calculated insight.
Existing measures can be removed. If a measure is removed from the SQL expression, the calculated insight will run and delete the field for the measure from the calculated insight object. However, the consultant should be aware that removing a measure can affect the existing segments or activations that use the calculated insight.
New measures can be added. If a measure is added to the SQL expression, the calculated insight will run and create a new field for the measure in the calculated insight object. However, the consultant should be careful not to add too many measures, as this can affect the performance and usability of the calculated insight.
Reference: Calculated Insights, Calculated Insights in a Data Space.
B
Explanation:
A calculated insight is a multidimensional metric that is defined and calculated from data using SQL expressions. A calculated insight can include dimensions and measures. Dimensions are the fields that are used to group or filter the data, such as customer ID, product category, or region. Measures are the fields that are used to perform calculations or aggregations, such as revenue, quantity, or average order value. A calculated insight can be modified by editing the SQL expression or changing the data space. However, the consultant needs to be aware of the following limitations and considerations when modifying a calculated insight12:
Existing dimensions cannot be removed. If a dimension is removed from the SQL expression, the calculated insight will fail to run and display an error message. This is because the dimension is used to create the primary key for the calculated insight object, and removing it will cause a conflict with the existing data. Therefore, the correct answer is B.
New dimensions can be added. If a dimension is added to the SQL expression, the calculated insight will run and create a new field for the dimension in the calculated insight object. However, the consultant should be careful not to add too many dimensions, as this can affect the performance and usability of the calculated insight.
Existing measures can be removed. If a measure is removed from the SQL expression, the calculated insight will run and delete the field for the measure from the calculated insight object. However, the consultant should be aware that removing a measure can affect the existing segments or activations that use the calculated insight.
New measures can be added. If a measure is added to the SQL expression, the calculated insight will run and create a new field for the measure in the calculated insight object. However, the consultant should be careful not to add too many measures, as this can affect the performance and usability of the calculated insight.
Reference: Calculated Insights, Calculated Insights in a Data Space.
Question #50
Cumulus Financial (CF) wants to target loyal and engaged customers. When a platinum tier customer visits their Investment pages more than three times in a 24-hour period, CF wants to Immediately Send an email that offers a private consultation.
What should a consultant recommend for this business requirement?
- A . Calculated insight with a data action to a Marketing Cloud Engagement transactional email
- B . Rapid segment to a data action journey in Marketing Cloud Engagement
- C . Standard segment with activation into Marketing Cloud Engagement
- D . Streaming insight with a data action into a journey in Marketing Cloud Engagement
Correct Answer: D
D
Explanation:
To meet the requirement of targeting loyal and engaged customers (platinum-tier customers visiting investment pages more than three times in 24 hours) and sending an immediate email offering a private consultation, the best solution is to use a streaming insight with a data action into a journey in Marketing Cloud Engagement. Here’s why:
Understanding the Requirement
The company wants to identify platinum-tier customers who visit their Investment pages more than three times within a 24-hour period.
Once identified, these customers should immediately receive an email offering a private consultation.
This requires real-time monitoring of customer behavior and triggering an automated response.
Why Streaming Insight with a Data Action?
Streaming Insights for Real-Time Monitoring:
A streaming insight in Salesforce Data Cloud monitors customer interactions in real time.
It can detect when a platinum-tier customer visits the Investment pages more than three times within 24 hours.
Data Actions for Immediate Response:
A data action allows you to trigger specific actions based on the insights generated.
In this case, the data action would send the customer’s information to a journey in Marketing Cloud
Engagement to initiate the email campaign.
Journey in Marketing Cloud Engagement:
Marketing Cloud Engagement journeys are designed to automate personalized marketing activities, such as sending transactional emails.
By integrating the streaming insight with a journey, the system can immediately send the email offering a private consultation.
Steps to Implement This Solution
Step 1: Create a Streaming Insight
Navigate to Data Cloud > Insights > Streaming Insights.
Define the criteria for identifying platinum-tier customers who visit the Investment pages more than three times in 24 hours.
Step 2: Configure a Data Action
Set up a data action that sends the identified customer’s information to Marketing Cloud Engagement.
Ensure the data action includes relevant details (e.g., customer ID, email address).
Step 3: Build a Journey in Marketing Cloud Engagement
In Marketing Cloud Engagement, create a journey that listens for incoming data from the data action.
Configure the journey to send a personalized email offering a private consultation.
Step 4: Test and Deploy
Test the entire workflow to ensure that the streaming insight triggers the data action and that the email is sent immediately.
Why Not Other Options?
D
Explanation:
To meet the requirement of targeting loyal and engaged customers (platinum-tier customers visiting investment pages more than three times in 24 hours) and sending an immediate email offering a private consultation, the best solution is to use a streaming insight with a data action into a journey in Marketing Cloud Engagement. Here’s why:
Understanding the Requirement
The company wants to identify platinum-tier customers who visit their Investment pages more than three times within a 24-hour period.
Once identified, these customers should immediately receive an email offering a private consultation.
This requires real-time monitoring of customer behavior and triggering an automated response.
Why Streaming Insight with a Data Action?
Streaming Insights for Real-Time Monitoring:
A streaming insight in Salesforce Data Cloud monitors customer interactions in real time.
It can detect when a platinum-tier customer visits the Investment pages more than three times within 24 hours.
Data Actions for Immediate Response:
A data action allows you to trigger specific actions based on the insights generated.
In this case, the data action would send the customer’s information to a journey in Marketing Cloud
Engagement to initiate the email campaign.
Journey in Marketing Cloud Engagement:
Marketing Cloud Engagement journeys are designed to automate personalized marketing activities, such as sending transactional emails.
By integrating the streaming insight with a journey, the system can immediately send the email offering a private consultation.
Steps to Implement This Solution
Step 1: Create a Streaming Insight
Navigate to Data Cloud > Insights > Streaming Insights.
Define the criteria for identifying platinum-tier customers who visit the Investment pages more than three times in 24 hours.
Step 2: Configure a Data Action
Set up a data action that sends the identified customer’s information to Marketing Cloud Engagement.
Ensure the data action includes relevant details (e.g., customer ID, email address).
Step 3: Build a Journey in Marketing Cloud Engagement
In Marketing Cloud Engagement, create a journey that listens for incoming data from the data action.
Configure the journey to send a personalized email offering a private consultation.
Step 4: Test and Deploy
Test the entire workflow to ensure that the streaming insight triggers the data action and that the email is sent immediately.
Why Not Other Options?