Data 360 Consultant Practice Test 4 — 25 Questions

Question 1

A consultant needs to create a segment that includes customers who have purchased a product from the 'Electronics' category and also purchased a product from the 'Apparel' category, but these purchases must have occurred within the same calendar month. The purchase data is stored in a single data stream with fields for CustomerId, ProductCategory, and PurchaseDate. How should the consultant model the segment criteria to achieve this?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Use a Calculated Insight to aggregate purchases by month and category, then filter on the CI output.. To enforce that two purchases from different categories occur in the same calendar month, you need to aggregate purchase data at the customer-month level. A Calculated Insight can perform this aggregation, creating a metric that indicates whether both categories were purchased in the same month. The segment can then filter on that metric. This is the correct approach because standard segment filters cannot easily correlate multiple records with temporal constraints.

Answer

Create a segment with a nested container that uses the 'within' operator on PurchaseDate for each category filter.

Answer

Create two separate filters on the purchase data stream for each category and combine them with an AND, ensuring the PurchaseDate falls within the same month.

Answer

Use a single filter on the purchase data stream with conditions for both categories and a date range for the current month.

Question 2

An administrator is setting up a Salesforce CRM data stream and notices that certain custom objects created in CRM are not available to select in the CRM connector bundle wizard. What is the reason?

Accepted Answer

Custom objects must be ingested using individual custom Salesforce CRM data streams if they are not included in the standard CRM bundles.. Custom objects in CRM must have specific properties (such as being queried via API or included in change data capture / enabled for reporting/streaming) or custom objects can be added via custom data streams if not part of the standard CRM bundles.

Answer

Custom objects are automatically blocked from Data Cloud by Salesforce security baselines.

Answer

Custom objects must be converted to standard objects in Object Manager before streaming.

Answer

The administrator must first write an Apex SOAP web service to expose custom objects to Data Cloud.

Question 3

An organization has configured a Data Action that triggers a Salesforce Flow whenever a high-value purchase event is ingested. The flow fails intermittently with a concurrency error. What is the underlying reason for this behavior in Data Cloud?

Accepted Answer

High-volume streaming events from Data Cloud are triggering simultaneous Flow transactions in Salesforce Core, exceeding concurrency limits.. Data Actions trigger real-time asynchronous or synchronous events in external systems or Core CRM. High-volume streaming data can cause high concurrency on Flow execution in Core, leading to locking or concurrency limits.

Answer

The Connected App has exceeded its daily API call allocation.

Answer

Data Cloud batch jobs are conflicting with real-time segment activation schedules.

Answer

The Identity Resolution ruleset is re-matching profiles while the flow runs.

Question 4

What is the primary purpose of an Activation Target in Data Cloud?

Accepted Answer

To store the authentication and destination configuration details for an external platform receiving activations.. An activation target stores the authentication, destination, and configuration details required to connect Data Cloud to an external platform or destination.

Answer

To define the demographic criteria used to build audience segments.

Answer

To ingest raw data files from an external cloud storage bucket.

Answer

To merge duplicate customer profiles into a single unified record.

Question 5

A retail organization wants to push segment membership data to Google Cloud Storage on a nightly basis. Which type of Activation Target should the consultant create?

Accepted Answer

Cloud File Storage Activation Target. Cloud File Storage activation targets, such as Amazon S3, Google Cloud Storage, or Azure Blob Storage, allow organizations to export batch segments to file storage systems.

Answer

Data Action Target

Answer

Ad Platform Activation Target

Answer

Marketing Cloud Activation Target

Question 6

An enterprise customer has configured a data stream from an external transactional database. After running the data stream, the consultant notices that records containing special characters are failing ingestion due to encoding mismatches. Where should the consultant verify or adjust the encoding settings?

Accepted Answer

In the Data Stream configuration settings where file format and character encoding are defined.. When creating a data stream from cloud storage or external connectors, specifying the correct file encoding (such as UTF-8) is critical to prevent ingestion parsing errors.

Answer

In the Activation Target authentication parameters.

Answer

In the Identity Resolution reconciliation ruleset.

Answer

In the Salesforce CRM Company Information settings.

Question 7

An enterprise customer using Data Cloud wants to calculate the total lifetime value (LTV) of a customer using a complex SQL query that joins multiple Data Model Objects (Individual, Order__c, and Invoice__c). Which feature should the consultant use to build this metric?

Accepted Answer

Calculated Insights. Calculated Insights in Data Cloud are purpose-built for computing aggregate metrics (sums, counts, averages, complex joins) across DMOs and storing the results as a Calculated Insight DMO that can be used in segments, activations, and personalization. A complex SQL query joining Individual, Order__c, and Invoice__c to compute lifetime value is exactly the Calculated Insight use case. The resulting metric is materialized and refreshed on a schedule, making it queryable at scale.

Answer

Identity Resolution Ruleset

Answer

Data Model Mapping

Answer

Segmentation Builder

Question 8

What is required before you can create an activation in Data Cloud?

Accepted Answer

An active Segment and a configured Activation Target. An activation requires both an existing segment and a configured activation target.

Answer

A Marketing Cloud account with Journey Builder enabled

Answer

An active Tableau dashboard connection

Answer

A custom Apex trigger on the Individual object

Question 9

An administrator is setting up an AWS S3 data stream and receives an error indicating that Salesforce Data Cloud cannot assume the IAM role provided. What is the most likely misconfiguration in AWS?

Accepted Answer

The IAM trust policy (assume role policy) does not correctly specify the Salesforce AWS account ID and external ID.. Cross-account access between Salesforce Data Cloud and AWS S3 requires configuring an IAM role with a trust relationship (assume role policy) that specifies Salesforce's AWS account ID and external ID.

Answer

The Salesforce Data Cloud connector user password has expired in AWS IAM.

Answer

The S3 bucket policy lacks a public read statement for all IP addresses.

Answer

The AWS S3 bucket is encrypted using AES-128 instead of AES-256.

Question 10

An administrator notices that after adding a new Contact Point Phone match rule to an existing identity resolution ruleset, the number of unified profiles decreased drastically. What is the underlying reason for this?

Accepted Answer

The new match rule introduced broad matching criteria that bridged separate customer clusters together, causing over-merging.. Adding a new match rule with broad criteria (such as phone numbers shared among family members) can cause previously separate clusters to bridge together, resulting in a dramatic drop in unified profile counts (over-merging).

Answer

Reconciliation rules overrode the match rules and deleted conflicting profiles.

Answer

The Contact Point Phone DMO failed to map correctly, causing all phone data to be ignored.

Answer

Data Cloud automatically purges historical profiles whenever a match rule is edited.

Question 11

Which THREE key responsibilities does a Data Cloud consultant have when designing the data ingestion and modeling strategy? (Choose THREE)

Accepted Answer

Establish object relationships and cardinality to support downstream segmentation.. Consultants must identify source systems and choose appropriate ingestion methods, design scalable data model objects adhering to the CIM, and establish correct relationships between DMOs.

Answer

Manually configure HTML email templates in Marketing Cloud Engagement.

Answer

Write Apex triggers to manage database indexing on external ERP systems.

Question 12

An administrator is configuring a Google Cloud Storage batch data stream. The data stream runs successfully, but zero records are ingested, and the error log indicates a file permission denial. What must the administrator check in Google Cloud?

Accepted Answer

Verify that the Salesforce service account has correct IAM read permissions on the Google Cloud storage bucket.. Cloud storage integration requires granting appropriate read permissions (IAM roles and service account access) to the Salesforce Data Cloud service principal.

Answer

Check that the Google Cloud storage bucket has public internet access enabled for all IP addresses.

Answer

Rewrite all filenames to remove uppercase letters.

Answer

Switch the ingestion format from CSV to XML.

Question 13

Which Salesforce product icon or menu item leads administrators to the Data Cloud setup and configuration landing page?

Accepted Answer

Data Cloud Setup in Salesforce CRM Setup menu. In Salesforce CRM Setup, administrators can search for 'Data Cloud Setup' to access the core administration landing page.

Answer

Tableau Server connection manager

Answer

Marketing Cloud Engagement administration panel

Answer

Heroku dashboard settings

Question 14

An administrator is configuring data streams from an Amazon S3 bucket. Which THREE requirements must be met for successful data ingestion? (Choose three.)

Accepted Answer

The data stream configuration must specify the correct file path prefix and naming convention.. AWS S3 integration requires proper bucket permissions, correct file formats (CSV, JSON, Parquet), and valid connector configuration in Data Cloud.

Answer

The S3 bucket must be configured with public read-write access for all external IP addresses.

Answer

Every CSV file must include an Apex trigger definition in the header row.

Question 15

Which TWO key components are required when defining a batch data stream from Google Cloud Storage? (Choose TWO)

Accepted Answer

The source bucket path and file format specifications (e.g., CSV, delimiter).. Configuring a GCS data stream requires authenticating with cloud storage credentials (or IAM) and specifying the file location/bucket path along with file format settings.

Answer

An active Apex trigger class deployed in Google Cloud.

Answer

A pre-built Marketing Cloud journey canvas.

Answer

A physical SFTP server bridge.

Question 16

Where do administrators configure and manage Identity Resolution rulesets in Data Cloud?

Accepted Answer

Data Cloud Setup > Data Manager > Identity Resolution. Identity resolution is configured under the Data Manager section in Data Cloud.

Answer

Data Cloud Setup > Data Spaces > Rulesets

Answer

Setup > Security > Identity Providers

Answer

Setup > Identity > Match Rules

Question 17

When designing a segment, a consultant wants to see an estimate of the audience size before publishing. Where can this estimated count be viewed?

Accepted Answer

Estimated profile counts are displayed directly on the Segment Canvas as criteria are configured.. The Segment Canvas provides estimated profile counts as criteria are added and modified.

Answer

Estimates are only available after the segment has finished its first full publish.

Answer

In the Data Cloud Home dashboard metrics widget.

Answer

In the activation summary report after export.

Question 18

When configuring a new segment, what is the significance of selecting the 'Individual' DMO as the primary profile object?

Accepted Answer

It ensures the segment evaluates unified customer profiles rather than unmerged source records.. The Individual DMO represents the unified customer profile resulting from Identity Resolution, serving as the central anchor for customer-centric segmentation.

Answer

It automatically converts the segment into a real-time streaming segment.

Answer

It restricts the segment from being used in activations.

Answer

It bypasses the need for Calculated Insights.

Question 19

A Data Cloud Consultant is asked to set up an activation that targets specific contacts who have abandoned a shopping cart within the last 2 hours. Which activation approach best fits this requirement?

Accepted Answer

Configure a streaming Data Action targeting a webhook that triggers a real-time abandoned cart message.. A streaming Data Action targeting a webhook is designed for real-time, event-driven activation, which is required to reach contacts within minutes of cart abandonment. It can trigger an immediate outbound message via the webhook as soon as the qualifying event is ingested, meeting the 2-hour window.

Answer

Schedule an hourly Calculated Insight batch job.

Answer

Export daily SFTP files to an external email service provider.

Answer

Create a batch segment with a 24-hour refresh schedule activated to Marketing Cloud.

Question 20

Which TWO statements are true regarding the relationship between Individual DMOs and Unified Individual DMOs? Choose 2 options.

Accepted Answer

Source individual records are mapped into the Individual DMO.. Source individual records map to the Individual DMO, and identity resolution links multiple source individuals into a single Unified Individual DMO.

Answer

Unified Individual profiles are stored directly in core Salesforce CRM user tables.

Answer

The Individual DMO is populated directly by activation targets.

Answer

The Individual DMO cannot be used in identity resolution rulesets.