Search the practice set

126 questions, 454 terms and 400 topics in 20 areas.

60 results for “Cloud Databases”

Terminology · 27
term

Block Storage

A virtual disk attached to one instance at a time, presented as raw blocks and formatted with a filesystem — the storage databases and stateful workloads run on.

Cloud Storage
term

Connection Proxy

A pooling layer between applications and a managed database that multiplexes many client connections onto a small number of database connections.

Cloud Databases
term

Provisioned vs Serverless Capacity

Paying for a fixed database size continuously, versus paying for capacity consumed with automatic scaling — a crossover decision driven by duty cycle.

Cloud Databases
term

Cloud Exit Plan

A documented, costed assessment of what leaving a provider or service would require — increasingly a regulatory expectation and a better lock-in control than portability itself.

Multi-Cloud
term

Cloud Pricing Models

The purchase options for cloud compute — on-demand, committed use, and spot — which differ by up to 90% for identical hardware.

Cost & FinOps
term

Multi-Cloud

Deliberately running across more than one cloud provider — a decision with a much higher cost than the lock-in it is usually adopted to avoid.

Cloud Architecture
term

Virtual Private Cloud

A logically isolated network inside a cloud provider, with an address range you control and explicit rules for what may enter and leave.

Networking
term

Account Vending

Automated creation of new cloud accounts pre-configured with the organisation's networking, identity, logging, guardrails and cost allocation.

Landing Zones
term

Application Discovery

Establishing what applications exist, what they depend on, who owns them and whether anyone uses them — the step whose absence makes every later step a guess.

Cloud Migration
term

Autoscaling

Adding and removing capacity automatically in response to a demand signal, to track load without paying for peak all the time.

Cloud Architecture
term

Availability Zone

One or more physically separate data centres inside a cloud region, with independent power, cooling and network, connected by low-latency links.

Cloud Architecture
term

Backup Strategy

A plan for what is copied, how often, where to, how long it is kept, and — the part that decides whether it is real — how the restore is verified.

Cloud Architecture
term

Blast Radius

The set of things that break, or become reachable, when one component fails or is compromised.

Cloud Architecture
term

Blast Radius Reduction

The set of deliberate partitions — accounts, regions, zones, cells, tenants, deployment stages — that bound how far any single failure or compromise can reach.

Cloud Architecture
term

Capital One's Data Centre Exit

A major US bank closed all eight of its data centres and moved fully to public cloud, treating governance automation as the enabling technology rather than a constraint.

Enterprise Architecture
term

Chargeback and Showback

Attributing cloud cost to the teams that generate it — either informationally (showback) or by moving it onto their budget (chargeback).

Cost & FinOps
term

Connection Pool

A fixed set of reusable database connections shared by an application's requests, and one of the most common hidden capacity ceilings.

Performance & Capacity
term

Control Plane and Data Plane

The separation between the machinery that makes changes to a system and the machinery that serves its traffic.

Cloud Architecture
term

Cross-Zone Data Transfer

Charges incurred when data moves between availability zones within a region — invisible on architecture diagrams and a recurring surprise on cloud bills.

Availability Zones
term

Database Index

A secondary structure that lets the engine find rows without scanning, trading write cost and storage for read speed.

Data Architecture
term

Durability vs Availability

Two different storage guarantees — whether data survives, and whether it can be reached right now — routinely conflated because both are quoted in nines.

Cloud Storage
term

Egress Cost

The charge for moving data out of a cloud provider or across its zones and regions — usually the least-anticipated line on a cloud bill.

Cost & FinOps
term

Identity and Access Management

The system of record for principals, credentials and permissions, and the policy engine that decides what each principal may do.

Security Architecture
term

Indexing Strategy

Choosing the set of indexes a table carries by working backwards from its actual queries, and accepting the write cost that each one adds.

Data Architecture
term

Infrastructure as Code

Defining infrastructure in version-controlled declarative files that a tool reconciles against the real environment.

Cloud Architecture
term

Kubernetes

A container orchestrator that continuously reconciles the running state of a cluster towards a declared desired state.

Cloud Architecture
term

Landing Zone

A pre-configured, governed cloud environment — accounts, networking, identity, logging, guardrails — into which workloads can be deployed safely.

Cloud Architecture
Questions · 14
quiz

A serverless API works in testing and fails under load with connection errors. The database is at 5% CPU. Explain and fix.

The mechanism Serverless functions scale by creating independent execution environments , each with its own process and its own connection pool. Two hundred con

Cloud Databases
quiz

An organisation is starting cloud adoption. Three teams want to deploy next month. What must exist first, and what can wait?

What must exist before anything reaches production Account structure. Separation by environment and by workload, because an account is the strongest isolation b

Landing Zones
quiz

Design the network layout for a three-tier application in one cloud region. What are the decisions you cannot easily change later?

What the interviewer is testing Whether you know which network decisions are cheap and which are effectively permanent. This is a knowledge question with a clea

Networking
quiz

Finance wants to cut cloud spend by committing to one-year and three-year reservations. What do you commit to, and what could go wrong?

What the interviewer is testing Whether you can turn a blunt cost mandate into a portfolio decision with a stated risk, rather than either refusing it or over c

Cost & FinOps
quiz

Four services want four different databases: Postgres, MongoDB, Cassandra and Neo4j. What do you say?

The response: make each team justify it against a default Polyglot persistence is legitimate and routinely over applied. The question for each is not "is this d

Polyglot Persistence
quiz

The cloud bill has tripled in six months while traffic grew 40%. How do you find out why, and what do you expect to find?

What the interviewer is testing Whether you approach cost with the same rigour as latency, and whether you know where cloud money actually goes. How to find out

Cost & FinOps
quiz

You are asked to choose between a cloud data warehouse and a lakehouse for a new analytics platform. How do you decide?

What actually differs The gap has narrowed considerably, so the decision turns on fewer things than the marketing suggests. Format ownership. In a lakehouse, da

Data Lakes & Lakehouses
quiz

You are asked to lead a migration of 300 applications to cloud. What happens in the first ninety days?

Days 1–30: discovery, and the foundation in parallel Discovery from evidence, not interviews. Network flow logs for dependencies (the only trustworthy source),

Cloud Migration
quiz

A DR test fails: the secondary region cannot launch enough instances. What happened, and what standing checks prevent it?

What happened Service quotas in the secondary region are far lower than in the primary , because nothing has ever run there at scale. Quotas are per account and

Cloud Governance
quiz

A dashboard query that took 200ms now takes 40 seconds. The table has grown to 200 million rows. Walk me through diagnosis and fix, including what you would not do.

What the interviewer is testing Whether you diagnose with evidence before changing anything, and whether you know the costs of the fixes you propose. Diagnosis,

Data Architecture
quiz

A team tells you backups run nightly and are retained for 30 days. What is missing from that answer?

What the interviewer is testing Whether you know that a backup is not a control until it has been restored — one of the most reliable ways to find an unrecovere

Cloud Architecture
quiz

A team wants to build a new internal API on serverless functions. It will serve steady traffic of about 200 requests per second during business hours. What do you advise?

What the interviewer is testing Whether you can apply the serverless trade off to a specific workload rather than treating it as a default good or a default bad

Cloud Architecture
quiz

Choose storage for four workloads: a Postgres data directory, user-uploaded images, a shared build cache, and seven years of audit records.

Postgres data directory — block storage It needs low latency random reads and writes and a filesystem, and it attaches to one instance. That is precisely block

Cloud Storage
quiz

In the 2017 AWS S3 outage, the status page could not report the outage because it depended on S3. What does that tell you about designing status and control systems?

The case, as publicly reported On 28 February 2017, an authorised engineer running an established playbook to debug an S3 billing issue in us east 1 entered a c

Cloud Architecture
Topics · 18
topic

Cloud Databases

Managed relational, key-value, document and analytical services.

5 items
topic

Cloud Architecture

General material on designing for cloud platforms.

28 items
topic

Cloud Governance

Preventive policy, tagging, quotas and cost and security guardrails.

7 items
topic

Cloud Migration

Per-application disposition, sequencing and the capability change underneath.

5 items
topic

Cloud Pricing Models

On-demand, committed and spot, and the crossover arithmetic.

Cost Architecture & FinOps — no content yet
topic

Cloud Storage

Object, block and file storage, and the access patterns each suits.

5 items
topic

Multi-Cloud

Best-of-breed, portfolio and portable — three very different costs.

2 items
topic

Vector Databases

Approximate nearest-neighbour search, filtering and re-indexing.

AI-Era Architecture — no content yet
topic

Autoscaling

Signals, delays and bounds — and the maximum that caps a runaway bill.

5 items
topic

Availability Zones

The unit of correlated physical failure, and what zones do not protect against.

5 items
topic

Backup Strategies

Scope, immutability, separation, and the restore drill that makes it real.

7 items
topic

Compute Models

Instances, containers and functions, and what each is priced and shaped for.

5 items
topic

Containers

Images, registries, immutability and the deployment model they enable.

4 items
topic

Disaster Recovery

Backup-restore, pilot light, warm standby and active-active postures.

4 items
topic

Edge Computing

Moving compute towards the user, and what cannot follow it.

3 items
topic

Infrastructure as Code

Declarative infrastructure, drift, state files and rebuild-from-empty.

5 items
topic

Kubernetes

The reconciliation loop, and whether the workload needs what it provides.

7 items
topic

Landing Zones

A governed foundation of accounts, network, identity and guardrails.

5 items