Data 360 Consultant Practice Test 9 — 10 Questions

Question 1

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?

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

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.