Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DC Questions > Data Ingestion and Modeling > Flashcards

Data Ingestion and Modeling Flashcards

1
Q

What is the first step in the two step process to
ingest data from SFMC to Salesforce CDP?

A. Extract marketing Cloud data to customer owned
S3 bucket
B. Extract Marketing cloud data to Salesforce owned
SFTP
C. Extract Marketing Cloud data to Salesforce
owned S3 bucket
D. Extract Marketing Cloud data to customer owned
SFT

A

C. Extract Marketing Cloud data to Salesforce
owned S3 bucket

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the two refresh models available for a
cloud storage data stream?

A. Update
B. Upsert
C. Append
D. Full Refresh

A

B. Upsert
D. Full Refresh

https://help.salesforce.com/s/articleView?id=sf.c360_a_data_stream_schedule.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which data model type in Salesforce CDP defines
interactions with party?

A. Sales Order
B. Transaction
C. Engagement
D. Individual

A

C. Engagement

https://help.salesforce.com/s/articleView?id=sf.c360_a_engagement_data_model.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What modeling format describe the Individual and Contact Point objects?

A. Jagged
B. Normalized
C. Compress
D. De-Normalized

A

B. Normalized

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which field in the recommended source schema is
not editable?

A. Field Label
B. Field API Name
C. Header Label
D. Data Type

A

C. Header Label

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is customizable in Salesforce CDP canonical
model?
A. Objects
B .Objects & Fields
C. Fields
D. Objects, Fields & relationships

A

D. Objects, Fields & relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How can records in a Data Stream object be
updated?

A. Using the edit data stream feature
B. Using data explorer
C. Using API
D. Using a new source file

A

A. Using the edit data stream feature

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which configuration supports separate AWS S3
buckets for data ingestion and activation?

A. Dedicated S3 data source configuration in
Activation Setup
B. Dedicated S3 data source configuration in CDP
setup
C. Separate user credentials for data stream and
activation target
D. Separate user credentials for data stream and
activation

A

C. Separate user credentials for data stream and
activation target

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the relationship between Individual and Contact Point Objects?

A. Many:Many
B. None of the above
C. 1:Many
D. 1:1

A

C. 1:Many
https://trailhead.salesforce.com/content/learn/modules/data-and-identity-in-salesforce-cdp/map-required-objects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Which data model defines the complete set of experiences that customers go through when
interacting with a company?

A. Engagement Data Model
B. Case Data Model
C. Journey Data Model
D. Party Data Model

A

C. Journey Data Model

https://trailhead.salesforce.com/content/learn/modules/customer-360-audiences-data-ingestion-and-modeling/map-your-data-and-define-the-data-model

https://help.salesforce.com/s/articleView?id=sf.c360_a_software_application_data_model.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which Steps should an administrator take if a
successfully configured cloud storage data stream
fails to refresh with a NO FILE FOUND error
message?

A. Check if the file exists in S3 bucket
B. Check permissions are configured for the CDP
user
C. Check permissions are configured for the S3 user
D. Check if cloud storage data source is enabled in
CDP setup

A

A. Check if the file exists in S3 bucket

B. Check permissions are configured for the CDP
user

https://help.salesforce.com/s/articleView?id=sf.c360_a_create_cloud_storage_data_stream.htm&type=5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which 2 characteristics describe the CIM (Cloud
Information Model)?
A. Product sold by salesforce
B. Conceptual model
C. Statistical model
D. Canonical model

A

B. Conceptual model
D. Canonical model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which function does the Copy SOQL button
perform in Data Explorer?

A.Copy SOQL for any formula fields in that object
B. Copy SOQL for the current data view to clipboard
and export
C. Copy SOQL for data export from Salesforce CDP

A

B. Copy SOQL for the current data view to clipboard
and export

https://help.salesforce.com/s/articleView?id=sf.c360_a_view_your_data.htm&language=en_US&type=5#:~:text=Copy%20SOQL,execute%20it%20via%20Developer%20Console.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What should be the type of the Event Time Field while ingesting Engagement data?

A. Mutable
B. Inconsistent
C. Immutable
D. None of the above

A

C. Immutable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How many Business Units under the same Enterprise
ID (EID) can be connected for data ingestion?

A. 1
B. 4
C. 10
D. No hard limit

A

No hard limit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How many Metrics can be present in 1 segment
container?

A. 1
B. 5
C. 10
D. 100

A

A. 1

https://help.salesforce.com/s/articleView?id=sf.c360_a_calculated_insights_in_segments.htm&language=en_US&type=5

17
Q

What does the source sequence reconciliation rule
do in Identity Resolution?

A. Source data from disparate systems across the
enterprise.
B. Reconcile data by data that’s most frequent across
records.
C. Sort data sources in order of most to least preferred
for inclusion in Unified Profile.
D. Includes data from sources where the data is
alphanumerically sequenced.

A

C. Sort data sources in order of most to least preferred
for inclusion in Unified Profile.

https://trailhead.salesforce.com/content/learn/modules/data-and-identity-in-salesforce-cdp/select-identity-resolution-match-rules#:~:text=While%20match%20rules%20are%20used,know%20which%20one%20to%20display

18
Q

Which CDP objects are available as tables via theTableau connector to discover new insights about
customers?

A. Calculated insights
B. Data Model Objects
C. All Objects
D. Unified Profile

A

C. All Objects

https://help.salesforce.com/s/articleView?id=release-notes.rn_direct_data_for_cdp_ga.htm&release=236&type=5

19
Q

Which of the following functions returns the first value from a list that isn’t empty?

A. CONCAT
B. COALESCE
C. REPLACE
D. FIND

A

B. COALESCE

https://help.salesforce.com/s/articleView?id=sf.c360_a_supported_library_functions.htm&type=5

20
Q

What are the two steps of data ingestion in
Salesforce CDP?

A. Map ingested data to existing ingested data objects.
B. Map ingested data to data model with consistent semantics.
C. Preserve data per source schema with ingestion to
data lake.
D. Establish a connection with the source data via REST
API

A

C. Preserve data per source schema with ingestion to
data lake.

B. Map ingested data to data model with consistent semantics

21
Q

In addition to Unified Individual Object, what other object does Salesforce CDP automatically create and manage during the Identity Resolution
process?

A. Unified Lead Objects
B. Unified Contact Point Objects
C. Unified Order Objects
D. Unified Product Objects

A

B. Unified Contact Point Objects

22
Q

Which two types of data can be ingested from Interaction Studio (now called Marketing Cloud Personalization) using the connector?

A. Product Catalog
B. Behavioral Events
C. User Profile
D. Segment Membership

A

B. Behavioral Events
C. User Profile (Customer Profile)

https://help.salesforce.com/s/articleView?id=sf.c360_a_interaction_studio_connector.htm&language=en_US&type=5

23
Q

When can the data types be changed during ingestion?

A. After the DSO is created
B. Before DSO is created
C. Data type can never be changed
D. Data type can be changed at any time

A

B. Before DSO is created

https://help.salesforce.com/s/articleView?id=sf.c360_a_data_types.htm&type=5

24
Q

Which datatype is not supported in Salesforce CDP?

A. Date
B. Boolean
C. Text
D. Number

A

B. Boolean (?)

https://help.salesforce.com/s/articleView?id=sf.c360_a_data_types.htm&type=5

25
Q

How many days of historical data is loaded when B2C Commerce Data Stream is created from the Order Bundle?

A. 90 days
B. 60 days
C. 30 days
D. 10 days

A

C. 30 days

https://help.salesforce.com/s/articleView?id=sf.c360_a_create_commerce_cloud_starter_bundle.htm&type=5

26
Q

Which permission set needs to be added to the salesforce CRM object to be available in Salesforce Data Cloud?

A. Salesforce CDP external connector
B. Salesforce External Integration
C. Salesforce Data Cloud Salesforce Connector Integration
D. Salesforce External Connector

A

C. Salesforce Data Cloud Salesforce Connector Integration

https://help.salesforce.com/s/articleView?id=sf.c360_a_enable_user_permissions_external_salesforce_org.htm&type=5

27
Q

Which of the following are characteristics of
Formulas?

A. Simple logic on a row-based operation
B. Ease of use, self-service
C. Highly reusable content
D. Attribute updated regularly

A

A. Simple logic on a row-based operation
C. Highly reusable content

28
Q

What happens if no file name is specified in AWS S3
data stream during ingestion?

A. The system does not fetch any file and the data
stream shows an error.
B. The system chooses the first file found in the S3
bucket
C. The ingestion setup can’t be completed without
specifying the filename.
D The ingestion setup is completed but the data
stream shows 0 records

A

B. The system chooses the first file found in the S3
bucket

29
Q

Which dependencies need to be
removed before a data stream can be deleted?

A. Data Model
B. Segmentation
C. Calculated Insights
D. Activation

A

A. Data Model
C. Calculated Insights

https://help.salesforce.com/s/articleView?id=sf.c360_a_delete_a_data_stream.htm&language=en_US&type=5

30
Q

How often does subscriber data from Marketing
Cloud Bundles refresh?

A. Every 12 hours
B. Every 15 mins
C. Hourly
D. Daily

A

C. Hourly

https://help.salesforce.com/s/articleView?id=sf.c360_a_data_stream_schedule.htm&language=en_US&type=5

31
Q

In Salesforce CRM, the customer has a custom ‘Customer_Email__c’ object related to standard ‘Contact’ object. Which CDP data model object do you map it to?

A. Contact
B. Custom ‘Customer_Email’ object
C. Contact Point Email
D. Individual

A

C. Contact Point Email

32
Q

Which operator can be used to check if an attribute
value in blank?

A. Is Empty
B. Is Null
C. Is Not Null
D. Has No Value

A

D. Has No Value

https://trailhead.salesforce.com/content/learn/modules/customer-360-audiences-segmentation/create-filtered-segments

33
Q

Which data model in Salesforce CDP defines the future revenue or quantity for an opportunity of the
product family?

A. Party
B. Product
C. Engagement
D. Sales Order

A

D. Sales Order

34
Q

Which formula function should a Data Specialist use to create composite key if the primary key is notavailable in the data stream?

A. UUID
B. SUBTITUTE
C. COALESCE
D. CONCATE

A

D. CONCATE

35
Q

Which of these three CRM objects do reconciliation rules operate across?

A. Contact
B. Party Identification
C. Individual
D. Lead
E. Contact Point Email

A

A. Contact
C. Individual
E. Contact Point Email

36
Q

What is the primary object for an Organization, Individual, Affiliation Group, Member in the Cloud
Information Model?

A. Individual
B. Global Account
C. Party
D. Membership

DC Questions (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions