• nr0-015题库demo免费下载

  Filed under NCR Teradata
  Aug 3

  NCR Teradata认证nr0-015考试题库介绍

  考试代号: nr0-015
  问题数量:120 Q&As
  
  更新时间: 2009-08-31
  注册地点: Prometric/Pearson VUE
  题库全称:Teradata Design Architecture v2r5 Exam

  免费nr0-015题库Demo赏析

  　
  　
  Exam : NCR Teradata NR0-015
  Title : Teradata design architecture v2r5 exam

  1. Permanent space on a Teradata machine is being used up rapidly. The DBA wants to ensure there will be enough spool space in the system to satisfy all requests. What should the DBA do to ensure there will be enough spool space in the system for query needs?
  A. create a database called Spool_Space with all currently available space assigned to it
  B. create a database equal to at least twenty percent of the total user space to reserve for spool usage
  C. take all available space and divide by the number of users in the system and give this amount to each user as spool space
  D. give each user a spool size equal to the sum of the sizes of the tables that the user can access, the system managing the rest
  Answer: B

  2. What three elements affect the amount of raw data generated by a single INSERT EXPLAIN in the Query Capture Database? (Choose three.)
  A. size of the SQL statement
  B. size of the EXPLAIN statement output
  C. average size of the tables in the query
  D. number of tables and views in the query
  Answer: ABD

  3. Which two options are available when grouping the Teradata users under profiles? (Choose two.)
  A. control over the object creation access rights
  B. management of the Priority Scheduler Performance Groups
  C. management over the external connections available to users
  D. control of the AMP Usage Logging and Account String Expansion
  Answer: BD

  4. What should an analysis defining TDQM restrictions include? (Choose three.)
  A. the client resources available during the peak periods
  B. a list of users whose access must be above restriction
  C. a projection of the growth pattern for major tables in the database
  D. an understanding of the timing requirements for maintenance of specific tables or databases
  E. a listing of the requirements for critical applications and the times of day that are most critical
  Answer: BDE

  5. Which types of Teradata locks are compatible? (Choose two.)
  A. a read lock and a read lock
  B. a read lock and a write lock
  C. a write lock and a write lock
  D. a write lock and an access lock
  Answer: AD

  6. In Priority Scheduler, which two tasks are important in planning the allocation of system resources? (Choose two.)
  A. calculating how many CPU cycles are available
  B. recognizing the goal of using Priority Scheduler
  C. gaining an understanding of the current workload
  D. defining at least four Resource Partitions for workload balance
  Answer: BC

  7. You are using the Statistics Wizard. You define a workload from _____. (Choose two.)
  A. statement text
  B. workload monitor
  C. DBQL statements
  D. TDQM statements
  Answer: AC

  8. Which two statements are true of lock levels? (Choose two.)
  A. A read lock ensures that no modification of that resource is permitted while a SELECT operation is in progress.
  B. A read lock permits modifications on the underlying data while a SELECT operation is in progress.
  C. A write lock ensures that the requester has exclusive rights to the locked resource except for readers not concerned with data consistency.
  D. A write lock ensures that the requester has exclusive rights to the locked resource so that no other process can read from, write to, or access the locked resource in any way.
  Answer: AC

  9. Which is the right formula to calculate the base table size with Fallback?
  A. (Number of blocks*Typical block size) + (Number of header bytes*2)
  B. 2(Number of blocks*Typical block size) – Number of header bytes
  C. 2(Number of blocks*Typical block size) + Number of header bytes
  D. (Number of blocks*Typical block size) – (Number of header bytes*2)
  Answer: C

  10. An eight node Teradata system has DBC.CRASHDUMPS defined as FALLBACK. Assume 200 MB/node is required for one PDE dump. The current allocation for CRASHDUMPS is 1600 MB. The DBA wants the CRASHDUMPS allocation to hold the recommended three PDE dumps. What should the total space allocation be for CRASHDUMPS, and what database does this space come from?
  A. 600 MB from database ALL
  B. 600 MB from database DBC
  C. 4800 MB from database DBC
  D. 4800 MB from database ALL
  Answer: C

  11. How will a query be affected when run against a table without Fallback if an AMP is down?
  A. The query will not execute under these conditions.
  B. The query will execute and return data from all AMPs.
  C. The query will execute only if it does not require data from the down AMP.
  D. The query will always execute and return data from only the AMPs that are available.
  Answer: C

  12. What improves overall job mix and throughput? (Choose three.)
  A. changing the poorly performing queries to $R status
  B. defining Allocation Groups for different times of the day
  C. maintaining development and testing users in a separate Allocation Group
  D. using the Priority Scheduler Administrator to set slow AMPs to a higher priority
  E. using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU
  Answer: BCE

  13. What can you do to improve a query’s performance without restarting Teradata? (Choose three.)
  A. increase the number of cylinder slots in FSG Cache
  B. modify the weights assigned to the user’s Allocation Group
  C. modify the weights assigned to the user’s Resource Partition
  D. change the priority of the user’s session which is running slow
  E. modify the user’s account to increase the spool space of the user
  Answer: BCD

  14. Which Teradata Analyst tool is used to perform a "what-if" analysis on a given workload to determine the optimal set of secondary indexes?
  A. Teradata Index Wizard
  B. Teradata Visual Explain
  C. Teradata Statistics Wizard
  D. Teradata System Emulation Tool
  Answer: A

  15. Which three processes are useful when determining a workload definition for TDQM? (Choose three.)
  A. DBQL analysis of join types for the schedule period
  B. DBQL analysis of full table scans requested during the period
  C. the number of Resource Partitions defined in Priority Scheduler
  D. Priority Scheduler output containing queue length and wait times
  E. the Statistics Wizard analysis of needed statistics for this workload
  Answer: ABD

  16. Which two Teradata RDBMS facilities are important for software fault tolerance? (Choose two.)
  A. dual buffering
  B. Fallback tables
  C. vproc migration
  D. Checktable Utility
  Answer: BC

  17. When organizing the system into databases, the Teradata administrator must consider which two questions? (Choose two.)
  A. How frequently are the archives of the tables needed?
  B. Which views are needed to be used by the same users?
  C. Which users will be doing the FastLoads of multiple tables?
  D. Which views are needed to have extended privileges such as update and delete?
  Answer: BD

  18. When defining Roles in Teradata, what are two questions that should be asked? (Choose two.)
  A. From which network path will this user access Teradata?
  B. Will this user need more than just SELECT access to the data?
  C. Will this user be assigned to perform more than one job function?
  D. What characteristics are important for this user’s password controls?
  Answer: BC

  19. When tuning for tactical queries in Priority Scheduler, which two options are available? (Choose two.)
  A. reserve AMP Worker Tasks for tactical queries
  B. place the users submitting tactical queries in Allocation Group 0
  C. place the users submitting tactical queries in Resource Partition 0
  D. place the users submitting tactical queries in Allocation Groups with the highest weight
  Answer: AD

  20. When predicting the size requirements for global temporary tables, which two should be considered? (Choose two.)
  A. the archive policy for the system
  B. the spool requirements for the user
  C. the size and number of rows per use
  D. the number of concurrent materializations per user
  Answer: CD

  免费下载nr0-015题库Demo

  Examsoon提供最新的TCP认证 nr0-015题库，其全名为：(Teradata Design Architecture v2r5 Exam). 在您决定是否购买之前 可以先下载nr0-015题库的部分演示. Examsoon是全球唯一提供所有IT认证考试题库demo免费下载的厂商 ，以下为免费nr0-015模拟测试题的下载链接

  免费的nr0-015题库PDF下载链接

  NCR Teradata nr0-015学习指南

  TCP认证 nr0-015考试已经证明了它在全世界的广泛性和重要性，因此明白这项认证考试的世界各地的人必须具备与认证考试相关领域所需的技能和知识。NCR Teradata认证 nr0-015学习指南的目的是检查考生的能力和他对概念的意识。很多时候练习测试nr0-015考试都已经被修改过了，删掉了许多过时的东西，而那些需求是在考试课程。当应用到时候你所学的知识的时候，就会鉴定出你所学到的东西以及对所学知识的应用是多么的恰到好处。NCR Teradata认证 nr0-015是在IT行业的知名品牌，所以如果您通过了这样一个知名公司举行的一次考试，你可以想象你将来的事业会做的多么好。

  想要通过这个考试当然存在很多困难。你所要做的就是准备好充足的勇气和信心，而这些都来源与你平时训练的好坏.建议大家可以去Examsoon这个网站看一下，它的nr0-015考试是为了测试您在这方面的知识的掌握程度，最好的部分是它可以使你不断更新你所学的知识，不断进步。如果你知道所有的概念和如何使用他们的时候才是你真正掌握了Examsoon的用意。这门考试检查了您的能力和一旦你通过这次考验你将成为最优秀的人才，其他nr0-015考试的Examsoon结算值得注意的影响就是你的薪水将直线上升这大概也是每个人都希望获得的，所以要找一些好的资源才行。

  Examsoon考题大师nr0-015试题都是考试原题的完美组合，覆盖率95％以上，答案由多位专业资深讲师原版破解得出，正确率100％，只要您使用Examsoon的考试题库参加nr0-015考试，保证您一次轻松通过考试；

  售后服务第一！我们相信要想在当今时代取得成功，必须为广大用户提供全套的周到细致的全程优质售后服务，只有客户满意了，才能发展。客户至上是Examsoon考题大师的一贯宗旨；
  
  

  No Comments

Leave a Reply

You must be logged in to post a comment.