NR0-015 Teradata Design Architecture V2R5 Practice Test Set 2

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


Options are :

  • . MultiLoad
  • FastExport
  • Teradata Warehouse Builder Load operator (Correct)
  • FastLoad (Correct)

Answer : Teradata Warehouse Builder Load operator FastLoad

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


Options are :

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

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

TE0-121 Teradata Basics Practice Test Set 3

In regards to data marts, which two of the following statements are right? (Select two.)


Options are :

  • 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. (Correct)
  • Dependent data marts are isolated entities entirely separate from the enterprise data warehouse.
  • A logical data mart is a form of dependent data mart that is constructed virtually from the physical data warehouse. (Correct)

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.

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


Options are :

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

Answer : how frequently the column value changes

For what two reasons are allowing columns to follow consistent data types administered at the domain level important? (Choose two.)


Options are :

  • eliminates need for constraints
  • reduces data storage requirements
  • eliminates data compression
  • reduces data redistribution (Correct)
  • avoids data conversions (Correct)

Answer : reduces data redistribution avoids data conversions

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

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
  • one byte per column for compression
  • four bytes for the primary index
  • eight bytes per row for the rowid (Correct)
  • two bytes per row for row length (Correct)

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

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 AMPs on the failed node migrate to the other nodes in the clique. (Correct)
  • The RAID groups owned by the AMPs on the failing nodes migrate to AMPs already running on the remaining nodes in the clique.
  • The RAID groups owned by the AMPs on the failing nodes are shut down.

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

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


Options are :

  • queries that often eliminate a large percent of the rows of a large table using a superset of the table
  • queries that repeatedly use the same subset of the table (Correct)
  • 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 rarely redistribute a large table in complex join processing

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

NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 4

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 (Correct)
  • FastLoad into an empty Table Y, then INSERT/SELECT into Table X (Correct)
  • Teradata Warehouse Builder Load Operator
  • MultiLoad

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

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


Options are :

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

Answer : no journaling no secondary indexes on the target table

Which of the following are two "smooth" Referential Integrity (RI) statements? (Select two.)


Options are :

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

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

NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 2

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 (Correct)

Answer : to decrease response time on well known queries

The difference between the COPY and RESTORE operations of the ARC utility is best described by which two of the followingstatements? (Choose two.)


Options are :

  • A RESTORE operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored. (Correct)
  • A COPY operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database. (Correct)
  • A RESTORE operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database.
  • A COPY operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored.

Answer : A RESTORE operation moves the data from an archived file back to the same Teradata system from which it was archived or moves data to a different Teradata system as long as the database DBC is already restored. A COPY operation moves the data from an archived file back to any Teradata system and creates a new table if one does not already exist on the target database.

Which two statements are right referring to a model of dimensional information?(Choose two.)


Options are :

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

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

TE0-141 14 Teradata Basics Certified Practice Test Set 2

A RAID configuration for system availability has what advantage?


Options are :

  • 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.
  • If a single drive fails, work can proceed because the disk controller can reconstruct the data. (Correct)

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

Why would you choose an NUPI for whichtwo purposes? (Select two.)


Options are :

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

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

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


Options are :

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

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-141 14 Teradata Basics Certified Practice Test Set 1

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


Options are :

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

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

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


Options are :

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

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

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 :

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

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

NCR NR0-017 Teradata Masters Update V2R5 Practice Exam Set 6

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


Options are :

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

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-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which three of the followingstatements pertaining to data compression are true? (Choose three.)


Options are :

  • It reduces the overhead for storing variable character data.
  • It can achieve substantial reduction of space for both numeric and character data (Correct)
  • The actual uncompressed values are stored in the table header. (Correct)
  • CPU path length associated with the I/Os saved is substantial. (Correct)

Answer : It can achieve substantial reduction of space for both numeric and character data The actual uncompressed values are stored in the table header. CPU path length associated with the I/Os saved is substantial.

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


Options are :

  • SQL not referencing the added columns will not use the index. (Correct)
  • Usually there will be fewer base table rows per index entry. (Correct)
  • Usually there will be more 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.

Real-time data requirements are supported secondary indexes in which way?


Options are :

  • are given priority in the Optimizer queue
  • are maintained with the base table (Correct)
  • require less row header space
  • require no extra disk access
  • completely eliminate full table scans

Answer : are maintained with the base table

NR0-012 Teradata Physical Implementation V2R5 Practice Exam Set 3

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


Options are :

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

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

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


Options are :

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

Answer : object definitions table and column statistics hardware characteristics

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 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.
  • All the rows inserted are rolled back and an abort message is issued. (Correct)

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

TE0-141 14 Teradata Basics Certified Practice Test Set 3

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 (Correct)
  • 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

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


Options are :

  • . If a Permanent journal is defined on a Fallback table, the journal rows will be Fallback protected. (Correct)
  • 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.
  • 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. (Correct)

Answer : . If a Permanent journal is defined on a Fallback table, the journal rows will be Fallback protected. 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.

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 :

  • derived data
  • horizontal partitioning (Correct)
  • vertical partitioning
  • pre-joined tables
  • vertical partitioning

Answer : horizontal partitioning

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions