kaoccna 的优势

nr0-017 试题的质量和价值
mcsepass 模拟测试题具有最高的专业技术含量，只供具有相关专业知识的专家和学者学习和研究之用。
100% 保证您通过 nr0-017 的考试
如果你使用 mcsepass 模拟测试，我们将保证你的第一次参加考试即取得成功，否则，我们将全额退款！
试用后再购买
mcsepass 提供每种产品免费测试。在您决定购买之前，请检测联接，可能存在的问题及试题质量和适用性。
kaoccna认证考试题库网专业提供 NCR Teradata nr0-017 最新题库下载，完全覆盖 mcsepass 考试原题。

部分考题展示

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


1. 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

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

3. 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

4. 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

5. 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

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. Which three filters are available within Teradata Manager's Session Status report? (Choose three.)
A. blocked
B. unusual
C. parceling
D. logging on
E. responding
Answer: ABE

8. 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

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. 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

11. Which two does the Teradata System Emulation Tool (TSET) utility allow? (Choose two.)
A. import workloads from other Teradata utilities
B. import sample data from one system to another
C. import data demographics from one system to another
D. import system characteristics from one system to another
Answer: CD

12. 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

13. 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

14. 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