Search the practice set
126 questions, 454 terms and 400 topics in 20 areas.
17 results for “Compute Optimisation”
Burstable Instance
An instance that provides a low baseline CPU allocation and accrues credits while idle, spendable for short periods of full performance.
Cardinality Estimation
The planner's prediction of how many rows each step of a query will produce — the input that determines every other choice it makes.
Cloud Pricing Models
The purchase options for cloud compute — on-demand, committed use, and spot — which differ by up to 90% for identical hardware.
ETL vs ELT
Whether data is transformed before loading into the target or after it, which decides where the compute happens and how much raw history you keep.
Instance Family
A group of instance types sharing a resource profile — general purpose, compute optimised, memory optimised, storage optimised, accelerated — chosen by which resource the workload…
Join Strategies
The three ways a database combines two row sets — nested loop, hash join and merge join — and the conditions under which each is correct.
Rightsizing
Matching provisioned resources to observed demand, rather than to the guess made when they were created.
Serverless
A model where the provider allocates and scales compute per request, and you are billed for execution rather than for provisioned capacity.
Your observability bill is now 40% of your compute bill. Leadership wants it cut in half without going blind. What do you cut?
What the interviewer is testing Whether you understand what each telemetry type is for , so you can cut the redundant parts rather than cutting uniformly — whic
A fleet of 200 instances averages 15% CPU and 85% memory. Finance wants a 40% cost reduction. What do you do?
The diagnosis The instance family is wrong. 15% CPU and 85% memory means the workload is memory bound running on general purpose or compute optimised instances,
A query that ran in 50ms for two years now takes 90 seconds. Nothing was deployed and the data volume grew normally. What happened?
The most likely cause: a plan flip The optimiser's choice is a function of estimated row counts. As the data grows or its distribution shifts, an estimate cross
Compute Optimisation
Instance families, utilisation, and architecture that wastes less.
Compute Models
Instances, containers and functions, and what each is priced and shaped for.
Profiling & Optimisation
Measuring before optimising, and optimising the dominant term.
Query Optimisation
Reading a plan, fixing statistics, and finding the real bottleneck.
Edge Computing
Moving compute towards the user, and what cannot follow it.
Telemetry Cost
Observability bills that rival compute, and where to cut without going blind.