Instiq

2Managing across multiple database technologies

Practice questions →Glossary →
  • 2.1Access management and monitoring/troubleshooting

    Understand IAM and policies for database connectivity/access control, managing user authentication/access, investigating slow queries/locking/missing indexes, monitoring vitals (RAM/CPU/storage/IO) and audit logging, quota management, resource contention, and alerts for errors and performance.

  • 2.2Backup/recovery, cost/performance optimization, and automation

    Understand backup/recovery (automatic scheduled backups, export/import, RTO/RPO/PITR), data retention, optimizing cost/performance via scale up/out and replication strategies, query optimization, and automating common database tasks (index rebuilds, exports, upgrades, SLA/SLO monitoring).