1. Regulatory Reporting Pipelines advanced

    Your platform issues B2B invoices in a market where tax law requires each invoice to be registered with a government portal before it is valid, and the portal returns a reference number the invoice must carry. The portal's availability is outside your control. How does this change the invoicing architecture?

    3 min answer e-invoicinggstexternal-dependencyidempotency
  2. Rehosting intermediate Multiple choice

    A data-centre exit must move about 600 virtual machines in nine months. The first wave moved 40 machines chosen because they were the least busy and three business applications became unusably slow overnight. What should decide which machines travel in the same wave?

    3 min answer rehostdata centre exitmove groupslatency
  3. Rehosting intermediate Multiple choice

    A data-centre lease expires in eleven months and will not be renewed. The team plans to rehost about 300 virtual machines with no application changes. Which benefit is the one rehosting reliably delivers and therefore the one the plan should be justified on?

    2 min answer rehostlift-and-shiftbusiness-casecost
  4. Rehosting intermediate Multiple choice

    A nightly billing batch that ran in 4 hours 10 minutes on a 2016 on-premises server takes 9 hours 20 minutes after a lift-and-shift onto a cloud instance with twice the vCPUs and four times the memory. CPU sits near 12 percent across all cores and the instance is never network-throttled. Where is the time going?

    3 min answer rehostlift-and-shiftbatch-windowsingle-thread
  5. Rehosting intermediate

    An organisation rehosts its estate to cloud infrastructure and finds costs higher and reliability no better. What did rehosting not deliver, and what should follow?

    2 min answer rehostlift-and-shiftcostcloud
  6. Rehosting intermediate

    When is lift-and-shift the right migration strategy, and what must be planned alongside it?

    2 min answer rehostmigrationcostreplatform
  7. Relational Modelling beginner Multiple choice

    A service uses a random version-4 UUID as the clustered primary key of its largest table. At 200 million rows, insert throughput has fallen by more than half and the buffer cache hit rate keeps dropping, although the table is append-only and no query changed. Which explanation is correct?

    3 min answer uuidprimary keyb-treewrite amplification
  8. Relational Modelling intermediate

    A team proposes storing the customer's address on every order row "so order history is accurate". Is that denormalisation or a modelling error?

    2 min answer normalisationmodellinghistorytemporal
  9. Relational Modelling intermediate

    A team wants to store a product's variable attributes as a JSON column rather than modelling them as tables. When is that right and what is given up?

    2 min answer relationaljsonschemamodelling
  10. Relational Modelling advanced Multiple choice

    An issue-tracking product lets every customer define custom fields, workflows and screens. Which data model should the platform use for custom fields?

    2 min answer data-modellingeavmulti-tenancyjsonb
  11. Relational Modelling intermediate

    At 03:40 every insert into the events table starts failing with an out-of-range error for the id column. The table holds about 2.1 billion rows, nothing was deployed, reads are unaffected. What happened, and what is the recovery while traffic continues?

    3 min answer sequenceinteger overflowmigrationcapacity
  12. Release Strategies advanced

    A brokerage must deploy without disrupting customers who may be mid-transaction. Which release strategy fits, and what does it require?

    2 min answer growwreleasecanarydraining