Data-Cloud-Consultant Salesforce Certified Data Cloud Consultant(WI24) Question and Answers

The B2C Commerce Order Bundle is a data bundle that creates a data stream to flow order data from a B2C Commerce instance to Data Cloud. However, this data bundle does not ingest any historical data and only ingests new orders from the time the data stream is created. Therefore, if a consultant wants to ingest historical order data, they need to use a different method, such as exporting the data from B2C Commerce and importing it to Data Cloud using a CSV file12. References:

• Create a B2C Commerce Data Bundle
• Data Access and Export for B2C Commerce and Commerce Marketplace

To support separate Amazon S3 buckets for data ingestion and activation, you need to configure dedicated S3 data sources in Data Cloud setup. Data sources are used to identify the origin and type of the data that you ingest into Data Cloud1. You can create different data sources for each S3 bucket that you want to use for ingestion or activation, and specify the bucket name, region, and access credentials2. This way, you can separate and organize your data by different criteria, such as brand, region, product, or business unit3. The other options are incorrect because they do not support separate S3 buckets for data ingestion and activation. Multiple S3 connectors are not a valid configuration in Data Cloud setup, as there is only one S3 connector available4. Dedicated S3 data sources in activation setup are not a valid configuration either, as activation setup does not require data sources, but activation targets5. Separate user credentials for data stream and activation target are not sufficient to support separate S3 buckets, as you also need to specify the bucket name and region for each data source2. References: Data Sources Overview, Amazon S3 Storage Connector, Data Spaces Overview, Data Streams Overview, Data Activation Overview

To use the Amazon S3 Storage Connector in Data Cloud, the consultant needs to provide the S3 bucket name, region, and access key and secret key for authentication. The access key and secret key are generated by AWS and can be managed in the IAM console. The other options are not supported by the S3 Storage Connector or by Data Cloud. References: Amazon S3 Storage Connector - Salesforce, How to Use the Amazon S3 Storage Connector in Data Cloud | Salesforce Developers Blog

Learn more

1blob:https://www.bing.com/fed40cd6-30db-497b-a587-44e59b9e1f0b

help.salesforce.com2blob:https://www.bing.com/ec651c64-71a9-4e79-94f1-3631d6942839

developer.salesforce.com

 The solution that provides an easy way to ingest Marketing Cloud subscriber profile attributes into Data Cloud on a daily basis is the Marketing Cloud Data extension Data Stream. The Marketing Cloud Data extension Data Stream is a feature that allows customers to stream data from Marketing Cloud data extensions to Data Cloud data spaces. Customers can select which data extensions they want to stream, and Data Cloud will automatically create and update the corresponding data model objects (DMOs) in the data space. Customers can also map the data extension fields to the DMO attributes using a user interface or an API. The Marketing Cloud Data extension Data Stream can help customers ingest subscriber profile attributes and other data from Marketing Cloud into Data Cloud without writing any code or setting up any complex integrations.

The other options are not solutions that provide an easy way to ingest Marketing Cloud subscriber profile attributes into Data Cloud on a daily basis. Automation Studio and Profile file API are tools that can be used to export data from Marketing Cloud to external systems, but they require customers to write scripts, configure file transfers, and schedule automations. Marketing Cloud Connect API is an API that can be used to access data from Marketing Cloud in other Salesforce solutions, such as Sales Cloud or Service Cloud, but it does not support streaming data to Data Cloud. Email Studio Starter Data Bundle is a data kit that contains sample data and segments for Email Studio, but it does not contain subscriber profile attributes or stream data to Data Cloud.

References:

• Marketing Cloud Data Extension Data Stream
• Data Cloud Data Ingestion
• [Marketing Cloud Data Extension Data Stream API]
• [Marketing Cloud Connect API]
• [Email Studio Starter Data Bundle]

A “NO FILE FOUND” error message indicates that Data Cloud cannot access or locate the file from the Amazon S3 source. There are two possible reasons for this error and two corresponding steps that a consultant should take to troubleshoot it:

• The Data Cloud user does not have the correct permissions to read the file from the Amazon S3 bucket. This could happen if the user’s permission set or profile does not include the Data Cloud Data Stream Read permission, or if the user’s Amazon S3 credentials are invalid or expired. To fix this issue, the consultant should check and update the user’s permissions and credentials in Data Cloud and Amazon S3, respectively.
• The file does not exist in the specified bucket location. This could happen if the file name or path has changed, or if the file has been deleted or moved from the Amazon S3 bucket. To fix this issue, the consultant should check and verify the file name and path in the Amazon S3 bucket, and update the data stream configuration in Data Cloud accordingly. References: Create Amazon S3 Data Stream in Data Cloud, How to Use the Amazon S3 Storage Connector in Data Cloud, Amazon S3 Connection

 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

 The consultant should use B. Segmentation exclude rules to remove the recent customers. Segmentation exclude rules are filters that can be applied to a segment to exclude records that meet certain criteria. The consultant can use segmentation exclude rules to exclude customers who have made purchases within the last week from the segment that contains customers who have purchased within the past 6 months. This way, the segment will only include customers who are eligible for the promotional campaign.

The other options are not correct. Option A is incorrect because batch transforms are data processing tasks that can be applied to data streams or data lake objects to modify or enrich the data. Batch transforms are not used for segmentation or activation. Option C is incorrect because related attributes are attributes that are derived from the relationships between data model objects. Related attributes are not used for excluding records from a segment. Option D is incorrect because streaming insights are derived attributes that are calculated at the time of data ingestion. Streaming insights are not used for excluding records from a segment. References: Salesforce Data Cloud Consultant Exam Guide, Segmentation, Segmentation Exclude Rules

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. References: Ingest Data from Amazon S3, Refresh Modes

A customer who wants to view the last time each segment was published within their Data Cloud org can use the dashboard and report features to achieve this requirement. A dashboard is a visual representation of data that can show key metrics, trends, and comparisons. A report is a tabular or matrix view of data that can show details, summaries, and calculations. Both dashboard and report features allow the user to create, customize, and share data views based on their needs and preferences. To view the last time each segment was published, the user can create a dashboard or a report that shows the segment name, the publish date, and the publish status fields from the segment object. The user can also filter, sort, group, or chart the data by these fields to get more insights and analysis. The user can also schedule, refresh, or export the dashboard or report data as needed. References: Dashboards, Reports

The Data Cloud User permission set is the minimum permission set needed to accommodate this use case. The Data Cloud User permission set grants access to the Data Explorer feature, which allows the user to review individual rows of ingested data and validate that it has been modeled successfully to its linked data model object. The user can also make changes to the data model object fields, such as adding or removing fields, changing field types, or creating formula fields. The Data Cloud User permission set does not grant access to other Data Cloud features or tasks, such as creating data streams, creating segments, creating activations, or managing users. The other permission sets are either too restrictive or too permissive for this use case. The Data Cloud for Marketing Specialist permission set only grants access to the segmentation and activation features, but not to the Data Explorer feature. The Data Cloud Admin permission set grants access to all Data Cloud features and tasks, including the Data Explorer feature, but it is more than what the user needs. The Data Cloud for Marketing Data Aware Specialist permission set grants access to the Data Explorer feature, but also to the segmentation and activation features, which are not required for this use case. References: Data Cloud Standard Permission Sets, Data Explorer, Set Up Data Cloud Unit

Data Cloud requires a Contact Point for Marketing Cloud activations, which is a record that links an individual to an email address. This ensures that the individual has given consent to receive email communications and that the email address is valid. If the individual does not have a related Contact Point, they will not be activated in Marketing Cloud. This may result in a lower activated count than the segment count. References: Data Cloud Activation, Contact Point for Marketing Cloud

When creating a segment on an individual, using two separate containers linked by an AND means that the individual must satisfy both the conditions in the containers. In this case, the individual must have purchased at least one product with the color attribute equal to ‘red’ and at least one product with the primary product category attribute equal to ‘shoes’. The products do not have to be the same or purchased in the same transaction. Therefore, the correct answer is A.

The other options are incorrect because they imply different logical operators or conditions. Option B implies that the individual must have purchased a single product that has both the color attribute equal to ‘red’ and the primary product category attribute equal to ‘shoes’. Option C implies that the individual must have purchased only one product that has both the color attribute equal to ‘red’ and the primary product category attribute equal to ‘shoes’ and no other products. Option D implies that the individual must have purchased either one product with the color attribute equal to ‘red’ or one product with the primary product category attribute equal to ‘shoes’ or both, which is equivalent to using an OR operator instead of an AND operator.

References:

• Create a Container for Segmentation
• Create a Segment in Data Cloud
• Navigate Data Cloud Segmentation

According to the Salesforce Data Cloud documentation, an attribute is a dimension or a measure that can be used in activation. A dimension is a categorical variable that can be used to group or filter data, such as branch, region, or product. A measure is a numerical variable that can be used to calculate metrics, such as revenue, profit, or count. A filter is a condition that can be applied to limit the data that is used in a calculated insight, such as high net worth, age range, or gender. In this question, the calculated insight uses “banking value” as a metric, which is a measure, and “branch” as a dimension. Therefore, only “branch” can be included as an attribute in activation, since it is a dimension. The other options are either measures or filters, which are not attributes. References: Data Cloud Permission Sets, Salesforce Data Cloud Exam Questions

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

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.

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

Data Cloud is a data platform that can help customers connect, prepare, harmonize, unify, query, analyze, and act on their data across various Salesforce and external sources. Some of the common use cases that can be addressed with Data Cloud are:

• Understand and act upon customer data to drive more relevant experiences. Data Cloud can help customers gain a 360-degree view of their customers by unifying data from different sources and resolving identities across channels. Data Cloud can also help customers segment their audiences, create personalized experiences, and activate data in any channel using insights and AI.
• Harmonize data from multiple sources with a standardized and extendable data model. Data Cloud can help customers transform and cleanse their data before using it, and map it to a common data model that can be extended and customized. Data Cloud can also help customers create calculated insights and related attributes to enrich their data and optimize identity resolution.

The other two options are not common use cases for Data Cloud. Data Cloud does not provide data governance or backup and disaster recovery features, as these are typically handled by other Salesforce or external solutions.

References:

• Learn How Data Cloud Works
• About Salesforce Data Cloud
• Discover Use Cases for the Platform
• Understand Common Data Analysis Use Cases

To validate the data on a unified profile, the consultant can use the following features:

• Identity Resolution: This feature allows the consultant to view and edit the identity resolution rulesets that determine how individuals are unified from different data sources1.
• Data Explorer: This feature allows the consultant to browse and filter the unified profiles and view their attributes, segments, and activities2.
• Profile Explorer: This feature allows the consultant to drill down into a specific unified profile and view its details, such as source records, identity graph, calculated insights, and data actions3. References:
• 1: Identity Resolution in Data Cloud
• 2: Data Explorer in Data Cloud
• 3: Profile Explorer in Data Cloud

 The field type Text should be chosen to ensure that leading zeros in the purchase order number are preserved. This is because text fields store alphanumeric characters as strings, and do not remove any leading or trailing characters. On the other hand, number, decimal, and serial fields store numeric values as numbers, and automatically remove any leading zeros when displaying or exporting the data123. Therefore, text fields are more suitable for storing data that needs to retain its original format, such as purchase order numbers, zip codes, phone numbers, etc. References:

• Zeros at the start of a field appear to be omitted in Data Exports
• Keep First ‘0’ When Importing a CSV File
• Import and export address fields that begin with a zero or contain a plus symbol

 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

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]

 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

The consolidation rate is a metric that measures the amount by which source profiles are combined to produce unified profiles in Data Cloud, calculated as 1 - (number of unified profiles / number of source profiles). A higher consolidation rate means that more source profiles are matched and merged into fewer unified profiles, while a lower consolidation rate means that fewer source profiles are matched and more unified profiles are created. There are two likely explanations for why the consolidation rate has recently increased for a customer:

• New data sources have been added to Data Cloud that largely overlap with the existing profiles. This means that the new data sources contain many profiles that are similar or identical to the profiles from the existing data sources. For example, if a customer adds a new CRM system that has the same customer records as their old CRM system, the new data source will overlap with the existing one. When Data Cloud ingests the new data source, it will use the identity resolution ruleset to match and merge the overlapping profiles into unified profiles, resulting in a higher consolidation rate.
• Identity resolution rules have been added to the ruleset to increase the number of matched profiles. This means that the customer has modified their identity resolution ruleset to include more match rules or more match criteria that can identify more profiles as belonging to the same individual. For example, if a customer adds a match rule that matches profiles based on email address and phone number, instead of just email address, the ruleset will be able to match more profiles that have the same email address and phone number, resulting in a higher consolidation rate.

References: Identity Resolution Calculated Insight: Consolidation Rates for Unified Profiles, Configure Identity Resolution Rulesets

The correct answer is A. Deactivate the segment. If a segment is no longer needed, it can be deactivated through Data Cloud and applies to all chosen targets. A deactivated segment no longer publishes, but it can be reactivated at any time1. This option allows the user to pause a segment activation with the intent of using that segment again.

The other options are incorrect for the following reasons:

• B. Delete the segment. This option permanently removes the segment from Data Cloud and cannot be undone2. This option does not allow the user to use the segment again.
• C. Skip the activation. This option skips the current activation cycle for the segment, but does not affect the future activation cycles3. This option does not pause the segment activation indefinitely.
• D. Stop the publish schedule. This option stops the segment from publishing to the chosen targets, but does not deactivate the segment4. This option does not pause the segment activation completely.

References:

• 1: Deactivated Segment article on Salesforce Help
• 2: Delete a Segment article on Salesforce Help
• 3: Skip an Activation article on Salesforce Help
• 4: Stop a Publish Schedule article on Salesforce Help

 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

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. References: Configure Identity Resolution Rulesets, A framework of identity resolution: evaluating identity attributes and methods

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.

The Party Identification object is the correct object to use in identity resolution to perform exact match rules on the Loyalty ID. The Party Identification object is a child object of the Individual object that stores different types of identifiers for an individual, such as email, phone, loyalty ID, social media handle, etc. Each identifier has a type, a value, and a source. The consultant can use the Party Identification object to create a match rule that compares the Loyalty ID type and value across different sources and links the corresponding individuals.

The other options are not correct objects to use in identity resolution to perform exact match rules on the Loyalty ID. The Loyalty Identification object does not exist in Data Cloud. The Individual object is the parent object that represents a unified profile of an individual, but it does not store the Loyalty ID directly. The Contact Identification object is a child object of the Contact object that stores identifiers for a contact, such as email, phone, etc., but it does not store the Loyalty ID.

References:

• Data Modeling Requirements for Identity Resolution
• Identity Resolution in a Data Space
• Configure Identity Resolution Rulesets
• Map Required Objects
• Data and Identity in Data Cloud