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 #111
How does Data Cloud ensure high availability and fault tolerance for customer data?
- A . By distributing data across multiple regions and data centers
- B . By using a data center with robust backups
- C . By Implementing automatic data recovery procedures
- D . By limiting data access to essential personnel
Correct Answer: A
A
Explanation:
Ensuring High Availability and Fault Tolerance:
High availability refers to systems that are continuously operational and accessible, while fault tolerance is the ability to continue functioning in the event of a failure.
Reference: Salesforce High Availability and Fault Tolerance Whitepaper Data Distribution Across Multiple Regions and Data Centers:
Salesforce Data Cloud ensures high availability by replicating data across multiple geographic regions and data centers. This distribution mitigates risks associated with localized failures.
If one data center goes down, data and services can continue to be served from another location, ensuring uninterrupted service.
Reference: Salesforce Infrastructure Overview
Benefits of Regional Data Distribution:
Redundancy: Having multiple copies of data across regions provides redundancy, which is critical for disaster recovery.
Load Balancing: Traffic can be distributed across data centers to optimize performance and reduce latency.
Regulatory Compliance: Storing data in different regions helps meet local data residency requirements.
Reference: Salesforce Data Center Locations and Regional Data Hosting Implementation in Salesforce Data Cloud:
Salesforce utilizes a robust architecture involving data replication and failover mechanisms to maintain data integrity and availability.
This architecture ensures that even in the event of a regional outage, customer data remains secure and accessible.
Reference: Salesforce Trust and Compliance Documentation
A
Explanation:
Ensuring High Availability and Fault Tolerance:
High availability refers to systems that are continuously operational and accessible, while fault tolerance is the ability to continue functioning in the event of a failure.
Reference: Salesforce High Availability and Fault Tolerance Whitepaper Data Distribution Across Multiple Regions and Data Centers:
Salesforce Data Cloud ensures high availability by replicating data across multiple geographic regions and data centers. This distribution mitigates risks associated with localized failures.
If one data center goes down, data and services can continue to be served from another location, ensuring uninterrupted service.
Reference: Salesforce Infrastructure Overview
Benefits of Regional Data Distribution:
Redundancy: Having multiple copies of data across regions provides redundancy, which is critical for disaster recovery.
Load Balancing: Traffic can be distributed across data centers to optimize performance and reduce latency.
Regulatory Compliance: Storing data in different regions helps meet local data residency requirements.
Reference: Salesforce Data Center Locations and Regional Data Hosting Implementation in Salesforce Data Cloud:
Salesforce utilizes a robust architecture involving data replication and failover mechanisms to maintain data integrity and availability.
This architecture ensures that even in the event of a regional outage, customer data remains secure and accessible.
Reference: Salesforce Trust and Compliance Documentation
Question #112
A consultant is setting up a data stream with transactional data, Which field type should the consultant choose to ensure that leading zeros in the purchase order number are preserved?
- A . Text
- B . Number
- C . Decimal
- D . Serial
Correct Answer: A
A
Explanation:
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.
Reference: 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
A
Explanation:
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.
Reference: 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
Question #113
Cumulus Financial created a segment called High Investment Balance Customers. This is a foundational segment that includes several segmentation criteria the marketing team should consistently use.
Which feature should the consultant suggest the marketing team use to ensure this consistency when creating future, more refined segments?
- A . Create new segments using nested segments.
- B . Create a High Investment Balance calculated insight.
- C . Package High Investment Balance Customers in a data kit.
- D . Create new segments by cloning High Investment Balance Customers.
Correct Answer: A
A
Explanation:
Nested segments are segments that include or exclude one or more existing segments. They allow the marketing team to reuse filters and maintain consistency in their data by using an existing segment to build a new one. For example, the marketing team can create a nested segment that includes High Investment Balance Customers and excludes customers who have opted out of email marketing. This way, they can leverage the foundational segment and apply additional criteria without duplicating the rules.
The other options are not the best features to ensure consistency because:
B. A calculated insight is a data object that performs calculations on data lake objects or CRM data and returns a result. It is not a segment and cannot be used for activation or personalization.
C. A data kit is a bundle of packageable metadata that can be exported and imported across Data Cloud orgs. It is not a feature for creating segments, but rather for sharing components.
D. Cloning a segment creates a copy of the segment with the same rules and filters. It does not allow the marketing team to add or remove criteria from the original segment, and it may create confusion and redundancy.
Reference: Create a Nested Segment – Salesforce, Save Time with Nested Segments (Generally Available) – Salesforce, Calculated Insights – Salesforce, Create and Publish a Data Kit Unit | Salesforce Trailhead, Create a Segment in Data Cloud – Salesforce
A
Explanation:
Nested segments are segments that include or exclude one or more existing segments. They allow the marketing team to reuse filters and maintain consistency in their data by using an existing segment to build a new one. For example, the marketing team can create a nested segment that includes High Investment Balance Customers and excludes customers who have opted out of email marketing. This way, they can leverage the foundational segment and apply additional criteria without duplicating the rules.
The other options are not the best features to ensure consistency because:
B. A calculated insight is a data object that performs calculations on data lake objects or CRM data and returns a result. It is not a segment and cannot be used for activation or personalization.
C. A data kit is a bundle of packageable metadata that can be exported and imported across Data Cloud orgs. It is not a feature for creating segments, but rather for sharing components.
D. Cloning a segment creates a copy of the segment with the same rules and filters. It does not allow the marketing team to add or remove criteria from the original segment, and it may create confusion and redundancy.
Reference: Create a Nested Segment – Salesforce, Save Time with Nested Segments (Generally Available) – Salesforce, Calculated Insights – Salesforce, Create and Publish a Data Kit Unit | Salesforce Trailhead, Create a Segment in Data Cloud – Salesforce
Question #114
Cumulus Financial wants to segregate Salesforce CRM Account data based on Country for its Data Cloud users.
What should the consultant do to accomplish this?
- A . Use streaming transforms to filter out Account data based on Country and map to separate data model objects accordingly.
- B . Use the data spaces feature and applying filtering on the Account data lake object based on Country.
- C . Use Salesforce sharing rules on the Account object to filter and segregate records based on Country.
- D . Use formula fields based on the account Country field to filter incoming records.
Correct Answer: B
B
Explanation:
Data spaces are a feature that allows Data Cloud users to create subsets of data based on filters and permissions. Data spaces can be used to segregate data based on different criteria, such as geography, business unit, or product line. In this case, the consultant can use the data spaces feature and apply filtering on the Account data lake object based on Country. This way, the Data Cloud users can access only the Account data that belongs to their respective countries.
Reference: Data Spaces, Create a Data Space
B
Explanation:
Data spaces are a feature that allows Data Cloud users to create subsets of data based on filters and permissions. Data spaces can be used to segregate data based on different criteria, such as geography, business unit, or product line. In this case, the consultant can use the data spaces feature and apply filtering on the Account data lake object based on Country. This way, the Data Cloud users can access only the Account data that belongs to their respective countries.
Reference: Data Spaces, Create a Data Space
Question #115
When trying to disconnect a data source an error will be generated if it has which two dependencies
associated with it? Choose 2 answers
- A . Activation
- B . Data stream
- C . Segment
- D . Activation target
Correct Answer: BC
BC
Explanation:
When disconnecting a data source in Salesforce Data Cloud, the system checks for active dependencies that rely on the data source. Based on Salesforce’s official documentation (Disconnect a Data Source), the error occurs if the data source has data streams or segments associated with it.
Here’s the breakdown:
Key Dependencies That Block Disconnection
Data Stream (Option B):
Why It Matters:
A data stream is the pipeline that ingests data from the source into Data Cloud. If an active data stream is connected to the data source, disconnecting the source will fail because the stream depends on it for ongoing data ingestion.
Resolution:
Delete or pause the data stream first.
Documentation
Reference: "Before disconnecting a data source, delete all data streams that are associated with it." (Salesforce
Help Article)
Segment (Option C):
Why It Matters:
Segments built using data from the source will reference that data source. Disconnecting the source would orphan these segments, so the system blocks the action. Resolution:
Delete or modify segments that depend on the data source.
Documentation
Reference: "If there are segments that use data from the data source, you must delete those segments before disconnecting the data source." (Salesforce Help Article)
Why Other Options Are Incorrect
Activation (A):
Activations send segments to external systems (e.g., Marketing Cloud) but do not directly depend on the data source itself. The dependency chain is Segment → Activation, not Data Source → Activation. Activation Target (D):
Activation targets (e.g., Marketing Cloud) are destinations and do not tie directly to the data source.
Steps to Disconnect a Data Source
Delete Dependent Segments:
Navigate to Data Cloud > Segments and remove any segments built using the data source.
Delete or Pause Data Streams:
Go to Data Cloud > Data Streams and delete streams linked to the data source.
Disconnect the Data Source:
Once dependencies are resolved, disconnect the source via Data Cloud > Data Sources.
BC
Explanation:
When disconnecting a data source in Salesforce Data Cloud, the system checks for active dependencies that rely on the data source. Based on Salesforce’s official documentation (Disconnect a Data Source), the error occurs if the data source has data streams or segments associated with it.
Here’s the breakdown:
Key Dependencies That Block Disconnection
Data Stream (Option B):
Why It Matters:
A data stream is the pipeline that ingests data from the source into Data Cloud. If an active data stream is connected to the data source, disconnecting the source will fail because the stream depends on it for ongoing data ingestion.
Resolution:
Delete or pause the data stream first.
Documentation
Reference: "Before disconnecting a data source, delete all data streams that are associated with it." (Salesforce
Help Article)
Segment (Option C):
Why It Matters:
Segments built using data from the source will reference that data source. Disconnecting the source would orphan these segments, so the system blocks the action. Resolution:
Delete or modify segments that depend on the data source.
Documentation
Reference: "If there are segments that use data from the data source, you must delete those segments before disconnecting the data source." (Salesforce Help Article)
Why Other Options Are Incorrect
Activation (A):
Activations send segments to external systems (e.g., Marketing Cloud) but do not directly depend on the data source itself. The dependency chain is Segment → Activation, not Data Source → Activation. Activation Target (D):
Activation targets (e.g., Marketing Cloud) are destinations and do not tie directly to the data source.
Steps to Disconnect a Data Source
Delete Dependent Segments:
Navigate to Data Cloud > Segments and remove any segments built using the data source.
Delete or Pause Data Streams:
Go to Data Cloud > Data Streams and delete streams linked to the data source.
Disconnect the Data Source:
Once dependencies are resolved, disconnect the source via Data Cloud > Data Sources.
Question #116
A company stores customer data in Marketing Cloud and uses the Marketing Cloud Connector to ingest data into Data Cloud.
Where does a request for data deletion or right to be forgotten get submitted?
- A . In Data Cloud settings
- B . On the individual data profile in Data Cloud
- C . In Marketing Cloud settings
- D . through Consent API
Correct Answer: C
C
Explanation:
Data Deletion Requests: For companies using Salesforce Marketing Cloud and Data Cloud, managing
data privacy and deletion requests is essential.
Marketing Cloud Connector: This connector facilitates data integration between Marketing Cloud and Data Cloud, but data deletion requests must follow specific procedures.
Deletion Requests in Marketing Cloud:
Data Management: Requests for data deletion or the right to be forgotten are submitted through Marketing Cloud settings, where the customer data is originally stored and managed.
Propagation: Once the request is processed in Marketing Cloud, the changes are propagated to Data Cloud through the connector.
Reference: Salesforce Marketing Cloud Documentation: Data Management Salesforce Data Cloud Connector Guide
C
Explanation:
Data Deletion Requests: For companies using Salesforce Marketing Cloud and Data Cloud, managing
data privacy and deletion requests is essential.
Marketing Cloud Connector: This connector facilitates data integration between Marketing Cloud and Data Cloud, but data deletion requests must follow specific procedures.
Deletion Requests in Marketing Cloud:
Data Management: Requests for data deletion or the right to be forgotten are submitted through Marketing Cloud settings, where the customer data is originally stored and managed.
Propagation: Once the request is processed in Marketing Cloud, the changes are propagated to Data Cloud through the connector.
Reference: Salesforce Marketing Cloud Documentation: Data Management Salesforce Data Cloud Connector Guide
Question #117
Which two steps should a consultant take if a successfully configured Amazon S3 data stream fails to refresh with a "NO FILE FOUND" error message? Choose 2 answers
- A . Check if correct permissions are configured for the Data Cloud user.
- B . Check if the Amazon S3 data source is enabled in Data Cloud Setup.
- C . Check If the file exists in the specified bucket location.
- D . Check if correct permissions are configured for the S3 user.
Correct Answer: A C
A C
Explanation:
: 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.
Reference: Create Amazon S3 Data Stream in Data Cloud, How to Use the Amazon S3 Storage Connector in Data Cloud, Amazon S3 Connection
A C
Explanation:
: 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.
Reference: Create Amazon S3 Data Stream in Data Cloud, How to Use the Amazon S3 Storage Connector in Data Cloud, Amazon S3 Connection
Question #118
What does the Ignore Empty Value option do in identity resolution?
- A . Ignores empty fields when running any custom match rules
- B . Ignores empty fields when running reconciliation rules
- C . Ignores Individual object records with empty fields when running identity resolution rules
- D . Ignores empty fields when running the standard match rules
Correct Answer: B
B
Explanation:
The Ignore Empty Value option in identity resolution allows customers to ignore empty fields when running reconciliation rules. Reconciliation rules are used to determine the final value of an attribute for a unified individual profile, based on the values from different sources. The Ignore Empty Value option can be set to true or false for each attribute in a reconciliation rule. If set to true, the reconciliation rule will skip any source that has an empty value for that attribute and move on to the next source in the priority order. If set to false, the reconciliation rule will consider any source that has an empty value for that attribute as a valid source and use it to populate the attribute value for the unified individual profile.
The other options are not correct descriptions of what the Ignore Empty Value option does in identity resolution. The Ignore Empty Value option does not affect the custom match rules or the standard match rules, which are used to identify and link individuals across different sources based on their attributes. The Ignore Empty Value option also does not ignore individual object records with empty fields when running identity resolution rules, as identity resolution rules operate on the attribute level, not the record level.
Reference: Data Cloud Identity Resolution Reconciliation Rule Input
Configure Identity Resolution Rulesets
Data and Identity in Data Cloud
B
Explanation:
The Ignore Empty Value option in identity resolution allows customers to ignore empty fields when running reconciliation rules. Reconciliation rules are used to determine the final value of an attribute for a unified individual profile, based on the values from different sources. The Ignore Empty Value option can be set to true or false for each attribute in a reconciliation rule. If set to true, the reconciliation rule will skip any source that has an empty value for that attribute and move on to the next source in the priority order. If set to false, the reconciliation rule will consider any source that has an empty value for that attribute as a valid source and use it to populate the attribute value for the unified individual profile.
The other options are not correct descriptions of what the Ignore Empty Value option does in identity resolution. The Ignore Empty Value option does not affect the custom match rules or the standard match rules, which are used to identify and link individuals across different sources based on their attributes. The Ignore Empty Value option also does not ignore individual object records with empty fields when running identity resolution rules, as identity resolution rules operate on the attribute level, not the record level.
Reference: Data Cloud Identity Resolution Reconciliation Rule Input
Configure Identity Resolution Rulesets
Data and Identity in Data Cloud
Question #119
A consultant is integrating an Amazon 53 activated campaign with the customer’s destination system.
In order for the destination system to find the metadata about the segment, which file on the 53 will contain this information for processing?
- A . The .txt file
- B . The json file
- C . The .csv file
- D . The .zip file
Correct Answer: B
B
Explanation:
The file on the Amazon S3 that will contain the metadata about the segment for processing is B. The json file. The json file is a metadata file that is generated along with the csv file when a segment is activated to Amazon S3. The json file contains information such as the segment name, the segment ID, the segment size, the segment attributes, the segment filters, and the segment schedule. The destination system can use this file to identify the segment and its properties, and to match the segment data with the corresponding fields in the destination system.
Reference: Salesforce Data Cloud Consultant Exam Guide, Amazon S3 Activation
B
Explanation:
The file on the Amazon S3 that will contain the metadata about the segment for processing is B. The json file. The json file is a metadata file that is generated along with the csv file when a segment is activated to Amazon S3. The json file contains information such as the segment name, the segment ID, the segment size, the segment attributes, the segment filters, and the segment schedule. The destination system can use this file to identify the segment and its properties, and to match the segment data with the corresponding fields in the destination system.
Reference: Salesforce Data Cloud Consultant Exam Guide, Amazon S3 Activation
Question #120
Cumulus Financial needs to create a composite key on an incoming data source that combines the fields Customer Region and Customer Identifier.
Which formula function should a consultant use to create a composite key when a primary key is not
available in a data stream?
- A . CONCAT
- B . COMBIN
- C . COALE
- D . CAST
Correct Answer: A
A
Explanation:
Composite Keys in Data Streams: When working with data streams in Salesforce Data Cloud, there may be situations where a primary key is not available. In such cases, creating a composite key from multiple fields ensures unique identification of records.
Formula Functions: Salesforce provides several formula functions to manipulate and combine data fields. Among them, the CONCAT function is used to combine multiple strings into one.
Creating Composite Keys: To create a composite key using CONCAT, a consultant can combine the values of Customer Region and Customer Identifier into a single unique identifier. Example Formula: CONCAT(Customer_Region, Customer_Identifier)
Reference: Salesforce Documentation: Formula Functions
Salesforce Data Cloud Guide
A
Explanation:
Composite Keys in Data Streams: When working with data streams in Salesforce Data Cloud, there may be situations where a primary key is not available. In such cases, creating a composite key from multiple fields ensures unique identification of records.
Formula Functions: Salesforce provides several formula functions to manipulate and combine data fields. Among them, the CONCAT function is used to combine multiple strings into one.
Creating Composite Keys: To create a composite key using CONCAT, a consultant can combine the values of Customer Region and Customer Identifier into a single unique identifier. Example Formula: CONCAT(Customer_Region, Customer_Identifier)
Reference: Salesforce Documentation: Formula Functions
Salesforce Data Cloud Guide