Which benefit is achieved by creating profiles?

Which benefit is achieved by creating profiles?
A . Reducing the growth of the DBC.AccessRights table
B . Managing user privileges on database objects
C . Assigning permanent space for groups of users with similar needs
D . Defining spool space for groups of users with similar needs

View Answer

Answer: D

Explanation:

Profiles in Teradata are used to manage and enforce resource limits for groups of users. This includes defining spool space, temporary space, and permanent space for users who share similar needs. Spool space is important for query processing, and managing it by profile helps prevent individual users from consuming excessive resources and ensures better overall system performance. Reducing the growth of the DBC.AccessRights table is not directly related to profiles. Profiles do not reduce access rights or the growth of this table, which tracks individual user privileges. Managing user privileges on database objects is handled through roles and grants, not profiles.

Profiles focus on resource management, not privileges.

Assigning permanent space for groups of users is partially true since profiles can manage some space attributes, but the main focus of profiles is on managing spool space rather than permanent space.