NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 2

To determine the optimal set of secondary indexes on a given workload, a "what-if" analysis is performed using which Teradata Analyst tool?


Options are :

  • Teradata Statistics Wizard
  • Teradata Index Wizard
  • Teradata System Emulation Tool
  • Teradata Visual Explain

Answer : Teradata Index Wizard

A join index has been created to optimize access to frequently used tables. For daily updates on these tables, MultiLoad is employed. What group of tasks can you execute to update these tables now?


Options are :

  • run the MultiLoad script unchanged (The join index will automatically be updated.)
  • modify the MultiLoad script to include the join index
  • drop the join index; run the MultiLoad script; recreate the join index
  • use the Teradata Warehouse Builder Apply Operator instead of MultiLoad

Answer : drop the join index; run the MultiLoad script; recreate the join index

Which two of the followingstatements concerning Disaster Recovery (DR) plans are true? (Choose two.)


Options are :

  • Standardized DR plans can be used to cover most business situations
  • A DR plan should be tested regularly.
  • Data recovery plans may be built without linking data objects to business processes and priorities.
  • A well defined DR plan develops and documents details unique to your business needs and recovery strategy.

Answer : A DR plan should be tested regularly. A well defined DR plan develops and documents details unique to your business needs and recovery strategy.

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which two statements regarding Permanent Journals are true? (Choose two.)


Options are :

  • Permanent Journal images are placed on the Primary AMP, a Backup AMP, and/or a Fallback AMP depending on the type of journal specified and on the protection type of the journaled table.
  • . If a Permanent journal is defined on a Fallback table, the journal rows will be Fallback protected.
  • The space used by the Permanent Journal is limited by the spool space limit of the Database or User where they are defined.
  • They provide an alternative for Fallback and RAID without using as much real disk space.

Answer : Permanent Journal images are placed on the Primary AMP, a Backup AMP, and/or a Fallback AMP depending on the type of journal specified and on the protection type of the journaled table. . If a Permanent journal is defined on a Fallback table, the journal rows will be Fallback protected.

Which are two true statements with reference to FastLoad? (Choose two.)


Options are :

  • . It can load up to five empty tables.
  • It can load data from tape files on a channel-attached client system.
  • Number of sessions are defaulted to one session per AMP.
  • When an error occurs, locks are dropped with no ill effect.

Answer : It can load data from tape files on a channel-attached client system. Number of sessions are defaulted to one session per AMP.

What are two ways of adding new rows to an existing table that has a Referential Integrity constraint? (Choose two.)


Options are :

  • drop the Referential Integrity constraint and MultiLoad the new rows
  • use MultiLoad if the table contains the primary key not the foreign key
  • use TPump to insert the new rows
  • insert the new rows with FastLoad

Answer : drop the Referential Integrity constraint and MultiLoad the new rows use TPump to insert the new rows

TE0-121 Teradata Basics Practice Test Set 2

Which are three accurate statements regarding global temporary tables? (Choose three.)


Options are :

  • Global temporary tables provide the user with a place to store interim results.
  • Global temporary tables can reduce the number of times the user needs to create and drop tables.
  • Global temporary tables require the user to have the necessary permanent space to store data when the table is materialized.
  • Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions.

Answer : Global temporary tables provide the user with a place to store interim results. Global temporary tables can reduce the number of times the user needs to create and drop tables. Global temporary tables have a persistent definition that is stored in the Data Dictionary, but their contents do not persist across sessions.

Whichof the followingmay justify the use of the Fast Export and FastLoad utilities as a backup/recovery approach?


Options are :

  • 20 small volatile tables
  • 300 large volatile tables
  • 20 small static tables
  • 300 large static tables

Answer : 20 small static tables

The sharing of data across user sessions is allows by what kind of table?


Options are :

  • volatile
  • permanent
  • global temporary
  • derived

Answer : permanent

TE0-141 14 Teradata Basics Certified Practice Test Set 3

Which two of the followingare features of highly non-unique primary index values? (Choose two.)


Options are :

  • cause multiple data blocks to be used and incur multiple I/Os
  • cause database full condition on AMPs where excessive number of rows are store
  • maximize parallel processing
  • cause efficient distribution among AMPs

Answer : cause efficient distribution among AMPs

Which of the followingis a true statement regarding row inserts into a table with an identity column?


Options are :

  • Values will be unique if the GENERATED BY DEFAULT option is used.
  • Generated numbers reflect row insertion sequence.
  • Serialization is guaranteed.
  • Numbering gaps can occur.

Answer : Numbering gaps can occur.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Teradata System Emulation Tool uses which three sets of information to model production system processes on a test system? (Choose three.)


Options are :

  • table and column statistics
  • object definitions
  • samples of table data
  • hardware characteristics

Answer : table and column statistics object definitions hardware characteristics

Whichtwoof the followingare planning considerations when you want to set up Roles in Teradata? (Choose two.)


Options are :

  • Will the users need to create volatile tables?
  • Will the users be assigned to the same profile?
  • Will the users need permissions to access specific tables?
  • Will the users need to create permanent tables?

Answer : Will the users need permissions to access specific tables? Will the users need to create permanent tables?

When grouping the Teradata users under profiles, which of the followingare two options that are available? (Choose two.)


Options are :

  • control over the object creation access rights
  • management of the Priority Scheduler Performance Groups
  • management over the external connections available to users
  • control of the AMP Usage Logging and Account String Expansion

Answer : management of the Priority Scheduler Performance Groups control of the AMP Usage Logging and Account String Expansion

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

What is the correct formula for the number of bytes used by a table with Fallback, if you are given the following information? b = block size c = table row count n = number of AMPs r = rows per block h = table header size


Options are :

  • 2*(r/c)*b + n*h
  • 2*(c/r)*b + n*h
  • (c/r)*b + n*h
  • (r/c)*b + n*h

Answer : 2*(c/r)*b + n*h

You are a database administrator at Your company. Your companyhas an eight node Teradata system with DBC.CRASHDUMPS defined as FALLBACK. Assume that a 200 MB/node is required for one PDE dump. Youwant the CRASHDUMPS allocation, which is currently 1600 MB, to hold the recommended three PDE dumps. What must the total space allocation be for CRASHDUMPS, and what database does it come from?


Options are :

  • 4800 MB from database ALL
  • 600 MB from database ALL
  • 4800 MB from database DBC
  • 600 MB from database DBC

Answer : 4800 MB from database DBC

Multiple sources of data arriving from multiple platforms concurrently, is supported by which utility?


Options are :

  • Teradata Warehouse Builder
  • BTEQ
  • FastLoad
  • MultiLoad

Answer : Teradata Warehouse Builder

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

When creating profiles on the Teradata Database, whichof the followingare two concerns? (Choose two.)


Options are :

  • Which users will need the same priorities?
  • Which users will need to create tables and which will not?
  • Which users will need approximately the same amount of spool?
  • Which databases are to be accessed at the same time?

Answer : Which users will need the same priorities? Which users will need approximately the same amount of spool?

Which is an accurate statement pertaining to Performance Periods in Priority Scheduler?


Options are :

  • Performance Periods allow for users assigned to one performance group to be automatically shifted into a different Allocation Group.
  • A Performance Period is assigned to only one Performance Group.
  • There are five types of Performance Periods allowed Time, Session, Period, Query, and Cycle
  • Performance Periods allow for a DBA to be notified that a user is using more system resources than planned.

Answer : Performance Periods allow for users assigned to one performance group to be automatically shifted into a different Allocation Group.

Which three of the following options will enhance overall job mix and throughput? (Choose three.)


Options are :

  • changing the poorly performing queries to $R status
  • using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU
  • defining Allocation Groups for different times of the day
  • maintaining development and testing users in a separate Allocation Group
  • using the Priority Scheduler Administrator to set slow AMPs to a higher priority

Answer : using the MODIFY USER statement to change the ACCOUNT for users receiving too much or too little CPU defining Allocation Groups for different times of the day maintaining development and testing users in a separate Allocation Group

NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 4

For what three reasons would you make use of identity columns? (Choose three.)


Options are :

  • to reduce the need to generate keys outside of Teradata
  • when users need key values with hidden significance or intelligence
  • when more even data distribution is needed
  • to facilitate moving applications from other systems to Teradata

Answer : to reduce the need to generate keys outside of Teradata when more even data distribution is needed to facilitate moving applications from other systems to Teradata

When a column defined as a foreign key in the referencing table is compared to the primary key in the referenced table, which three rules will apply? (Choose three.)


Options are :

  • The case sensitivity must be the same.
  • No column in the foreign key (referencing) can be an identity column.
  • The compression values must be the same.
  • The data type must be the same.

Answer : The case sensitivity must be the same. No column in the foreign key (referencing) can be an identity column. The data type must be the same.

Of the followingfeatures, which one allows multiple users to share the blocks that are read from a table?


Options are :

  • PreReads
  • Access Locking
  • SyncScan
  • Redistribution Buffering

Answer : SyncScan

TE0-121 12 Teradata Basics Certification Practical Exam Set 6

For software fault tolerance, which are two vital Teradata RDBMS facilities? (Choose two.)


Options are :

  • Checktable Utility
  • Fallback tables
  • vproc migration
  • dual buffering

Answer : Fallback tables vproc migration

How can improve a query's performance without restarting Teradata? (Choose three.)


Options are :

  • By modifying the user's account to increase the spool space of the user
  • By increasing the number of cylinder slots in FSG Cache
  • By modifying the weights assigned to the user's Allocation Group
  • By modifying the weights assigned to the user's Resource Partition
  • By changing the priority of the user's session which is running slow

Answer : By modifying the weights assigned to the user's Allocation Group By modifying the weights assigned to the user's Resource Partition By changing the priority of the user's session which is running slow

What would best describe user's MAXSPOOL?


Options are :

  • a value used to limit the number of bytes the system will allocate to create spool files for a user
  • the maximum number of bytes created in a spool reserve database to ensure all queries have enough spool space to run efficiently
  • . the maximum number of bytes used by a transaction for a user since the value was last reset by the ClearPeakDisk macro

Answer : a value used to limit the number of bytes the system will allocate to create spool files for a user

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Adding columns to an index has which two effects? (Choose two.)


Options are :

  • SQL not referencing the added columns will not use the index.
  • Usually there will be more base table rows per index entry.
  • Usually there will be fewer base table rows per index entry.
  • The index selectivity does not change.

Answer : SQL not referencing the added columns will not use the index. Usually there will be fewer base table rows per index entry.

Which is a denormalization technique that you can apply to a table to help optimize query access when there are many rows that are seldom used?


Options are :

  • horizontal partitioning
  • vertical partitioning
  • vertical partitioning
  • pre-joined tables
  • derived data

Answer : horizontal partitioning

Of the following options,which three are considered when you select a column as a primary index? (Choose three.)


Options are :

  • frequency of change
  • sample data
  • maximum rows per value
  • minimum rows per value
  • distinct values

Answer : frequency of change maximum rows per value distinct values

TE0-122 12 Teradata SQL Certification Practice Exam Set 4

You are an administrator at Your company.You define Referential Integrity (RI) on a table WITH CHECK option. An implicit transaction with multiple inserts is submitted against the table. What will happen when the RI is violated by one insert?


Options are :

  • All the rows inserted are rolled back and an abort message is issued.
  • All rows except the one violator are inserted. An error message informs the user which row did not get inserted.
  • An error table is created with a copy of offending column(s) that violated RI.
  • All rows are inserted. An error message informs the user of which row is the problem row that needs to be fixed.

Answer : All the rows inserted are rolled back and an abort message is issued.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions