Teradata Teradata Administration 2

Question 1

Which Teradata privilege allows a user to pass their granted privileges on to other users?

Accepted Answer

WITH GRANT OPTION

Answer

GRANT OPTION

Answer

PASS PRIVILEGE

Answer

CASCADE GRANT

Question 2

What is a Teradata role used for in security management?

Accepted Answer

Bundling a set of privileges that can be assigned to multiple users

Answer

Grouping tables into logical schemas

Answer

Defining CPU resource limits for users

Answer

Creating virtual users for batch processes

Question 3

Which DBC system view lists all privileges granted to users and roles in Teradata?

Accepted Answer

DBC.AccessRights

Answer

DBC.Users

Answer

DBC.RoleMembers

Answer

DBC.AllRights

Question 4

What does the REVOKE statement do in Teradata?

Accepted Answer

Removes previously granted privileges from a user or role

Answer

Removes a user from the system

Answer

Drops a database object

Answer

Disables a user account temporarily

Question 5

Which Teradata feature provides row-level security by filtering which rows a user can see in a table?

Accepted Answer

Row-Level Security (RLS) via security constraints

Answer

Column-Level Security (CLS)

Answer

Table Access Control (TAC)

Answer

Dynamic Data Masking (DDM)

Question 6

What is the purpose of the GRANT LOGON statement in Teradata?

Accepted Answer

Authorizes a specific host or network client to log on to Teradata

Answer

Creates a new user login account

Answer

Resets a user's password

Answer

Enables multi-factor authentication for a user

Question 7

Which Teradata profile attribute controls the maximum number of concurrent sessions a user is allowed to open?

Accepted Answer

SESSIONS

Answer

MAXLOGONATTEMPTS

Answer

CONCURRENT_SESSIONS

Answer

MAX_SESSIONS