TDVAN5 practice question 6 of 15

Which benefit is achieved by creating profiles?

Full set: 72 questions
Answer options
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 Correct answer
Correct Answer:
D. Defining spool space for groups of users with similar needs
Explanation

A Teradata profile is a database object that defines a set of attributes that can be assigned to multiple users. This simplifies administration by allowing common settings to be managed in one place. One of the key attributes that can be defined within a profile is the SPOOL space limit. This allows an administrator to set a consistent spool space allocation for a group of users who have similar query processing needs, rather than defining it individually for each user.

Why Incorrect

A. Reducing the growth of the DBC.AccessRights table: This benefit is achieved by using roles to grant privileges to groups of users, not by using profiles.
B. Managing user privileges on database objects: This is the primary function of roles. Profiles manage user environment attributes, not object access rights.
C. Assigning permanent space for groups of users with similar needs: Permanent space (PERM) is an attribute of a user or database and is assigned directly, not through a profile.

References

1. Teradata Vantage™ SQL Data Definition Language, Release 17.20, B035-1184-172K, December 2022.

Section: "Chapter 2: Data Dictionary Objects > Profiles > Purpose of a Profile". This section states, "A profile is a set of attributes that can be assigned to one or more users... For example, you can use a profile to specify a common SPOOL space limit for a group of users."

Section: "Chapter 6: SQL Data Definition Language Statements > CREATE PROFILE". The syntax for the CREATE PROFILE statement explicitly includes the SPOOL = integer | decimal clause, confirming that spool space is a definable attribute. It does not include a PERM space clause.

2. Teradata Vantage™ - Database Administration, Release 17.20, B035-1093-172K, December 2022.

Section: "Chapter 10: Setting Up Users > About User Definitions > Profiles". This chapter explains, "A profile is a named object that defines limits for spool space... and other user attributes. You can assign a profile to one or more users to simplify the management of these attributes." It clearly distinguishes this from roles, which manage privileges.

Scroll to Top