Salesforce Marketing-Cloud-Intelligence 問題集

質問 1：
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.

正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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 B
B. Data Stream C
C. Data Stream A
D. Any of the data streams can technically be the parent
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
An implementation engineer is requested to extract the first three-letter segment of the Campaign Name values.
For example:
Campaign Name: AFD@Mulop-1290
Desired outcome: AFD
Other examples:

Which formula will return the desired values?
A. LEFT(EXTRACT(csy['campaign_name]],~',0),3)
B. EXTRACT(csv[campaign_name!;@',1)
C. LEFT(EXTRACT(csv[campaign_name'}/-',1),3)
D. EXTRACT(csv[campaign_name'],-,0)
E. EXTRACT(EXTRACT(csv['campaign_name]]/@',1),-,0)
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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 January (entire month). What is the number of opportunities in the Interest stage?
A. 0
B. 2
C. 3
D. 1
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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. An attribute of 'Meeting Code'
B. A custom metric and set aggregation to SUM
C. A custom metric and set aggregation to AUTO
D. A separate entity key
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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. 300
B. N-A
C. 150
D. 100
正解：D
解説: (Topexam メンバーにのみ表示されます)