TDVAN5 practice question 5 of 15

A Vantage instance includes the following four databases: Tables Database contains base tables and associated index subtables Upsert_Database…

Full set: 72 questions
A Vantage instance includes the following four databases: Tables Database contains base tables and associated index subtables Upsert_Database: contains views and other objects to support base table modifications Query Database: contains views and other objects supporting queries and reporting Development_Database: contains objects supporting development of new data applications The Administrator needs to add a new user that will perform batch-level functions. Which action should the Administrator take to achieve this goal?
Answer options
A: Grant the CHECKPOINT privilege on the Tables_Database to the new user’s account.
B: Set the user’s default role to one that has the CREATE TABLE privilege on the Tables_Database. Correct answer
C: Set the user's profile to one that has the CREATE TABLE privilege on the Tables_Database.
D: Grant the CHECKPOINT privilege on the Tables_Database to the new user’s profile.
Correct Answer:
B. Set the user’s default role to one that has the CREATE TABLE privilege on the Tables_Database.
Explanation

Batch-level functions, such as data loading with Teradata Parallel Transporter (TPT) or legacy utilities, frequently require the creation of temporary work, error, or staging tables within the target database. The CREATE TABLE privilege is essential for these operations. In Teradata, the best practice for managing permissions is to bundle privileges into roles and then grant those roles to users. By setting the user's default role to one that possesses the CREATE TABLE privilege on the TablesDatabase, the administrator correctly and efficiently enables the user to perform the required batch tasks.

Why Incorrect

A. The CHECKPOINT privilege is specific to the FastLoad utility for restart capabilities and is insufficient by itself for most batch operations, which also require DDL and DML privileges.
C. Profiles in Teradata are used to manage system resources like spool space, temporary space, and password policies, not for granting object access privileges like CREATE TABLE.
D. Object access privileges cannot be granted to a profile. Privileges are granted directly to users or, more commonly, to roles, which are then assigned to users.

References

1. Teradata Vantage™ - Security Administration, Release 17.20, B035-1100-2109K, Chapter 4: Managing Access Rights, Section: About Roles: "A role is a database object that is a collection of privileges. You can grant a role to a user or to another role... Using roles simplifies security administration." This supports using roles to manage collections of privileges.

2. Teradata Vantage™ - Security Administration, Release 17.20, B035-1100-2109K, Chapter 3: Managing User Accounts, Section: About Profiles: "A profile is a named object that contains a set of session- and resource-related attributes that you can assign to one or more users... For example, you can use a profile to specify... Spool space limit... Password controls." This confirms that profiles manage resources, not object privileges, making options C and D incorrect.

3. Teradata® Tools and Utilities Access Module Reference, Release 17.10, B035-2425-021K, Chapter 2: Access Module Privileges, Section: Teradata PT Load Operator: This section details the privileges required for loading data, which include INSERT on the target table and CREATE TABLE and DROP TABLE on the database where error tables are created. This confirms the necessity of the CREATE TABLE privilege for batch functions.

Scroll to Top