Data 360 Consultant Timed Hard Questions — 25 Difficult Questions

Question 1

An administrator has configured a Marketing Cloud connector in Data Cloud. However, data streams are failing to initialize because the connected user lacks permissions. Which configuration error most likely occurred?

15 minute time limit — choose an answer to begin.

Accepted Answer

The Marketing Cloud connector user lacks API Integration and Data View permissions.. Connecting Marketing Cloud requires the Marketing Cloud connector user to have specific API and data view permissions enabled in Marketing Cloud before establishing the connection in Data Cloud Setup.

Answer

The connected user was not assigned the Data Cloud Admin permission set in Salesforce CRM.

Answer

The Marketing Cloud tenant URL was entered using HTTP instead of HTTPS.

Answer

The Marketing Cloud Business Unit was not mapped to a Data Space.

Question 2

An enterprise ingests orders from three separate e-commerce platforms. Each platform uses a different currency (USD, EUR, GBP). To aggregate total purchase value accurately in Calculated Insights, what must the consultant do during the harmonization and modeling stage?

Accepted Answer

Ensure both the monetary amount and currency ISO code are mapped to standard DMO attributes to enable currency normalization.. To aggregate multi-currency values, consultants must ingest the currency ISO code along with the amount, map them to standard DMO attributes, or normalize currencies into a common base currency using conversion rates.

Answer

Reject orders not denominated in USD during the S3 batch file upload.

Answer

Store all monetary amounts as text strings and let SQL queries perform manual string stripping.

Answer

Hardcode an exchange rate multiplier in an Apex trigger during ingestion.

Question 3

An organization requires that audience segment data exported to a cloud storage activation target be encrypted at rest using a customer-managed encryption key (CMES). How is this requirement satisfied in Data Cloud?

Accepted Answer

By configuring Customer-Managed Encryption Keys (BYOK) using Salesforce Shield and cloud provider key management services.. Customer-managed encryption keys (CMEK/BYOK) in Data Cloud are implemented through Salesforce Shield's Customer-Managed Encryption Keys feature, integrated with the cloud provider's key management service (e.g., AWS KMS, Google Cloud KMS). This allows the organization to control the encryption keys used for data at rest, satisfying the requirement for customer-managed encryption on exported audience data.

Answer

By setting an activation attribute flag for encryption.

Answer

By writing a custom encryption script in a Data Transform before export.

Answer

By enabling HTTPS TLS 1.3 on the activation target connection string.

Question 4

An administrator has set up identity resolution with match rules based on Email and Phone Number. After running the ruleset, they notice that records with different spelling variations of names were not merged despite sharing the same email. What is the correct way to incorporate name matching into the identity resolution process?

Accepted Answer

Add a fuzzy match rule for Party Identification or Name to the existing Identity Resolution ruleset.. To incorporate name matching, a fuzzy match rule for Party Identification or Name must be added to the identity resolution ruleset. Fuzzy matching handles spelling variations and typos, enabling records with similar names to be considered matches even if exact match rules on email or phone fail.

Answer

Export the data to Tableau, merge the profiles, and re-import via API.

Answer

Modify the Data Model Object primary key to be a composite name key.

Answer

Write an Apex trigger to normalize names prior to data stream ingestion.

Question 5

A Data Cloud Consultant is configuring Identity Resolution to unify disparate customer records from multiple source systems into a single golden record. Which TWO actions must the consultant perform during this configuration? (Choose two.)

Accepted Answer

Configure Reconciliation Rules to determine survivorship rules for unified profile attributes.. Identity Resolution in Data Cloud requires two core configuration steps: defining Match Rules (option E) to specify the criteria—such as exact or fuzzy matching on email address, phone number, or other attributes—that determine when source records from different systems are considered the same individual, and configuring Reconciliation Rules (option D) to establish survivorship logic that decides which source value wins for each unified profile attribute when matched records conflict. These two rule sets are the essential building blocks of a ruleset that produces the unified golden profile. Option A is incorrect because Data Cloud Identity Resolution does not rely on manual database constraints in the underlying Data Lake Object storage; matching is handled declaratively through rulesets. Option B is incorrect because a batch SOQL query via Data Loader is a data extraction technique, not a configuration action for Identity Resolution, and merged profiles are surfaced through Data Cloud, not exported via SOQL. Option C is incorrect because a custom Apex trigger merging duplicates in Sales Cloud operates outside Data Cloud and does not participate in Data Cloud Identity Resolution configuration.

Answer

Create manual database constraints in the underlying Data Lake Object storage.

Answer

Execute a batch SOQL query via Data Loader to export merged profiles.

Answer

Write a custom Apex trigger to merge duplicate contact records in Sales Cloud.

Question 6

A consultant is troubleshooting an identity resolution implementation where multiple source records from an e-commerce platform are failing to merge with CRM records despite having matching email addresses. Upon investigation, what is the most likely cause?

Accepted Answer

The e-commerce email field was mapped to a custom attribute instead of the standard Contact Point Email DMO with proper primary key/foreign key relationships.. If matching fails despite matching data, checking data mapping, data space segregation, or normalization discrepancies is crucial. Specifically, unmapped email fields or mapping to the wrong Contact Point Email type will prevent matching.

Answer

Reconciliation rules were set to Most Recent instead of Source Sequence.

Answer

Data Cloud requires manual SQL triggers to activate e-commerce data streams.

Answer

The Unified Individual DMO is missing an activation target assignment.

Question 7

An administrator observes that after adding a new Fuzzy Email match rule to an existing ruleset, the Identity Resolution batch job fails with a system memory/timeout exception. What is the most appropriate troubleshooting step?

Accepted Answer

Remove or refine the newly added fuzzy match rule to reduce computational complexity and prevent Cartesian explosion during matching.. Fuzzy email matching on massive datasets without proper scoping can cause performance bottlenecks. Reviewing and refining match criteria or breaking down large rulesets is necessary.

Answer

Increase data stream ingestion frequency from hourly to real-time.

Answer

Restart the core Salesforce CRM production server.

Answer

Switch the reconciliation rule to Highest Frequency.

Question 8

A consultant creates a custom Data Model Object (DMO) in Data Cloud and attempts to relate it to the standard Individual DMO. The relationship creation fails. What is the most likely reason?

Accepted Answer

The foreign key in the custom DMO does not match the data type and length of the target primary key in the Individual DMO.. Relationships between DMOs require specific cardinality configurations (e.g., 1-to-1, 1-to-many, many-to-many) and must link compatible primary and foreign keys with matching data types.

Answer

The Individual DMO is locked and does not accept outgoing foreign key relationships.

Answer

Custom DMOs cannot have relationships with standard DMOs under any circumstances.

Answer

Standard DMO relationships can only be established using SQL queries in Calculated Insights.

Question 9

An administrator is troubleshooting a failing Salesforce CRM data stream. Which THREE diagnostic steps or checks should the administrator perform in Salesforce Data Cloud? (Choose three.)

Accepted Answer

Verify that the Salesforce CRM connector bundle was successfully deployed and activated.. Troubleshooting CRM data streams involves checking stream run history, connector status, and data model mappings.

Answer

Check the core CRM Apex code coverage for all triggers in the organization.

Answer

Verify that all Data Model Objects have been converted to custom Salesforce objects in Object Manager.

Question 10

A multinational company needs segments to evaluate rules based on local time zones rather than UTC. How should the consultant configure date-based segment criteria to account for time zone differences?

Accepted Answer

Use relative date filters or calculated insights that normalize timestamps to local time before evaluation.. When evaluating date/time attributes in segments, understanding how Data Cloud stores timestamps in UTC and configuring appropriate relative date filters is crucial.

Answer

Configure Activation Targets to automatically shift timestamps by the recipient's UTC offset.

Answer

Modify the Data Lake Object primary key data type from Timestamp to Text.

Answer

Change the Data Cloud instance timezone setting in Setup.

Question 11

A Data Cloud Consultant is building a Calculated Insight using ANSI SQL to calculate the average order value (AOV) per customer. When attempting to save the Calculated Insight, the system throws a validation error regarding the dimensions. What is the most likely cause of this error?

Accepted Answer

The query includes a dimension that is not part of the Profile DMO space or properly related via a foreign key.. Calculated Insights require dimensions to be mapped correctly using primary and foreign keys from the Data Model, and mixing unaggregated non-measure fields without proper GROUP BY clauses will cause validation failures.

Answer

Calculated Insights only support Standard SQL and do not permit aggregate functions like AVG().

Answer

The AOV result is stored as a text field instead of a numerical measure.

Answer

The query references a streaming data model object directly without a time window.

Question 12

A user in Sales Cloud wants to see Data Cloud insights (like calculated insights) directly on the Account record page. Which tool should the consultant use to enable this?

Accepted Answer

Data Cloud Related List Component. The Data Cloud Related List component allows administrators to surface Data Cloud insights directly in the Salesforce CRM UI.

Answer

Custom API calls

Answer

Visualforce Page

Answer

Salesforce Flow

Question 13

A consultant notices that after modifying an identity resolution ruleset's match rules, the Unified Individual counts and links did not update immediately. What is the correct explanation for this behavior?

Accepted Answer

Identity resolution rulesets require a manual run or scheduled execution to re-process records after rule modifications.. Identity resolution in Data Cloud does not automatically re-run when match rules are modified. The ruleset must be manually executed or scheduled to re-process existing records and update Unified Individual links and counts. Until that run occurs, the previously computed unified profiles remain unchanged, which explains why the consultant saw no immediate update.

Answer

The data space must be deleted and re-provisioned for rule changes to take effect.

Answer

Match rule changes only apply to newly ingested data and cannot re-evaluate historical profiles.

Answer

Unified profiles are cached for exactly 30 days and cannot be cleared manually.

Question 14

A consultant creates a segment using a related Engagement Data Model Object (DMO). The segment size is significantly smaller than expected. Upon troubleshooting, the consultant discovers that many records lack a foreign key relationship to the Unified Individual DMO. What architectural mechanism caused this discrepancy?

Accepted Answer

Unresolved identity links or missing foreign key mappings between the engagement DMO and Unified Individual.. Data must be properly mapped through Identity Resolution and relationships to the Unified Individual DMO for related engagement data to link correctly to unified profiles.

Answer

Calculated Insights stripped out historical records older than 90 days.

Answer

Batch segmentation only processes the first 10 million records by default.

Answer

Streaming segments overwrite batch segment membership automatically.

Question 15

A consultant is setting up a data stream from an external database via Amazon S3. The source system generates CSV files with custom delimiters (pipes `|` instead of commas `,`). How should the consultant configure this in Data Cloud?

Accepted Answer

Specify the pipe delimiter (`|`) in the file format configuration settings during data stream creation.. During the S3 data stream creation wizard, Data Cloud allows administrators to specify custom delimiters (such as pipes, tabs, or semicolons) for CSV file parsing.

Answer

Write an Apex transformation class to replace pipes with commas.

Answer

Rename the file extension from `.csv` to `.pipe` so Data Cloud auto-detects it.

Answer

Convert all files to JSON because CSV does not support custom delimiters.

Question 16

An administrator has provisioned Data Cloud in a Sandbox org for testing. After refreshing the Sandbox, the administrator notices that the Data Cloud connection is broken and data streams are failing. What is the expected behavior of Data Cloud in Salesforce Sandboxes?

Accepted Answer

Data Cloud is not provisioned by default in refreshed sandboxes and requires reprovisioning or re-establishing connections.. Data Cloud is not fully supported or automatically preserved across standard sandbox refreshes in the same manner as core CRM configuration, often requiring reprovisioning or special handling.

Answer

Data Cloud configuration is fully preserved and requires no manual intervention after a sandbox refresh.

Answer

Data Cloud data streams automatically switch to mock test data after a sandbox refresh.

Answer

Sandbox refreshes automatically clone all data lakes and S3 buckets linked to Data Cloud.

Question 17

An activation publishing job fails repeatedly with a timeout error when attempting to connect to a custom REST webhook Data Action Target. What is the most robust troubleshooting step?

Accepted Answer

Verify the external endpoint's server performance, response latency, and ensure it acknowledges payloads quickly to prevent gateway timeout.. A timeout error when connecting to a custom REST webhook typically indicates the external endpoint is slow to respond or does not acknowledge the payload quickly. Verifying server performance, response latency, and ensuring fast acknowledgment is the most robust troubleshooting step to resolve gateway timeouts.

Answer

Recreate the Identity Resolution ruleset to clear transaction locks.

Answer

Increase the Data Cloud activation target chunk size to 1 million records per request.

Answer

Switch the activation target type from webhook to cloud storage.

Question 18

When configuring a streaming segment in Data Cloud, which THREE limitations or considerations must a consultant keep in mind? Choose 3 options.

Accepted Answer

Streaming segments have limitations on complex multi-object joins and certain SQL operators compared to batch segments.. Option A is correct because streaming segments in Data Cloud are evaluated incrementally against incoming events, so they do not support the full range of complex multi-object joins and SQL operators that batch segments can use, which is a key design limitation consultants must account for. Option C is correct because the defining behavior of a streaming segment is that it continuously evaluates data as it arrives, so audience membership is updated automatically when qualifying data changes occur, rather than waiting for a scheduled batch run. Option E is correct because streaming segmentation depends on the underlying Data Lake Objects and their Data Streams being configured with streaming enabled; without that ingestion path, the segment cannot receive the near-real-time events it needs to evaluate. Option B is not correct because a 24-hour refresh restriction describes batch-style scheduling, not streaming segments, which are designed for near-real-time updates. Option D is not correct because streaming segments can be activated to multiple targets, not exclusively Marketing Cloud Engagement.

Answer

Streaming segments are restricted to a maximum refresh frequency of once every 24 hours.

Answer

Streaming segments can only be published to Marketing Cloud Engagement and no other targets.

Question 19

A financial services organization is leveraging Salesforce Data Cloud and requires that queries executed by Marketing Cloud against Data Cloud data models do not incur heavy compute latency or duplicate storage overhead. The tables reside in Snowflake. Which feature should the consultant implement?

Accepted Answer

Zero Copy Query Federation with Snowflake. Snowflake Zero Copy Share or Snowflake Direct Share allows Data Cloud to query Snowflake data directly without duplicating the storage or running heavy ETL batch pipelines, leveraging Zero Copy architecture.

Answer

Standard Data Stream bundle with scheduled syncs

Answer

Ingestion API push streaming

Answer

Amazon S3 Cloud File Storage batch connector

Question 20

An administrator has configured a Calculated Insight that aggregates customer purchase totals. However, when users try to use this Calculated Insight in a segment, the insight is unavailable. What is the most likely administrative oversight?

Accepted Answer

The Calculated Insight has not been successfully published or built, or lacks the necessary object relationships for segmentation.. Calculated insights must be published and associated with the correct Data Space and object relationships to be available in segmentation.

Answer

The Calculated Insight must be exported to Amazon S3 before it can be used in segments.

Answer

The user lacks the 'View Setup and Configuration' permission in core CRM.

Answer

Calculated insights cannot be used in segments; only Data Model Objects can be used.