Salesforce Marketing Cloud Intelligence Exam Practice Test Instant Access

Question 1

An implementation engineer has been asked to perform QA for a standard file ingestion, done by the client.

The source file that was ingested can be seen below:

The number of rows added to this data stream is 3. What could have led to this discrepancy?

AAll fields are mapped except for the Media Buy Key.

BAll fields are mapped except for the Creative Name

CAll fields are mapped except for the Media Buy Name.

DAll fields are mapped except for the Campaign Key

Answer : D

The source file shows data related to media buys, including a 'Media Buy Key', 'Media Buy Name', 'Campaign Key', and 'Site Key', among other fields. If only three rows were added, and the discrepancy is due to a missing field, it's likely that 'Campaign Key' is the field not mapped, because it is crucial for linking related records in the data stream. Without the 'Campaign Key', the system cannot associate the media buy data with specific campaigns, leading to a potential loss of data rows during ingestion.

Question 2

An implementation engineer is requested to integrate the following files:

File A:

File B:

The client would like to link the two files in order to view the two KPIS (Tasks Completed' and 'tasks Assignmed') alongside'Employee Name' and/or 'Squard'.

A Parent-Child configuration was set between the two.

Which two statements are correct?

AThe two files cannot be Joined as they hold different measurements

BThe two files cannot be joined as they hold different dates

CThe join can be successful even if 'empjd' isn't mapped and employee.name' is mapped to the same entity name in both data streams

DAny one of the files can potentially be set as the Parent data stream

EThe two files were uploaded to a different Generic type

Answer : C, D

In Marketing Cloud Intelligence, joining two files requires a common field to be mapped as the same entity. If 'employee_name' is consistently mapped across both data streams, it can serve as the basis for the join, regardless of whether 'employee_id' is mapped. The choice of which file serves as the Parent stream depends on the use case and the desired reporting structure, but technically, either could serve as the Parent.

Question 3

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?

ATwo separate patterns (filtered by Linkedin or AdRoll sources)
Within Google Analytics' mapping A formula that reflects the logic above will be populated within a Web Analytics Site custom attribute
Another pattern to be created for the newly Web Analytics Site custom attribute (filtered by Google Analytics source).
A total of 3 patterns.

BTwo separate patterns (filtered by Linkedin or AdRoll sources)
Within Google Analytics' mapping: A formula that reflects the logic above will be populated within a Campaign custom attribute.
Another pattern to be created for the newly campaign attribute (filtered by Google Analytics source).
A total of 3 patterns

CTwo separate patterns (filtered by Linkedin or AdRoll sources).
Another single pattern for Campaign Name (filtered by Google Analytics source).
A total of 3 patterns.

DTwo separate patterns (filtered by Linkedln or AdRoll sources).
Another single pattern for Web Analytics Site Source (filtered by Google Analytics source), extracting all three positions A total of 3 patterns.

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 4

Which two statements are correct regarding variable Dimensions in marketing Cloud intelligence's data model?

AThese dimensions are stored at the workspace level

BVariable Dimensions hold a Many-to-Many relationship with its main entity

CAll variables exist in every data set type, hence are considered as overarching dimensions

DThese are stand alone dimensions that pertain to the data set itself rather than to a specific entity

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 5

What is the relationship between "Media Buy Key" and "Creative Key?

AOne-to-many (one Media Buy ley has many Creative Key)

BOne-to-one

CMany-to-many

DMany-to-one (one Creative Key has many Media Buy Keys)

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 6

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.

Question 7

What is the relationship between ''Media Buy Key'' and ''Campaign Key''?

AMany-to-one (one Campaign Key has many Media Buy Keys)

BMany-to-many

COne-to-many (one Media Buy Key has many Campaign Keys)

DOne-to-one

Answer : A

Typically, 'Campaign Key' is a unique identifier for a specific marketing campaign, while 'Media Buy Key' refers to the purchases of advertising space associated with that campaign. A campaign can have multiple media buys, so the relationship is many-to-one, with many media buys (Media Buy Keys) associated with a single campaign (Campaign Key).

Salesforce Marketing Cloud Intelligence Accredited Professional Exam Practice Test