Data-Cloud-Consultant Salesforce Certified Data Cloud Consultant (SP24) Questions and Answers

The most efficient approach that a consultant should take when ingesting this data to ensure all the different phone numbers are properly mapped and available for use in activation is B. Ingest the Contact object and use streaming transforms to normalize the phone numbers from the Contact data stream into a separate Phone data lake object (DLO) that contains three rows, and then map this new DLO to the Contact Point Phone data map object. This approach allows the consultant to use the streaming transforms feature of Data Cloud, which enables data manipulation and transformation at the time of ingestion, without requiring any additional processing or storage. Streaming transforms can be used to normalize the phone numbers from the Contact data stream, such as removing spaces, dashes, or parentheses, and adding country codes if needed. The normalized phone numbers can then be stored in a separate Phone DLO, which can have one row for each phone number type (work, home, mobile). The Phone DLO can then be mapped to the Contact Point Phone data map object, which is a standard object that represents a phone number associated with a contact point. This way, the consultant can ensure that all the phone numbers are available for activation, such as sending SMS messages or making calls to the customers.

The other options are not as efficient as option B. Option A is incorrect because it does not normalize the phone numbers, which may cause issues with activation or identity resolution. Option C is incorrect because it requires creating a calculated insight, which is an additional step that consumes more resources and time than streaming transforms. Option D is incorrect because it requires creating formula fields in the Contact data stream, which may not be supported by the CRM Connector or may cause conflicts with the existing fields in the Contact object. References: Salesforce Data Cloud Consultant Exam Guide, Data Ingestion and Modeling, Streaming Transforms, Contact Point Phone

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. References: Salesforce Data Cloud Consultant Exam Guide, Identity Resolution

Data spaces are logical containers that allow you to separate and organize your data by different criteria, such as brand, region, product, or business unit1. Data spaces can help you manage data access, security, and governance, as well as enable cross-cloud data integration and activation2. For NTO, data spaces can support their desire to separate their data by brand, so that they can have different data models, rules, and insights for their outdoor lifestyle clothing and gourmet camping food businesses. Data spaces can also help NTO comply with any data privacy and security regulations that may apply to their different brands3. The other options are incorrect because they do not provide the same level of data separation and organization as data spaces. Data streams are used to ingest data from different sources into Data Cloud, but they do not separate the data by brand4. Data model objects are used to define the structure and attributes of the data, but they do not isolate the data by brand5. Data sources are used to identify the origin and type of the data, but they do not partition the data by brand. References: Data Spaces Overview, Create Data Spaces, Data Privacy and Security in Data Cloud, Data Streams Overview, Data Model Objects Overview, [Data Sources Overview]

To create a segment based on the product color and product type from the Order Product object, the consultant should place the attributes for product color and product type in a single container. This way, the segment will include only the customers who have purchased black pants, and not those who have purchased black shirts or blue pants. A container is a grouping of attributes that defines a segment of individuals based on a logical AND operation. Placing the attributes in separate containers would result in a segment that includes customers who have purchased any black product or any pants product, which is not the desired criteria. Placing an attribute for the “black” calculated insight would not work, because calculated insights are based on aggregated data and not individual-level data. Placing the attributes as direct attributes would not work, because direct attributes are used to filter individuals based on their profile data, not their order data. References:

• Create a Segment in Data Cloud
• Learn About Segmentation Tools
• Salesforce Launches: Data Cloud Consultant Certification

 Engagement-based related attributes are attributes that describe the interactions of a person with an email message, such as opens, clicks, unsubscribes, etc. These attributes are stored in the Engagement data model object (DMO) and can be added to an activation to send more personalized communications. However, there are some considerations and limitations when using engagement-based related attributes, such as:

• For engagement data, activation supports a 90-day lookback window. This means that only the attributes from the engagement events that occurred within the last 90 days are considered for activation. Any records outside of this window are not included in the activation payload. Therefore, the consultant should review the event time of the related engagement events and make sure they are within the lookback window.
• The correct path to the related attributes must be selected for the activation. A path is a sequence of DMOs that are connected by relationships in the data model. For example, the path from Individual to Engagement is Individual -> Email -> Engagement. The path determines which related attributes are available for activation and how they are filtered. Therefore, the consultant should review the path selection and make sure it matches the desired related attributes and filters.

The other two options are not relevant for this issue. The activations can reference segments that segment on profile data rather than engagement data, as long as the activation target supports related attributes. The activated profiles do not need to have a Unified Contact Point, which is a unique identifier for a person across different data sources, to activate engagement-based related attributes. References: Add Related Attributes to an Activation, Related Attributes in Data Cloud activation have no values, Explore the Engagement Data Model Object

The cause of this issue is that the new custom data model object (DMO) is not of category Profile. A category is a property of a DMO that defines its purpose and functionality in Data Cloud. There are three categories of DMOs: Profile, Event, and Other. Profile DMOs are used to store attributes of individuals or entities, such as name, email, address, etc. Event DMOs are used to store actions or interactions of individuals or entities, such as purchases, clicks, visits, etc. Other DMOs are used to store any other type of data that does not fit into the Profile or Event categories, such as products, locations, categories, etc. Only Profile DMOs can be used for creating segments in Data Cloud, as segments are based on the attributes of individuals or entities. Therefore, if the new custom DMO is not of category Profile, it will not appear in the segmentation canvas. The other options are not correct because they are not the cause of this issue. Data ingestion is not a prerequisite for creating segments, as segments can be created based on the data model schema without actual data. The new DMO does not need to have a relationship to the individual DMO, as segments can be created based on any Profile DMO, regardless of its relationship to other DMOs. Segmentation is not only supported for the Individual and Unified Individual DMOs, as segments can be created based on any Profile DMO, including custom ones. References: Create a Custom Data Model Object from an Existing Data Model Object, Create a Segment in Data Cloud, Data Model Object Category

 The most efficient way to guarantee that the various phone number formats are standardized is to assign the PhoneNumber field type when creating the data stream. The PhoneNumber field type is a special field type that automatically converts phone numbers into the E164 format, which is the international standard for phone numbers. The E164 format consists of a plus sign (+), the country code, and the national number. For example, +1-202-555-1234 is the E164 format for a US phone number. By using the PhoneNumber field type, the consultant can ensure that the phone numbers are consistent and can be used for future SMS campaigns. The other options are either more time-consuming, require manual intervention, or do not address the formatting issue. References: Data Stream Field Types, E164 Phone Number Format, Salesforce Data Cloud Exam Questions

Deleting an identity resolution ruleset has two major impacts that the consultant should communicate to the customer. First, it will permanently remove all unified customer data that was created by the ruleset, meaning that the unified profiles and their attributes will no longer be available in Data Cloud1. Second, it will eliminate dependencies on data model objects that were used by the ruleset, meaning that the data model objects can be modified or deleted without affecting the ruleset1. These impacts can have significant consequences for the customer’s data quality, segmentation, activation, and analytics, so the consultant should advise the customer to carefully consider the implications of deleting a ruleset before proceeding. The other options are incorrect because they are not impacts of deleting a ruleset. Option A is incorrect because deleting a ruleset will not remove all individual data, but only the unified customer data. The individual data from the source systems will still be available in Data Cloud1. Option D is incorrect because deleting a ruleset will not remove all source profile data, but only the unified customer data. The source profile data from the data streams will still be available in Data Cloud1. References: Delete an Identity Resolution Ruleset

The data model subject area that should be used for any Organization, Individual, or Member in the Customer 360 data model is the Party subject area. The Party subject area defines the entities that are involved in any business transaction or relationship, such as customers, prospects, partners, suppliers, etc. The Party subject area contains the following data model objects (DMOs):

• Organization: A DMO that represents a legal entity or a business unit, such as a company, a department, a branch, etc.
• Individual: A DMO that represents a person, such as a customer, a contact, a user, etc.
• Member: A DMO that represents the relationship between an individual and an organization, such as an employee, a customer, a partner, etc.

The other options are not data model subject areas that should be used for any Organization, Individual, or Member in the Customer 360 data model. The Engagement subject area defines the actions that people take, such as clicks, views, purchases, etc. The Membership subject area defines the associations that people have with groups, such as loyalty programs, clubs, communities, etc. The Global Account subject area defines the hierarchical relationships between organizations, such as parent-child, subsidiary, etc.

References:

• Data Model Subject Areas
• Party Subject Area
• Customer 360 Data Model

To personalize the email content with information about each customer’s current mutual fund investments, the Data Cloud consultant needs to add related attributes to the activation. Related attributes are additional data fields that can be sent along with the segment to the target system for personalization or analysis purposes. In this case, the consultant needs to add the Fund Name attribute, which contains the name of the mutual fund that the customer has invested in, and apply a filter for Fund Type equal to “Mutual Fund” to ensure that only relevant data is sent. The other options are not correct because:

• A. Including Fund Type equal to “Mutual Fund” as a related attribute is not enough to personalize the email content. The consultant also needs to include the Fund Name attribute, which contains the specific name of the mutual fund that the customer has invested in.
• C. Adding related attribute Fund Type is not enough to personalize the email content. The consultant also needs to add the Fund Name attribute, which contains the specific name of the mutual fund that the customer has invested in, and apply a filter for Fund Type equal to “Mutual Fund” to ensure that only relevant data is sent.
• D. Including Fund Name and Fund Type by default for post processing in the target system is not a valid option. The consultant needs to add the related attributes and filters during the activation configuration in Data Cloud, not after the data is sent to the target system. References: Add Related Attributes to an Activation - Salesforce, Related Attributes in Activation - Salesforce, Prepare for Your Salesforce Data Cloud Consultant Credential

The correct answer is B, Unified Individual. A Unified Individual is a record that represents a customer across different data sources, created by applying identity resolution rulesets. Identity resolution rulesets are sets of match and reconciliation rules that define how to link and merge data from different sources based on common attributes. Data Cloud uses identity resolution rulesets to resolve data across multiple data sources and helps you create one record for each customer, regardless of where the data came from1. A retail customer who wants to bring customer data from different sources and use identity resolution for segmentation should segment on the Unified Individual entity, which contains the resolved and consolidated customer data. The other options are incorrect because they do not represent the resolved customer data across different sources. A Subscriber is a record that represents a customer who has opted in to receive marketing communications. A Unified Contact is a record that represents a customer who has a relationship with a specific business unit. An Individual is a record that represents a customer’s profile data from a single data source. References:

• Identity Resolution Ruleset Processing Results
• Consider Data Implications for Segmentation
• Prepare for your Salesforce Data Cloud Consultant Credential
• AI-based Identity Resolution: Linking Diverse Customer Data

 The Ingestion API is a RESTful API that allows you to stream data from any source into Data Cloud in a fast and scalable way. You can use the Ingestion API to send data from your inventory management system into Data Cloud as JSON objects, and then use Data Cloud to create data models, segments, and insights based on your inventory data. The Ingestion API supports both batch and streaming modes, and can handle up to 100,000 records per second. The Ingestion API also provides features such as data validation, encryption, compression, and retry mechanisms to ensure data quality and security. References: Ingestion API Developer Guide, Ingest Data into Data Cloud

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. References: Salesforce Data Cloud Consultant Exam Guide, Segmentation, Activation

 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. References: Sales Order Subject Area, Sales Order Revenue DMO Reference

Data streams are the sources of data that are ingested into Data Cloud and mapped to the data model. Data streams have different categories that determine how the data is processed and used in Data Cloud. Transaction data streams are used for time-based operations in segmentation and calculated insights, such as filtering by date range, aggregating by time period, or calculating time-to-event metrics. Transaction data streams are typically used for event data, such as purchases, clicks, or visits, that have a timestamp and a value associated with them. References: Data Streams, Data Stream Categories

To honor a Request to be Forgotten by a customer, a consultant should use Data Cloud in two ways:

• Add the Individual ID to a headerless file and use the delete from file functionality. This option allows the consultant to delete multiple Individuals from Data Cloud by uploading a CSV file with their IDs1. The deletion process is asynchronous and can take up to 24 hours to complete1.
• Use the Consent API to suppress processing and delete the Individual and related records from source data streams. This option allows the consultant to submit a Data Deletion request for an Individual profile in Data Cloud using the Consent API2. A Data Deletion request deletes the specified Individual entity and any entities where a relationship has been defined between that entity’s identifying attribute and the Individual ID attribute2. The deletion process is reprocessed at 30, 60, and 90 days to ensure a full deletion2. The other options are not correct because:
• Deleting the data from the incoming data stream and performing a full refresh will not delete the existing data in Data Cloud, only the new data from the source system3.
• Using Data Explorer to locate and manually remove the Individual will not delete the related records from the source data streams, only the Individual entity in Data Cloud. References:
• Delete Individuals from Data Cloud
• Requesting Data Deletion or Right to Be Forgotten
• Data Refresh for Data Cloud
• [Data Explorer]

The correct answer is C, the desired attributes reside on different related paths. When creating an activation in Data Cloud, you can select related attributes from data model objects that are linked to the segment entity. However, not all related attributes are available for every activation. The availability of related attributes depends on the container path, which is the sequence of data model objects that connects the segment entity to the related entity. For example, if you segment on the Unified Individual entity, you can select related attributes from the Order Product entity, but only if the container path is Unified Individual > Order > Order Product. If the container path is Unified Individual > Order Line Item > Order Product, then the related attributes from Order Product are not available for activation. This is because Data Cloud only supports one-to-many relationships for related attributes, and Order Line Item is a many-to-many junction object between Order and Order Product. Therefore, you need to ensure that the desired attributes reside on the same related path as the segment entity, and that the path does not include any many-to-many junction objects. The other options are incorrect because they do not explain why the related attributes are not available. The segment entity can be any data model object, not just profile data. The attributes are not restricted by being used in another activation. Activations can include one-to-many attributes, not just one-to-one attributes. References:

• Related Attributes in Activation
• Considerations for Selecting Related Attributes
• Salesforce Launches: Data Cloud Consultant Certification
• Create a Segment in Data Cloud

A streaming insight is a feature that allows users to create and monitor real-time metrics from streaming data sources, such as web and mobile events. A streaming insight can also trigger data actions, such as sending notifications, creating records, or updating fields, based on the metric values and conditions. Therefore, a streaming insight is the best feature to achieve the goal of identifying candidates who have browsed the jobs page on the website at least twice within the last 24 hours, and adding them to the recruiting system. The other options are incorrect because:

• A streaming data transform is a feature that allows users to transform and enrich streaming data using SQL expressions, such as filtering, joining, aggregating, or calculating values. However, a streaming data transform does not provide the ability to monitor metrics or trigger data actions based on conditions.
• A calculated insight is a feature that allows users to define and calculate multidimensional metrics from data using SQL expressions, such as LTV, CSAT, or average order value. However, a calculated insight is not suitable for real-time data analysis, as it runs on a scheduled basis and does not support data actions.
• A batch data transform is a feature that allows users to create and schedule complex data transformations using a visual editor, such as joining, aggregating, filtering, or appending data. However, a batch data transform is not suitable for real-time data analysis, as it runs on a scheduled basis and does not support data actions. References: Streaming Insights, Create a Streaming Insight, Use Insights in Data Cloud, Learn About Data Cloud Insights, Data Cloud Insights Using SQL, Streaming Data Transforms, Get Started with Batch Data Transforms in Data Cloud, Transformations for Batch Data Transforms, Batch Data Transforms in Data Cloud: Quick Look, Salesforce Data Cloud: AI CDP.

 To address this new use case, the consultant should map the primary key from the two systems to Party Identification, using CRM ID as the identification name for both, and create a matching rule based on party identification that matches on CRM ID as the party identification name. This way, the consultant can ensure that the CRM Contacts and Marketing Contacts are matched based on their CRM ID, which is a unique identifier for each individual. By using Party Identification, the consultant can also leverage the benefits of this attribute, such as being able to match across different entities and sources, and being able to handle multiple values for the same individual. The other options are incorrect because they either do not use the CRM ID as the primary key, or they do not use Party Identification as the attribute type. References: Configure Identity Resolution Rulesets, Identity Resolution Match Rules, Data Cloud Identity Resolution Ruleset, Data Cloud Identity Resolution Config Input

To create a segment for a birthday campaign that is evaluated daily, the consultant should use the Is Anniversary Of operator. This operator compares a date field with the current date and returns true if the month and day are the same, regardless of the year. For example, if the date field is 1990-01-01 and the current date is 2023-01-01, the operator returns true. This way, the consultant can create a segment that includes all the customers who have their birthday on the same day as the current date, and the segment will be updated daily with the new birthdays. The other options are not the best operators to use for this purpose because:

• A. The Is Today operator compares a date field with the current date and returns true if the date is the same, including the year. For example, if the date field is 1990-01-01 and the current date is 2023-01-01, the operator returns false. This operator is not suitable for a birthday campaign, as it will only include the customers who were born on the same day and year as the current date, which is very unlikely.
• B. The Is Birthday operator is not a valid operator in Data Cloud. There is no such operator available in the segment canvas or the calculated insight editor.
• C. The Is Between operator compares a date field with a range of dates and returns true if the date is within the range, including the endpoints. For example, if the date field is 1990-01-01 and the range is 2022-12-25 to 2023-01-05, the operator returns true. This operator is not suitable for a birthday campaign, as it will only include the customers who have their birthday within a fixed range of dates, and the segment will not be updated daily with the new birthdays.

 Metrics on metrics is a feature that allows creating new metrics based on existing metrics and applying mathematical operations on them. This can be useful for calculating complex business metrics such as LTV, ROI, or conversion rates. In this case, the consultant can use metrics on metrics to calculate the LTV of each customer by summing up the revenue generated by them across different channels. The consultant can also create breakdowns of the revenue by channel by using the channel attribute as a dimension in the metric definition. References: Metrics on Metrics, Create Metrics on Metrics

 Data Cloud allows customers to analyze the segment membership history of individuals using the Segment Membership data model object. This object stores information about when an individual joined or left a segment, and can be used to create reports and dashboards to track segment performance over time. Cumulus Financial can use this object to filter individuals who have been in the segment within the last 2 years and compare them with other metrics.

The other options are not Data Cloud components that allow for this analysis. Segment exclusion is a feature that allows customers to remove individuals from a segment based on another segment. Nested segments are segments that are created from other segments using logical operators. Calculated insights are derived attributes that are created from existing data using formulas.

References:

• Segment Membership Data Model Object
• Data Cloud Reports and Dashboards
• Create a Segment in Data Cloud

 To ensure that freshly imported data from an Amazon S3 Bucket is ready and available to use for any segment, the following processes should be run in this order:

• Refresh Data Stream: This process updates the data lake objects in Data Cloud with the latest data from the source system. It can be configured to run automatically or manually, depending on the data stream settings1. Refreshing the data stream ensures that Data Cloud has the most recent and accurate data from the Amazon S3 Bucket.
• Identity Resolution: This process creates unified individual profiles by matching and consolidating source profiles from different data streams based on the identity resolution ruleset. It runs daily by default, but can be triggered manually as well2. Identity resolution ensures that Data Cloud has a single view of each customer across different data sources.
• Calculated Insight: This process performs calculations on data lake objects or CRM data and returns a result as a new data object. It can be used to create metrics or measures for segmentation or analysis purposes3. Calculated insights ensure that Data Cloud has the derived data that can be used for personalization or activation.

References:

• 1: Configure Data Stream Refresh and Frequency - Salesforce
• 2: Identity Resolution Ruleset Processing Results - Salesforce
• 3: Calculated Insights - Salesforce

 The reason for the activated count being smaller than the segment count is A. Data Cloud enforces the presence of Contact Point for Marketing Cloud activations. If the individual does not have a related Contact Point, it will not be activated. A Contact Point is a data model object that represents a channel or method of communication with an individual, such as email, phone, or social media. For Marketing Cloud activations, Data Cloud requires that the individual has a related Contact Point of type Email, which contains a valid email address. If the individual does not have such a Contact Point, or if the Contact Point is missing or invalid, the individual will not be activated and will not receive the email communication. Therefore, the activated count may be lower than the segment count, depending on how many individuals in the segment have a valid email Contact Point. References: Salesforce Data Cloud Consultant Exam Guide, Contact Point, Marketing Cloud Activation

When advising a customer about using the Consent API in Salesforce to comply with requests for the right to be forgotten, the consultant should focus on two primary considerations:

• Data deletion requests are submitted for Individual profiles (Answer C): The Consent API in Salesforce is designed to handle data deletion requests specifically for individual profiles. This means that when a request is made to delete data, it is targeted at the personal data associated with an individual's profile in the Salesforce system. The consultant should inform the customer that the requests must be specific to individual profiles to ensure accurate processing and compliance with privacy laws.
• Data deletion requests submitted to Data Cloud are passed to all connected Salesforce clouds (Answer D): When a data deletion request is made through the Consent API in Salesforce Data Cloud, the request is not limited to the Data Cloud alone. Instead, it propagates through all connected Salesforce clouds, such as Sales Cloud, Service Cloud, Marketing Cloud, etc. This ensures comprehensive compliance with the right to be forgotten across the entire Salesforce ecosystem. The customer should be aware that the deletion request will affect all instances of the individual’s data across the connected Salesforce environments.

A calculated insight is a custom metric or measure that is derived from one or more data model objects or data lake objects in Data Cloud. A calculated insight can be used in segmentation to filter or group the data based on the calculated value. However, not all calculated insights can appear in the segmentation canvas. There are two requirements that must be met for a calculated insight to appear in the segmentation canvas:

• The calculated insight must contain a dimension including the Individual or Unified Individual Id. A dimension is a field that can be used to categorize or group the data, such as name, gender, or location. The Individual or Unified Individual Id is a unique identifier for each individual profile in Data Cloud. The calculated insight must include this dimension to link the calculated value to the individual profile and to enable segmentation based on the individual profile attributes.
• The primary key of the segmented table must be a dimension in the calculated insight. The primary key is a field that uniquely identifies each record in a table. The segmented table is the table that contains the data that is being segmented, such as the Customer or the Order table. The calculated insight must include the primary key of the segmented table as a dimension to ensure that the calculated value is associated with the correct record in the segmented table and to avoid duplication or inconsistency in the segmentation results.

References: Create a Calculated Insight, Use Insights in Data Cloud, Segmentation

The best option to map the data to be used for both segmentation and identity resolution is to create custom fields on the standard Individual DMO. This way, the consultant can leverage the existing fields and functionality of the Individual DMO, such as identity resolution rulesets, calculated insights, and data actions, while adding the additional fields that are specific to the beauty company’s data1. Creating a custom DMO from scratch or duplicating the standard Individual DMO would require more effort and maintenance, and might not be compatible with the existing features of Data Cloud. Creating a custom DMO with only the additional fields and mapping it to the standard Individual DMO would create unnecessary complexity and redundancy, and might not allow the use of the custom fields for identity resolution. References:

• 1: Data Model Objects in Data Cloud

The Salesforce CRM Connector uses the Salesforce Integration User to access the data from the Salesforce CRM org. The Integration User must have the Read permission on the fields that are included in the data stream. If the Integration User does not have the Read permission on the newly created field, the field will not be available for selection in the data stream configuration. To resolve this issue, the administrator should assign the Read permission on the new field to the Integration User profile or permission set. References: Create a Salesforce CRM Data Stream, Edit a Data Stream, Salesforce Data Cloud Full Refresh for CRM, SFMC, or Ingestion API Data Streams