Salesforce Data-Cloud-Consultant Exam Questions (Updated 2024) 100% Real Question Answers [Q31-Q52]

Q31. A consultant has an activation that is set to publish every 12 hours, but has discovered that updates to the data prior to activation are delayed by up to 24 hours.
Which two areas should a consultant review to troubleshoot this issue?
Choose 2 answers

Review data transformations to ensure they’re run after calculated insights.

Review calculated insights to make sure they’re run before segments are refreshed.

Review segments to ensure they’re refreshed after the data is ingested.

Review calculated insights to make sure they’re run after the segments are refreshed.

Q32. A consultant is planning the ingestion of a data stream that has profile information including a mobile phone number.
To ensure that the phone number can be used for future SMS campaigns, they need to confirm the phone number field is in the proper E164 Phone Number format. However, the phone numbers in the file appear to be in varying formats.
What is the most efficient way to guarantee that the various phone number formats are standardized?

Create a formula field to standardize the format.

Edit and update the data in the source system prior to sending to Data Cloud.

Assign the PhoneNumber field type when creating the data stream.

Create a calculated insight after ingestion.

Q33. Northern Trail Outfitters wants to use some of its Marketing Cloud data in Data Cloud.
Which engagement channel data will require custom integration?

SMS

Email

CloudPage

Mobile push

Q34. Which consideration related to the way Data Cloud ingests CRM data is true?

CRM data cannot be manually refreshed and must wait for the next scheduled synchronization,

The CRM Connector’s synchronization times can be customized to up to 15-minute intervals.

Formula fields are refreshed at regular sync intervals and are updated at the next full refresh.

The CRM Connector allows standard fields to stream into Data Cloud in real time.

Q35. A consultant needs to package Data Cloud components from one
organization to another.
Which two Data Cloud components should the consultant include in a
data kit to achieve this goal?
Choose 2 answers

Data model objects

Segments

Calculated insights

Identity resolution rulesets

Q36. Cumulus Financial created a segment called High Investment Balance Customers. This is a foundational segment that includes several segmentation criteria the marketing team should consistently use.
Which feature should the consultant suggest the marketing team use to ensure this consistency when creating future, more refined segments?

Create new segments using nested segments.

Create a High Investment Balance calculated insight.

Package High Investment Balance Customers in a data kit.

Create new segments by cloning High Investment Balance Customers.

Q37. A consultant has an activation that is set to publish every 12 hours, but has discovered that updates to the data prior to activation are delayed by up to 24 hours.
Which two areas should a consultant review to troubleshoot this issue?
Choose 2 answers

Review data transformations to ensure they’re run after calculated insights.

Review calculated insights to make sure they’re run before segments are refreshed.

Review segments to ensure they’re refreshed after the data is ingested.

Review calculated insights to make sure they’re run after the segments are refreshed.

Q38. What does the Source Sequence reconciliation rule do in identity resolution?

Includes data from sources where the data is most frequently occurring

Identifies which individual records should be merged into a unified profile by setting a priority for specific data sources

Identifies which data sources should be used in the process of reconcillation by prioritizing the most recently updated data source

Sets the priority of specific data sources when building attributes in a unified profile, such as a first or last name

Q39. Which data model subject area should be used for any Organization, Individual, or Member in the Customer
360 data model?

Engagement

Membership

Party

Global Account

Q40. Northern Trail Outfitters unifies individuals in its Data Cloud instance.
Which threefeatures ca e consultant use to validate the data on a unified profile?
Choose 3 answers

Identity Resolution

Query APL

Data Explorer

Profile Explorer

Data Actions

Q41. A healthcare client wants to make use of identity resolution, but does not want to risk unifying profiles that may share certain personally identifying information (PII).
Which matching rule criteria should a consultant recommend for the most accurate matching results?

Party Identification on Patient ID

Exact Last Name and Emil

Email Address and Phone

Fuzzy First Name, Exact Last Name, and Email

Q42. What does the Ignore Empty Value option do in identity resolution?

Ignores empty fields when running any custom match rules

Ignores empty fields when running reconciliation rules

Ignores Individual object records with empty fields when running identity resolution rules

Ignores empty fields when running the standard match rules

Q43. Northern Trail Outfitters is using the Marketing Cloud Starter Data Bundles to bring Marketing Cloud data into Data Cloud.
What are two of the available datasets in Marketing Cloud Starter Data Bundles?
Choose 2 answers

Personalization

MobileConnect

Loyalty Management

MobilePush

Q44. What is Data Cloud’s primary value to customers?

To provide a unified view of a customer and their related data

To connect all systems with a golden record

To create a single source of truth for all anonymous data

To create personalized campaigns by listening, understanding, and acting on customer behavior

Q45. Cloud Kicks wants to be able to build a segment of customers who have visited its website within the previous
7 days.
Which filter operator on the Engagement Date field fits this use case?

Is Between

Greater than Last Number of

Next Number of Days

Last Number of Days

Q46. Cumulus Financial wants to be able to track the daily transaction volume of each of its customers in real time and send out a notification as soon as it detects volume outside a customer’s normal range.
What should a consultant do to accommodate this request?

Use a calculated insight paired with a flow.

Use streaming data transform with a flow.

Use a streaming insight paired with a data action

Use streaming data transform combined with a data action.

Q47. Cloud Kicks received a Request to be Forgotten by a customer.
In which two ways should a consultant use Data Cloud to honor this request?
Choose 2 answers

Delete the data from the incoming data stream and perform a full refresh.

Add the Individual ID to a headerless file and use the delete from file functionality.

Use Data Explorer to locate and manually remove the Individual.

Use the Consent API to suppress processing and delete the Individual and related records from source data streams.

Q48. A consultant is setting up a data stream with transactional data,
Which field typeshould the consultant choose toensure that leading
zeros in the purchase order number are preserved?

Text

Number

Decimal

Serial

Q49. A customer has a calculated insight about lifetime value.
What does the consultant need to be aware of if the calculated insight.
needs to be modified?

Mew dimensions can be added.

Existing dimensions can be removed.

Existing measures can be removed.

Mew measures can be added.

Explanation
A calculated insight is a multidimensional metric that is defined and calculated from data using SQL expressions. A calculated insight can include dimensions and measures. Dimensions are the fields that are used to group or filter the data, such as customer ID, product category, or region. Measures are the fields that are used to perform calculations or aggregations, such as revenue, quantity, or average order value. A calculated insight can be modified by editing the SQL expression or changing the data space. However, the consultant needs to be aware of the following limitations and considerations when modifying a calculated insight12:
* Existing dimensions cannot be removed. If a dimension is removed from the SQL expression, the calculated insight will fail to run and display an error message. This is because the dimension is used to create the primary key for the calculated insight object, and removing it will cause a conflict with the existing data. Therefore, the correct answer is B.
* New dimensions can be added. If a dimension is added to the SQL expression, the calculated insight will run and create a new field for the dimension in the calculated insight object. However, the consultant should be careful not to add too many dimensions, as this can affect the performance and usability of the calculated insight.
* Existing measures can be removed. If a measure is removed from the SQL expression, the calculated insight will run and delete the field for the measure from the calculated insight object. However, the consultant should be aware that removing a measure can affect the existing segments or activations that use the calculated insight.
* New measures can be added. If a measure is added to the SQL expression, the calculated insight will run and create a new field for the measure in the calculated insight object. However, the consultant should be careful not to add too many measures, as this can affect the performance and usability of the calculated insight. References: Calculated Insights, Calculated Insights in a Data Space.

Individuals who purchased at least one of any red’ product and also purchased at least one pair of ‘shoes’

Individuals who purchased at least one ‘red shoes’ as a single line item in a purchase

Individuals who made a purchase of at least one ‘red shoes’ and nothing else

Individuals who purchased at least one of any ‘red’ product or purchased at least one pair of
‘shoes’

Q51. Which two common use cases can be addressed with Data Cloud?
Choose 2 answers

Understand and act upon customer data to drive more relevant experiences.

Govern enterprise data lifecycle through a centralized set of policies and processes.

Harmonize data from multiple sources with a standardized and extendable data model.

Safeguard critical business data by serving as a centralized system for backup and disaster recovery.

Q52. Cumulus Financial wants to be able to track the daily transaction volume of each of its customers in real time and send out anotification as soon as it detects volume outside a customer’s normal range.
What should a consultant do to accommodate this request?

Use a calculated insight paired with a flow.

Use streaming data transform with a flow.

Use a streaming insight paired with a data action

Use streaming data transform combined with a data action.