AWS Certified Data Analytics – Specialty — Question 90

A data analytics specialist is setting up workload management in manual mode for an Amazon Redshift environment. The data analytics specialist is defining query monitoring rules to manage system performance and user experience of an Amazon Redshift cluster.
Which elements must each query monitoring rule include?

Answer options

• A. A unique rule name, a query runtime condition, and an AWS Lambda function to resubmit any failed queries in off hours
• B. A queue name, a unique rule name, and a predicate-based stop condition
• C. A unique rule name, one to three predicates, and an action
• D. A workload name, a unique rule name, and a query runtime-based condition

Correct answer: C

Explanation

The correct answer is C because each query monitoring rule in Amazon Redshift must include a unique rule name, a set of predicates to evaluate conditions, and an action to take when those conditions are met. Options A, B, and D fail to include the necessary components as specified in the requirements for query monitoring rules in Redshift.