Teradata Certified Administrator V2R5

Candidates must pass:
Exam NR0-011: Teradata Basics V2R5
Exam NR0-012: Physical Implementation V2R5
Exam NR0-014: Administration V2R5

Exam NR0-014: Administration V2R5 consist of 50 questions. Time allowed for the exam is 75 minutes. Here are some example questions and answers:

When will Reconfiguration utility abort?
A - when the Database Window shuts down
B - when the hash maps are incorrectly calculated
C - when the database restarts
D - when the system does not have sufficient storage capacity

Correct: D


Which clause in a CREATE VIEW statement restricts the columns in a table that can be viewed by users?
A - SELECT
B - USING
C - WHERE
D - WITH CHECK OPTION

Correct: A


Which two tasks should be performed before a Reconfig? (Choose two)
A - verify data integrity
B - drop secondary indexes
C - reassign spool to Reconfig
D - delete unneeded data

Correct: A,D


The passing score for the exam is 596 out of a possible maximum score of 800.

Teradata Certification