Data 360 Consultant Practice Questions 1 — 50 Questions

Question 1

Which TWO actions are necessary when preparing to ingest data from an external Salesforce CRM organization into Data Cloud?

Accepted Answer

Authenticate the CRM source using a dedicated integration user. The consultant must first establish the connection via the CRM connector and then select the specific objects to ingest.

Answer

Install the Marketing Cloud package in the CRM

Answer

Configure a private cloud gateway

Answer

Create a sandbox for the Data Cloud environment

Question 2

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?

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 3

Which TWO methods can be used to bring data from external AWS services into Data Cloud? (Choose two.)

Accepted Answer

Utilizing the Data Cloud Ingestion API for custom streaming integrations from AWS compute instances. Option A is correct because the Data Cloud Ingestion API is a REST-based streaming ingestion endpoint that accepts data from any external source, including custom applications or AWS compute instances (EC2, Lambda, ECS), making it a valid method to bring data from external AWS services into Data Cloud. Option E is correct because Data Cloud provides a native Amazon S3 connector (Cloud File Storage Data Source) that lets you register an S3 bucket as a data source and ingest CSV, JSON, or Parquet files directly from AWS into Data Cloud. Option B is wrong because Salesforce CRM Change Data Capture applies only to Salesforce objects, not to AWS RDS, and cannot be enabled on an external RDS database. Option C is wrong because Marketing Cloud Connect integrates Salesforce CRM with Marketing Cloud, not Data Cloud, and installing it on EC2 does not ingest AWS data. Option D is wrong because Data Cloud does not support a direct SQL Server replication tunnel as an ingestion method.

Answer

Enabling Salesforce CRM Change Data Capture on AWS RDS

Answer

Installing Marketing Cloud Connect on an AWS EC2 instance

Answer

Establishing a direct SQL Server replication tunnel

Question 4

An administrator needs to ingest customer feedback ratings stored as numeric values from 1 to 5. When mapping this field to a custom DMO attribute, which data type should the administrator select?

Accepted Answer

Number (Integer or Decimal). Numeric ratings (like 1 to 5) should be mapped to a Number (Integer or Decimal) data type in the DMO to allow calculations and aggregations.

Answer

DateTime

Answer

Boolean (True/False)

Answer

Text (String)

Question 5

An administrator is setting up a new Salesforce CRM data stream and wants to filter out inactive contacts during the ingestion process to save storage. Where can the administrator configure data filtering?

Accepted Answer

Apply filter criteria during the Data Stream creation wizard under the filter step.. Data 360 (Data Cloud) allows filtering at the data stream level during the ingestion setup wizard, where you can define filter criteria to exclude records such as inactive contacts before they are stored. This reduces storage and processing by preventing unwanted records from entering the data model. The filter step is part of the Data Stream creation flow, making option C the correct configuration point.

Answer

Create a Sharing Rule in CRM to block inactive contacts from syncing.

Answer

Write an Apex trigger on the Data Model Object after ingestion.

Answer

Configure a validation rule in Salesforce CRM Setup.

Question 6

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 7

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 8

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 9

A Data Cloud Consultant is reviewing the available connectors and ingestion capabilities in Data Cloud. Which THREE data sources are natively supported for direct integration and ingestion without requiring custom middleware? (Choose three.)

Accepted Answer

Amazon S3 (Cloud Storage). Amazon S3 (Cloud Storage) is correct because Data Cloud provides a native Amazon S3 connector that ingests CSV, JSON, and Parquet files directly from S3 buckets without custom middleware. Salesforce CRM (Sales and Service Cloud) is correct because Data Cloud has a native Salesforce CRM connector that streams Sales and Service Cloud objects and fields directly into data streams. Marketing Cloud Engagement is correct because Data Cloud offers a native Marketing Cloud Engagement connector for ingesting subscriber, journey, and engagement data directly. A custom on-premise relational database via direct ODBC driver installation is not natively supported, since on-premise databases require a secure agent or MuleSoft-based integration rather than a direct ODBC install. A legacy local file server accessed via FTP without intermediate cloud storage is also not natively supported, because Data Cloud ingestion requires cloud storage staging (such as S3) or a supported connector rather than direct FTP access.

Answer

A custom on-premise relational database via direct ODBC driver installation.

Answer

A legacy local file server accessed via FTP without intermediate cloud storage.

Question 10

A consultant is reviewing identity resolution metrics and sees the metric 'Total Unified Individuals'. What does this metric represent?

Accepted Answer

The total number of unique, consolidated individual profiles generated by the ruleset.. Total Unified Individuals represents the count of unique, consolidated profile records resulting from the identity resolution ruleset execution.

Answer

The number of activation targets successfully configured.

Answer

The total number of segments created in the data space.

Answer

The total number of raw source records ingested across all data streams.

Question 11

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 12

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 13

What is the function of the Identity Resolution Ruleset wizard in Salesforce Data Cloud?

Accepted Answer

To guide administrators through creating and configuring match and reconciliation rules for unified profiles.. The Identity Resolution Ruleset wizard guides the user step-by-step through selecting match rules, reconciliation rules, and target objects.

Answer

To construct marketing segments and publish them to activation targets.

Answer

To write SQL queries for Calculated Insights.

Answer

To provision new data spaces and assign user licenses.

Question 14

A consultant is designing identity resolution for an organization that receives customer data from both a B2C retail app and a B2B corporate portal. The client wants separate unified profile structures for consumers versus business buyers. How should this be structured in Data Cloud?

Accepted Answer

Partition the B2C and B2B data into separate data spaces and configure dedicated identity resolution rulesets for each space.. Different profile structures or distinct business domains with strict separation requirements should be partitioned into separate data spaces, each housing its own identity resolution ruleset.

Answer

Create a single ruleset with conflicting match rules to automatically separate them.

Answer

Map both B2C and B2B data streams to the same exact unmapped DLO without data transforms.

Answer

Use Calculated Insights to delete B2B profiles from the B2C unified individual table.

Question 15

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 16

Which TWO statements are true regarding Data Model Object (DMO) relationships in Data Cloud? (Choose TWO)

Accepted Answer

Relationships can be established between standard DMOs and custom DMOs.. DMO relationships define how objects connect (e.g., 1-to-many between Individual and Contact Point), and they are configured visually in the Data Model canvas.

Answer

Standard CIM DMO relationships cannot be modified or extended.

Answer

Relationships require Apex code to enforce referential integrity.

Answer

Relationships are automatically created by Identity Resolution without user configuration.

Question 17

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 18

An administrator needs to ingest data from an external relational database into Data Cloud using a scheduled batch process. Which connector type is best suited for this requirement?

Accepted Answer

Cloud Storage Connector (e.g., Amazon S3, Google Cloud Storage, Azure Blob Storage). External database ingestion where Salesforce pulls data via batch files or direct connections can utilize Cloud Storage connectors (like S3, Google Cloud Storage, Azure Blob) or standard file upload methods. For scheduled batch file drops, Cloud Storage connectors are standard.

Answer

Marketing Cloud Connector

Answer

Real-Time Interaction Collector

Answer

Salesforce CRM Connector

Question 19

What is the function of the Data Cloud Setup Home page for an administrator?

Accepted Answer

To provide an overview of provisioning status, guided setup steps, and quick links to core configuration tasks.. Data Cloud Setup Home provides a centralized dashboard showing setup progress, key metrics, quick links, and guidance for provisioning and configuring Data Cloud.

Answer

To manage core Salesforce CRM user profiles and permission sets.

Answer

To write SQL queries for Calculated Insights.

Answer

To create marketing segments and activation targets.

Question 20

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.