Data Warehousing on AWS Training Monitoring and Troubleshooting

Question 1

Which Amazon CloudWatch metric should you monitor to detect when an Amazon Redshift cluster is running low on available memory?

Accepted Answer

PercentageDiskSpaceUsed

Answer

CPUUtilization

Answer

DatabaseConnections

Answer

NetworkTransmitThroughput

Question 2

Which system view in Amazon Redshift shows currently running queries along with their resource usage?

Accepted Answer

STV_INFLIGHT

Answer

SVL_QUERY_SUMMARY

Answer

STL_QUERY

Answer

SVV_TABLE_INFO

Question 3

What does a high value in the QueuedQueries CloudWatch metric indicate for an Amazon Redshift cluster?

Accepted Answer

Queries are waiting in WLM queues due to insufficient concurrency slots

Answer

Too many open database connections

Answer

Disk space is nearly full

Answer

The cluster is undergoing a resize operation

Question 4

Which Redshift system table helps you identify queries that are performing full table scans instead of using zone map filtering?

Accepted Answer

STL_SCAN

Answer

STL_LOAD_ERRORS

Answer

SVL_QUERY_SUMMARY

Answer

STV_BLOCKLIST

Question 5

What does the Redshift EXPLAIN command help you do?

Accepted Answer

Display the query execution plan so you can identify bottlenecks before running the query

Answer

Show current cluster health metrics

Answer

Generate table statistics for the optimizer

Answer

List all active user connections

Question 6

Which Amazon Redshift feature provides automated recommendations and alerts based on cluster performance analysis?

Accepted Answer

Redshift Advisor

Answer

CloudWatch Alarms

Answer

AWS Config Rules

Answer

Performance Insights