Contributor Insights in DynamoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Identify the top contributor by write operations

Given a DynamoDB table with Contributor Insights enabled, which query result shows the contributor with the highest number of write operations in the last hour?

DynamoDB

SELECT contributor_id, SUM(write_ops) AS total_writes FROM contributor_insights WHERE timestamp > CURRENT_TIMESTAMP - INTERVAL '1' HOUR GROUP BY contributor_id ORDER BY total_writes DESC LIMIT 1;

A {"contributor_id": "user321", "total_writes": 800}

B {"contributor_id": "user456", "total_writes": 1200}

C {"contributor_id": "user789", "total_writes": 900}

D {"contributor_id": "user123", "total_writes": 1500}

💡 Hint

Look for the highest sum of write_ops grouped by contributor_id.

The query sums write operations per contributor in the last hour and orders them descending. The top contributor is user123 with 1500 writes.

🧠 Conceptual

intermediate

Understanding Contributor Insights metrics

Which metric does Contributor Insights NOT provide by default?

A Latency of individual requests per contributor

B Number of write operations per contributor

C Number of read operations per contributor

D Number of throttled requests per contributor

💡 Hint

Think about what Contributor Insights tracks about contributors' activity.

Contributor Insights tracks counts of reads, writes, and throttled requests but does not provide latency metrics per contributor by default.

📝 Syntax

advanced

Correct syntax to enable Contributor Insights on a table

Which of the following AWS CLI commands correctly enables Contributor Insights on a DynamoDB table named 'Orders'?

A aws dynamodb update-table --table-name Orders --contributor-insights-status ENABLED

B aws dynamodb update-table --table-name Orders --contributor-insights-enabled true

C aws dynamodb update-table --table-name Orders --enable-contributor-insights

D aws dynamodb update-table --table-name Orders --contributor-insights ENABLE

💡 Hint

Check the exact parameter name for enabling Contributor Insights in AWS CLI.

The correct parameter is --contributor-insights-status with value ENABLED to enable Contributor Insights.

❓ optimization

advanced

Optimizing Contributor Insights for high-cardinality contributors

You have a DynamoDB table with thousands of unique contributors causing Contributor Insights to generate too many metrics. What is the best approach to reduce metric cardinality?

A Increase the table's read capacity units to handle more metrics

B Disable Contributor Insights entirely to stop metric collection

C Use Contributor Insights filters to include only top contributors

D Aggregate contributors into groups before enabling Contributor Insights

💡 Hint

Think about filtering metrics to reduce the number of contributors tracked.

Contributor Insights supports filters to limit metrics to top contributors, reducing cardinality and cost.

🔧 Debug

expert

Diagnosing missing Contributor Insights data

You enabled Contributor Insights on your DynamoDB table, but no contributor metrics appear after 24 hours. Which is the most likely cause?

A The table has no activity matching the contributor dimension

B The IAM role lacks permissions to publish Contributor Insights metrics

C Contributor Insights only works on global secondary indexes, not tables

D Contributor Insights requires at least 48 hours to start reporting metrics

💡 Hint

Check permissions related to Contributor Insights metric publishing.

Without proper IAM permissions, Contributor Insights cannot publish metrics, causing no data to appear.