Data and Storage Monitoring GCTD Practice Questions (Page 9)

Questions 41–45

1. 41application · medium

   A company must retain financial records for seven years, but wants to automatically delete temporary files after 30 days. The compliance team also needs to be able to prove that no data was deleted before the retention period ended. Which combination of monitoring and data lifecycle controls should be implemented?

   • ACreate a manual process to delete temporary files and keep all other data indefinitely
   • BSet up a replication rule to copy all objects to another region and rely on the replica as a backup
   • CEnable versioning and set a lifecycle rule to delete all objects after 30 days
   • DUse object lifecycle policies for deletion and enable object lock with retention, while logging all lifecycle actions
   Reveal Solution Discussion Select an answer first
2. 42expert · hard

   A database administrator is investigating a potential data breach. The audit logs show that a large number of SELECT queries were executed by a single user account over a short period. The queries returned a large volume of data. Which additional log source would help determine if the data was actually exfiltrated?

   • AThe database's storage utilization metrics.
   • BThe database's connection count at the time of the queries.
   • CThe database's backup logs showing the last successful backup time.
   • DThe database's network traffic logs showing the destination IPs of query results.
   Reveal Solution Discussion Select an answer first
4. 43application · medium

   A security analyst notices that a cloud database's connection count spikes to 10x normal for 15 minutes every night at 2:00 AM, but no corresponding increase in query latency or CPU is observed. The analyst suspects a legitimate batch job but wants to confirm. Which monitoring approach would best validate the cause without creating noise?

   • ACreate an alert that triggers on any connection count above the 95th percentile and page the on-call engineer immediately.
   • BDisable connection logging to reduce the performance impact of the nightly spike.
   • CCorrelate the connection spike with database audit logs that record the application name and client IP for each new connection.
   • DIncrease the database connection pool size to accommodate the spike and then ignore future occurrences.
   Reveal Solution Discussion Select an answer first
5. 44expert · hard

   A database administrator is troubleshooting a performance issue. The database's query latency is high, but CPU and memory utilization are normal. The administrator suspects that the issue is due to inefficient queries or locking. Which monitoring data would best help confirm this suspicion?

   • AStorage capacity metrics for the database's disk
   • BNetwork latency metrics between the application and database
   • CBackup job status for the database
   • DDatabase query performance insights showing slow query logs and lock wait times
   Reveal Solution Discussion Select an answer first
6. 45expert · hard

   A company's backup strategy uses nightly backups to object storage with a 30-day retention period. The company's recovery point objective (RPO) is 24 hours and the recovery time objective (RTO) is 12 hours. The backup team wants to reduce the RTO to 4 hours without increasing the backup frequency. Which action should the team take?

   • ASwitch to a different storage class that has lower latency for reads
   • BIncrease the backup retention period to 60 days
   • CTest the restore process regularly and document the steps to ensure a faster restore
   • DMove backups to a different region to improve availability
   Reveal Solution Discussion Select an answer first