CLF-C02 Database Services 5

Question 1

Which pricing model for Amazon DynamoDB is best for applications with consistent, predictable traffic patterns?

Accepted Answer

Provisioned Mode with Auto Scaling

Answer

Provisioned Mode with Auto Scaling is cost-effective for predictable workloads as you specify expected read/write capacity and pay for reserved throughput.

Question 2

How does Amazon Aurora Global Database help multi-region applications?

Accepted Answer

It replicates data to secondary regions with less than 1 second lag for fast local reads

Answer

Aurora Global Database uses dedicated replication infrastructure to achieve sub-second replication lag to up to five secondary regions.

Question 3

A company stores user session data that should automatically expire after 24 hours. Which DynamoDB feature handles this without manual deletion?

Accepted Answer

DynamoDB Time to Live (TTL)

Answer

DynamoDB TTL automatically deletes items at a specified expiration timestamp, making it ideal for session data and temporary records.

Question 4

What is the key advantage of using Amazon Redshift Serverless compared to provisioned Redshift clusters?

Accepted Answer

It charges only when queries are running, with no idle cluster costs

Answer

Redshift Serverless automatically provisions capacity and charges only for the compute used during query execution, eliminating idle cluster costs.

Question 5

Which AWS service would you use to convert a Microsoft SQL Server database to an open-source engine like Aurora PostgreSQL?

Accepted Answer

AWS Schema Conversion Tool (SCT)

Answer

AWS Schema Conversion Tool automatically converts your existing database schema and most of the application code to a new target database engine.

(CLF-C02) AWS Certified Cloud Practitioner Practice Test

(CLF-C02) AWS Certified Cloud Practitioner Practice Test

CLF-C02 Database Services 5