Salesforce Marketing Cloud Intelligence Accredited Professional (AP-215) Exam Questions Instant Access

Question 1

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 assume that the file is mapped in the OPPORTUNITIES Data Stream type with the following mapping:

''Day'' --- ''Created Date''

''Opportunity Key'' + Opportunity Key

''Opportunity Stage'' --- Opportunity Stage

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 Confirmed Interest stage?

Answer : D

pivot table is filtered on January 11th, we refer to the Opportunity file and see that there are no records for January 11th. Thus, there would be zero opportunities in the Confirmed Interest stage on that date. The Salesforce Marketing Cloud Intelligence's pivot table feature allows for the display of counts of entities based on the filtered criteria, which in this scenario would show zero since no records exist for the filtered date. Reference: Salesforce Marketing Cloud Intelligence documentation on pivot table functionalities.

Question 2

What Is a disadvantage of using a Vlookup formula?

ACan return values only from the same data stream type

BIt cannot be used more than once from the same data stream.

CCould extend processing time of data streams.

DIt allows classifying data only on a basis of mutual entity keys.

Answer : C

The use of VLOOKUP formulas can increase the processing time of data streams because it requires a lookup operation for each row in the data set. When large volumes of data are involved, or when multiple VLOOKUPs are used, this can significantly impact processing time due to the complexity and computational requirements of matching and retrieving the data.

Question 3

Which two statements are correct regarding LiteConnect?

AIt does not require any identification of entities, keys or any other categorization.

BThe dataset does not conform to the standard data model

CAll of the dimensions mapped within a LiteConnect data stream are considered overarching entities.

DData coming from LiteConnect cannot be harmonized with the rest of the workspace data via the harmonization center at a later step.

Answer : A, B

LiteConnect is a feature in Salesforce Marketing Cloud Intelligence that allows users to bring external data into the platform quickly and easily. Here are the correct statements regarding LiteConnect:

A . LiteConnect allows for a quick setup by not requiring detailed identification of entities, keys, or categorization. Users can upload files without having to conform to the standard data model, which speeds up the process of data integration.

B . With LiteConnect, datasets are uploaded in their native format and do not conform to the standard data model of Marketing Cloud Intelligence. This means that the original structure of the dataset is maintained, and there is no need for extensive transformation or mapping upon the initial data import.

For C and D: While LiteConnect datasets might not conform to the standard data model initially, there are capabilities within Marketing Cloud Intelligence to further categorize and harmonize this data if needed. Therefore, C is not entirely correct, and D is incorrect because harmonization can indeed occur at a later step.

Question 4

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

APerformance

BEase of setup

CEase of maintenance

DScalability

Answer : A

In a workspace with a high number of data streams, such as one hundred, the biggest downside of using calculated dimensions is the performance impact. Calculated dimensions require computational resources to dynamically compute values based on existing data. This can lead to increased load times and slower performance, especially in environments with large amounts of data or complex calculations. This performance degradation is due to the extra processing power needed every time the data is accessed or refreshed, impacting the overall efficiency of data retrieval and analysis operations.

Question 5

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 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

A client's data consists of three data streams as follows:

Data Stream A:

The data streams should be linked together through a parent-child relationship.

Out of the three data streams, Data Stream C is considered the source of truth for both the dimensions and measurements.

The client would like to have a "Site Revenue" measurement.

This measurement should return the highest revenue value per Site, for example:

For Site Key 'SK_C_2', the "Site Revenue" should be $7.00.

When aggregated by date, the "Site Revenue" measurement should return the total sum of the results of all sites.

For example:

For the date 1 Apr 2020, "Site Revenue" should be $11.00 (sum of Site Revenue for Site Keys 'SK_C_1' ($4.00) and 'SK_C_2' ($7.00))

Which options will yield the desired result;

AOption #1 & Option #4

BOption #1 & Option #3

COption #2 & Option #3

DOption #2 & Option #4

Answer : D

Option #2: It suggests using the 'SUM' function to aggregate the 'Site Revenue' for each 'Site Key'. This is necessary to ensure that when aggregated by date, 'Site Revenue' should return the total sum of the highest revenue for all sites.

Option #4: It indicates changing the Aggregation Function of Revenue to 'MAX' within Data Stream C. This ensures that for a given 'Site Key', the highest revenue value is selected, which is correct for individual site revenue determination.

Combining Option #2 and Option #4 will provide the desired result:

For an individual 'Site Key', it will give the highest revenue (using MAX aggregation in Option #4).

When aggregating by date across all 'Site Key's, it will sum the highest revenues (using the SUM function in Option #2).