CBP Data Management 2 — Questions and Answers
Question 1: In Adobe Campaign, what is the primary purpose of a 'reconciliation' activity in a workflow?
- To send a confirmation email after data import
- To match imported data with existing records in the database (Correct answer)
- To delete duplicate records automatically
- To schedule recurring data exports
Correct answer: To match imported data with existing records in the database
Reconciliation links incoming data to existing database records using defined join keys to avoid duplicates and maintain data integrity.
Question 2: Which Adobe Campaign feature allows marketers to define audience segments based on behavioral and transactional data without IT involvement?
- Schema Editor
- Query Activity (Correct answer)
- Dynamic Reports
- Delivery Logs
Correct answer: Query Activity
The Query Activity in workflows lets marketers filter and segment recipients using a visual interface based on any available data.
Question 3: What happens when you set a field as 'mandatory' in an Adobe Campaign custom resource?
- The field is hidden from end users
- The field cannot be left empty when saving a record (Correct answer)
- The field is automatically populated by the system
- The field is excluded from exports
Correct answer: The field cannot be left empty when saving a record
Marking a field as mandatory enforces data validation so that a record cannot be saved unless that field contains a value.
Question 4: In Adobe Campaign Standard, what is a 'seed address' used for in data management?
- To define the primary key of a recipient table
- To test deliveries without using real recipient data (Correct answer)
- To merge duplicate customer profiles
- To store database connection credentials
Correct answer: To test deliveries without using real recipient data
Seed addresses receive copies of deliveries for testing and quality control purposes, independent of the actual recipient list.
Question 5: Which data retention strategy is recommended in Adobe Campaign to manage the growth of tracking and log tables?
- Archive all logs to a cold storage filesystem
- Use database cleanup workflows to purge old records on a schedule (Correct answer)
- Manually delete records via the admin console weekly
- Export logs to CSV and truncate the tables monthly
Correct answer: Use database cleanup workflows to purge old records on a schedule
Adobe Campaign's built-in database cleanup workflow automatically removes outdated logs and temporary data based on configurable retention periods.
Question 6: What is the function of an 'Enrichment' activity in an Adobe Campaign workflow?
- To encrypt PII fields before export
- To add additional data from another data source to the working population (Correct answer)
- To validate email addresses in a list
- To schedule a delivery at a future date
Correct answer: To add additional data from another data source to the working population
The Enrichment activity joins supplementary data to the current working population, making those additional fields available downstream in the workflow.
Question 7: In Adobe Campaign, what does the 'deduplication' activity do when multiple records share the same identifier?
- It merges all matching records into one and sums their transaction values
- It keeps one record per group based on a defined rule and discards the rest (Correct answer)
- It flags duplicates for manual review by an administrator
- It sends an alert email to the campaign owner
Correct answer: It keeps one record per group based on a defined rule and discards the rest
The Deduplication activity retains a single record per duplicate group according to a user-defined priority rule, removing the others from the workflow population.
In Adobe Campaign, what is the primary purpose of a 'reconciliation' activity in a workflow?