Database / HA / migrate keywords

20 timed questions (~32 min, ~96 sec each). Underline force words before picking. Pair with the night guide.

1. 1.Sync standby in another AZ for RDS failover.

   A.Multi-AZ deploymentB.Read replicaC.DynamoDB global tableD.Manual snapshot hourly

2. 2.Relational multi-Region RPO 1s RTO under 1 minute.

   A.Aurora Global DatabaseB.RDS cross-Region read replicaC.DynamoDB (non-relational)D.Single-AZ RDS + frequent snapshots

3. 3.Frequent schema changes + global low latency.

   A.DynamoDBB.Aurora + replicasC.RDS Multi-AZD.Redshift

4. 4.Aurora prod on large instances; reports on small.

   A.Custom endpoints by capacityB.Default Aurora routingC.Reader endpoint for writes tooD.Only instance endpoints forever

5. 5.RDS MySQL auth token from EC2 instance profile.

   A.Enable IAM database authenticationB.Attach IAM role onlyC.SSL onlyD.STS without IAM DB auth

6. 6.Aurora MySQL row delete → distributed SQS consumers.

   A.RDS event subscription → SNSB.Native Lambda invoke → SQSC.RDS event → SQS directly as row triggerD.Only DynamoDB Streams

7. 7.DynamoDB item update → email subscribers.

   A.DAX + SNSB.Streams + Lambda + SNSC.Kinesis Adapter without enabling StreamsD.Scan every minute

8. 8..NET Windows + Oracle; minimize code change; HA.

   A.EKS Fargate refactorB.Beanstalk Multi-AZ + DMS to RDS Oracle Multi-AZC.ECS Anywhere as first choiceD.Keep Oracle on-prem only

9. 9.API usually quiet; bursts within seconds.

   A.API GW + EC2 ASGB.API GW + LambdaC.API GW + ECS ASGD.API GW + Beanstalk

10. 10.Need 2 instances after AZ failure; peak 6.

    A.Min 2 max 6 with 1 per AZB.Min 4 max 6 across two AZsC.Min 2 max 4D.All six in one AZ

11. 11.Per-process CPU on RDS OS.

    A.CloudWatch CPUUtilization onlyB.SSH to RDS host with agentC.Enhanced MonitoringD.Inspector

12. 12.Hot DynamoDB partitions / uneven WCU.

    A.Low-cardinality keysB.Fewer partition keysC.High-cardinality partition keysD.Avoid sort keys always

13. 13.Read replica vs Multi-AZ — replica is primarily?

    A.Synchronous AZ failoverB.Identical to Multi-AZC.Async read scaling / DR with lagD.Only for DynamoDB

14. 14.Homogeneous Oracle→Oracle migration tool of choice?

    A.SCT required alwaysB.Snowball onlyC.DMSD.OpenSearch

15. 15.Predictable 9–5 traffic; morning slowness.

    A.Wait for CPU dynamic scalingB.Predictive always if mixed sizesC.Scheduled scaling before 9D.Terminate ASG nightly

16. 16.RDS event subscriptions notify mainly about?

    A.Every INSERT/UPDATEB.CloudFront invalidationsC.S3 putsD.Operational/instance events

17. 17.Aurora cluster endpoint is for?

    A.Load-balanced readers onlyB.ElastiCacheC.Custom capacity groupsD.Current primary/writer

18. 18.Force words RPO/RTO across Regions for SQL → first map check?

    A.S3 Transfer AccelerationB.NACL rulesC.Instance StoreD.Aurora Global vs cross-Region replica lag

19. 19.IAM role on EC2 mentioning RDS without IAM DB auth enabled fails because?

    A.CostB.Wrong interfaceC.Fake magicD.Missing the toggle

20. 20.Before options on a migration stem, underline what first?

    A.Company brand colorsB.Only the word cloudC.Employee namesD.minimize change / engine / HA / time words