Data 360 Consultant Practice Test 27 — 15 Questions

Question 1

An administrator has set up a data stream from a custom AWS S3 bucket. The data stream runs, but zero rows are processed and no error is thrown. What configuration check should the administrator perform first?

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

Accepted Answer

Verify that the file path prefix and naming convention in the stream configuration match the actual files in the S3 bucket.. When an S3 stream processes zero rows without error, it typically means no files matched the specified file prefix, naming convention, or folder path in the connector settings.

Answer

Restart the Data Cloud background worker processes via Setup.

Answer

Verify that the AWS IAM user has AdministratorAccess across the entire AWS account.

Answer

Check if the Salesforce core org has reached its daily API storage limit.

Question 2

A consultant is troubleshooting a newly created Data Stream in Salesforce Data Cloud where records are failing to ingest from an external REST API source via the Ingestion API. Which THREE factors should the consultant investigate? (Choose three.)

Accepted Answer

Verify that the JSON payload matches the schema definition of the target Data Lake Object (DLO).. Ingestion API failures typically relate to authentication credentials (JWT/OAuth), payload schema validation errors against the DLO definition, or incorrect endpoint/connector configurations.

Answer

Modify the Apex controller class in Sales Cloud to trigger the API push.

Answer

Update the Identity Resolution match rules to resolve duplicate source records.

Question 3

What is the primary function of the Data Streams tab in Data Cloud?

Accepted Answer

To create, configure, and monitor data streams from connected sources. The Data Streams tab is where administrators create, configure, edit, and monitor data streams from various connected sources.

Answer

To design audience segmentation filters

Answer

To configure activation targets and publishing schedules

Answer

To write ANSI SQL queries for Calculated Insights

Question 4

An enterprise is evaluating Data Cloud editions and wants to understand what core capabilities are included with the base license. Which feature is universally included across standard Data Cloud implementations?

Accepted Answer

Standard connectors for Salesforce CRM and Marketing Cloud Engagement. Standard connectors for Salesforce CRM and Marketing Cloud Engagement are part of the base Data Cloud license, enabling immediate data ingestion from these core Salesforce sources without additional cost or configuration. These connectors are foundational to Data Cloud's value proposition, allowing organizations to unify CRM and marketing data out of the box. Other options describe premium, custom, or unrealistic capabilities not included universally.

Answer

Custom AI model training using Amazon SageMaker

Answer

Unlimited external API ingestion without throttling

Answer

Real-time mobile SDK generation

Question 5

An organization notices that an activation associated with a segment is failing to deliver data to an external marketing platform. What should the consultant check first?

Accepted Answer

Verify the Activation Target connection settings, credentials, and attribute mappings.. When an activation fails to deliver data to an external platform, the most common root causes are misconfigured activation target connection settings, expired or incorrect credentials, and incorrect attribute mappings between the segment's schema and the destination's expected fields. These are the first things a consultant should inspect because they are the direct interface between the platform and the external system.

Answer

Delete all data streams and re-ingest raw data files.

Answer

Recreate the entire Identity Resolution ruleset from scratch.

Answer

Increase the browser timeout limit for the Salesforce administrator.

Question 6

Which TWO benefits does a Calculated Insight provide in Data Cloud? Choose 2 options.

Accepted Answer

Enhances segmentation capabilities by providing quantitative attributes for audience filtering.. Calculated Insights allow users to compute metrics and build longitudinal summaries of customer behavior across engagement data.

Answer

Automatically provisions external S3 storage buckets for data archiving.

Answer

Streams raw clickstream data directly into external CRM contact records.

Answer

Replaces the need for Identity Resolution rule sets entirely.

Question 7

What is the primary role of Data Source Objects (DSOs) in the Data Cloud architecture?

Accepted Answer

To store unharmonized raw data from connected data streams. DSOs store raw incoming data streams before they are mapped to harmonized Data Model Objects.

Answer

To publish data to external ad networks

Answer

To execute audience segmentation queries

Answer

To build machine learning models in Einstein Studio

Question 8

A consultant is designing a segment that requires filtering based on a Calculated Insight metric (e.g., Total Spend > 500). What type of attribute is used in the Segment Canvas to achieve this?

Accepted Answer

Calculated Insight attributes related to the Unified Individual.. Calculated Insight objects appear as related attributes or direct attributes on the Unified Individual once mapped, allowing them to be dragged into segment containers.

Answer

Identity Resolution rule set parameters.

Answer

Activation Target schema fields.

Answer

Data Lake Object raw event logs.

Question 9

Which THREE actions can a consultant perform when configuring segment publishing in Data Cloud? (Choose three.)

Accepted Answer

Map the segment to one or more compatible Activation Targets.. Segment publishing allows setting refresh schedules, selecting attributes to publish, and choosing activation targets.

Answer

Modify the underlying Identity Resolution rules directly from the publishing menu.

Answer

Manually write custom Apex triggers to control the exact data packet routing.

Question 10

A company is setting up an activation to a cloud storage bucket. They want to ensure that files are partitioned or named in a specific structure so that their downstream data warehouse ingestion pipeline can parse them easily. How should the consultant configure this?

Accepted Answer

Configure the file naming convention, prefix, and folder path settings within the Cloud File Storage Activation Target configuration.. Cloud File Storage Activation Targets in Data 360 expose configuration fields for file naming convention, prefix, and folder path, allowing the consultant to control the output structure without post-processing. This is the native, supported way to ensure downstream ingestion pipelines can parse files consistently.

Answer

Write an external cron job in the cloud storage bucket to rename files after export.

Answer

Modify the Data Model Object primary keys to include folder names.

Answer

Use an Apex trigger on the activation object to alter file headers.

Question 11

What is the first step an administrator must take before creating a data stream from an external cloud storage provider like Amazon S3?

Accepted Answer

Configure a Cloud Storage connector in Data Cloud Setup.. Before creating a data stream from cloud storage, the administrator must configure the Cloud Storage connector with authentication credentials and bucket details.

Answer

Assign the Data Cloud Ingestion API permission set to all users.

Answer

Build custom Calculated Insights to parse the raw storage files.

Answer

Create a custom Identity Resolution ruleset.

Question 12

A consultant is configuring identity resolution and wants to ensure that exact phone matching takes country code formatting differences into account. How does Data Cloud handle phone number matching?

Accepted Answer

Data Cloud normalizes phone numbers into a standard international format during ingestion and mapping before evaluating exact phone rules.. Data Cloud normalizes phone numbers into a standard international format during ingestion and mapping, before exact phone match rules are evaluated. This means formatting differences such as spaces, dashes, parentheses, and country code prefixes are reconciled so that two records with the same underlying number match. The normalization step is part of the data preparation pipeline, not something the match rule itself performs.

Answer

Phone match rules require exact string matches without any prior formatting normalization.

Answer

Phone matching requires manual Apex code to strip country codes.

Answer

Phone matching only evaluates the last 4 digits of the phone string.

Question 13

A Data Cloud Consultant is configuring an activation that includes optional activation attributes. Some profile records do not have values for these optional attributes. How does Data Cloud treat null attribute values in the exported activation payload?

Accepted Answer

Data Cloud exports null attributes as empty strings or omits them based on the activation target schema configuration.. Data Cloud handles null attribute values in activation payloads based on the target schema configuration: nulls are typically exported as empty strings or omitted entirely, depending on how the target field is defined. This prevents activation failures when optional attributes are missing for some profiles, and the behavior is configurable per target schema.

Answer

Data Cloud automatically populates missing values with default system placeholder text such as 'N/A'.

Answer

The entire activation publish job fails with a schema validation error.

Answer

Profiles with missing attributes are automatically dropped from the segment entirely.

Question 14

An activation targeting an external advertising platform is failing consistently with an authentication error. The consultant verified that the client ID and client secret are correct. What other configuration on the activation target needs verification?

Accepted Answer

Verify that the associated Connected App or OAuth credential scope and token grant have not expired or revoked.. External platform integrations often require validating OAuth token endpoints, refresh tokens, scopes, and active authorization grants.

Answer

Ensure the Data Stream for the ad network has finished ingesting historical logs.

Answer

Confirm that the Calculated Insight refresh frequency matches the ad platform API limits.

Answer

Check if the segment has more than 10 million records, which causes auth timeouts.

Question 15

A consultant wants to create a Calculated Insight that calculates the total revenue generated by each customer over the last 12 months, using an ANSI SQL expression in Data Cloud. Which syntax rule must be followed when writing the Calculated Insight?

Accepted Answer

The query must include at least one dimension and one aggregate measure using standard ANSI SQL.. Calculated Insights in Data Cloud use ANSI SQL. When writing aggregation queries, measures must be aggregated using standard SQL aggregate functions (like SUM, COUNT, AVG) and grouped by valid dimensions from the Data Model Objects.

Answer

Custom Apex code must be embedded within the SQL block for date calculations.

Answer

Queries must be written in Salesforce Object Query Language (SOQL).

Answer

All table names must reference raw Data Lake Objects (DLOs) rather than Data Model Objects (DMOs).