Data 360 Consultant Practice Test 1 — 10 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.