NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 3

The allocation of system CPU resources in a mixed workload environment can be improved by executing which three of the followingtasks? (Choose three.)


Options are :

  • use the MODIFY USER statement to change the ACCOUNT for a user
  • modify the Default Resource Partition to a lower weight than other Resource Partitions
  • maintain development and test users in separate Allocation Groups
  • define Allocation Groups for different times of the day
  • use the MODIFY USER statement to give a user more spool space

Answer : use the MODIFY USER statement to change the ACCOUNT for a user maintain development and test users in separate Allocation Groups define Allocation Groups for different times of the day

TE0-141 14 Teradata Basics Certified Practice Test Set 3

For which two reasons would Partitioned Primary Index (PPI) be considered on a table? (Choose two.)


Options are :

  • to reduce response time by placing all data in the same partition on the same AMP
  • to reduce the number of columns in a table to those needed by most queries
  • to eliminate ranges of data values from a query and thereby reduce scan time
  • to reduce the amount of I/O needed to process queries

Answer : to eliminate ranges of data values from a query and thereby reduce scan time to reduce the amount of I/O needed to process queries

What type of query population is helped by a sparse index?


Options are :

  • queries that rarely redistribute a large table in complex join processing
  • queries that often redistribute a large table
  • queries that often return a large percent of the rows of a large table based on the primary key
  • queries that repeatedly use the same subset of the table
  • queries that often eliminate a large percent of the rows of a large table using a superset of the table

Answer : queries that repeatedly use the same subset of the table

Which of the following applies to Non-Partitioned Primary Index (NPPI) tables when determining the size of a row in Teradata? (Choose two.)


Options are :

  • two bytes for variable length accommodation
  • four bytes for the primary index
  • two bytes per row for row length
  • one byte per column for compression
  • eight bytes per row for the rowid

Answer : two bytes per row for row length eight bytes per row for the rowid

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

When is a fully covering join index advantageous to a query?


Options are :

  • when the base table is small enough to fit in cache
  • when relatively few columns are in the result and join or selection criteria includes values other than the base tables' primary index(es)
  • when there is an unpredictable selection of columns from the base table
  • when the result set is produced through either join or selection criteria on the base tables' primary index(es)

Answer : when relatively few columns are in the result and join or selection criteria includes values other than the base tables' primary index(es)

Which of the following are two true statements regarding "soft" Referential Integrity (RI)? (Choose two.)


Options are :

  • The PK columns can appear anywhere in the WHERE clause.
  • The RI is enforced by the database.
  • The RI is presumed to be enforced outside of the database.
  • Redundant joins between soft RI defined tables are eliminated

Answer : The RI is presumed to be enforced outside of the database. Redundant joins between soft RI defined tables are eliminated

On the subject of FastLoad, which two statements are correct? (Choose two.)


Options are :

  • loads duplicate rows into a multiset table
  • no secondary indexes on the target table
  • no journaling
  • can maintain NUSIs but not USIs

Answer : no secondary indexes on the target table no journaling

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

Whichthree of the followingshould be included in an analysis that defines TDQM restrictions? (Choose three.)


Options are :

  • an understanding of the timing requirements for maintenance of specific tables or databases
  • a projection of the growth pattern for major tables in the database
  • a listing of the requirements for critical applications and the times of day that are most critical
  • a list of users whose access must be above restriction
  • the client resources available during the peak periods

Answer : an understanding of the timing requirements for maintenance of specific tables or databases a listing of the requirements for critical applications and the times of day that are most critical a list of users whose access must be above restriction

For whichtwo reasons would you choose a NUPI? (Choose two.)


Options are :

  • It allows clustering of data rows.
  • It allows the user to generate a much larger table.
  • . It is a closer match for the primary key.
  • It allows duplicate rows in a set table.
  • It facilitates AMP-local joins of matching sets.

Answer : It allows clustering of data rows. It facilitates AMP-local joins of matching sets.

If you are defining Roles in Teradata, what are two QUESTION NO:s that you should ask yourself? (Choose two.)


Options are :

  • Will this user need more than just SELECT access to the data?
  • From which network path will this user access Teradata?
  • Will this user be assigned to perform more than one job function?
  • What characteristics are important for this user's password controls?

Answer : Will this user need more than just SELECT access to the data? Will this user be assigned to perform more than one job function?

TE0-121 Teradata Basics Practice Test Set 5

A join index would be added to a set of tables for what reason?


Options are :

  • to enforce Referential Integrity across tables
  • to enforce data uniqueness
  • to ensure same distribution of both tables
  • to decrease response time on well known queries

Answer : to decrease response time on well known queries

What are you calculating when you analyze volatility as a factor for selecting indexes?


Options are :

  • how frequently the column value changes
  • the difference between the maximum and minimum values
  • how unique the column values are
  • how frequently the column is used for access

Answer : how frequently the column value changes

A Partitioned Primary Index (PPI), NUSIs, and a USI is defined on Table X. which two of the following can you employ for daily maintenance? (Choose two.)


Options are :

  • TPump
  • FastLoad into an empty Table Y, then INSERT/SELECT into Table X
  • Teradata Warehouse Builder Load Operator
  • MultiLoad

Answer : TPump FastLoad into an empty Table Y, then INSERT/SELECT into Table X

TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

An empty target table is required by which two utilities when loading data? (Choose two.)


Options are :

  • . MultiLoad
  • FastExport
  • Teradata Warehouse Builder Load operator
  • FastLoad

Answer : Teradata Warehouse Builder Load operator FastLoad

How is system availability guaranteed, if a node fails in a MPP environment with multi-node cliques?


Options are :

  • The remaining nodes migrate to an alternate clique.
  • The RAID groups owned by the AMPs on the failing nodes are shut down.
  • The RAID groups owned by the AMPs on the failing nodes migrate to AMPs already running on the remaining nodes in the clique.
  • The AMPs on the failed node migrate to the other nodes in the clique.

Answer : The AMPs on the failed node migrate to the other nodes in the clique.

Which two statements referring to a dimensional data model are correct? (Choose two.)


Options are :

  • It often implements fewer tables
  • It can be adapted to optimize performance
  • It requires significantly less ETL activity
  • It is extremely flexible.
  • It reduces the need for summary tables.

Answer : It often implements fewer tables It can be adapted to optimize performance

TE0-121 12 Teradata Basics Certification Practical Exam Set 7

FastExport is best described by which three of the following? (Choose three.)


Options are :

  • uses multiple sessions
  • exports from multiple tables
  • exports data to multiple files without use of OUTMOD
  • uses Support Environment

Answer : uses multiple sessions exports from multiple tables uses Support Environment

Which are two features of the MultiLoad utility? (Choose two.)


Options are :

  • The processing rate can be controlled.
  • Up to ten tables can be specified in a single execution.
  • The upsert function is supported.
  • It uses macros to improve performance.
  • Insert, update, and delete are all supported.

Answer : The upsert function is supported. Insert, update, and delete are all supported.

A RAID configuration for system availability has what advantage?


Options are :

  • If a single drive fails, work can proceed because the disk controller can reconstruct the data.
  • A disk array cabinet failure does not interrupt operation since RAID forces redundancy across RAID cabinets.
  • If a node fails, the AMPs running on that node migrate to the other nodes in a different clique.
  • If multiple drives fail in the same drive group, work can proceed using the redundant copies.

Answer : If a single drive fails, work can proceed because the disk controller can reconstruct the data.

TE0-123 Teradata 12 Physical Design & Implementation Exam Set 3

Which two of the following statements are correct in relation to data marts? (Choose two.)


Options are :

  • Dependent data marts are isolated entities entirely separate from the enterprise data warehouse.
  • Independent data marts are derived from the enterprise data warehouse.
  • A data mart is generally a relatively small application-specific subset of the data warehouse.
  • A logical data mart is a form of dependent data mart that is constructed virtually from the physical data warehouse.

Answer : A data mart is generally a relatively small application-specific subset of the data warehouse. A logical data mart is a form of dependent data mart that is constructed virtually from the physical data warehouse.

You are a database administrator at Your companywho is using the Statistics Wizard. From which two of the following can you define a workload? (Choose two.)


Options are :

  • statement text
  • TDQM statements
  • workload monitor
  • DBQL statements

Answer : statement text DBQL statements

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which are two available options when tuning for tactical queries in Priority Scheduler? (Choose two.)


Options are :

  • reserve AMP Worker Tasks for tactical queries
  • place the users submitting tactical queries in Allocation Groups with the highest weight
  • place the users submitting tactical queries in Allocation Group 0
  • place the users submitting tactical queries in Resource Partition 0

Answer : reserve AMP Worker Tasks for tactical queries place the users submitting tactical queries in Allocation Groups with the highest weight

Of the followingsoftware components,which two runs on a Teradata channel-attached client? (Choose two.)


Options are :

  • TPA
  • TDP
  • CLI
  • PE
  • TGTW

Answer : TDP CLI

Which are two accurate statements about TPump? (Choose two.)


Options are :

  • TPump cannot operate on tables with Referential Integrity specified.
  • It uses time-based checkpoints, rather than count-based.
  • The processing rate can be modified
  • The larger the batch is, the faster the throughput is.

Answer : It uses time-based checkpoints, rather than count-based. The processing rate can be modified

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 3

Assume that table Big_T is a very large table, with hash distributed rows that are based on 16 unique values. Applications using Big T operates well with high parallelism on a system with 1 or 2 nodes and 8 to 16 AMPs. Which two statements are true if the system is expanded to 8 nodes and 128 AMPs? (Choose two.)


Options are :

  • . Applications accessing Big_T could be rewritten to utilize the new system configuration more efficiently.
  • The rows of Big_T will be distributed across the AMPs equally and the application will perform much better.
  • The rows of Big_T will still be distributed across 16 AMPs and applications will not perform any better.
  • Applications accessing Big_T could perform much worse than before the system was upgraded.

Answer : The rows of Big_T will still be distributed across 16 AMPs and applications will not perform any better. Applications accessing Big_T could perform much worse than before the system was upgraded.

You are a database administrator at Your company. Your company'sPermanent space on a Teradata machine is being used up rapidly. You want to make sure that there will be enough spool space in the system to satisfy all queries. What should you do to meet these requirements?


Options are :

  • create a database called Spool Space with all currently available space assigned to it
  • create a database equal to at least twenty percent of the total user space to reserve for spool usage
  • take all available space and divide by the number of users in the system and give this amount to each user as spool space
  • 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 : create a database equal to at least twenty percent of the total user space to reserve for spool usage

When determining a workload definition for TDQM, which of the followingare three useful methods? (Choose three.)


Options are :

  • the Statistics Wizard analysis of needed statistics for this workload
  • DBQL analysis of full table scans requested during the period
  • Priority Scheduler output containing queue length and wait times
  • the number of Resource Partitions defined in Priority Scheduler
  • DBQL analysis of join types for the schedule period

Answer : DBQL analysis of full table scans requested during the period Priority Scheduler output containing queue length and wait times DBQL analysis of join types for the schedule period

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which three of the followingTeradata utilities are also CLI applications? (Choose three.)


Options are :

  • SQL Assistant
  • C Preprocessor2
  • BTEQWin
  • PM/API

Answer : C Preprocessor2 BTEQWin PM/API

Which three Teradata tools use the Query Capture Database (QCD)? (Choose three.)


Options are :

  • Teradata Statistics Wizard
  • DBQL
  • Visual EXPLAIN
  • Teradata Index Wizard
  • Teradata DQM

Answer : Teradata Statistics Wizard Visual EXPLAIN Teradata Index Wizard

When you choose a primary index, what are three requirements that must be met? (Choose three.)


Options are :

  • must be primary key
  • must ensure row uniqueness
  • volatility of data values
  • reasonable distribution
  • most frequently accessed column(s)

Answer : volatility of data values reasonable distribution most frequently accessed column(s)

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions