Salesforce Certified Data Cloud Consultant Free Sample Questions

20 free sample questions242 in the full practice test

Try simulator

certified-data-cloud-consultant Sample Questions

  1. Question 1

    A financial services firm is ingesting sensitive customer data from an on-premise data warehouse into Data Cloud via the MuleSoft Anypoint Connector. A requirement is to mask the middle digits of all Social Security Number (SSN) fields during ingestion before the data is stored in a Data Lake Object (DLO). Which Data Cloud feature is the most efficient and secure tool for this transformation?

    Answer and explanation

    Correct answer: C

    Batch Data Transforms are designed for complex, large-scale transformations on data at rest after it has landed in the DLO. Using a Library function allows for reusable, complex logic like PII masking to be defined once and applied across multiple transforms, which is efficient and maintainable. Calculated Insights operate on DMOs, not DLOs during ingestion. Streaming Data Transformations act on data in-flight but are more suited for real-time event data, not large batch loads from a data warehouse. Formula fields on the DMO are applied after ingestion and do not mask the raw data in the DLO.

  2. Question 2

    Multiple answers

    An e-commerce company wants to create a segment of 'High-Intent Shoppers' who have viewed a product more than three times in the last 24 hours but have not made a purchase in the last 7 days. This segment needs to be updated in near real-time to trigger cart abandonment journeys. Which combination of features should be used? (Select TWO)

    Answer and explanation

    Correct answers: B, C

    Streaming Insights are designed to process and aggregate data from real-time event streams (like website clicks) over a rolling time window, which is perfect for the 'viewed more than three times in 24 hours' criteria. This allows the segment to be updated in near real-time.

    After the Streaming Insight identifies the high-intent behavior, a standard segment is used to combine this insight with other criteria, such as filtering out customers who have made a purchase in the last 7 days. The segment builder brings together both real-time and historical data for precise targeting.

  3. Question 3

    A consultant is designing the data model for a subscription-based media company. They have two primary Data Lake Objects: Subscription_Events_c (containing start, stop, renewal events) and User_Profiles_c (containing user details). The goal is to create a UnifiedSubscription_c Data Model Object that links each user to their current subscription status. What is the correct relationship configuration to achieve this?

    Answer and explanation

    Correct answer: B

    The correct data model is to have the Individual DMO (representing the unified customer profile) as the 'one' side and the UnifiedSubscription_c DMO as the 'many' side. This allows a single unified individual to have multiple subscription events over time (e.g., a past subscription and a current one), which accurately reflects the business reality. The relationship is established by mapping a field in UnifiedSubscription_c (like User_Id__c) to the Individual DMO.

  4. Question 4

    A travel agency, 'Global Voyages,' has activated a segment of 'Platinum Members' to Marketing Cloud Engagement. The activation includes a related attribute for the member's 'Next Upcoming Trip Destination' from a custom DMO. A journey in Marketing Cloud is designed to send destination-specific content. However, marketers report that the 'Next Upcoming Trip Destination' field is often blank in the resulting data extension, even for members who have upcoming trips. What is the most likely cause of this issue?

    Answer and explanation

    Correct answer: D

    When activating a related attribute from a one-to-many relationship (one individual can have many trips), Data Cloud must be told how to select a single record if multiple exist. If this isn't configured, it may arbitrarily select one. If that selected record has a null value for the destination, the activated attribute will be blank. The consultant should edit the activation to add criteria for selecting the related attribute, such as 'Choose the record with the earliest upcoming trip date' and 'where Destination is not null'.

  5. Question 5

    A university uses Data Cloud to unify student data from its Student Information System (SIS), Learning Management System (LMS), and alumni portal. The identity resolution ruleset is configured as follows:

    1. Match Rule 1: Exact Match on Student ID (High Confidence)
    2. Match Rule 2: Fuzzy First Name, Fuzzy Last Name, and Exact Date of Birth (Medium Confidence)
    3. Reconciliation Rule: For the 'Status' field (e.g., 'Current Student', 'Alumni'), prioritize the SIS source, then the LMS, then the alumni portal.

    A profile from the alumni portal matches a profile from the SIS on Rule 2. What will the 'Status' of the resulting Unified Individual be?

    Answer and explanation

    Correct answer: B

    Reconciliation rules determine which source system's value to use for a specific field when multiple source profiles are merged into a Unified Individual. In this case, the rule explicitly states to prioritize the SIS source for the 'Status' field. Even though the match occurred between the alumni portal and SIS, the reconciliation rule for the 'Status' field dictates that the value from the SIS will be the winner and populated on the unified profile.

  6. Question 6

    True or False: Once a segment has been created and activated in Data Cloud, its criteria cannot be modified. A new segment must be created if changes are needed.

    Answer and explanation

    Correct answer: B

    False. Segment criteria can be edited after creation and activation. When you edit and republish a segment, Data Cloud re-evaluates its membership based on the new criteria during its next scheduled or manual refresh. This allows for dynamic and iterative refinement of audiences without needing to create new segments and reconfigure activations.

  7. Question 7

    A consultant is using the Ingestion API to stream website engagement events into Data Cloud. The payload for each event includes a page_url field. The requirement is to categorize each event into 'Product Page', 'Category Page', or 'Homepage' based on the URL structure. This categorization needs to happen as the data is ingested to allow for real-time segmentation. What is the most appropriate feature to use?

    Answer and explanation

    Correct answer: B

    Streaming Data Transformations are specifically designed to perform transformations on data ingested in near real-time via the Ingestion API before it's written to a Data Lake Object. They are ideal for use cases like classifying or cleansing event data in-flight. A Batch Data Transform runs on a schedule against data already at rest. A Calculated Insight operates on DMOs, not during ingestion. A formula field on the DMO also processes data after it has already landed.

  8. Question 8

    Multiple answers

    A consultant needs to create a segment that includes all individuals who have an 'Open' service case and also have a Customer Lifetime Value (CLV) greater than $5,000. The CLV is not a standard field and must be calculated by summing the total value of all past orders for each individual. Which steps must be performed to enable the creation of this segment? (Select THREE)

    Answer and explanation

    Correct answers: B, C, D

    Data must be modeled in DMOs before it can be used in Calculated Insights or Segmentation. Both Case and Order data need their own DMOs, and they must be related back to the Individual DMO to link them to a unified customer profile.

    Calculated Insights are used to perform aggregations like summing up order values to compute the CLV. This insight is created on the Individual DMO, allowing the CLV to be an attribute of the unified profile.

    Once the data is modeled and the CLV is calculated, the segment can be built. It targets the Individual DMO and uses direct attributes (from the Calculated Insight) and related attributes (from the linked Case DMO) to define the audience.

  9. Question 9

    A business user is building a segment and wants to include customers whose last website visit was within the past 30 days. They add a filter on the WebVisit DMO and set the VisitDate attribute with the operator 'Is In Last' and a value of '30 Days'. However, the segment count is zero, despite knowing that recent web visits have been ingested. What is the most likely reason for this issue?

    Answer and explanation

    Correct answer: C

    For time-based segmentation operators like 'Is In Last' to function correctly, the date field being used (VisitDate) must be designated as the 'Event Time' field in the DMO's properties. If this is not set, Data Cloud does not know which field represents the timestamp of the event, and time-windowed filters will not work as expected, often resulting in a count of zero.

  10. Question 10

    A marketing team wants to send a real-time welcome message via a Marketing Cloud journey to any new loyalty program members as soon as they sign up. The sign-up event is captured via the Data Cloud Ingestion API. Which Data Cloud feature should be configured to listen for this event and immediately trigger the journey?

    Answer and explanation

    Correct answer: C

    Data Actions are designed to trigger processes in target systems based on real-time events or streaming insight rules. By creating a Data Action that listens for the 'Loyalty Sign-up' event and targets a Marketing Cloud Journey Entry Event, the welcome message can be sent in near real-time. Standard segment activations are batch-based and would not meet the immediacy requirement.

Register free to unlock 10 more sample questions

Lifetime One

Own this practice test forever.

$79.99
$75.99
one-time
  • Full access to 242 questions
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • Brainy AI Assistant
  • Lifetime updates

Two

Any 2 exams per month.

$20.00/exam
$39.99
/month
  • 2 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 1,000 Brainy AI Credits
  • Cancel anytime

Premium Twelve

Any 12 exams over 3 months.

$15.00/exam
$179.99
/3 months
  • 4 active exam slots
  • Study, Timed & Flashcard Modes
  • All past and future versions i
  • Detailed Explanations
  • Study Tracking & Past Attempts
  • 15,000 Brainy AI Credits
  • Dedicated support
  • Friend seat included — full access

Trusted by professionals at

NvidiaSupabaseGitHubOpenAITursoClerkClaude AIAmazon