Teradata Certified Implementation Specialist V2R5

Exam NR0-012: Physical Implementation V2R5 consist of 60 questions. Time allowed for the exam is 75 minutes. Here are some example questions and answers:

Collected statistics on a Teradata table allows the Optimizer to predict which two factors? (Choose two)A - the AMP to send data toB - the number of occurrences of a valueC - the size of spool filesD - the PE that will be assigned to the process

Correct: B,C

Use of the SQL option: locking row nowait enables which action by the system?A - abort requesting task on a waitB - abort holding lock task on a waitC - downgrade to an access lockD - immediate access to the row

Correct: A

What happens to a submitted query when a deadlock occurs?A - Dispatcher identifies which query to hold and waits for completion of deadlock query.B - Youngest query is aborted.C - Query waits for deadlock to resolve.D - Oldest query is aborted.

Correct: B

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