Full Marketing-Cloud-Intelligence Practice Test and 63 Unique Questions, Get it Now!
The Best Marketing-Cloud-Intelligence Exam Study Material Premium Files and Preparation Tool
NEW QUESTION # 14
A client has integrated data from Facebook Ads. Twitter ads, and Google ads in marketing Cloud intelligence.
For each data source, the source, the data follows a naming convensions as ...
Facebook Ads Naming Convention - Campaign Name:
CampID_CampName#Market_Object#object#targetAge_TargetGender
Twitter Ads Naming Convention- Media Buy Name
MarketTargeAgeObjectiveOrderID
Google ads Naming Convention-Media Buy Name:
Buying_type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization Center. Given the above information, which statement is correct regarding the ability to implement this request?
wet Me - Given the above information, which statement i 's Correct regarding the ability to implement this request?
- A. The client will be able to do this and it will require building three patterns.
- B. The clientWi-Fibe able to harmonize only Google Ads and Twitter Ads, as Facebook Ads naming convention contains mufti delimiters.
- C. it is not possible to do this, as the naming conventions are different
- D. This is not possible as the naming conventions are in different fields (Campaign Name and Placement Name)
Answer: A
Explanation:
Despite the different naming conventions, harmonization is possible using patterns in the Harmonization Center. By extracting the 'Market' and 'Objective' components from the naming conventions of each platform, three separate patterns would be created to map these common fields consistently across the data from Facebook Ads, Twitter Ads, and Google Ads.
NEW QUESTION # 15
What Is a disadvantage of using a Vlookup formula?
- A. It cannot be used more than once from the same data stream.
- B. Could extend processing time of data streams.
- C. Can return values only from the same data stream type
- D. It allows classifying data only on a basis of mutual entity keys.
Answer: B
Explanation:
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.
NEW QUESTION # 16
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:
- A. An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.
- B. A Harmonized dimension was created via a pattern over the Creative Name.
- C. A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
- D. An EXTRACT formula (for Color) was written and mapped to a Media Buy custom attribute.
Answer: A
Explanation:
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.
NEW QUESTION # 17
What areunstable measurements?
- A. Measurements for which Aggregation Settings are set as 'Not Auto' and Granularity is set as 'None'.
- B. Measurements that are set with the LIFETIME aggregation function
- C. Measurements for which Aggregation Settings are set as 'Auto' and Granularity is set as 'None'.
- D. Measurements for which Aggregation Settings are set as 'Not Auto' and Granularity is set as 'Not Empty'.
Answer: A
Explanation:
Unstable measurements refer to metrics that are not aggregated in a standard manner across different grains of data, which can result in inconsistent or unpredictable results when reporting across different dimensions or time frames.
* Option C describes a scenario where measurements have manual (Not Auto) aggregation settings, meaning they do not automatically adjust to theaggregation level of the report. Combined with a Granularity setting of 'None', this can lead to instability because the metric isn't bound to a specific granularity, which can cause data inconsistencies or misinterpretations when analyzed at varying levels of detail.
NEW QUESTION # 18
Which three statements describe Overarching Entities? 03m 23s
- A. Some overarching entities hold a Many-to-Many relationship with the main entity, and others hold a One-to-Many relationship with it.
- B. The values of these entities are stored at the workspace level, rather than the data stream level
- C. When needed, these entities can act as a main entity, replacing the original one.
- D. Once the data streams in which Custom Classification values were mapped are deleted, their data is deleted.
- E. These are mappable dimensions that are present in each and every dataset type
Answer: A,B,C
Explanation:
Overarching Entities in Salesforce Marketing Cloud Intelligence are designed to provide a high level of data organization that spans across multiple data streams. The key points about Overarching Entities are:
* B. Relationship Types: Overarching entities can have either a Many-to-Many or One-to-Many relationship with the main entity, which allows for flexible data modeling and relationship definitions based on the nature of the data and how it should be analyzed and reported.
* C. Acting as Main Entity: They can serve as a main entity in certain situations, enabling a shift in perspective for data analysis. This can be particularly useful when there is a need to view data from a different dimension that is more aligned with business requirements.
* E. Storage Level: The values of these entities are not tied to any single data stream but are maintained at a workspace level, ensuring that they can be applied consistently across different datasets, which is critical for maintaining data integrity and ensuring that classifications are applied uniformly.
NEW QUESTION # 19
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
"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
7th - 10th. How many different stages are presented in the table?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Based on the Opportunity file and considering the filter dates from January 7th to 10th, the different stages presented are 'Interest', 'Confirmed Interest', and 'Registered'. This makes a total of 3 different stages that would be presented in the pivot table. Salesforce Marketing CloudIntelligence allows for the creation of pivot tables that can display counts of entities across different dimensions, in this case, Opportunity Stages.
Reference to Salesforce Marketing Cloud Intelligence documentation that covers data mapping and pivot table creation would support this conclusion.
NEW QUESTION # 20
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 Confirmed Interest stage?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Based on the data provided and the date filter set to January 11th, there are no records for 'Confirmed Interest' on that specific date in the Opportunity file. Thus, the number of opportunities in the 'Confirmed Interest' stage for January 11th would be zero (0). In Salesforce Marketing Cloud Intelligence, when creating pivot tables, the data is aggregated based on the selected filters. If no records meet the filter criteria, the result for that category would be zero. The answer is supported by best practices in data analysis and reporting within Salesforce Marketing Cloud Intelligence, where date filters are applied to segment and analyze data.
NEW QUESTION # 21
A client provides the following two data streams:
Data Stream 1:
Question-
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?
- A.
- B.
- C.
- D.
Answer: A
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 # 22
An implementation engineer has been asked by a client for assistance with the following problem:
The below dataset was ingested:
However, when performing QA and querying a pivot table with Campaign Category and Clicks, the value for Type' is 4.
What could be the reason for this discrepancy?
- A. The measurement 'Clicks' is set as a percentage.
- B. The aggregation function is set as AVG
- C. The aggregation function is set as LIFETIME
- D. A mapping formula was populated, indicating not to bring Type! values.
Answer: B
Explanation:
The discrepancy of 'Clicks' being reported as 4 for 'Type1' when the sum of clicks in the dataset for 'Type1' is
8 (2 on 02/02/2021 and 6 on 03/02/2021) suggests that the aggregation function used in the pivot table is set to average (AVG) rather than sum. Salesforce Marketing Cloud Intelligence allows setting different aggregation functions for metrics, and setting it to average would result in such a discrepancy when more than one entry for the same type exists. References: Salesforce Marketing Cloud Intelligence documentation on custom measurements and data aggregations explains how to set and understand different aggregation functions.
NEW QUESTION # 23
Aclient has integrated 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 Assigned) alongside 'Employee Name' and/or
'Squad'.
The client set the following properties:
+ File Ais set as the Parent data stream
* Both files were uploaded to a generic data stream type.
* Override Media Buy Hierarchies is checked for file A.
* The 'Data Updates Permissions' set for file B is 'Update Attributes and Hierarchy'.
When filtering on the entire date range (1-30/8), and querying employee ID, Name and Squad with the two measurements - what will the result look like?
- A.
- B.
- C.
- D.
Answer: B
Explanation:
In Marketing Cloud Intelligence, when linking two data streams, the parent data stream (File A) provides the main structure. Since 'Override Media Buy Hierarchies' is checked for File A, the hierarchies from File B will be aligned with File A. Given 'Data UpdatesPermissions' set for file B as 'Update Attributes and Hierarchy', this means that attributes and hierarchy will be updated in the parent file based on the child file (File B), but the child file's metrics won't be associated with the parent file's date.
Hence, when filtering on the entire date range (1-30/8), the resulting view will align with the structure of the parent data stream, showing the KPIs ('Tasks Completed' from File A and 'Tasks Assigned' from File B) alongside the employee names and squads from the respective files. Since the employee IDs align, the data can be linked properly. However, since the dates do not align (File A data is from 01/08/2019 and File B from
15/08/2019), only attributes from File B will be updated without date association.
The result will look like Option C, where the employee names are corrected based on File B's data, the squads are added from File B, and the tasks_completed and tasks_assigned are displayed from their respective files.
The tasks_assigned from File B are shown without date association as File B's date doesn't match with File A's.
NEW QUESTION # 24
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'opportunitiesin the Confirmed Interest stage?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
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.
NEW QUESTION # 25
Your client is interested in ingested the below file to a new generic data stream type:
The field 'Meeting Code' was mapped to the main entity key. 'How should the 'Room Number' be mapped?
- A. A separate entity key
- B. An attribute of 'Meeting Code'
- C. A custom metric and set aggregation to SUM
- D. A custom metric and set aggregation to AUTO
Answer: B
Explanation:
In Marketing Cloud Intelligence, when a field is mapped to the main entity key, other related fields should be mapped as attributes of that key if they provide additional descriptors or details. Since 'Room Number' is related to 'Meeting Code', it would be an attribute of the'Meeting Code' entity, providing additional context to the meetings without serving as a metric or a separate entity key.
NEW QUESTION # 26
Your client has provided sample files 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
Which action(s) are needed to take place in order to meet the client's requirement and set Google DV360 as the source of truth for Cost?
- A. Set Update Attributes and Hierarchies' as the Data updates Permissions for Google DV360
- B. Unmap 'Cost' in Google Campaign Manager
- C. Unmap 'Cost' in Google DV360
- D. Set 'Inherit Attributes and Hierarchies' as the Data updates Permissions for Google DV360
Answer: B
Explanation:
To set Google DV360 as the source of truth for cost:
* The cost data from Google DV360 should be prioritized, which means ensuring that the 'Cost' field in Google Campaign Manager is not mapped or is mapped with less priority compared to Google DV360.
* Given that DV360 is to be the source of truth, you do not want competing cost data from Campaign Manager. Unmapping 'Cost' in Google Campaign Manager prevents conflicting data between the two sources and upholds the integrity of the cost data coming from Google DV360.
NEW QUESTION # 27
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. 1
- C. Depends on the Data Updates Permissions
- D. 2
Answer: D
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 # 28
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?
- A. Any one of the files can potentially be set as the Parent data stream
- B. The two files cannot be joined as they hold different dates
- C. The join can be successful even if "empjd' isn't mapped and employee.name' is mapped to the same entity name in both data streams
- D. The two files were uploaded to a different Generic type
- E. The two files cannot be Joined as they hold different measurements
Answer: A,C
Explanation:
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.
NEW QUESTION # 29
A client has integrated data from Facebook Ads, Twitter Ads, and Google Ads in Marketing Cloud Intelligence. For each data source, the data follows a naming convention as shown below:
Facebook Ads Naming Convention - Campaign Name:
Camp|D_CampName#Market_Objective#TargetAge_TargetGender
Twitter Ads Naming Convention - Media Buy Name:
Market|TargetAge|Objective|OrderID
' Google Ads Naming Convention - Media Buy Name:
Buying Type_Market_Objective
The client wants to harmonize their data on the common fields between these two platforms (i.e. Market and Objective) using the Harmonization 'Center.
In addition to the previous details, the client provides the following data sample:
Logic specification:
If a value is not present in the Validation List, return "Not Valid"
If a value is not present in the Classification File, return "Unclassified".
If the Harmonization center is used to harmonize the above data and files, what table will show the final output?
- A.
- B.
- C.
- D.
Answer: A
Explanation:
The correct table would be Option B. The harmonization process would identify the 'Market' from the campaign or media buy name based on the delimiter and position rules specified in the naming conventions.
The harmonized 'Market' would then be matched against the classification file and validation list. If a value does not match the validation list, it would return 'Not Valid', and if it's not present in the classification file, it would return 'Unclassified'. Option B is the only table showing the 'Not Valid' category which aligns with the logic specification provided.
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 Name, Impressions
- B. Media Buy Type, Analyzed Impressions
- C. Media Buy Type, Media Buy Name, Impressions, Analyzed Impressions
- D. Creative Name, Impressions, Analyzed Impressions
Answer: C
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). References: Salesforce Marketing Cloud Intelligence documentation on data integration, Parent-Child relationships, and QA procedures for data setup.
NEW QUESTION # 31
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: C
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 # 32
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.
Assuming the data was ingested properly and the Parent Child was created correctly according to the client's requirements, what is the total Impressions value for Campaign Key 'CK_3'?
- A. N-A
- B. 0
- C. 1
- D. 2
Answer: B
Explanation:
Assuming that Data Stream A is set correctly with parent-child relationships:
* To find the total impressions for Campaign Key 'CK_3', you would look in Data Stream A, since it contains the 'Impressions' metric.
* As per the provided data, Campaign Key 'CK_3' has 100 impressions.
NEW QUESTION # 33
......
Get Instant Access to Marketing-Cloud-Intelligence Practice Exam Questions: https://actual4test.practicetorrent.com/Marketing-Cloud-Intelligence-practice-exam-torrent.html