Teradata Masters Update v2r5 Exam braindumps free download

Free nr0-017 Demo Download

just4cert offers free demo for NCR Teradata certification nr0-017 (Teradata Masters Update v2r5 Exam). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

Download nr0-017 PDF Demo

Why choose just4cert nr0-017 braindumps

Quality and Value for the nr0-017 Exam
100% Guarantee to Pass Your nr0-017 Exam
Downloadable, Interactive nr0-017 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

nr0-017 free demo:

　
　
Exam : NCR Teradata NR0-017
Title : Teradata masters update v2r5 exam

1. To use the Teradata System Emulation Tool (TSET), Target Level Emulation must first be enabled on a test system using which utility?
A. Ferret
B. DBSControl
C. Vproc Manager
D. Teradata Performance Monitor
Answer: B

2. Teradata Manager’s utilities can be used for which three activities? (Choose three.)
A. workload analysis
B. performance monitoring
C. archiving and restoring data
D. running remote console commands
E. distributing Teradata application software to remote clients
Answer: ABD

3. 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.
Answer: BC

4. 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
Answer: ABE

5. 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
Answer: ABC

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
Answer: BD

7. An EXPLAIN output contains the following phrase:
"group_amps"
Which statement is true?
A. A group of rows on a fallback AMP is being updated.
B. The AMPs are being prepared for a local aggregation step.
C. The AMPs are being grouped in preparation for a vertical sort.
D. Subsequent steps will use a subset of AMPs instead of all AMPs.
Answer: D

8. Teradata Visual Explain supports the comparison of how many plans?
A. 4
B. 16
C. 32
D. unlimited
Answer: D

9. 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
Answer: BE

10. Using the Teradata Statistics Wizard, workloads may be _____. (Choose two.)
A. defined from Query Capture Database (QCD) statements
B. imported from another system
C. defined from the Workload Monitor
D. defined from Teradata Dynamic Query Manager (TDQM) statements
Answer: AB

11. Which three statements about collecting statistics are true? (Choose three.)
A. Statistics can be collected using a sample of the table data.
B. Multi-column statistics can be collected without creating an index.
C. Statistics can be collected on a maximum of 16 columns and indexes per table.
D. Statistics can be collected on a maximum of 512 columns and indexes per table.
E. Statistics can be useful in determining which AMP(s) will be accessed for query processing.
Answer: ABD

12. What are two functions of the Teradata Index Wizard? (Choose two.)
A. allows for "what-if" analysis
B. allows you to schedule index creation
C. allows importing of workload from Teradata Manager
D. allows for a visual explanation of the index creation plan
Answer: AB