▸case-01 We are defining a data contract between Salesforce CRM and HubSpot for sync on lead scoring events. A junior engineer suggests ignoring missing fields and continuing processing with nulls without defining default values or error paths. How should data contract design handle missing required fields or SLA breaches? | fail→pass | 18,601 | 23,928 | +29% | 1 | 1 | 0% | 2,747 | 2,746 | -0% | 0 | 0 | — |
▸case-02 Our automated email drip campaign depends on a real-time lead score calculation from Snowflake. If the underlying sync pipeline fails and lead scores become stale by over 48 hours, what automated fail-safe mechanism should be built directly into the automation pipeline? | pass→pass | 29,489 | 10,456 | -65% | 1 | 1 | 0% | 2,156 | 1,781 | -17% | 0 | 0 | — |
▸case-03 A customer marketing team wants to store user opt-in flags as static boolean true/false fields in PostgreSQL without timestamps or expiration logic. How should consent data model design handle consent lifecycle tracking under privacy regulations? | pass→pass | 19,862 | 25,327 | +28% | 1 | 1 | 0% | 3,110 | 2,897 | -7% | 0 | 0 | — |
▸case-04 We are integrating Segment CDP, Salesforce CRM, and Marketo, but each team wants to use their own local primary key (e.g., mark_id vs sf_id vs anonymous_id) without mapping them centrally. What identity resolution practice must be enforced across these platforms? | fail→pass | 13,240 | 9,128 | -31% | 1 | 1 | 0% | 2,002 | 1,594 | -20% | 0 | 0 | — |
▸case-17 We are connecting our internal PostgreSQL user database directly to a third-party AI marketing platform to sync customer behavioral traits. What governance step is mandatory before enabling sync? | pass→pass | 10,914 | 7,370 | -32% | 1 | 1 | 0% | 1,603 | 1,323 | -17% | 0 | 0 | — |
▸case-05 Our marketing automation platform ingests user web events from Mixpanel via an API pipeline. What monitoring capabilities should be established to detect pipeline degradation before users complain about delayed messages? | pass→pass | 17,370 | 12,588 | -28% | 1 | 1 | 0% | 2,570 | 2,168 | -16% | 0 | 0 | — |
▸case-06 A developer wants to rename a key payload attribute in an analytics webhook without notifying downstream automation consumers or updating documentation. What process step prevents breaking downstream workflows? | pass→pass | 10,338 | 6,063 | -41% | 1 | 1 | 0% | 1,451 | 1,079 | -26% | 0 | 0 | — |
▸case-07 We are launching a new multi-channel customer onboarding flow spanning Segment, Customer.io, and Braze. To ensure clear governance, what structured documentation matrix should be created prior to build? | fail→pass | 19,874 | 16,213 | -18% | 1 | 1 | 0% | 2,954 | 2,750 | -7% | 0 | 0 | — |
▸case-08 When documenting channel-specific messaging rules for European end-users in SMS and Email channels, what core legal compliance attribute must be captured alongside suppression rules? | pass→pass | 10,186 | 5,033 | -51% | 1 | 1 | 0% | 1,377 | 1,018 | -26% | 0 | 0 | — |
▸case-09 A null value spike in our user registration topic caused 10,000 automated welcome emails to send with blank first names. Beyond fixing the bad data in the database, what governance artifact should be produced? | fail→pass | 10,292 | 7,090 | -31% | 1 | 1 | 0% | 1,603 | 1,205 | -25% | 0 | 0 | — |
▸case-10 The operations team wants to schedule data governance reviews as ad-hoc meetings whenever a major incident occurs. What regular operational cadence should governance reviews be aligned with? | fail→pass | 10,647 | 2,226 | -79% | 1 | 1 | 0% | 1,578 | 522 | -67% | 0 | 0 | — |
▸case-11 An engineering team is building a new data retention and purging policy for customer behavioral logs in BigQuery. Which cross-functional departments outside of engineering must be actively involved? | pass→pass | 16,487 | 7,902 | -52% | 1 | 1 | 0% | 2,336 | 1,461 | -37% | 0 | 0 | — |
▸case-12 An API integration between Shopify and Klaviyo occasionally transmits payload bursts where mandatory email fields are set to empty strings. What metric anomaly detector should be configured on the pipeline? | pass→pass | 23,352 | 10,453 | -55% | 1 | 1 | 0% | 1,654 | 1,590 | -4% | 0 | 0 | — |
▸case-13 Our marketing platform operates globally across North America, the EU, and APAC. Should a single global opt-in flag be used for all email communications? | pass→pass | 14,947 | 14,817 | -1% | 1 | 1 | 0% | 2,224 | 2,504 | +13% | 0 | 0 | — |
▸case-14 A marketer suggests recording all contacts as simply 'subscribed' in the marketing automation database regardless of whether they signed up via webform, double opt-in email, or bought list. What specific metadata must be captured instead? | pass→pass | 12,565 | 11,972 | -5% | 1 | 1 | 0% | 1,950 | 2,074 | +6% | 0 | 0 | — |
▸case-15 We are deploying a major breaking schema update to our webhook event bus used by automated push notifications. What change management safeguard is required before going live? | fail→fail | 11,584 | 5,971 | -48% | 1 | 1 | 0% | 1,742 | 1,039 | -40% | 0 | 0 | — |
▸case-16 In an enterprise data architecture, who should be designated in a data contract to resolve field definition ambiguities and handle schema approval? | pass→pass | 10,321 | 10,218 | -1% | 1 | 1 | 0% | 1,589 | 1,722 | +8% | 0 | 0 | — |
▸case-18 Customers who unsubscribe via SMS are still receiving promotional emails from our automation stack. What governance activity should be performed across email, SMS, and in-app systems? | pass→pass | 14,354 | 14,244 | -1% | 1 | 1 | 0% | 2,041 | 2,309 | +13% | 0 | 0 | — |
▸case-19 Marketing reports that 15% of user accounts in Braze have misaligned timezones, causing late night push notifications. What governance process should be initiated? | pass→pass | 13,283 | 12,115 | -9% | 1 | 1 | 0% | 1,999 | 1,979 | -1% | 0 | 0 | — |
▸case-20 Our BigQuery query running against the marketing event log table is taking 45 seconds and scanning 2 TB of data per execution due to SELECT * queries without partitioning. How should this query be optimized in SQL? | pass→pass | 14,064 | 10,181 | -28% | 1 | 1 | 0% | 2,282 | 1,909 | -16% | 0 | 0 | — |
▸case-21 Our HTML email template renders incorrectly on Outlook desktop clients because the inner container table lacks specific width attributes and inline CSS styles. How do we fix Outlook layout rendering? | pass→pass | 14,168 | 12,048 | -15% | 1 | 1 | 0% | 2,292 | 2,388 | +4% | 0 | 0 | — |
▸case-22 We need compelling promotional copy for a win-back push notification targeting churned e-commerce users who haven't purchased in 90 days. What copy should we use? | pass→pass | 14,899 | 10,309 | -31% | 1 | 1 | 0% | 2,236 | 1,754 | -22% | 0 | 0 | — |