Data 360 Consultant Practice Test 5 — 25 Questions

Question 1

Which TWO factors influence the speed and performance of batch data stream ingestion in Data Cloud? (Choose TWO)

Accepted Answer

Complexity and number of formula transformations applied during mapping.. Batch ingestion performance is affected by file size/number of files in cloud storage and the complexity of formula transformations or data types being parsed.

Answer

The physical location of the administrator's laptop.

Answer

The color scheme configured in the Salesforce CRM user interface.

Answer

The number of active browser tabs open by the administrator viewing the Data Streams tab.

Question 2

A Data Cloud consultant is configuring a Data Action to trigger an event in Salesforce Core whenever a high-value customer's calculated insight score crosses a specific threshold. The Data Action fails to trigger when the insight updates. Which component should the consultant inspect first?

Accepted Answer

Verify that the Data Action Target is correctly mapped and authorized with the destination endpoint.. Data Actions rely on Data Action Targets linked to AWS EventBridge or Core triggers; misconfigurations in the Data Action Target mapping or the underlying Calculated Insight schedule are primary points of failure.

Answer

Check if the activation target's publishing schedule is set to real-time.

Answer

Ensure the segment has been published at least once today.

Answer

Verify that the Marketing Cloud connector package is updated to the latest version.

Question 3

A consultant needs to troubleshoot a Calculated Insight that is not returning expected results. Which TWO areas should the consultant check? Choose 2 options.

Accepted Answer

Ensure the Calculated Insight output is mapped to the appropriate profile data model objects if used for segmentation.. Option C is correct because a Calculated Insight's output must be mapped to the appropriate profile data model objects (such as the correct profile or related entities) for it to be usable in segmentation; if the mapping is wrong or missing, the insight won't surface the expected results downstream. Option E is correct because Calculated Insights are defined with ANSI SQL, and the query's syntax plus its GROUP BY clauses must align with the target object's primary key; mismatched grouping or invalid SQL causes the insight to fail or return incorrect aggregates. Option A is not relevant here because the Activation Target authorization token relates to activating data outbound to a target, not to computing a Calculated Insight. Option B is incorrect because a Data Stream's ingestion schedule (streaming vs. batch) is unrelated to troubleshooting the Calculated Insight's query results. Option D is incorrect because the Segment Canvas refresh schedule governs when segments are recalculated, not whether the Calculated Insight itself returns expected results.

Answer

Verify that the Activation Target authorization token is active.

Answer

Check that the underlying Data Stream ingestion schedule is set to streaming mode.

Answer

Confirm that the Segment Canvas refresh schedule matches the Calculated Insight run time.

Question 4

An administrator has configured a data stream from a Google Cloud Storage bucket. The stream runs successfully, but no new records appear in the Data Model Object. Upon checking, the administrator realizes the files are placed in the bucket using a nested folder structure that the connector is not parsing. How should the administrator resolve this?

Accepted Answer

Update the file path and prefix settings in the Data Stream configuration to include wildcard or subfolder patterns.. Cloud storage connectors require proper path and file pattern configurations (such as wildcard matching) to locate and ingest files within nested folders.

Answer

Write an Apex trigger in Google Cloud Storage to flatten the folder structure.

Answer

Recreate the Google Cloud Storage bucket as an Amazon S3 bucket.

Answer

Move all files to the root directory of the Google Cloud Storage bucket and restart the Salesforce CRM connector.

Question 5

Which TWO file storage providers are natively supported for batch data stream ingestion in Data Cloud? (Choose TWO)

Accepted Answer

Google Cloud Storage. Data Cloud supports native connectors for major cloud storage providers including Amazon S3, Google Cloud Storage, and Azure Blob Storage.

Answer

Personal Dropbox account

Answer

Apple iCloud Drive

Answer

Local Windows file share via SMB

Question 6

Which user permission is required to create and publish activations in Data Cloud?

Accepted Answer

Data Cloud Activation Admin or equivalent custom permission set. Creating and publishing activations in Data Cloud requires the Data Cloud Activation Admin permission (or an equivalent custom permission set granting the same activation-related permissions). This permission grants the ability to configure activation targets, map fields, and publish activations to downstream systems.

Answer

Data Cloud Data Streaming Specialist

Answer

Marketing Cloud Administrator only

Answer

Salesforce CRM System Administrator

Question 7

An enterprise client has millions of historical records and wants to run Identity Resolution. The consultant notices that the identity resolution job is taking an excessively long time to complete. What is the recommended approach to optimize Identity Resolution performance?

Accepted Answer

Review match rules to remove overly broad match criteria and ensure proper data modeling of primary keys and foreign keys.. Identity resolution performance is dominated by the number and breadth of match rules and the volume/quality of source records. Overly broad match criteria (e.g., fuzzy matching on common names without additional qualifiers) cause the matching engine to evaluate enormous candidate sets, dramatically increasing compute time. Ensuring proper data modeling of primary and foreign keys also reduces unnecessary joins and improves match efficiency. Reviewing and tightening match rules is the recommended optimization.

Answer

Disable all data streams before running the ruleset refresh.

Answer

Increase the batch size in the Data Cloud connector settings to maximum capacity.

Answer

Switch all reconciliation rules from Source Sequence to Most Recent.

Question 8

What is the primary function of the Unified Link Individual object in Salesforce Data Cloud?

Accepted Answer

It stores the many-to-one relationship mapping between source individual records and unified individual profiles.. The Unified Link Individual object maps source individual records to their corresponding unified individual record.

Answer

It acts as an activation target for S3 exports.

Answer

It stores encrypted authentication tokens for external API integrations.

Answer

It houses raw marketing engagement logs.

Question 9

How can a consultant verify how many profiles currently qualify for a published segment?

Accepted Answer

Check the segment details page in Data Cloud for total member count and publish history.. In Data Cloud, the segment details page displays the total member count, publish history, and refresh status for a published segment. This is the authoritative UI location to verify how many profiles currently qualify, because it reflects the last successful segment publish and its resulting membership.

Answer

Review the Data Stream error log file.

Answer

Open the Identity Resolution match history report.

Answer

Run a SOQL query against the standard Salesforce CRM Account object.

Question 10

A marketing team wants to target customers who have made a purchase in the last 30 days but have not opened an email in the last 7 days. Where should the marketer build this audience criteria?

Accepted Answer

Data Cloud Segmentation canvas. Audience segments in Data Cloud are created in the Segmentation canvas using harmonized data model objects and attribute operators.

Answer

Sales Cloud Report Builder with joined reports

Answer

Calculated Insights SQL editor

Answer

Marketing Cloud Engagement Journey Builder decision splits only

Question 11

A consultant is troubleshooting an activation that has a status of 'Publishing' for an unusually long time. Where should the consultant check to diagnose potential pipeline bottlenecks?

Accepted Answer

The Activation History and Monitor tab in Data Cloud to review job progress and error logs.. The Activation History and Monitor tab in Data Cloud is the dedicated surface for tracking activation job status, including 'Publishing' states, and it exposes job progress, record counts, and error logs. When an activation is stuck in 'Publishing', this tab reveals whether the bottleneck is in segment refresh, data transformation, or the downstream target connector. Other tools listed do not surface activation pipeline telemetry.

Answer

The Einstein Studio model training metrics.

Answer

The Salesforce Core Setup Audit Trail.

Answer

The Marketing Cloud Journey Builder analytics dashboard.

Question 12

An enterprise client requires that all data exported via activation to an ad network be subjected to a final attribute masking rule to obscure sensitive demographics. How can this requirement be met?

Accepted Answer

Create derived attributes or transformed DMO fields upstream before segment activation to ensure sensitive values are obscured or masked prior to export.. Data transformations, calculated insights, or masked attribute mappings should be applied upstream or via derived data model fields before activation export, as activation targets export mapped attributes directly.

Answer

Write an Apex trigger on the Unified Individual object to intercept and scrub outbound activation payloads.

Answer

Configure an encryption mask in the Activation Target configuration screen.

Answer

Enable Salesforce Shield Platform Encryption specifically for activation exports.

Question 13

A consultant is configuring a Marketing Cloud Engagement activation. The marketing team wants to personalize the message content using attributes that change frequently (e.g., current loyalty tier). How should the consultant ensure the activation includes the latest attribute values?

Accepted Answer

Ensure the source data streams, calculated insights (if applicable), and activation schedules are aligned to refresh frequently enough to capture changing attributes.. Ensuring attributes are refreshed involves scheduling the underlying data streams and calculated insights to run frequently, and configuring the activation to publish regularly.

Answer

Enable real-time streaming for the Marketing Cloud Engagement activation target.

Answer

Hardcode the loyalty tier attributes directly into the Activation Target configuration screen.

Answer

Rely on Identity Resolution to automatically update attribute values in real-time.

Question 14

When configuring a Data Action, what are the two main components that must be linked together?

Accepted Answer

A Data Source/Event and a Data Action Target. A Data Action in Data 360 is composed of two linked elements: a Data Source or Event that triggers the action, and a Data Action Target that defines where the action is sent (e.g., a webhook, Marketing Cloud, or external API). Both must be configured and connected for the action to execute.

Answer

An Identity Resolution Ruleset and a Calculated Insight

Answer

A Segment and an Activation Target

Answer

An Ingestion API connection and an SFTP server

Question 15

Which THREE actions should a consultant take when auditing an identity resolution implementation where records are incorrectly merging across distinct customer households? Choose 3 options.

Accepted Answer

Incorporate high-cardinality unique identifiers like distinct account numbers or verified emails.. Incorrect cross-household merging (over-merging) requires reviewing broad match rules, adding secondary criteria with strict AND logic, and verifying unique identifiers.

Answer

Switch all reconciliation rules from Most Recent to Longest String.

Answer

Delete all unified link records manually via Apex.

Question 16

Which TWO actions are required when setting up an Activation Target for Marketing Cloud Engagement? (Choose two.)

Accepted Answer

Configure an installed package in Marketing Cloud Engagement providing Client ID, Client Secret, and Authentication URI.. Option C is correct because setting up an Activation Target for Marketing Cloud Engagement requires an installed package in Marketing Cloud Engagement that supplies the Client ID, Client Secret, and Authentication URI used for the OAuth connection between the systems. Option E is correct because the Activation Target configuration must specify the target Business Unit in Marketing Cloud Engagement where the data extensions and audiences will be published. Option A is not required, since Calculated Insights are optional analytics constructs and are not part of the Activation Target setup. Option B is not required, as SSL certificates are not uploaded directly on the activation target screen; secure connectivity is handled through the installed package and authentication settings. Option D is not required, because no custom Apex REST service in Salesforce Core CRM is needed to bridge the connection.

Answer

Define a Calculated Insight to aggregate messaging metrics.

Answer

Upload an SSL private key certificate directly into the activation target screen.

Answer

Write a custom Apex REST service in Salesforce Core CRM to bridge the connection.

Question 17

An organization experiences performance degradation and timeout errors whenever their scheduled Identity Resolution ruleset executes. Upon reviewing the setup, the consultant finds that the ruleset contains five broad fuzzy match rules running against 50 million records without any pre-filtering. What is the recommended architectural remedy?

Accepted Answer

Restructure the match rules to prioritize high-confidence exact matches first, followed by selective secondary rules, and remove overly broad fuzzy combinations.. Reducing unnecessary broad fuzzy rules and structuring match rules hierarchically (from exact high-confidence matches to broader fuzzy matches) optimizes performance.

Answer

Change all reconciliation rules from Most Recent to Longest String.

Answer

Increase the Salesforce CRM API polling frequency to every 5 minutes.

Answer

Delete all contact point email records older than 30 days.

Question 18

Universal Containers wants to implement Data Cloud to unify customer data from multiple sources across Sales Cloud, Marketing Cloud Engagement, and an external legacy order management system. Which architectural component should the consultant recommend as the foundational layer to ingest and normalize this data?

Accepted Answer

Data Streams. Data Streams are the foundational ingestion layer in Data Cloud. They connect to source systems (Sales Cloud, Marketing Cloud Engagement, external systems via S3, Snowflake, etc.) and bring raw data into Data Lake Objects (DLOs), which are then mapped and transformed into Data Model Objects (DMOs). Without Data Streams, no data enters Data Cloud, so they are the correct foundational component for ingesting and normalizing multi-source data.

Answer

Activation Targets

Answer

Data Spaces

Answer

Calculated Insights

Question 19

A consultant writes a Calculated Insight using ANSI SQL to calculate total spend per customer. When attempting to save, the system throws an error regarding dimensionality. What is the cause?

Accepted Answer

The query is missing a GROUP BY clause corresponding to the primary key of the target entity.. Calculated Insights in Data 360 require that the SQL query's output be aggregated at the grain of the target entity's primary key. Without a GROUP BY clause matching that primary key, the query returns rows at an undefined grain, which the system cannot map to the entity — hence the dimensionality error. The GROUP BY must align with the entity's primary key to produce a valid metric per entity record.

Answer

Calculated Insights only support Standard SQL, not ANSI SQL.

Answer

The metric name contains spaces or special characters.

Answer

The query references fields from more than three distinct data streams simultaneously.

Question 20

An enterprise wants to publish a segment of high-value customers to an external S3 bucket. Which feature must the consultant configure prior to publishing the segment?

Accepted Answer

Activation Target. To publish a segment to an external S3 bucket, you must configure an Activation Target in Data Cloud (Data 360). Activation Targets define the destination for segment activation, such as an S3 bucket, and include the necessary connection details and credentials. This is a prerequisite before you can publish or activate a segment to that external system.

Answer

Data Action Target

Answer

Ingestion API Source

Answer

Connected App Framework