DBS-C01 Practice Test 4 — 10 Questions

Question 1

Match each DynamoDB concept to its definition.

Question 2

Match each AWS database-related CLI command to its function.

Question 3

Match each AWS monitoring tool to its capability for databases.

Question 4

Match each AWS security feature to its purpose for databases.

Question 5

Match each backup/restore concept to its AWS database feature.

Question 6

Match each AWS database migration tool/service to its function.

Question 7

A company is designing a database for an e-commerce application that needs to store product catalog data. The data is highly structured with relationships between products, categories, and suppliers. The application requires ACID transactions to maintain data integrity when updating inventory. The company expects moderate read and write traffic. Which AWS database service is MOST suitable for this workload?

Accepted Answer

Amazon RDS for MySQL. Amazon RDS for MySQL is the most suitable choice because it provides a fully managed relational database that supports ACID transactions, which are essential for maintaining data integrity during inventory updates. The highly structured nature of product catalog data with relationships between products, categories, and suppliers maps naturally to MySQL's relational model with foreign keys and joins. RDS for MySQL handles moderate read/write traffic efficiently and offers features like Multi-AZ for high availability and read replicas for scaling reads.

Answer

Amazon ElastiCache for Redis

Answer

Amazon Neptune

Answer

Amazon DynamoDB

Question 8

A company runs a production Amazon RDS for PostgreSQL DB instance. The database experiences intermittent high latency during peak hours. The company's monitoring shows that CPU utilization is below 40%, memory is adequate, and network throughput is normal. The DB instance uses General Purpose SSD (gp2) storage with 3,000 Provisioned IOPS. Which TWO actions should a database specialist take to diagnose and resolve the performance issue? (Choose two.)

Accepted Answer

Check the Burst Balance metric in Amazon CloudWatch for the DB instance.. Option A is correct because gp2 storage uses a credit-based burst model, and the Burst Balance metric indicates the remaining I/O credits. If the burst balance is depleted, the instance is throttled to the baseline IOPS (3,000 for this size), causing high latency despite low CPU and adequate memory. Checking this metric directly identifies whether the storage is starved for I/O credits.

Answer

Change the storage type to Provisioned IOPS SSD (io1) with 10,000 IOPS.

Answer

Increase the Read IOPS by modifying the instance to a larger instance class.

Answer

Review the SwapUsage metric for the DB instance to check for memory pressure.

Question 9

A database specialist sees the above error log entries from an Amazon RDS for MySQL DB instance. Which action should be taken to resolve the issue?

Accepted Answer

Restore the DB instance from the latest automated snapshot.. The error log entries indicate corruption in the InnoDB tablespace, likely due to a crash or hardware failure. Restoring from the latest automated snapshot is the correct action because it provides a consistent, point-in-time recovery of the entire database, including all table structures and data, without relying on potentially corrupted files. This approach ensures data integrity and avoids further damage that could occur from attempting repairs on a corrupted instance.

Answer

Increase the allocated storage for the DB instance.

Answer

Reboot the DB instance to clear the error.

Answer

Run the mysqlcheck command to repair the corrupted tables.

Question 10

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The security team requires that all connections to the database be encrypted in transit. Which TWO steps should be taken to enforce this requirement?

Accepted Answer

Set the rds.force_ssl parameter to 1 in the DB parameter group.. Setting the rds.force_ssl parameter to 1 in the DB parameter group forces all connections to the Oracle RDS instance to use SSL/TLS encryption. This is the direct method to enforce encryption in transit for Amazon RDS for Oracle, as it rejects any non-SSL connections at the database level.

Answer

Enable Oracle native network encryption (NNE) in the sqlnet.ora file.

Answer

Use AWS Secrets Manager to store database credentials and enable Kerberos authentication.

Answer

Use AWS Direct Connect or a VPN to connect to the VPC.