練習できるMarketing-Cloud-Intelligence問題には認定ガイド問題と解答とトレーニングを提供しています
無料Salesforce Marketing-Cloud-Intelligenceテスト練習問題試験問題集
質問 # 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" + 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. Interest & Registered
- B. Confirmed Interest & Registered
- C. Confirmed Interest
- D. Registered
- E. Interest
正解：A
解説：
Analyzing the Opportunity file with a filter set from January 7th to 11th, Opportunity Key '123AA01' appears under 'Interest' on January 6th and 8th, and under 'Registered' on January 10th. Therefore, during the specified date range, Opportunity Key '123AA01' is associated withboth 'Interest' and 'Registered' stages. Salesforce Marketing Cloud Intelligence provides the capability to map and track opportunity stages over time, allowing for historical stage tracking and reporting. This answer aligns with the ability to use pivot tables to filter and display data by specific attributes and timeframes, as outlined in the Salesforce Marketing Cloud Intelligence documentation.
質問 # 21
A client's data consists of three data streams as follows:
Data Stream A:
- A. Update Attributes
- B. Update Attributes and Hierarchies
- C. Inherit Attributes and Hierarchies
- D. It doesn't matter. As long as Data stream A is set as a Parent', the rest of the Data Updates Permissions are irrelevant.
正解：C
解説：
For the client's data consisting of three data streams, setting Data Stream A as the Parent allows for inheriting attributes and hierarchies from it to the child data streams. This ensuresconsistency across the data streams, making it possible to analyze the data collectively, using the structure and attributes defined in the Parent data stream.
質問 # 22
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
正解：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.
質問 # 23
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 Media Buy custom attribute.
- B. An EXTRACT formula (for Color) was written and mapped to a Creative custom attribute.
- C. A Harmonized dimension was created via a pattern over the Creative Name.
- D. A calculated dimension was created with the formula: EXTRACT([Creative_Namel, #1)
正解：B
解説：
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.
質問 # 24
Aclient's data consists of three data streams as follows:
* 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.
Which data stream should be set as a parent?
- A. Data Stream A
- B. Data Stream B
- C. Data Stream C
- D. Any of the data streams can technically be the parent
正解：C
解説：
Since Data Stream C is considered the source of truth for both dimensions and measurements, it should be set as the parent data stream. This is because the parent data stream is used as the primary source for hierarchical and attribute data within a parent-child relationship setup. As the source of truth, Data Stream C will provide the foundational data upon which the other streams can be aligned and will ensure consistency and accuracy across the linked data.
質問 # 25
Which Marketing Cloud Intelligence field is considered an attribute and not a "variable"?
- A. Campaign Category
- B. Device Browser
- C. Device Category
- D. Geo Location
正解：C
解説：
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.
質問 # 26
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
正解：A
解説：
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.
質問 # 27
Animplementation engineer has been provided with 4 different source files: 03m 48s
1. Twitter Ads ~
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:
Creative ID - links back to Creative Key (Twitter Ads)
1st Party Placement Classification by
File structure/headers:
- A.
- B.
- C.
- D.
正解：D
解説：
In Salesforce Marketing Cloud Intelligence, connections between source files and classification files are established through common keys that link data records. For this scenario:
* The "1st Party Creative Classification" file has a "Creative ID" field which corresponds to the "Creative Key" in the "Twitter Ads" data. This link enables enrichment of Twitter Ads data with creative classification details.
* The "1st Party Placement Classification" file will contain a "Placement ID" that connects to a corresponding field in the "Twitter Ads" data, enabling the enrichment of placement classification details.
Option A appears to accurately depict this setup where data streams for "Creative Classification" and
"Placement Classification" are connected to the "Twitter Ads" data stream using the "Creative ID" and
"Placement ID", respectively. This structure allows for the enhancement of the main Twitter Ads data with additional classification information.
質問 # 28
An implementation engineer is requested to create the harmonization field - Magician This field should come from multiple Twitter Ads data streams, and should follow the below logic:
Using the Harmonization Center, the engineer created a single Pattern for Campaign Name. What other action should the engineer take to meetthe requirements?
- A. Create a second Pattern for Media Buy Name and add a validation list (with the two values) for the final Harmonized Dimension.
- B. Create a second Pattern for Media Buy Name and apply two Classification Rules (one for 'Messi' and another for Ronaldo') for the final Harmonized Dimension.
- C. Create a second Pattern for Media Buy Name and apply a Classification Rule (with the two values) for the final Harmonized Dimension
- D. Create a second Pattern for Media Buy Name
正解：B
解説：
For the field 'Magician', the engineer is required to follow a logic that extracts a value from 'Campaign Name' and checks against a validation list for specific values ('Messi' or 'Ronaldo'). If those values are not found, it should instead extract from 'Media Buy Name'. To accomplish this, the engineer should:
* Use the created Pattern for 'Campaign Name'.
* Create a second Pattern for 'Media Buy Name' to capture the fallback values.
* Apply two Classification Rules to the Harmonized Dimension: one for the value 'Messi' and another for
'Ronaldo'. This is to check the extracted 'Campaign Name' against these specific values.
These steps ensure that the 'Magician' field will be populated with the correct values from the respective data streams following the specified logic.
質問 # 29
Which Marketing Cloud Intelligence field is considered an attribute and not a "variable"?
- A. Campaign Category
- B. Device Browser
- C. Device Category
- D. Geo Location
正解：C
質問 # 30
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
正解：D
解説：
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.
質問 # 31
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?
- A. All fields are mapped except for the Media Buy Name.
- B. All fields are mapped except for the Campaign Key
- C. All fields are mapped except for the Media Buy Key.
- D. All fields are mapped except for the Creative Name
正解：B
解説：
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.
質問 # 32
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.
正解：B
解説：
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.
質問 # 33
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.
正解：A
解説：
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.
質問 # 34
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.
* Data Stream C was set as a 'Parent', and the 'Override Media Buy Hierarchy' checkbox is checked What should the Data Updates Permissions be set to for Data Stream B?
- A. There is no difference, all permissions will have a similar effect given the scenario.
- B. Update Attributes
- C. Update Attributes and Hierarchies
- D. Inherit Attributes and Hierarchies
正解：C
解説：
With Data Stream C set as the 'Parent' and 'Override Media Buy Hierarchy' checked:
* The appropriate setting for Data Stream B would be 'Update Attributes and Hierarchies'. This setting will ensure that the hierarchy and attributes from the parent data stream (C) are updated based on the child data stream (B) without overwriting the measurement data that the parent is the source of truth for.
* The 'Override Media Buy Hierarchy' option checked indicates that the hierarchy of the parent is to be considered as the main one, but the attributes and hierarchy can still be updated from the child data stream, which aligns with option B.
質問 # 35
Animplementation engineer has been provided with 4 different source files: 03m 16s
1. Twitter Ads
2. Creative Classification
3. Placement Classification
4, Campaign Category Classification
The main source is Twitter Ads (which includes various fields and KPIs), and the rest are classification files that connect to Twitter Ads and enrich different fields within it.
The connections between the files are described as follows:
1st Party Creative Classification
File structure/headers:
Creative ID - links back to Creative Key (Twitter Ads)
1st Party Placement Classification &
File structure/headers:
Category - links back to Campaign Category (Twitter Ads)
Which proposed solution meets the client's requirements for the above use case?
- A.
- B.
- C.
- D.
正解：C
解説：
For the given use case, where the Twitter Ads data stream needs to be enriched with classifications from three other sources, the correct implementation would involve creating links between the various fields across these files.
Option A is correct because it shows the correct usage of the fields from the classification files:
* "Creative ID" in the Creative Classification file is linked to the "Creative Key" in the Twitter Ads data, allowing for enrichment with creative details.
* "Placement ID" in the Placement Classification file is linked to a corresponding field in the Twitter Ads data, allowing for placement details to be added.
* "Category" in the Campaign Category Classification file is linked back to "Campaign Category" in the Twitter Ads data, thus enriching the campaign data with the correct categories.
This configuration correctly uses VLOOKUP to enrich the Twitter Ads data stream with additional details from the classification files, aligning with best practices for data integration and enrichment in Marketing Cloud Intelligence.
質問 # 36
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 custom metric and set aggregation to SUM
- B. A separate entity key
- C. An attribute of 'Meeting Code'
- D. A custom metric and set aggregation to AUTO
正解：C
解説：
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.
質問 # 37
What is the relationship between "Media Buy Key" and "Creative Key?
- A. One-to-many (one Media Buy ley has many Creative Key)
- B. Many-to-many
- C. Many-to-one (one Creative Key has many Media Buy Keys)
- D. One-to-one
正解：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.
質問 # 38
......
試験準備には欠かさない！トップクラスのSalesforce Marketing-Cloud-Intelligence試験アプリ学習ガイドで練習問題最新版：https://jp.fast2test.com/Marketing-Cloud-Intelligence-premium-file.html