CloudWatch metrics for DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the CloudWatch metric for DynamoDB read capacity units.

DynamoDB

SELECT MetricName FROM CloudWatchMetrics WHERE MetricName = '[1]';

Drag options to blanks, or click blank then click option'

AConsumedReadCapacityUnits

BWriteCapacityUnits

CConsumedWriteCapacityUnits

DReadCapacityUnits

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing write capacity metrics instead of read capacity.

Confusing consumed units with provisioned units.

The metric ConsumedReadCapacityUnits shows the number of read capacity units consumed by your DynamoDB table.

2fill in blank

medium

Complete the code to filter CloudWatch metrics for DynamoDB tables with the dimension 'TableName'.

DynamoDB

SELECT MetricName FROM CloudWatchMetrics WHERE Namespace = 'AWS/DynamoDB' AND [1] = 'TableName';

Drag options to blanks, or click blank then click option'

ADimensionValue

BMetricName

CNamespace

DDimensionName

Attempts:

3 left

💡 Hint

Common Mistakes

Filtering by DimensionValue instead of DimensionName.

Using Namespace instead of dimension fields.

The DimensionName field specifies the dimension type, such as 'TableName' for DynamoDB metrics.

3fill in blank

hard

Fix the error in the query to get the sum of consumed write capacity units for a DynamoDB table.

DynamoDB

SELECT SUM(Value) FROM CloudWatchMetrics WHERE MetricName = '[1]' AND DimensionName = 'TableName' AND DimensionValue = 'MyTable';

Drag options to blanks, or click blank then click option'

ASumWriteCapacity

BWriteCapacityUnits

CConsumedWriteCapacityUnits

DConsumedReadCapacityUnits

Attempts:

3 left

💡 Hint

Common Mistakes

Using read capacity metrics instead of write capacity.

Using incorrect metric names that do not exist.

The correct metric to sum is ConsumedWriteCapacityUnits, which tracks the write capacity units consumed.

4fill in blank

hard

Fill both blanks to create a query that retrieves the average latency for a DynamoDB table named 'Orders'.

DynamoDB

SELECT [1] FROM CloudWatchMetrics WHERE MetricName = '[2]' AND DimensionName = 'TableName' AND DimensionValue = 'Orders';

Drag options to blanks, or click blank then click option'

AAVG(Value)

BSUM(Value)

CSuccessfulRequestLatency

DThrottledRequests

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM instead of AVG for latency.

Choosing the wrong metric like 'ThrottledRequests'.

The average latency is calculated using AVG(Value) on the metric SuccessfulRequestLatency.

5fill in blank

hard

Fill all three blanks to write a query that gets the maximum number of throttled requests for a DynamoDB table named 'Customers' in the last hour.

DynamoDB

SELECT [1] FROM CloudWatchMetrics WHERE MetricName = '[2]' AND DimensionName = 'TableName' AND DimensionValue = '[3]' AND Timestamp >= NOW() - INTERVAL '1' HOUR;

Drag options to blanks, or click blank then click option'

AMAX(Value)

BReadThrottleEvents

CCustomers

DConsumedReadCapacityUnits

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or AVG instead of MAX.

Using the wrong table name or metric.

To find the maximum throttled requests, use MAX(Value) on the ReadThrottleEvents metric for the 'Customers' table.