Hyperion Drm Interview Questions and Answers - 3

Question: 11

What is canceling SQL and terminating sessions?

You can specify the directives to cancel long running SQL queries or to terminate long running sessions based on the amount of system resources consumed.

In other words, you can cancel SQL queries or kill sessions if consumer group meets certain criteria.

The criterion is specified using the SWITCH_TIME and SWITCH_ESTIMATE parameters.

The option to CANCEL_SQL or KILL_SESSION can be specified by the SWITCH_GROUP parameter.

Question: 12

What is automatic consumer group switching?

It is a type of resource allocation method used to automatically switch the consumer group if the switch criterion is met.

The switch group is specified using the SWITCH_GROUP parameter.

Switch criteria can be set using the SWITCH_TIME and SWITCH_ESTIMATE parameters.