Hyperion Drm Interview Questions and Answers - 1

Question: 1

What is DRM?

DRM offers a component based approach to resource allocation management.

It allows you to create resource plans, which specify resource allocation to various consumer groups. You can group users based on the resource requirement.

DRM offers an easy to use and flexible system by defining distinct independent components.

Question: 2

What are the components or elements of DRM?

The three main components or elements of DRM are given as follows:

Resource consumer groups

Resource plans

Resource plan directives

Question: 3

What is a resource allocation method?

This parameter is used to define the method used to allocate database resource.

There can be many different resource allocation methods, such as CPU method, idle time, and active session pool.

These are also called parameters to resource plan directive.

Question: 4

List some of the benefits of DRM?

Following are the benefits of the DRM:

Enables you to limit the length of time a user session can stay idle and automatically terminates long running SQL statements and user sessions.

Sets the initial login priorities for various consumer groups

Uses the concept of active session pool to specify the maximum number of concurrent active sessions for a consumer group.

The database resource manager will automatically queue all the subsequent requests until the currently running sessions complete.

Question: 5

What is a sub plan?

A resource sub plan is a plan, which gets the resource to allocate from a higher level plan.

It is created in a similar manner as a plan. However, a top level plan gets to allocate 100% of the resource while a sub plan can allocate only the resources allocated to it by the top level plan.