Data operations and support
Practise only this domain. 65 questions with explanations, 20 at a time.
Start data operations and supportSample questions
- A product team runs MySQL on Amazon RDS and wants to restore the database to how it looked 3 hours ago after a faulty migration. The backup feature must be native to RDS and need no extra setup. Which option meets this?Easy
- An engineering manager wants automated checks that flag idle or underused resources across the account, including warehouse and storage services, plus suggestions for lowering spend. Which service should the manager review?Easy
- A streaming ETL pipeline feeds a customer-facing dashboard. If an entire AWS Region becomes unreachable, the pipeline must keep ingesting and serving within minutes rather than waiting for that Region to recover. Which design meets the requirement?Medium
- A finance team's critical Redshift reporting cluster must return to service with the smallest possible recovery time after a hardware or Availability Zone failure. Which option gives the lowest RTO?Medium
- A Lambda function writes plain-text log lines such as 'order=1182 status=FAILED region=eu-west-1' to a CloudWatch log group. An engineer wants the order ID and status to appear as queryable fields in Logs Insights. Which command pulls those values out of the message text?Medium
- An Athena query fails after running for several minutes, and the team needs stage-level timing and data volumes to find the bottleneck. What should they do first?Medium
- An Aurora PostgreSQL cluster serves 500 application servers. The team needs connection pooling, IAM-based database credentials instead of embedded passwords, faster recovery when the writer fails, and a cache for repeated read queries. Which combination covers all four?Hard
- CloudWatch shows ReadLatency on an RDS for MySQL instance climbing from about 2 ms to 40 ms while CPU stays moderate. Queries that use indexes are also getting slower. Which cause should be investigated first?Medium