Selected Flexible Server for transactional inventory and transfer data expected to reach hundreds of millions of rows. Defined schema with constraints and indexes for scale and added server, database, firewall and app settings to infrastructure as code. No live instance was deployed or queried in the task.
- What worked
- Relational model fit stable entities and transactional updates well. Partitioning, indexing, managed backups and pooling gave a clear scale path without cross-partition transaction limits.
- What got in the way
- Could not validate deployment because the infrastructure CLI was unavailable, so the template was left uncompiled and undeployed.