Salesforce Marketing Cloud Intelligence Accredited Professional Sample Questions:

1. A client's data consists of three data streams as follows:
Data Stream A:

A) Inherit Attributes and Hierarchies
B) Update Attributes
C) It doesn't matter. As long as Data stream A is set as a Parent', the rest of the Data Updates Permissions are irrelevant.
D) Update Attributes and Hierarchies

2. A technical architect is provided with the logic and Opportunity file shown below:
The opportunity status logic is as follows:
For the opportunity stages "Interest", "Confirmed Interest" and "Registered", the status should be "Open".
For the opportunity stage "Closed", the opportunity status should be closed.
Otherwise, return null for the opportunity status.

Given the above file and logic and assuming that the file is mapped in a GENERIC data stream type with the following mapping:
"Day" - Standard "Day" field
"Opportunity Key" > Main Generic Entity Key
"Opportunity Stage" - Generic Entity key 2
A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 7th -11th.Which option reflects the stage(s) the opportunity key 123AA01 is associated with?

A) interest
B) Confirmed Interest & Registered
C) Confirmed interest
D) Interest & Registered

3. An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.
For example:
Campaign Name: AFD@Mulop-1290
Desired outcome: AFD
Other examples:

Which formula will return the desired values?

A) EXTRACT(csv[campaign_name'],-,0)
B) EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
C) LEFT(EXTRACT(csy['campaign_name]],~',0),3)
D) EXTRACT(csv[campaign_name!;@',1)
E) LEFT(EXTRACT(csv[campaign_name'}/-',1),3)

4. Ina workspace that contains one hundred data streams and a lot of data, what is the biggest downside of using calculated dimensions?

A) Scalability
B) Ease of maintenance
C) Performance
D) Ease of setup

5. What are two potential reasons for performance issues (when loading a dashboard) when using the CRM data stream type?

A) No mappable measurements - all measurements are calculated
B) When a data stream type ''CRM - Leads' is created, another complementary 'CRM - Opportunity' is created automatically.
C) The data is stored at the workspace level.
D) Pacing - daily rows are being created for every lead and opportunity keys

Solutions: