You may contact us by email: datawarehouse4u.co.uk[at]gmail.com
Teradata Certified Implementation Specialist V2R5
Candidates must pass:
Exam NR0-011: Teradata Basics V2R5
Exam NR0-012: Physical Implementation 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)The passing score for the exam is 540 out of a possible maximum score of 800.
A - the AMP to send data to
B - the number of occurrences of a value
C - the size of spool files
D - the PE that will be assigned to the process
Use of the SQL option: locking row nowait enables which action by the system?
A - abort requesting task on a wait
B - abort holding lock task on a wait
C - downgrade to an access lock
D - immediate access to the row
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.
(C) 2009-2018 www.datawarehouse4u.co.uk
All Rights Reserved