Salesforce Certified Data 360 Consultant free question 8 / 10 · Domain 5: Data Enhancements, Sharing, and Analysis
You create two copy field enrichments, and both choose Primary Key as the ID match method. One has a DMO as the copy source, and the other has a calculated insight object (CIO) as the copy source. Which statement about filtering the target object matches the Help article?
- It filters a DMO source by the matching data source ID, and copies CIO rows unfiltered
- With a DMO source it filters by data source ID, and with a CIO source it filters by key qualifier
- With either a DMO or a CIO as the source, it filters the target by key qualifier
- With a DMO source it filters by key qualifier, and with a CIO source it adds no filter
Show the answer and explanation
Answer: D
Why this is correct
A note in the article on creating a copy field enrichment says that when you choose Primary Key as the ID match method, the enrichment does not filter the target object by data source ID. If the copy source is a DMO, it filters the target by key qualifier. If the copy source is a CIO, it does no filtering. Which rows get copied depends on the combination of match method and source type.
Why the other options are wrong
"With a DMO source it filters by data source ID, and with a CIO source it filters by key qualifier" … With the Primary Key match method, the target is not filtered by data source ID, and when the source is a CIO there is no filtering at all.
"With either a DMO or a CIO as the source, it filters the target by key qualifier" … Filtering by key qualifier happens when the copy source is a DMO. When the source is a CIO, no filtering is done.
"It filters a DMO source by the matching data source ID, and copies CIO rows unfiltered" … With the Primary Key match method, the target is not filtered by data source ID. A DMO source uses the key qualifier. Only the part about not filtering CIO rows is right.
Related settings
The match methods are Lookup (Individual, Account, Unified Individual, Unified Account), Primary Key, and Non-Primary Unique Key. By default, the primary key of the org's object is matched with the primary key of the Data 360 object. To reduce the amount copied, you can add a filter that copies only the source data that meets your conditions.