Data 360 Consultant Practice Test 8 — 10 Questions

Question 1

A consultant is troubleshooting a Calculated Insight that fails to compile and execute successfully. Which THREE factors commonly cause Calculated Insight SQL execution failures in Data Cloud? (Choose three.)

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

Accepted Answer

Exceeding the maximum allowed query complexity or join limits.. Calculated Insights rely on strict ANSI SQL syntax supported by Data Cloud, valid object relationships, and proper aggregate functions.

Answer

Configuring an activation target with an invalid webhook URL.

Answer

Failing to enable Salesforce Shield Platform Encryption on the user profile.

Question 2

Which THREE symptoms or error logs indicate an issue with an activation target connection or authentication? (Choose three.)

Accepted Answer

Connection timeout errors when attempting to reach the external endpoint.. Connection and authentication issues with activation targets typically manifest as HTTP 401/403 errors, timeout messages, or invalid credential notifications.

Answer

Identity Resolution match rule confidence score falling below threshold.

Answer

Segment recalculation taking longer than expected due to large record counts.

Question 3

A consultant needs to create an activation target for Meta Ads within Data Cloud. Where should the consultant navigate within the Data Cloud setup to establish this connection?

Accepted Answer

Setup > Data Cloud > Activation Targets. Activation targets are managed under the 'Activation Targets' tab in Data Cloud setup.

Answer

Data Cloud > Segments > New Target

Answer

Setup > Marketing Cloud > Connected Apps

Answer

Setup > Data Streams > External Connections

Question 4

A consulting firm is setting up Data Cloud for a multinational enterprise with distinct business units in North America and Europe. The enterprise requires strict data governance and logical separation of customer data between these two regions within a single Data Cloud instance. What should the consultant implement?

Accepted Answer

Data Spaces. Data Spaces allow an organization to logically partition data, metadata, and insights within a single Data Cloud instance to support distinct business units or regulatory requirements.

Answer

Individual Data Model Objects with custom formula fields

Answer

Permission Sets limiting object visibility

Answer

Multiple Data Cloud instances with Marketing Cloud Connect

Question 5

An enterprise customer has implemented Data Cloud and configured multiple data streams. They notice that a specific data stream is consistently skipping records because the timestamp format in the source file does not match the expected ISO 8601 format. How should the consultant fix this issue?

Accepted Answer

Apply a transformation formula during data stream mapping to parse and convert the date format.. Transformation formulas can be applied during data stream mapping to parse and convert non-standard date/timestamp formats into valid ISO 8601 timestamps.

Answer

Disable date validation in the Identity Resolution ruleset.

Answer

Modify the source system database schema to remove timestamps.

Answer

Increase the batch size of the data stream.

Question 6

Which TWO objects are core components directly involved in the output of an Identity Resolution ruleset in Salesforce Data Cloud? Choose 2 options.

Accepted Answer

Unified Link Individual object. The Unified Individual DMO and the Unified Link Individual object are the primary outputs and linkage tables generated by identity resolution.

Answer

Activation Target object

Answer

Ingestion Data Stream object

Answer

Calculated Insight definition table

Question 7

Which component in Salesforce Data Cloud connects source individual records to their corresponding unified individual record?

Accepted Answer

Unified Link Individual object. The Unified Link Individual object bridges the source individual records to the unified individual profile.

Answer

Contact Point Email object

Answer

Calculated Insight object

Answer

Activation Target object

Question 8

A consultant is setting up an activation for a Meta Ads activation target in Data Cloud. When attempting to select the desired audience segment, the consultant notices the segment is unavailable for selection. What is the most likely cause of this issue?

Accepted Answer

The segment does not include the mandatory identity attributes (such as hashed email or phone) required by the Meta activation target.. Activations to advertising platforms (such as Meta) require specific attributes like hashed emails or phone numbers to be mapped and available in the segment definition to satisfy platform matching requirements.

Answer

The activation target is configured for Marketing Cloud Engagement instead of Meta Ads.

Answer

The segment was built using a Calculated Insight instead of standard Data Model Objects.

Answer

The Data Stream associated with the segment has exceeded its daily ingestion limits.

Question 9

A consultant notices that an activation publish job completed with partial failures ('Completed with Errors'). Where should the consultant investigate to identify which specific records failed to export?

Accepted Answer

Review the Activation History log details in Data Cloud to inspect row-level error messages and failure codes.. Activation execution logs and error details provide row-level error reporting indicating which records failed validation or transmission during export.

Answer

Check the Salesforce Core Setup Audit Trail for login failure events.

Answer

Open the Marketing Cloud Engagement Tracking Report for email sends.

Answer

Examine the Data Stream Ingestion status dashboard for failed CSV files.

Question 10

A consultant is configuring an activation to an AWS S3 bucket. The target system requires files to be delivered in compressed GZIP format. How should the consultant configure this?

Accepted Answer

Select GZIP compression within the file format settings of the Cloud File Storage Activation Target configuration.. Cloud storage activation targets support output file format configurations, including compression options like GZIP or uncompressed formats.

Answer

Rely on AWS S3 bucket lifecycle rules to automatically compress incoming files.

Answer

Configure compression settings in the Data Stream ingestion mapping screen.

Answer

Write an Apex compression utility before generating the activation export.