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 questionsBatch-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.
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.
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.
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 6Which benefit is achieved by creating profiles?
- Question 7Users are complaining that queries in their workload are taking too long. The Administrat…
