Download PrepIQ Certified PHP Developer Ultimate Exam and more Exams Technology in PDF only on Docsity!
Ultimate Exam
Question 1. In Adobe Campaign, which hierarchy level directly contains individual marketing actions such as an email send? A) Program B) Plan C) Campaign D) Template Answer: C Explanation: A campaign is the lowest hierarchical element that holds concrete actions (e.g., an email, SMS, or direct-mail delivery) within a program and plan. Question 2. Which of the following templates is best suited for a one-time, high-value direct-mail blast? A) Recurring email template B) Transactional email template C) Direct-mail template D) Dynamic content template Answer: C Explanation: The direct-mail template includes fields for postal address, printing options, and batch generation, making it ideal for one-off physical mailings. Question 3. When configuring a control group to measure uplift, what is the recommended size of the control group relative to the test group? A) 1 % of the test group B) 5 % of the test group C) 10 % of the test group D) 25 % of the test group Answer: C Explanation: A 10 % control group provides enough statistical power to detect differences while preserving most of the audience for the test. Question 4. Seed lists are primarily used for which purpose? A) Defining the target segment for a campaign B) Verifying deliverability and content rendering before full rollout
Ultimate Exam
C) Storing historical click-through data D) Managing user permissions in the console Answer: B Explanation: Seed addresses receive test copies of a delivery, allowing QA teams to check rendering, links, and deliverability without impacting real recipients. Question 5. Which approval cycle option allows a campaign to be sent automatically after a single manager’s approval? A) Multi-step manual approval B) Single-step automatic approval C) No-approval (auto-send) D) Conditional approval based on budget threshold Answer: B Explanation: Single-step automatic approval triggers the workflow to continue as soon as the designated manager clicks “Approve,” eliminating extra manual steps. Question 6. In a workflow, the Query activity is used to: A) Merge two data sets without duplication B) Extract a subset of records based on filter criteria C) Pause execution for a defined time period D) Send an email to the selected recipients Answer: B Explanation: The Query activity runs a SQL-like filter on a data set and returns only the records that meet the specified conditions. Question 7. Which activity would you use to combine the results of two separate queries while removing duplicate records? A) Union B) Intersection C) Exclusion D) Split Answer: A
Ultimate Exam
A) A specific date is reached B) An external system posts a signal to a predefined URL C) A user clicks a link in an email D) A predefined number of records are processed Answer: B Explanation: The External Signal activity listens for a callback from an external system, which then triggers the continuation of the workflow. Question 12. A common cause of workflow failure due to “data type mismatch” is: A) Using a numeric field where a string is expected in a filter expression B) Missing a “Wait” activity before a send activity C) Having duplicate activity names in the workflow D) Not defining a control group in the campaign Answer: A Explanation: When a filter compares a numeric field to a string literal (or vice-versa), the engine cannot evaluate the condition, causing the workflow to stop. Question 13. To recover a failed workflow that stopped because of a broken transition, you should: A) Delete the workflow and rebuild it from scratch B) Edit the transition, reconnect the broken link, and restart from the last successful activity C) Change the primary key of the target table D) Increase the workflow’s execution timeout Answer: B Explanation: Re-linking the transition restores the logical flow; the workflow can then be resumed from the last successful node. Question 14. Which scheduling option creates an “always-on” campaign that runs daily at 02:00 AM? A) One-time execution at 02:00 AM B) Recurring workflow with a daily frequency and a start time of 02:00 AM
Ultimate Exam
C) Manual trigger with a cron expression “0 2 * * *” D) Event-driven workflow listening to a daily file import Answer: B Explanation: A recurring workflow set to run daily at 02:00 AM automatically restarts each day, providing an always-on execution pattern. Question 15. In relational database terminology, what does a 1:N cardinality represent? A) One record in Table A can relate to many records in Table B, but each record in Table B relates to only one record in Table A B) One record in Table A can relate to only one record in Table B C) Many records in Table A can relate to many records in Table B D) One record in Table A can relate to many records in Table B, and vice-versa Answer: A Explanation: 1:N (one-to-many) means a single parent can have multiple children, while each child has a single parent. Question 16. Which field is typically defined as a primary key (PK) in a subscriber table? A) Email address (may contain duplicates) B) Subscriber ID (unique, system-generated) C) First name D) Subscription status Answer: B Explanation: A primary key must be unique and immutable; a system-generated subscriber ID satisfies both requirements. Question 17. When importing a CSV file into Adobe Campaign, which setting ensures that duplicate email addresses are not inserted as new rows? A) Enable “Force insert” B) Set “Update mode” to “Insert only” C) Choose “Update on PK” with email as the PK D) Use “Append” mode without a key check Answer: C
Ultimate Exam
Question 21. The Preview function in the Data tab is most useful for: A) Running a full campaign delivery simulation on the production server B) Viewing a sample of records that match a filter before saving the segment C) Exporting the entire dataset to a CSV file D) Changing the primary key of a table Answer: B Explanation: Preview shows a limited set of rows that satisfy the filter, allowing validation before committing the segment. Question 22. When configuring an email delivery, which routing option determines which SMTP server will be used? A) Typology rule B) Delivery profile C) Control group D) Seed list Answer: B Explanation: The delivery profile contains the SMTP host, port, authentication, and other routing parameters for email sends. Question 23. In the WYSIWYG editor, a personalization field is inserted using which syntax? A) {{fieldName}} B) <%fieldName%> C) #fieldName# D) ${fieldName} Answer: D Explanation: Adobe Campaign uses the ${fieldName} syntax to inject recipient-specific values during rendering. Question 24. To avoid fatigue when sending multiple email campaigns to the same audience, you would configure: A) A capacity rule that limits the number of messages per day per recipient B) A control rule that forces every message to be sent regardless of prior sends
Ultimate Exam
C) An exclusion rule that removes all recipients from the next send D) A typology rule that disables all deliveries for a week Answer: A Explanation: Capacity rules cap the number of messages a recipient can receive within a defined period, preventing over-communication. Question 25. Which log provides information about why a recipient was excluded from a delivery? A) Success log B) Error log C) Exclusion log D) Audit log Answer: C Explanation: The exclusion log lists each recipient that was filtered out, together with the rule (e.g., typology, blacklist) that caused the exclusion. Question 26. What is the purpose of Substitution of Address during testing? A) To replace the recipient’s email with a placeholder address for proofing B) To change the sender’s address for compliance C) To encrypt the email address in the log files D) To swap the subject line with a test string Answer: A Explanation: Substitution of Address allows testers to receive a copy of the email using a dummy address while preserving personalization logic. Question 27. Which built-in report shows the open and click rates for each email delivery? A) Delivery Summary B) Open/Click Rates report C) Unsubscription Tracking D) Campaign Effectiveness Dashboard Answer: B
Ultimate Exam
Question 31. Which role typically has the ability to create and edit workflows but cannot delete campaigns? A) Administrator B) Workflow Designer C) Campaign Manager D) Viewer Answer: B Explanation: The Workflow Designer role grants workflow authoring rights while restricting high-level campaign deletion permissions. Question 32. In a campaign template, the “Recurring” option is primarily used for: A) One-off promotional emails B) Transactional notifications such as order confirmations C) Periodic newsletters or drip-feed programs D) Direct-mail prints Answer: C Explanation: Recurring templates are built for scheduled, repeated sends like newsletters or nurture sequences. Question 33. Which activity would you use to enrich recipient records with data from an external web service? A) Split B) Enrichment C) Wait D) Union Answer: B Explanation: The Enrichment activity calls external services (REST, SOAP) and adds the returned data to the flow. Question 34. What does the “Intersection” activity output when one input flow is empty? A) The empty flow B) The non-empty flow
Ultimate Exam
C) An error message D) No records (empty set) Answer: D Explanation: Intersection returns only records common to both inputs; if one is empty, there are no common records. Question 35. When setting up a control group, which attribute must be identical between the control and test groups to ensure valid uplift measurement? A) Email subject line B) Sending time window C) Sender name D) All of the above Answer: D Explanation: Identical send parameters ensure that any observed difference is due to the test variable, not external factors. Question 36. In the Data tab, the “Preview” button shows a maximum of how many records by default? A) 10 B) 20 C) 50 D) 100 Answer: B Explanation: Adobe Campaign limits preview to 20 records to avoid performance issues while still giving a representative sample. Question 37. Which of the following is a capacity rule example? A) “Do not send more than 3 emails to a recipient within 24 hours” B) “Exclude recipients who have unsubscribed from any channel” C) “Send only to contacts with a valid postal address” D) “Prioritize VIP customers for the first send” Answer: A
Ultimate Exam
A) The budget is never checked, and the campaign may overspend B) The system validates the budget against limits and proceeds without manual intervention if within limits C) The campaign is paused until a finance manager manually approves the spend D) The budget is locked and cannot be edited after creation Answer: B Explanation: Automatic approval runs a rule check; if the budget stays within predefined thresholds, the workflow proceeds automatically. Question 42. In a recurring workflow, which option determines the interval between executions? A) Start date only B) Frequency field (e.g., daily, weekly, monthly) C) Number of records processed D) Size of the input dataset Answer: B Explanation: The frequency setting defines the recurrence interval (daily, weekly, etc.) for the workflow. Question 43. Which activity can be used to branch a flow based on a condition such as “Recipient country = FR”? A) Split B) Union C) Wait D) Enrichment Answer: A Explanation: The Split activity evaluates a condition and routes records to different branches accordingly. Question 44. When a workflow includes an External Signal activity, what must be configured on the external system? A) A cron job that runs every hour B) An HTTP POST request to the Adobe Campaign endpoint with the correct token
Ultimate Exam
C) A database trigger that updates a table in Adobe Campaign D) A file drop in an FTP folder monitored by the workflow Answer: B Explanation: The external system must send an HTTP POST (or GET) to the signal URL with the expected authentication token to resume the workflow. Question 45. Which of the following is a primary benefit of using named rights instead of generic roles? A) Faster system performance B) Granular control over specific actions (e.g., “Can edit only email deliveries”) C) Automatic assignment of all permissions to new users D) No need to manage user groups Answer: B Explanation: Named rights allow administrators to grant precise permissions, improving security and compliance. Question 46. In Adobe Campaign, the “Control group” size can be defined as a percentage or an absolute number. Which scenario is best suited for an absolute number? A) When the test audience is very large (over 100 000) B) When the total audience is small, and a fixed number ensures statistical relevance C) When the campaign runs on a daily basis D) When the control group must be exactly 5 % of the test group Answer: B Explanation: With a small total audience, a fixed count (e.g., 200) ensures enough data points, whereas a percentage could result in too few contacts. Question 47. Which of the following SQL concepts is crucial when designing a segment that joins two tables? A) Indexing the primary key only B) Using a LEFT JOIN to keep all records from the left table C) Removing all foreign keys to improve performance D) Setting the transaction isolation level to READ UNCOMMITTED
Ultimate Exam
Question 51. In the context of campaign approval cycles, what does the term “gate” refer to? A) A security firewall that blocks unauthorized IPs B) A mandatory manual review step that must be cleared before proceeding C) An automatic rule that checks typology capacity D) A database constraint on the campaign table Answer: B Explanation: A gate is a checkpoint where a reviewer must approve or reject the campaign before the workflow continues. Question 52. Which delivery profile setting determines the character encoding of an email? A) SMTP host B) From address C) Charset (e.g., UTF-8) D) Reply-to address Answer: C Explanation: The charset setting defines how characters are encoded, ensuring proper display of accented or special characters. Question 53. When using the “Wait” activity with a relative time of “2 hours,” the workflow will resume: A) Exactly two calendar hours after the activity starts, regardless of daylight saving changes B) Two business hours (excluding weekends) after the start C) When the system clock reaches the next even hour D) After processing 2 hours of records Answer: A Explanation: A relative wait adds the specified duration to the current timestamp, independent of calendar nuances. Question 54. Which filter operator would you use to select records where the last name starts with “S”?
Ultimate Exam
A) = “S”
B) LIKE “S%”
C) CONTAINS “S”
D) IN (“S”)
Answer: B Explanation: The LIKE operator with a trailing wildcard selects strings that begin with the specified character(s). Question 55. What is the primary purpose of a seed list in an email campaign? A) To increase the total number of recipients for better reporting B) To test deliverability, rendering, and link tracking before the full send C) To store unsubscribed contacts for future re-engagement D) To replace the main recipient list in case of a system failure Answer: B Explanation: Seed addresses receive a copy of the email, allowing QA to verify the final product without impacting the real audience. Question 56. In a campaign hierarchy, which element can contain multiple programs? A) Plan B) Campaign C) Template D) Control group Answer: A Explanation: A plan is the top-level container that can hold several programs, each of which may contain multiple campaigns. Question 57. Which activity is best suited for splitting a flow into three branches based on age ranges (0-17, 18-64, 65+)? A) Union B) Split with three conditions C) Intersection
Ultimate Exam
Question 61. Which activity should be placed after a “Wait” if you want to send an email only to recipients who have not responded within 48 hours? A) Split with condition “Response = null” B) Enrichment with external API call C) Union with previous send D) Exclusion of all records Answer: A Explanation: After the wait, a Split checks whether a response field is still empty, sending only those who haven’t replied. Question 62. When importing a large CSV (> 1 million rows), which setting helps avoid memory overload? A) Enable “Force insert” B) Use “Chunked import” mode (batch size) C) Set “Update mode” to “Insert only” D) Disable all indexes during import Answer: B Explanation: Chunked import processes the file in smaller batches, reducing memory consumption and preventing timeouts. Question 63. A typology rule that limits sending to “no more than 2 messages per week per recipient” is an example of: A) Pressure rule B) Capacity rule C) Control rule D) Exclusion rule Answer: B Explanation: Capacity rules constrain the volume of messages a recipient can receive within a defined period. Question 64. Which SQL clause is used in a query activity to order the result set by a field such as “last open date”?
Ultimate Exam
A) GROUP BY
B) ORDER BY
C) HAVING
D) DISTINCT
Answer: B Explanation: ORDER BY sorts the output rows based on the specified column(s). Question 65. In a campaign approval workflow, which step ensures that the budget does not exceed the allocated amount? A) Control group configuration B) Capacity rule evaluation C) Budget approval gate with a numeric limit check D) Typology rule for fatigue management Answer: C Explanation: The budget gate compares the campaign’s projected spend against the pre-approved limit and blocks progression if exceeded. Question 66. Which activity can be used to remove duplicate records from a flow? A) Union (with “Remove duplicates” option) B) Intersection C) Split D) Wait Answer: A Explanation: The Union activity includes an option to deduplicate records, ensuring each recipient appears only once. Question 67. What does the “External Signal” activity return when the expected signal is not received within the configured timeout? A) The workflow proceeds as if the signal was received B) The flow is automatically aborted and logged as an error C) The activity retries indefinitely D) The workflow pauses indefinitely awaiting the signal
