Teradata Application Development v2r5 Exam braindumps free download

Free nr0-016 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-016 (Teradata Application Development 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.

Free nr0-016 pdf demo download!

nr0-016 exam Exam Description

It is well known that nr0-016 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-016 real test . It is the examination of the perfect combination and it will help you pass nr0-016 exam at the first time!

　
　
Exam : NCR Teradata NR0-016
Title : Teradata Application Development v2r5 Exam

1. What are two characteristics of an aggregate join index? (Choose two.)
A. can be directly referenced by a query
B. must contain more than one table reference
C. can be created using a Global Temporary table
D. automatically reflects changes in the underlying detail data
E. COUNT is automatically present if SUM is used
Answer: DE

2. Which two types of journals can be defined for a table? (Choose two.)
A. Transient LOCAL AFTER JOURNAL
B. Transient UPDATE ONLY JOURNAL
C. Permanent UPDATE ONLY JOURNAL
D. Permanent LOCAL AFTER JOURNAL
E. Permanent DUAL BEFORE JOURNAL
Answer: DE

3. Which type of processing workload is least likely to justify the cost of upgrading a system?
A. executive report
B. daily sales report
C. quarter end report
D. nightly batch process
Answer: C

4. Which two utilities can you use to export data for a report using RECORD mode from the Teradata database? (Choose two.)
A. BTEQ
B. TPump
C. FastExport
D. Teradata SQL Assistant
Answer: AC

5. How are Volatile tables similar to Derived tables? (Choose three.)
A. are local to the query
B. table definition kept in memory
C. are designed for optimal performance
D. have no Data Dictionary access or transaction locks
Answer: BCD

Why choose just4cert nr0-016 braindumps

Quality and Value for the nr0-016 Exam
100% Guarantee to Pass Your nr0-016 Exam
Downloadable, Interactive nr0-016 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.

Just4cert nr0-016 Exam Features

Teradata Design Architecture v2r5 Exam braindumps free download

Free nr0-015 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-015 (Teradata Design Architecture 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.

Free nr0-015 pdf demo download!

nr0-015 exam Exam Description

It is well known that nr0-015 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-015 real test . It is the examination of the perfect combination and it will help you pass nr0-015 exam at the first time!

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

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

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

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

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

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

Why choose just4cert nr0-015 braindumps

Quality and Value for the nr0-015 Exam
100% Guarantee to Pass Your nr0-015 Exam
Downloadable, Interactive nr0-015 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.

Just4cert nr0-015 Exam Features

Teradata Sql v2r5 Exam braindumps free download

Free nr0-013 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-013 (Teradata Sql 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.

Free nr0-013 pdf demo download!

nr0-013 exam Exam Description

It is well known that nr0-013 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-013 real test . It is the examination of the perfect combination and it will help you pass nr0-013 exam at the first time!

　
　
Exam : NCR Teradata NR0-013
Title : Teradata Sql v2r5 Exam

1. Click the Exhibit button.
Given the two tables and the query shown in the exhibit, what is the result set?
A. 5, NULL
B. 2, NULL
C. 2, 2300
D. 3, NULL
E. 2, 20000
Answer: B

2. What is the result of SELECT CAST(‘bb12345′ AS CHAR(3)) in Teradata mode? (Note: b = blank)
A. 1
B. ‘bb1′
C. 123
D. 345
E. ’123′
F. ’345′
Answer: B

3. What are three characteristics of views? (Choose three.)
A. Views can contain a WHERE clause.
B. Views cannot be used to UPDATE a table.
C. Views must change if columns are added to a table.
D. Views are not affected if columns are added to a table.
E. Views provide an additional level of security or authorization.
Answer: ADE

4. Given the query
SELECT AVG(column1) FROM t1;
where t1 is an empty table, what is the result?
A. 0
B. Null
C. Error
D. No record found
Answer: B

5. What two types of tables are available when users need to create a small temporary table but only have spool space allocated to them? (Choose two.)
A. Volatile
B. Derived
C. Permanent
D. Global Temporary
Answer: AB

Why choose just4cert nr0-013 braindumps

Quality and Value for the nr0-013 Exam
100% Guarantee to Pass Your nr0-013 Exam
Downloadable, Interactive nr0-013 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.

Just4cert nr0-013 Exam Features

Basics V2R5 Practice Exam Questions braindumps free download

Free nr0-011 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-011 (Basics V2R5 Practice Exam Questions). 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.

Free nr0-011 pdf demo download!

nr0-011 exam Exam Description

It is well known that nr0-011 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-011 real test . It is the examination of the perfect combination and it will help you pass nr0-011 exam at the first time!

　
　
Exam : NCR Teradata NR0-011
Title : Teradata Basics V2R5

1. Why would you have two physical LAN connections per node connected to the customer’s network?
A.for redundancy
B.to double the request speed
C.so two session connections can be made concurrently
D.so one can accept requests and the other can return responses
Answer: A

2. What are three main features of the Teradata database? (Choose three.)
A.portable to any platform
B.parallel aware optimizer
C.unconditional parallelism
D.automatic data distribution
Answer: BCD

3. How does Teradata handle data access? (Choose three.)
A.The PEs handle Session Control functions.
B.The BYNET sends a communication between the nodes.
C.The BYNET sends the answer set back to the application.
D.The AMPs convert the SQL into steps that are sent out by the Dispatcher.
E.The AMPs retrieve and perform database functions on the requested rows.
Answer: ABE

4. What describes Teradata’s architecture?
A.shared data
B.shared nothing
C.shared memory
D.shared everything
Answer: B

5. Which three are characteristics of Active Data Warehousing? (Choose three.)
A.allows for data redundancy
B.provides scalability to support large amounts of detailed data
C.allows users to directly update the operational data store (ODS)
D.provides an integrated environment that supports strategic and tactical queries
Answer: BCD

Why choose just4cert nr0-011 braindumps

Quality and Value for the nr0-011 Exam
100% Guarantee to Pass Your nr0-011 Exam
Downloadable, Interactive nr0-011 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.

Just4cert nr0-011 Exam Features

Teradata Physical Implementation v2r5 Exam braindumps free download

Free nr0-012 Demo Download

just4cert offers free demo for NCR Teradata certification nr0-012 (Teradata Physical Implementation 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-012 PDF Demo

Why choose just4cert nr0-012 braindumps

Quality and Value for the nr0-012 Exam
100% Guarantee to Pass Your nr0-012 Exam
Downloadable, Interactive nr0-012 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-012 free demo:

　
　
Exam : NCR Teradata NR0-012
Title : Teradata Physical Implementation v2r5 Exam

1. What should be considered when electing to denormalize a table?
A.volatility
B.cardinality
C.connectivity
D.number of users
Answer: A

2. What happens to a submitted query when a deadlock occurs?
A.Oldest query is aborted.
B.Youngest query is aborted.
C.Query waits for deadlock to resolve.
D.Dispatcher identifies which query to hold and waits for completion of deadlocking query.
Answer: B

3. Which three are data demographic elements? (Choose three.)
A.number of nulls
B.number of constraints
C.number of distinct values
D.number of rows per value
Answer: ACD

4. Click the Task Button.Place each normal form name next to its description.
Answer:

5. Which two factors should be considered when electing to denormalize a table? (Choose two.)
A.volatility
B.cardinality
C.connectivity
D.performance
Answer: AD

6. Which statement is true of join indexes?
A.They can be processed using MultiLoad.
B.They can be used to define Full Outer Joins.
C.They can be assigned a different primary index from the base table.
D.They can be used on a table with triggers and Referential Integrity constraints.
Answer: C

7. Whenever you have stand-alone derived data, you must decide whether to calculate it or store it.
On which two demographics should you base your decision? (Choose two.)
A.access column
B.access frequency
C.column data value volatility
D.number of sources involved
Answer: BC

8. Which two definitions are required on the referenced columns when implementing Referential Integrity? (Choose two.)
A.Unique
B.Nullable
C.Indexed
D.Not Null
Answer: AD

9. Which two statements about parallel steps are true? (Choose two.)
A.They are steps whose output may be used in a later statement.
B.They are sequentially numbered steps that may execute simultaneously.
C.They represent combined identical steps for two or more SQL statements within the request parcel.
D.They are seen in the creation of a spool file, which is subsequently used in more than one processing step.
Answer: AB

10. What is an effect of denormalization on application coding?
A.It usually increases data flexibility.
B.It increases the cost of data retrieval.
C.It generally reduces the potential for data problems.
D.It generally makes new applications more difficult to implement.
Answer: D

11. Which three join methods require spool files? (Choose three.)
A.Merge Join
B.Nested Join
C.Product Join
D.Exclusion Merge Join
Answer: ACD

12. During which phase of modeling design would a Partitioned Primary Index be defined?
A.Logical Data Modeling
B.Physical Data Modeling
C.Entity-Relationship Modeling
D.Business Information Modeling
Answer: B

Teradata Design Architecture v2r5 Exam braindumps free download

Free nr0-015 Demo Download

just4cert offers free demo for NCR Teradata certification nr0-015 (Teradata Design Architecture 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-015 PDF Demo

Why choose just4cert nr0-015 braindumps

Quality and Value for the nr0-015 Exam
100% Guarantee to Pass Your nr0-015 Exam
Downloadable, Interactive nr0-015 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-015 free demo:

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

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

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

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

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

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

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

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

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

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

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

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

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

Teradata Physical Implementation v2r5 Exam braindumps free download

Free nr0-012 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-012 (Teradata Physical Implementation 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.

Free nr0-012 pdf demo download!

nr0-012 exam Exam Description

It is well known that nr0-012 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-012 real test . It is the examination of the perfect combination and it will help you pass nr0-012 exam at the first time!

　
　
Exam : NCR Teradata NR0-012
Title : Teradata Physical Implementation v2r5 Exam

1. Which statement is true of join indexes?
A.They can be processed using MultiLoad.
B.They can be used to define Full Outer Joins.
C.They can be assigned a different primary index from the base table.
D.They can be used on a table with triggers and Referential Integrity constraints.
Answer: C

2. Which three join methods require spool files? (Choose three.)
A.Merge Join
B.Nested Join
C.Product Join
D.Exclusion Merge Join
Answer: ACD

3. What happens to a submitted query when a deadlock occurs?
A.Oldest query is aborted.
B.Youngest query is aborted.
C.Query waits for deadlock to resolve.
D.Dispatcher identifies which query to hold and waits for completion of deadlocking query.
Answer: B

4. Which two statements about parallel steps are true? (Choose two.)
A.They are steps whose output may be used in a later statement.
B.They are sequentially numbered steps that may execute simultaneously.
C.They represent combined identical steps for two or more SQL statements within the request parcel.
D.They are seen in the creation of a spool file, which is subsequently used in more than one processing step.
Answer: AB

5. Which two definitions are required on the referenced columns when implementing Referential Integrity? (Choose two.)
A.Unique
B.Nullable
C.Indexed
D.Not Null
Answer: AD

Why choose just4cert nr0-012 braindumps

Quality and Value for the nr0-012 Exam
100% Guarantee to Pass Your nr0-012 Exam
Downloadable, Interactive nr0-012 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.

Just4cert nr0-012 Exam Features

Teradata Masters Update v2r5 Exam braindumps free download

Free nr0-017 Demo Download

Just4cert offers free demo for NCR Teradata TCP 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.

Free nr0-017 pdf demo download!

nr0-017 exam Exam Description

It is well known that nr0-017 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-017 real test . It is the examination of the perfect combination and it will help you pass nr0-017 exam at the first time!

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

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

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

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

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

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

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.

Just4cert nr0-017 Exam Features

Teradata Administration v2r5 Exam braindumps free download

Free nr0-014 Demo Download

Just4cert offers free demo for NCR Teradata TCP nr0-014 (Teradata Administration 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.

Free nr0-014 pdf demo download!

nr0-014 exam Exam Description

It is well known that nr0-014 test is the hot exam of NCR Teradata certification. just4cert offer you all the Q&A of the nr0-014 real test . It is the examination of the perfect combination and it will help you pass nr0-014 exam at the first time!

　
　
Exam : NCR Teradata NR0-014
Title : Teradata Administration v2r5 Exam

1. You are using Database Query Log (DBQL).
Logging can be invoked on _____. (Choose three.)
A. all users
B. a list of users
C. a list of account strings
D. a list of database objects
Answer: ABC

2. What does the CPU Eff % column measure in the ResNode macro?
A. efficiency of each CPU in each node
B. percentage of CPUs working efficiently in all nodes
C. how well the CPUs work in parallel across all nodes
D. percentage of CPUs working in parallel across all nodes
Answer: C

3. What is a benefit of assigning account strings at the profile level?
A. enables you to change all or part of the designation just once for many users
B. enables you to grant privileges to a group of users based on their account string
C. enables you to save space by reducing the number of rows inserted into DBC. AMPUsage
D. enables you to save space by reducing the number of rows inserted into DBC. AccessRights
Answer: A

4. How are inherited privileges applied by the database administrator?
A. by using GIVE to change user hierarchy
B. by automatically applying inherited privileges
C. by granting inherited privileges directly to the user
D. by granting privileges with the ALL option to a user
Answer: D

5. Which three utilities are limited by the MaxLoadTasks parameter in the DBSControl utility? (Choose three.)
A. BTEQ
B. TPump
C. FastLoad
D. MultiLoad
E. FastExport
Answer: CDE

Why choose just4cert nr0-014 braindumps

Quality and Value for the nr0-014 Exam
100% Guarantee to Pass Your nr0-014 Exam
Downloadable, Interactive nr0-014 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.

Just4cert nr0-014 Exam Features

Basics V2R5 Practice Exam Questions braindumps free download

Free nr0-011 Demo Download

just4cert offers free demo for NCR Teradata certification nr0-011 (Basics V2R5 Practice Exam Questions). 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-011 PDF Demo

Why choose just4cert nr0-011 braindumps

Quality and Value for the nr0-011 Exam
100% Guarantee to Pass Your nr0-011 Exam
Downloadable, Interactive nr0-011 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-011 free demo:

　
　
Exam : NCR Teradata NR0-011
Title : Teradata Basics V2R5

1. Which three DBA tasks are not required in a Teradata environment? (Choose three.)
A.data modeling
B.index selection
C.database reorganizations
D.pre-prepare data for loading
E.pre-allocation of table space
Answer: CDE

2. What are three main features of the Teradata database? (Choose three.)
A.portable to any platform
B.parallel aware optimizer
C.unconditional parallelism
D.automatic data distribution
Answer: BCD

3. Which three aspects of the DSS environment have gained importance as technology has improved? (Choose three.)
A.the ability to use detailed data
B.the ability to do ad hoc queries
C.the ability to do batch reporting
D.requiring the data to be in a data mart
E.the decreased need to use summary data
Answer: ABE

4. Which two features are unique to Teradata? (Choose two.)
A.mature Optimizer
B.concurrent users
C.parallel architecture
D.industry standard access language (SQL)
Answer: AC

5. What describes Teradata’s architecture?
A.shared data
B.shared nothing
C.shared memory
D.shared everything
Answer: B

6. What are two benefits of a business model? (Choose two.)
A.Data is organized according to what it represents.
B.There is a unique data model for each department.
C.Data is organized according to how it is accessed.
D.The data model is the same regardless of data volume.
Answer: AD

7. Due to linear scalability, which two can Teradata provide? (Choose two.)
A.redundant data storage for fault tolerance
B.ability to accommodate 32 CPUs on a node
C.investment protection for application development
D.increased workload without decreased throughput
Answer: CD

8. You are designing a data warehouse which your customers will use for long range strategic planning and to answer "what if" type questions.
What type of system should you design?
A.DSS
B.ODS
C.OLTP
D.RDBD
Answer: A

9. Which three are characteristics of Active Data Warehousing? (Choose three.)
A.allows for data redundancy
B.provides scalability to support large amounts of detailed data
C.allows users to directly update the operational data store (ODS)
D.provides an integrated environment that supports strategic and tactical queries
Answer: BCD

10. How does Teradata handle data access? (Choose three.)
A.The PEs handle Session Control functions.
B.The BYNET sends a communication between the nodes.
C.The BYNET sends the answer set back to the application.
D.The AMPs convert the SQL into steps that are sent out by the Dispatcher.
E.The AMPs retrieve and perform database functions on the requested rows.
Answer: ABE

11. Why would you have two physical LAN connections per node connected to the customer’s network?
A.for redundancy
B.to double the request speed
C.so two session connections can be made concurrently
D.so one can accept requests and the other can return responses
Answer: A

12. Which two statements are true about an OLTP environment? (Choose two.)
A.Transactions are write intensive.
B.The number of rows per transaction is large.
C.The number of rows per transaction is small.
D.Transactions typically occur within seconds, not minutes.
Answer: CD