TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

A company has a set of external customers requiring access to their own data on demand. The company offers these customers web access to their data. Given the following requirements: users must design requests from a set of templates users can schedule requests users are prevented from building badly formed queries users are self-sufficient requiring minimal training, if any Which strategy meets these requirements?


Options are :

  • . due to the unpredictable nature of the requests, these requirements should not be accepted for development
  • make SQL Assistant Web Edition available to external customers
  • useFastExport to create a nightly data file and use secure FTP to transmit that data to each customer
  • use web-enabled development tools to create a report wizard to guide users through creating and scheduling their data retrieval requests

Answer : useFastExport to create a nightly data file and use secure FTP to transmit that data to each customer

A new application driving high-volume single-AMP queries is being implemented. What information needs to be communicated to the warehouse administration team?


Options are :

  • queries using existing views
  • queries using existing indexes
  • query spool demand
  • query forecast demand

Answer : queries using existing indexes

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

A user wants to create a Multi-level Partitioned Primary Index (MLPPI). Which three types of tables can be used? (Choose three.)


Options are :

  • Volatile Table
  • Permanent Table
  • Global Temporary Trace Table
  • Queue Table
  • Global Temporary Table

Answer : Permanent Table Global Temporary Trace Table Global Temporary Table

A project team decides to run in ANSI mode. Which three are ANSI mode characteristics and not Teradata mode characteristics? (Choose three.)


Options are :

  • A transaction is committed only by an explicit COMMIT.
  • The default attribute for character comparisons is CASESPECIFIC.
  • The default for CREATE TABLE is MULTISET table
  • The DDL statement must be the last statement in the transaction.
  • It must code with BT ET to establish transaction boundaries.

Answer : The default for CREATE TABLE is MULTISET table The DDL statement must be the last statement in the transaction. It must code with BT ET to establish transaction boundaries.

What information needs to be collected for use by the warehouse administration teams when planning backup and recovery for a new application?


Options are :

  • the list of Linux objects used by the application
  • the list of databases objects required to support the application
  • the list of hardware data protection requirements
  • the list of Linux permissions required by the database users

Answer : the list of Linux permissions required by the database users

TE0-124 Teradata 12 Database Administration Practice Exam Set 5

What are three physical model objects that can improve active access performance?


Options are :

  • Primary Index definitions, PPI definitions, and Multi-Value Compression (MVC)
  • Primary Key definitions, Key update frequency, and Multi-Value Compression (MVC)
  • Primary Key definitions, Foreign Key definitions, and Key update frequency
  • Primary Index definitions, Multi-Value Compression (MVC), and Physical table normalization

Answer : Primary Index definitions, Multi-Value Compression (MVC), and Physical table normalization

Which feature potentially eliminates joins between tables without any overhead to the maintenance jobs for those tables?


Options are :

  • Soft Referential Integrity
  • Join Index
  • COLLECT STATISTICS
  • summary tables

Answer : Join Index

Which two components of a dual systems architecture provide data synchronization? (Choose two.)


Options are :

  • Teradata Query Director
  • Teradata Dynamic Workload Manager
  • Dual Load
  • Replication

Answer : Teradata Query Director Teradata Dynamic Workload Manager

TE0-141 14 Teradata Basics Certified Practice Test Set 2

When an application is developed, which three categories of database space need to be collected and provided to the capacity planning process? (Choose three.)


Options are :

  • SYSADMIN space requirements
  • Temporary database space requirements
  • DBC space requirements
  • Transient Journal space requirements
  • Permanent database space requirements

Answer : Temporary database space requirements DBC space requirements Permanent database space requirements

Given the following EXPLAIN text: "... (group amps)..." What does this EXPLAIN text indicate?


Options are :

  • A partial GROUP BY was used to reduce cardinality by simultaneously sorting and grouping.
  • A partial GROUP BY optimization has been done on the SUM step.
  • The grouping column expression is not duplicated on or redistributed to other AMPs that are not part of the request.
  • The operation occurs on more than one AMP, but not necessarily all AMPs.

Answer : The grouping column expression is not duplicated on or redistributed to other AMPs that are not part of the request.

Which two are considerations of the ODBC interface and Unicode data with the Teradata Database? (Choose two.)


Options are :

  • The EBCDIC session character set is supported for the Unicode ODBC driver.
  • Passwords are converted to Unicode when stored in theTeradata Database.
  • Large Objects (LOBs) defined with the Unicode character set are limited to approximately 1 GB.
  • For Unicode character columns, the largestColumnSize is 64,000 characters.

Answer : The EBCDIC session character set is supported for the Unicode ODBC driver. For Unicode character columns, the largestColumnSize is 64,000 characters.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which two conditions should be considered when planning for Teradata utility client platform resource requirements? (Choose two.)


Options are :

  • NUSI on the target table
  • input data isvartext vs. binary
  • FILLER fields
  • whether access logging is enabled
  • fallback on the target table

Answer : input data isvartext vs. binary FILLER fields

When planning a new application, which two metrics need to be collected for data warehouse administration? (Choose two.)


Options are :

  • month-by-month I/O retry growth
  • month-by-month space growth
  • month-by-month CPU usage growth
  • month-by-month power and heat growth
  • month-by-month memory usage growth

Answer : month-by-month space growth month-by-month power and heat growth

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

A user wants to move data from a temporary table into a permanent table, update the permanent table, then drop the temporary table. The user needs to ensure that all steps must complete or all be rolled back. Which type of process is the most appropriate and what benefit would it provide?


Options are :

  • an explicit transaction because it allows DDL as the last statement
  • a Multi-statement request because if any statement fails everything is rolled back
  • a macro because the process is repeatable
  • each statement as an individual request because it reduces complexity

Answer : a macro because the process is repeatable

Given the following join plan: 1) Both left and right tables are distributed and sorted on the row hash values of the join columns 2) For each left table row, read right table rows scanning for the same row hash value 3) If no matching right table rows are found, return the left row Which join type does this represent?


Options are :

  • Merge Join
  • Nested Join
  • Product Join
  • Hash Join
  • Exclusion Merge Join

Answer : Nested Join

Given the following requirements: accept data from a message queue perform near realtime updates or inserts to a single large table minimize impact to concurrent queries Which strategy will most effectively meet these requirements?


Options are :

  • feed the messages directly into the TPT STREAM operator
  • write the rows to a file, periodically close the file, open the file and use the TPT UPDATE operator
  • write the rows to a file, periodically close the file, open the file and use the TPT STREAM operator
  • feed the messages directly into TPT UPDATE operator

Answer : write the rows to a file, periodically close the file, open the file and use the TPT UPDATE operator

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

What information is needed from the security planning process when an application requires ambiguous userids, such as EXTUSER or session pooling, and the application accesses sensitive information?


Options are :

  • a plan to track the true user via query banding
  • a plan to track the true user viadbc.accessrights
  • a plan to track the true user viadbc.queryrights
  • a plan to track the true user viaschmon

Answer : a plan to track the true user viadbc.queryrights

A manufacturing company has a variety of application requirements. They have selected the following four Teradata features which they would like to fully utilize: macros stored procedures external stored procedures User Defined Functions (UDFs) Their project requirements include using parameters substitution, dynamic SQL, cursor processing, and access to data on a remote platform. Which Teradata feature most completely fulfills the project requirements?


Options are :

  • User Defined Functions (UDFs)
  • macros
  • stored procedures
  • external stored procedures

Answer : stored procedures

A user community needs to access data with ad hoc data access requirements. Which data access strategy creates a self-sufficient environment for the user community?


Options are :

  • create read-only views and grant select access on those views then provide data model and SQL training with a roll-out of SQL Assistant for the user community
  • avoid collecting user community requirements and staff a user support center to accept requirements via written requests from the user community
  • grant SELECT access on the necessary physical tables and define a reasonable amount of spool space to save SQL responses
  • collect user community requirements and use them to create SQL macros and then grant execute privileges to the user community

Answer : grant SELECT access on the necessary physical tables and define a reasonable amount of spool space to save SQL responses

NR0-014 Teradata Administration V2R5 Certified Practice Exam Set 3

A Claims table is created with partitioning on claim date. Each partition represents one month and the table carries an eight year history. Queries against this table typically have a WHERE clause which defines the months of interest. Which statement would typically be true regarding these queries?


Options are :

  • All AMPs are accessed.
  • Partitions are scanned on a single AMP.
  • All partitions are scanned.
  • A full table scan is performed.

Answer : Partitions are scanned on a single AMP.

What is the benefit of having the TPump parameter ROBUST turned to ON?


Options are :

  • reduces the number of rows that have to be reapplied after a restart
  • reduces number of check points taken
  • reduces CPU usage associated with referential integrity
  • reduces database writes due to restart logic between check points

Answer : reduces CPU usage associated with referential integrity

A Claims table is created with partitioning on claim date. Each partition represents one month and the table carries an eight year history. Queries against this table typically have a WHERE clause which defines the months of interest. The primary index of the table is claim_id. Primary index access to the PPI table is much slower compared to a non-PPI version of the table. Which three techniques can be used to improve primary index access performance? (Choose three.)


Options are :

  • add a USI on top of the primary index column(s)
  • make the primary index column(s) a NUPI index
  • make the PPI column(s) part of the primary index
  • add a NUSI on top of the primary index column(s)

Answer : add a USI on top of the primary index column(s) make the primary index column(s) a NUPI index make the PPI column(s) part of the primary index

TE0-125 Teradata 12 Solutions Development Practice Exam Set 3

Which two are characteristics of the semantic data model? (Choose two.)


Options are :

  • It supports indexes.
  • It clarifies data access patterns.
  • It reduces complexity.
  • It requires stored procedures.

Answer : It supports indexes. It clarifies data access patterns.

Given the following table characteristics: * SET table with 50 billion rows representing 5 years of data * NUPI, single-level partitioning by month with a NO RANGE partition * 2 secondary indexes, one USI and one NUSI * Oldest month's data is copied to a history table and then deleted on a monthly basis To save and delete all of the rows for one month of old data, the customer's solution to drop the monthly partition is executed (in Teradata mode) as follows: ALTER TABLE ... DROP RANGE ... WITH INSERT INTO History_Table; Which two statements are true about the result of implementing this solution? (Choose two.)


Options are :

  • Rows are moved from the dropped partition to the NO RANGE partition.
  • Applications with access locks can continue to access this table
  • An exclusive lock is placed on the table.
  • The rows are deleted from the table.

Answer : An exclusive lock is placed on the table. The rows are deleted from the table.

There is an application that requires event-driven data and a strategic application that requires periodic data loads. Which two are important data load considerations when developing the event-driven application? (Choose two.)


Options are :

  • data latency
  • data volatility
  • volume of end users
  • locking level

Answer : data volatility locking level

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which two resources may be leveraged to analyze product join usage for a transaction? (Choose two.)


Options are :

  • DBC.ResUsageSldv
  • DBC.Acctg
  • DBC.ResUsageSps
  • DBC.DBQLStepTbl

Answer : DBC.Acctg DBC.ResUsageSps

What will occur when FastLoad attempts to load duplicate rows into a MultiSet table?


Options are :

  • All duplicate rows will be loaded.
  • The first row will be loaded, the duplicates will be discarded, and an entry placed into Error Table 2.
  • All duplicate rows will be copied into Error Table 2
  • The first row will be loaded and the duplicates will be discarded.

Answer : The first row will be loaded, the duplicates will be discarded, and an entry placed into Error Table 2.

An application loads Table_L. The load process is often blocked by users executing longrunning queries. Which solution will likely prevent query users from blocking the load process?


Options are :

  • change the view forTable_L to use the NOLOCKING modifier
  • execute the RELEASE LOCKS command onTable L
  • invoke Locking Logger
  • change the view forTable_L to use the LOCKING FOR ACCESS modifier

Answer : execute the RELEASE LOCKS command onTable L

TE0-124 Teradata 12 Database Administration Practice Exam Set 4

The development team is given requirements to provide a graphical interface for a large user community. Among the requirements, the application presents summarized data for review. While viewing summary data, the user can use a GUI button to inspect the supporting detail. Which solution meets the requirements?


Options are :

  • BTEQ in interactive mode
  • SQL Assistant
  • a custom developed application
  • SQL Assistant Web Edition

Answer : SQL Assistant Web Edition

When using a DELETE or UPDATE in a MultiLoad IMPORT task to integrate data, which statement is true when the table is partitioned by transaction date?


Options are :

  • The number of disk reads increases resulting in more data blocks being written
  • Values must be supplied for the PI and the partitioning column.
  • Partitioning by month will improve the load performance.
  • The PI and partitioning column can be updated.

Answer : The number of disk reads increases resulting in more data blocks being written

Which two resources may be leveraged to analyze I/O utilization for a transaction? (Choose two.)


Options are :

  • DBC.DBQLogTbl
  • DBC.ResNode
  • DBC.Acctg
  • DBC.AccessLog

Answer : DBC.DBQLogTbl DBC.AccessLog

TE0-121 12 Teradata Basics Certification Practical Exam Set 1

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions