TDVAN5 practice question 6 of 15
Which benefit is achieved by creating profiles?
Full set: 72 questionsA 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.
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.
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.
Keep practicing
Take the free TDVAN5 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other TDVAN5 practice questions
- Question 1Which description accurately characterizes the use of external authentication for Vantage?
- Question 2An Administrator needs to provide end users access to data in a Native Object Store using…
- Question 3There is corruption in a table in the DBC database. Which action should the Administrator…
- Question 4A Vantage customer is using the Hive Connector in QueryGrid to access a foreign server an…
- Question 5A Vantage instance includes the following four databases: Tables Database contains base t…
- Question 7Users are complaining that queries in their workload are taking too long. The Administrat…
