Real Marketing-Cloud-Intelligence Exam PDF Test Engine Practice Test Questions [Q28-Q45]

Real Marketing-Cloud-Intelligence Exam PDF Test Engine Practice Test Questions

Salesforce Marketing-Cloud-Intelligence Real 2025 Braindumps Mock Exam Dumps

NEW QUESTION # 28
Your client provided the following sources:
Source 1:

Source 2:

Source 3:

As can be seen, the Product values present in sources 2 and 3 are similar and can be linked with the first extraction from 'Media Buy Name' in source1 The end goal is to achieve a final view of Product Group alongside Clicks and Sign Ups, as described below:

Which two options will meet the client's requirement and enable the desired view?

A. Harmonization Center:
Patterns from sources 1 and 3 generate harmonized dimension 'Product'. Data Classification rule, using source 2, is applied on top of the harmonized dimension
B. Overarching Entities:
Source 1: custom classification key will be populated with the extraction of the Media Buy Name.
Source 2: 'Product' will be mapped to Product field and 'Product Group' to Product Name.
Source 3: 'Product' will be mapped to Product field.
C. Parent Child:
All sources will be uploaded to the same data stream type - Ads. The setup is the following:
Source 1: Media Buy Key -- Media Buy Key, extracted product value - Media Buy Attribute.
Source 2: Product - Media Buy Key, Product Group -- Media Buy Attribute.
Source 3: Product - Media Buy Key.
D. Custom Classification: 1
Source 1: Custom Classification key will be populated with the extraction of the Media Buy Name.
Source 2: 'Product' will be mapped to Custom Classification key and 'Product Group' to a Custom Classification level. Exam Timer Source 3: 'Product will be mapped to Custom Classification key. Came

Answer: A,D

Explanation:
To achieve a final view of Product Group alongside Clicks and Sign Ups, we should use:
Option A:
Custom Classification: By using a Custom Classification key populated with the extraction of the Media Buy Name in Source 1, we can then map 'Product' in Source 2 to this key and 'Product Group' to a Custom Classification level. This will allow for grouping and analysis by Product Group, as well as enable the desired view to be created.
Option D:
Harmonization Center: With patterns from Sources 1 and 3, we can create a harmonized dimension 'Product'. Then, by applying a Data Classification rule using Source 2, we can enhance the harmonized dimension. This allows us to align 'Product Group' with the 'Product' from Sources 1 and 3, facilitating an integrated view of Clicks and Sign Ups by Product Group.

NEW QUESTION # 29
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;

A. Option #1 & Option #3
B. Option #2 & Option #3
C. Option #2 & Option #4
D. Option #1 & Option #4

Answer: C

Explanation:
* 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).

NEW QUESTION # 30
A client would like to integrate the following two sources:
Google Campaign Manager:

IAS:

After configuring a Parent-Child relationship between the files, which query should an implementation engineer run in order to QA the setup?

A. Media Buy Type, Media Buy Name, Impressions, Analyzed Impressions
B. Media Buy Name, Impressions
C. Media Buy Type, Analyzed Impressions
D. Creative Name, Impressions, Analyzed Impressions

Answer: A

Explanation:
To QA the Parent-Child relationship setup between Google Campaign Manager and IAS data sources, it is essential to query fields that are common to both sources and that are relevant to the relationship. 'Media Buy Type' and 'Media Buy Name' are common identifiers between the two datasets. 'Impressions' from the Google Campaign Manager and 'Analyzed Impressions' from the IAS data are the metrics that should be compared to ensure they match or correlate as expected due to the Parent-Child relationship. The QA process involves checking that the data is correctly aligned and that the metrics from the parent source (Google Campaign Manager) are properly related to the metrics from the child source (IAS). Reference: Salesforce Marketing Cloud Intelligence documentation on data integration, Parent-Child relationships, and QA procedures for data setup.

NEW QUESTION # 31
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.
How should the "Override Media Buy Hierarchies" checkbox be set in order to meet the client's requirements?

A. It should be checked in Data Stream C
B. It should be checked in Data Stream B
C. It should not be checked in any of the three Data Streams.
D. It should be checked in Data Stream A

Answer: A

Explanation:
If Data Stream C is the source of truth, the "Override Media Buy Hierarchies" checkbox should be checked for Data Stream C. This means that the hierarchy defined within Data Stream C will take precedence over any other media buy hierarchies present in Data Streams A or B. By doing so, it enforces that the hierarchy from the source of truth (Data Stream C) is used throughout the dataset, maintaining the integrity of the hierarchical relationships as defined by the most reliable data source.

NEW QUESTION # 32
Your client would like to create a new harmonization field - Exam Topic.
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client has a requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client's requirement?

A. Transformers
B. Custom Classification
C. Calculated dimensions
D. Fusion
E. Parent Chile

Answer: B

Explanation:
To meet the client's requirement of slicing measurements by 'Exam Topic' values, an Implementation Engineer should use Custom Classification. This feature allows different Exam IDs to be classified into their respective Exam Topics, ensuring that data from all sources can be accurately harmonized and analyzed based on these topics.

NEW QUESTION # 33
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. The data is stored at the workspace level.
C. Pacing - daily rows are being created for every lead and opportunity keys
D. When a data stream type ''CRM - Leads' is created, another complementary 'CRM - Opportunity' is created automatically.

Answer: A,C

NEW QUESTION # 34
A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing Insights and cross-channel marketing activity analysis. Below are details regarding the different data sources and the number of data streams required for each source.

Which three advantages does a client gain from using Calculated Dimensions as the harmonization method for creating the Objective field?

A. Scalability - future data streams that will follow similar logic will be automatically harmonized.
B. Data model restrictions - Calculated Dimensions do not need to adhere to Marketing Cloud Intelligence's data model
C. Processing - creation of Calculated Dimensions will ease the processing time of the data streams it relates to
D. Ease of Maintenance - the logic is written and populated in one centralized place
E. Performance (Performance when loading a dashboard page) should be optimized as the values of calculated dimensions are stored within the database.

Answer: A,D,E

Explanation:
Scalability: Using Calculated Dimensions allows the client to apply the same harmonization logic to future data streams, ensuring consistency and reducing the need for individual adjustments.
Ease of Maintenance: With the logic centralized in Calculated Dimensions, any adjustments or updates are applied in one place, simplifying ongoing management.
Performance: Calculated Dimensions can improve dashboard performance because their values are pre-computed and stored, reducing the need for real-time calculations when loading dashboards.

NEW QUESTION # 35
A client wants to integrate their data within Marketing Cloud Intelligence to optimize their marketing Insights and cross-channel marketing activity analysis. Below are details regarding the different data sources and the number of data streams required for each source.

Which three advantages does a client gain from using Calculated Dimensions as the harmonization method for creating the Objective field?

A. Scalability - future data streams that will follow similar logic will be automatically harmonized.
B. Data model restrictions - Calculated Dimensions do not need to adhere to Marketing Cloud Intelligence's data model
C. Processing - creation of Calculated Dimensions will ease the processing time of the data streams it relates to
D. Performance (Performance when loading a dashboard page) should be optimized as the values of calculated dimensions are stored within the database.
E. Ease of Maintenance - thelogic is written and populated in one centralized place

Answer: A,D,E

Explanation:
* Scalability: Using Calculated Dimensions allows the client to apply the same harmonization logic to future data streams, ensuring consistency and reducing the need for individual adjustments.
* Ease of Maintenance: With the logic centralized in Calculated Dimensions, any adjustments or updates are applied in one place, simplifying ongoing management.
* Performance: Calculated Dimensions can improve dashboard performance because their values are pre-computed and stored, reducing the need for real-time calculations when loading dashboards.

NEW QUESTION # 36
A client provides the following two data streams:
Data Stream 1:

The client would like to use a VLOOKUP formula to calculate the Cost per Campaign Advertiser on January 1st 2020.
Which mapping options should the client apply to obtain the expected result?

Answer: C

Explanation:
To calculate Cost per Campaign Advertiser using a VLOOKUP formula, the client needs to look up the 'Cost' from Data Stream 2 based on a matching 'Media Buy Name' in Data Stream 1. Option A shows that 'Media Buy Name' is the lookup value, which is correct. The 'Campaign Advertiser' is then linked to the 'Cost' from Data Stream 2 through the VLOOKUP formula applied to the 'Media Buy Custom Attribute 01' in Data Stream 2. This setup will correctly associate the cost with the campaign advertiser.

NEW QUESTION # 37
A client's data consists of three data sources - Facebook Ads, LinkedIn Ads and Google Campaign Manager.
Notes:
* The client is planning on adding an additional 100 Facebook Ads data streams and 50 more LinkedIn Ads data streams.
* The final volume of data in the workspace will be 5M rows
* Each data source has a naming convention and it can be assumed that any additional profile (i.e. Data Stream) from one of these sources will follow the same naming convention.
The client provided the following sample files:
Facebook Ads:

The client would like to create a new harmonization field named "Market," which will only be coming from Facebook Ads and LinkedIn Ads. The logic for
"Market" is the following:
IF Media Buy Type is equal to "TypeB" or "TypeC" or "TypeD"
Return 'Europe'
ELSE
Return 'Rest Of The World'
In order to create the harmonization field Market, the client considers using either Mapping Formula, Calculated Dimension, VLOOKUP or Patterns.
Considering maintenance and scalability, which option is recommended?

A. Mapping Formulas
B. Patterns
C. vLookuP
D. Calculated Dimension

Answer: B

Explanation:
Patterns are the best approach in this scenario because:
Scalability: Patterns are highly scalable and can easily handle the addition of 100 more Facebook Ads and 50 more LinkedIn Ads streams. You can define pattern-matching rules that automatically apply to new data streams based on the naming conventions.
Flexibility and Maintenance: Patterns allow you to maintain and adjust logic easily. Since the logic for determining "Market" is based on a defined naming convention (e.g., Media Buy Type), Patterns can handle these rules effectively without requiring manual updates or static tables.
Efficient Harmonization: Patterns automatically classify data based on defined rules, reducing the need for ongoing manual maintenance compared to approaches like VLOOKUP or Mapping Formulas, which might require frequent updates as data changes.
Why not other options?
Mapping Formulas: While Mapping Formulas work well for static mappings, they are not as scalable or maintainable when the dataset grows or changes frequently.
Calculated Dimension: This option is valid for simple logic but is less maintainable for large-scale datasets, especially when new data streams are added.
VLOOKUP: This method is manual and not scalable. It would require you to update lookup tables for each new data stream, which is inefficient given the expected growth of the data.

NEW QUESTION # 38
Client has provided sample flies of their data from the following data sources:
Google Campaign Manager

Below are the requirements from the client and additional information:
* The sources are linked to each other by shared Media Buy names.
* In addition-to the mutual Media Buys, the sources contain campaign and site values. However, the client would like to see the campaign/site values coming from Google CM and not from Google DV360.
* The source of truth for cost is Google DV360.
As a first step, a Parent-Child relationship was created between the two files, and the following mapping was performed, within both data streams:

Please note:
* All other measurements were mapped as well to the appropriate fields.
* No other mapping manipulations or formulas were implemented.
How many records will the merged table hold?

A. 0
B. Depends on the Data Updates Permissions
C. 1
D. 2

Answer: C

Explanation:
Since the data sources are linked by shared Media Buy names and all other measurements are mapped to appropriate fields without additional manipulations, each unique Media Buy Name from Google DV360 will pair with its corresponding Media Buy Name in Google Campaign Manager. The number of records in the merged table will equal the number of unique Media Buy Names in Google DV360, provided there is a matching name in Google Campaign Manager. The sample shows 4 unique Media Buy Names in Google DV360, thus resulting in 4 records.

NEW QUESTION # 39
An implementation engineer has been provided with the below dataset:

*Note: CPC = Cost per Click
Formula: Cost / Clicks
Which action should an engineer take to successfully integrate CPC?

A. Populate the logic within a custom measurement. Set Aggregation to SUM.
B. Populate the logic within a custom measurement. Set Aggregation to AVG.
C. Unmap it, as Datorama will calculate it automatically.
D. Populate the logic within a custom measurement. No need to change Aggregation.

Answer: D

Explanation:
CPC (Cost per Click) is a calculated metric that should be created using a custom measurement based on the formula provided (Cost / Clicks). This calculation does not require a change in the aggregation setting because it is derived from other base metrics that are already aggregated appropriately. In Salesforce Marketing Cloud Intelligence, custom measurements are used to create new metrics from existing data points, and the system will use the underlying data's aggregation to perform the calculation. Reference: Salesforce Marketing Cloud Intelligence documentation on creating custom measurements and calculated metrics.

NEW QUESTION # 40
Which Marketing Cloud Intelligence field is considered an attribute and not a "variable"?

A. Geo Location
B. Device Category
C. Device Browser
D. Campaign Category

Answer: B

Explanation:
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.

NEW QUESTION # 41
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. Confirmed Interest & Registered
B. Interest & Registered
C. Confirmed interest
D. interest

Answer: B

Explanation:
Filtering the pivot table on January 7th-11th, we see that the Opportunity Key 123AA01 appears on January 6th with the stage 'Interest' and then on January 10th with the stage 'Registered'. Even though the 'Interest' stage is not within the filtered dates, it is the initial stage of the opportunity, so it should be counted along with the 'Registered' stage which falls within the filter range.

NEW QUESTION # 42
Which option will yield the desired result:?

A. Option 1
B. Option 4
C. Option 3
D. Option 2

Answer: B

Explanation:
Option 4 presents two calculated measurements for 'Group Min Cost' with 'MIN' and 'AVG' aggregations. This approach aligns with the client's need for the minimum and average media cost values. 'Group Min Cost 4 MIN' will calculate the minimum media cost across the 'Media Buy Key', while 'Group Min Cost 4 FINAL' will average these minimum costs at the 'Campaign Key' level. This will yield the desired result where minimum costs are calculated at the Media Buy Key level and then averaged at the Campaign Key level.

NEW QUESTION # 43
The following file was uploaded into Marketing Cloud Intelligence as a generic dataset type:

The mapping is as follows:
Day - Day
Web_site_source - Main Generic Entity Attribute 01
Page Views - Generic Metric 1
*Note that 'web_site_key' and 'web_site_name' are NOT mapped.
How many rows will be stored in Marketing Cloud Intelligence after the above file is ingested?

A. 0
B. 1
C. 2
D. 3

Answer: B

Explanation:
In Marketing Cloud Intelligence, when a file is uploaded as a generic dataset type and mapped accordingly, each unique combination of the mapped fields results in a separate row in the database. The file in question has been mapped with 'Day' to 'Day', 'Web_site_source' to 'Main Generic Entity Attribute 01', and 'Page Views' to 'Generic Metric 1'. The 'web_site_key' and 'web_site_name' are not mapped and thus, won't affect the row count.
Since there are 4 unique combinations of the mapped fields in the uploaded file (each day and source combination is unique), Marketing Cloud Intelligence will store 4 rows after ingestion, corresponding to each unique combination of 'Day' and 'Web_site_source'.

NEW QUESTION # 44
Your client would like to create a new harmonization field - Exam Topic.
The below table represents the harmonization logic from each source.

As can be seen from the table there are in fact two fields that hold a certain connection: Exam ID and Exam Topic. The connection indicates that where an Exam ID is found -a single Exam Topic value is associated with it.
The Client hasa requirement to be able to view measurements from all data sources sliced by Exam Topic values as seen in the following example:

Which harmonization feature should an Implementation engineer use to meet the client's requirement?