NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 2

With which kind of archived table are the ROLLBACK and ROLLFORWARD statements used?


Options are :

  • dictionary tables
  • index subtables
  • Permanent Journal tables
  • Transient Journal tables

Answer : Permanent Journal tables

The Teradata Warehouse Builder has which three attributes? (Choose three.)


Options are :

  • end to end parallelism
  • single scripting language
  • scalable
  • runs in interactive mode
  • Transient Journal compliant

Answer : end to end parallelism single scripting language scalable

TE0-121 Teradata Basics Practice Test Set 1

"Only 12 sessions can be logged on for a userid" is what kind of Teradata Dynamic Query Manager (TDQM) rule?


Options are :

  • query access
  • object access
  • workload
  • query resource

Answer : workload

Permanent space limits can be assigned at which two of the followinglevels? (Choose two.)


Options are :

  • table
  • database
  • user
  • system

Answer : database user

Setting the FreeSpacePercent parameter of the DBSControl utility to 15% has what effect?


Options are :

  • Each user is limited to 15% of memory for their active work space.
  • Cylinders are loaded to 85% of their capacity during load operations
  • Table blocks are written with 15% of the space left in the block for more rows to be inserted.
  • Spool files are not created when there is less than 15% free space on an AMP.

Answer : Cylinders are loaded to 85% of their capacity during load operations

TE0-141 14 Teradata Basics Certified Practice Test Set 3

The profile Acct_User is removed from UserA via which statement?


Options are :

  • REMOVE USER User A FROM PROFILE Acct User;
  • DROP USER User A;
  • MODIFY USERUserA AS PROFILE=NULL;
  • MODIFY PROFILE Acct_User AS ACCOUNT=NULL;

Answer : MODIFY USERUserA AS PROFILE=NULL;

Information on node utilization is provided by which ResUsage table?


Options are :

  • ResUsageSctl
  • ResUsageSvpr
  • ResUsageScpu
  • ResUsageSpma

Answer : ResUsageSpma

You are a database administrator at Your company. Your company has User A running a complex join with $L priority in the DEFAULT partition. You use Teradata Manager to alter the priority of the user's query to $R. this change has which two effects on the jobscurrently running on a busy system? (Choose two).


Options are :

  • The other users' jobs experience a performance improvement
  • The other users' jobs experience performance degradation
  • User A's job will experience a performance improvement
  • The other users' jobs are not affected.
  • User A's job will experience performance degradation

Answer : The other users' jobs experience performance degradation User A's job will experience a performance improvement

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

In which circumstance will the Reconfiguration utility abort?


Options are :

  • when the hash maps are incorrectly calculated
  • when the Database Window shuts down
  • when the system does not have sufficient storage capacity
  • when the database restarts

Answer : when the system does not have sufficient storage capacity

Which two of the following utilizations must be examined first when you troubleshoot bottlenecks? (Choose two.)


Options are :

  • BYNET utilization
  • disk utilization
  • channel utilization
  • memory utilization
  • CPU utilization

Answer : disk utilization CPU utilization

The Teradata Warehouse Builder DataConnector operator supports which three of the following functions? (Choose three.)


Options are :

  • preprocessing input data files
  • writing data to external data files
  • reading external data files
  • reading unspecified number of data files

Answer : writing data to external data files reading external data files reading unspecified number of data files

NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 2

If you are a Your company database administrator, how would you apply inherited privileges?


Options are :

  • by granting privileges with the ALL option to a user
  • by using GIVE to change user hierarchy
  • by granting inherited privileges directly to the user
  • by automatically applying inherited privileges

Answer : by granting privileges with the ALL option to a user

If no value is specified in the user's profile parameter or the CREATE USER statement, what default value is assigned as the user's default database?


Options are :

  • database DBC
  • the user's username
  • a NULL value
  • the default database of the user's parent

Answer : the user's username

You are a database administrator at Your company.You create User A and assigned this user 90 MB of spool. You create Profile B with 50 MB of spool a month later, after which you assign User A to Profile B. Which is the system view you would use to calculate how much access spool User A now has?


Options are :

  • DBC.ProfileInfo
  • DBC.SessionInfo
  • DBC.Users
  • DBC.Accountinfo

Answer : DBC.ProfileInfo

NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 2

The MaxLoadTasks parameter limits which three of the following utilities in the DBSControl utility? (Choose three.)


Options are :

  • TPump
  • BTEQ
  • FastExport
  • FastLoad
  • MultiLoad

Answer : FastExport FastLoad MultiLoad

To determine node memory usage, you should examine which ResUsage table?


Options are :

  • ResUsageSvpr
  • ResUsageSldv
  • ResUsageSpma
  • ResUsageScpu

Answer : ResUsageSpma

Of the following statements, which two pertaining to ownership privileges are correct? (Choose two.)


Options are :

  • They cannot be explicitly revoked.
  • They can be explicitly revoked by the Database Administrator
  • They cannot be taken away unless ownership is transferred
  • They must be explicitly granted

Answer : They cannot be explicitly revoked. They cannot be taken away unless ownership is transferred

TE0-121 Teradata Basics Practice Test Set 5

What benefit does assigning account strings at the profile level have?


Options are :

  • enables you to save space by reducing the number of rows inserted into DBC.AMPUsage
  • enables you to save space by reducing the number of rows inserted into DBC.Access Rights
  • enables you to change all or part of the designation just once for many users
  • enables you to grant privileges to a group of users based on their account string

Answer : enables you to change all or part of the designation just once for many users

Sessions are acquired in which MultiLoad stage?


Options are :

  • logon
  • preliminary
  • acquisition
  • application

Answer : preliminary

Which of the followingdescribes the Teradata Visual Explain utility input?


Options are :

  • Query Capture Table (QCT)
  • Visual Explain Database (VED)
  • Visual Explain Table (VET)
  • Query Capture Database (QCD)

Answer : Query Capture Database (QCD)

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

From which two of the followingsystem tables are rows deleted, when a DROP USER command is issued on a user who is assigned to a role? (Choose two.)


Options are :

  • DBC.RoleGrants
  • DBC.AccessRights
  • DBC.SessionInfo
  • DBC.AMPUsage

Answer : DBC.RoleGrants DBC.AccessRights

What occurs in the event of a database containing a Permanent Journal running out of space?


Options are :

  • All table updates that write to that Permanent Journal are written to the Fallback Permanent Journal.
  • All table updates that write to that Permanent Journal abort.
  • The DBS restarts.
  • All non-used Permanent Journals in that database are dropped.

Answer : All table updates that write to that Permanent Journal abort.

The rows in a table that can be updated by users is restrict by which two clauses in a CREATE VIEW statement? (Choose two.)


Options are :

  • WITH CHECK OPTION
  • SELECT
  • USING
  • WHERE

Answer : WITH CHECK OPTION WHERE

TE0-121 12 Teradata Basics Certification Practical Exam Set 6

You are a database administrator at Your company, and have an active session with a query in progress with data already cached. When you disable logging to the Database Query Log (DBQL), what will happen? (Choose two.)


Options are :

  • Collected rows are deleted from disk.
  • Cache is not immediately flushed.
  • Subsequent queries during that session are not logged.
  • Collected rows are committed immediately.

Answer : Collected rows are deleted from disk. Collected rows are committed immediately.

The growth of the AccessRights table can effectively be limited by which two of the following methods? (Choose two.)


Options are :

  • grant all privileges at the database level
  • grant all necessary privileges to each user on individual database objects
  • assign users to one or more roles
  • ensure that all users belong to a profile and inherit the profile's access rights

Answer : grant all privileges at the database level assign users to one or more roles

Whichof the followingis the maximum number of nested levels for a role?


Options are :

  • The limit is determined by the default system setting.
  • one
  • two
  • There is no limit on the number of nested levels

Answer : one

TE0-124 Teradata 12 Database Administration Practice Exam Set 1

Of the followingstatements, which two are accurate regarding Permanent Journals? (Choose two.)


Options are :

  • Permanent Journals must be Fallback.
  • Permanent Journals replace Fallback protection
  • Multiple Permanent Journals can be used by one data table
  • Multiple data tables can share one Permanent Journal
  • Data tables in one database can use Permanent Journals in other databases.

Answer : Multiple data tables can share one Permanent Journal Data tables in one database can use Permanent Journals in other databases.

Which two can be determined with AMPUsage data? (Choose two.)


Options are :

  • user activity
  • database owners
  • user privileges
  • session priority

Answer : user activity session priority

Which three are techniques for reducing the number of rows that are inserted into the DBC.AccessRights table? (Choose three.)


Options are :

  • assign users to a role
  • assign users to a profile
  • grant privileges at the user level
  • grant privileges at the database level

Answer : assign users to a role grant privileges at the user level grant privileges at the database level

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

Which clause in a CREATE VIEW statement restricts the columns in a table that can be viewed by users?


Options are :

  • SELECT
  • USING
  • WHERE
  • WITH CHECK OPTION

Answer : SELECT

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions