Teradata Fundamentals 12

Recovery will occur for the PEs on the failing node. ✘ Nothning would happen ✘ The PEs will continue processing the previous request. ✘ All Channel PEs will migrate to another node in the clique. ✔

is the system of record ✘ sourced from operational systems ✘ contains unique data ✘ subset of data often used by a department ✔

It allows users to submit ad hoc queries. ✘ It provides a single view of the business. ✘ Processing power can be added, without needing to change the data model. ✘ It provides a fault tolerant processing platform. ✔

Response time measures the queries processed per second and throughput measures the volume of transactions received. ✘ Response time measures the performance of a CPU and throughput measures I/O performance. ✘ Response time measures network delay and throughput measures the performance of the PEs. ✘ Response time measures the average duration of the queries and throughput measures the quantity of queries completed during a time interval. ✔

single view of the business ✘ data freshness ✘ dimensional data ✘ mature optimizer ✔

It supports table access using alternate, less frequently used paths. ✘ It uniquely identifies each row in the table. ✘ It can improve join performance. ✘ It ensures referential integrity of the data. ✔

to enable compression on the data to improve query performance ✘ to ensure enough AMPs are involved to reduce query processing time ✘ to provide a constraint to ensure Referential Integrity ✘ to support efficient data access ✔

mechanisms for logging on to the database ✘ named collection of SQL statements ✘ privileges on database objects ✘ privileges on database objects ✔

TPT ✘ MultiTool ✘ TSET ✘ FastLoad ✔

Nodes in the same clique. ✘ Non-TPA nodes on the system. ✘ The least busy node on the system. ✘ Vprocs will wait until the node is repaired. ✔