Page: 1
/ 14
Total 63 questions
Salesforce Marketing Cloud Intelligence Accredited Professional Exam Practice Test
Question 1
Which Marketing Cloud Intelligence field is considered an attribute and not a ''variable''?
Answer : B
In Marketing Cloud Intelligence, attributes refer to characteristics of the data that describe the environment or context but do not change within the scope of the data being analyzed. 'Device Category' is typically an attribute as it describes a characteristic of the device used and doesn't vary within a given session or user interaction. In contrast, variables are typically metrics or dimensions that can change value or be measured.
Question 2
An implementation engineer has been asked to perform a QA for a newly created harmonization field, Color, implemented by a client.
The source file that was ingested can be seen below:
The client performed the below standard mapping:
As a final step, the client had created the field 'Color'. As can be seen, it is extracted from the Creative Name (after the '#' sign).
For QA purposes, you have queried a pivot table, with the following fields:
* Media Buy Key
* Media Buy Name
* In View Impressions
The final pivot is presented below:
Answer : D
Given that the 'Color' field is extracted from the 'Creative Name' field and appears to be part of the creative-level data, the most logical method would be to create an EXTRACT formula and map it to a Creative custom attribute. This allows the 'Color' value to be associated directly with each creative entry. In Salesforce Marketing Cloud Intelligence, the EXTRACT formula can be used to parse and segment text strings within a field, and this process is used for harmonizing data by creating new dimensions or attributes based on existing data, which is what's described here. This answer is consistent with Salesforce Marketing Cloud Intelligence features that enable data transformation and harmonization through formulaic mapping, as per the official Salesforce documentation on data harmonization and transformation.
Question 3
Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?
Answer : A, B
Variable dimensions in Marketing Cloud Intelligence's data model are flexible and can be associated with multiple entities, forming a many-to-many relationship. These dimensions are configured and stored at the workspace level, allowing for customization and alignment with specific reporting needs and analytics practices.
Question 4
What is the relationship between "Media Buy Key" and "Creative Key?
Answer : A
In Marketing Cloud Intelligence, the 'Media Buy Key' is typically associated with the purchase details of a media campaign, such as the platform, audience, and budget. The 'Creative Key' relates to the specific creative asset used within a campaign, like an image, video, or text. A single media buy can have multiple creative variations to test performance or to target different audiences, leading to a one-to-many relationship.
Question 5
An Implementation engineer is requested to create a new harmonization field 'Offer' and apply the following logic:
The implementation engineer to use the Harmonization Center. Which of the below actions can help implement the new dimension 'Offer?
Answer : B
To implement the new harmonization field 'Offer', the implementation engineer would create two separate harmonization patterns for LinkedIn and AdRoll sources, extracting the 'Campaign Name' using the specified delimiter and position. Then, within Google Analytics' mapping, a custom attribute for the 'Campaign' would be created to apply the formula logic based on the source. This allows for the harmonization of campaign data across different platforms, ensuring consistency in the reporting and analysis within Marketing Cloud Intelligence. The total patterns required would be three, one for each data source involved.
Question 6
An implementation engineer is requested to extract the second position
of the Campaign Name values.
The Campaign values consist of multiple delimiter types, as can be
seen in the following example:
Campaign Name: Ad15X2w&Delux_wal90
Desired value: Delux
Which three harmonization methods will achieve the desired outcome?
Answer : A, B, E
To extract specific elements from a string in Marketing Cloud Intelligence, such as the second position of a Campaign Name with multiple delimiters, several harmonization methods can be employed:
Calculated Dimensions: These allow for the creation of custom dimensions using expressions or formulas that manipulate existing data. A calculated dimension can be designed to parse and extract segments of a string based on delimiters.
Patterns: This method involves defining a pattern or regex (regular expression) that matches and isolates the desired portion of the string. Patterns are highly effective for strings with complex structures and varying delimiter types.
Mapping Formula: Similar to calculated dimensions, mapping formulas provide a way to apply a transformation or extraction rule to data fields directly within data streams, enabling targeted data extraction like the desired 'Delux' from the Campaign Name.
These methods enable the implementation engineer to accurately segment and extract the needed data from complex string fields efficiently.
Question 7
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'' --- Main Generic Entity Attribute
''Opportunity Count'' --- Generic Custom Metric
A pivot table was created to present the count of opportunities in each stage. The pivot table is filtered on Jan 11th. What is the number of opportunities in the Interest stage?
Answer : D
Since the pivot table is filtered on January 11th and the provided Opportunity file does not show any records dated January 11th, there are zero opportunities in the Interest stage for that date. Salesforce Marketing Cloud Intelligence allows users to create pivot tables and filter data based on specific criteria, such as dates. In this case, the filter would exclude all rows that do not match the specified date, resulting in a count of zero for the Interest stage. This would apply to any stage since there are no records for January 11th. Reference can be made to Salesforce Marketing Cloud Intelligence documentation on filtering and pivot tables.
All Official Question Types