VUE/Prometric Code: NR0-017
Exam: Teradata Masters Update v2r5 Exam
Q&A:168 Q&As
Teradata Certified Professional NR0-017문제는 시험문제의 변화에 따라 업데이트가 될것입니다.시험문제가 매번 바뀐 후, 2일내에 시험문제 NR0-017를 수정하여 다시 조정함으로서NR0-017:Teradata Masters Update v2r5 Exam가 시험문제의 점유률을 항상 96% 이상으로 확보합니다.
시험문제보기:
5.Which two functions does the Teradata Statistics Wizard perform? (Choose two.)
A.recommends secondary indexes
B.executes the statistics collection recommendations
C.displays current versus captured statistics information
D.reproduces Optimizer-related issues in a test environment
E.recommends recollection of statistics based on table skew
Correct:B E
6.Which two can be used to validate the effectiveness and usefulness of statistics on a given
query? (Choose two.)
A.HELP STATISTICS
B.Teradata Statistics Wizard
C.checking how recently the statistics were refreshed
D.checking the confidence level in the EXPLAIN output
Correct:B D
7.Which three tasks can be performed by an authorized user of the Teradata Performance Monitor?
(Choose three.)
A.abort user sessions
B.identify a blocked user
C.purge ResUsage tables D.reset peak utilization values
E.display system efficiency measurements
Correct:A B E
8.Which three default options are available as built-in physical actions to a triggered alert within
Teradata Manager? (Choose three.)
A.send an email
B.abort a session
C.execute a program
D.increase spool space
E.raise the priority of a session
Correct:A B C
9.An EXPLAIN output contains the following phrase: "SORT to partition Spool 3 by rowkey" Which
two statements about Spool 3 are true? (Choose two.)
A.It will be partitioned by partition number within row hash.
B.It will be partitioned by row hash within partition number.
C.It will be sorted to prepare for joining to a partitioned table.
D.It will be sorted to prepare for joining to a non-partitioned table.
Correct:B C
NR0-017덤프다운로드바로가기: http://www.killtest.kr/TeradataCertifiedProfessional/NR0-017.asp