TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

What does the Teradata Parallel Transporter (TPT) STREAM driver attribute TD_PACK specify?


Options are :

  • how many statements to pack into Multi-statement requests
  • whether packing will be turned off or on for Multi-statement requests
  • the lowest number of statements to pack in a Multi-statement request
  • whether the STREAM driver will determine the pack factor of Multi-statement requests

Answer : whether the STREAM driver will determine the pack factor of Multi-statement requests

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two are characteristics of a physical data model? (Choose two.)


Options are :

  • It considers data demographics including cardinalities, value distributions, and data change ratings.
  • It's key goal is the elimination of redundant, inconsistent data along with the associated cost.
  • It includes some business rules of the enterprise that apply to the information to be stored in the data warehouse.
  • It defines entities, relationships, and the profiles needed for the system.

Answer : It includes some business rules of the enterprise that apply to the information to be stored in the data warehouse. It defines entities, relationships, and the profiles needed for the system.

Given the following join plan: 1) Identify the smaller table of a pair to be joined 2) Duplicate this table on all AMPs in spool 3) Compare each row of the larger table with each row from the smaller table 4) Join the rows that match the WHERE condition Which join type does this represent?


Options are :

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

Answer : Nested Join

A new application is being added to an already existing data warehouse. While writing and tuning a new query, which tool is used to determine if changes made to the query plan are producing more or less optimal results before moving the query into production?


Options are :

  • Statistics Wizard
  • AWT Monitor
  • Visual Explain
  • ResUsage

Answer : Statistics Wizard

TE0-124 Teradata 12 Database Administration Practice Exam Set 1

Defining the correct value in the PACK parameter in a TPump job provides which benefit?


Options are :

  • improves efficiency in the number of transmissions
  • reduces CPU usage associated with duplicate row checks
  • increases the efficiency of the restart logic
  • reduces the chance that any single DML statement will fail

Answer : increases the efficiency of the restart logic

Given the following SQL statement: SELECT ADD_MONTHS(date '2009-04-30', 1); What is the correct output?


Options are :

  • 30-05-2010
  • 30-04-2010
  • 30-05-2009
  • 31-05-2009

Answer : 31-05-2009

An application needs replicated data so that one version can be dedicated to the load process while users access the second version. Which two support this strategy? (Choose two.)


Options are :

  • user view access switching
  • Dual Systems
  • Journal Tables
  • fallback

Answer : user view access switching Journal Tables

TE0-141 14 Teradata Basics Certified Practice Test Set 1

A project team has decided to run in Teradata mode. Which is a Teradata mode characteristic but not an ANSI mode characteristic?


Options are :

  • Transaction rollbacks are specified by an ABORT or ROLLBACK statement.
  • he DDL statement must be the last statement in the transaction.
  • The COMMIT statement is valid.
  • If a request aborts in the transaction, the entire transaction is rolled back.

Answer : The COMMIT statement is valid.

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


Options are :

  • DBC.AccLogTbl
  • DBC.DBQLogtbl
  • DBC.ResUsageSpdsk
  • DBC.Acctg
  • DBC.ResUsageHst

Answer : DBC.DBQLogtbl DBC.ResUsageHst

A call center needs to query customer invoice data with the following requirements: minimal response time against very large invoice data tables the queries are known must query the invoice data in the Teradata system must support high-volume transactions at many thousand per second ad hoc queries are not permitted by the call center Which data access strategy will meet these requirements assuming workload management is implemented to protect the important queries?


Options are :

  • export the invoice data to an application on an external server
  • develop an application usingTeradata active integration components
  • provide views of the invoice data, data model and SQL training, and GRANT select rights to the user community
  • use TPT STREAM operator to process the high-volume transactions

Answer : use TPT STREAM operator to process the high-volume transactions

TE0-121 12 Teradata Basics Certification Practical Exam Set 4

Which three techniques prevent duplicate rows in a MultiSet table? (Choose three.)


Options are :

  • create a unique generated identity column on the table
  • insert the rows with TPump
  • place a UNIQUE constraint on a column of the table
  • load the table withMultiLoad
  • add a USI column to the table

Answer : create a unique generated identity column on the table insert the rows with TPump load the table withMultiLoad

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 internal execution. Which Teradata feature most completely fulfills the project requirements?


Options are :

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

Answer : external stored procedures

Given the following join plan: 1) Read the data from the left table into available memory 2) Read a row from the right table, which may be an unsorted spool file containing the row hash value for each row as well as its row data 3) Match each right row with all the left table rows having the same row hash 4) Join the rows Which join does this represent?


Options are :

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

Answer : Product Join

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

A customer performs INSERTS, UPDATES, DELETES, and UPSERTS against a populated table every day. Which statement is true about locking?


Options are :

  • The table cannot be queried while the load job is running.
  • The table can be queried via ACCESS lock.
  • The table can be queried via a view with a READ lock.
  • The table can be queried using a READ lock

Answer : The table can be queried using a READ lock

A user community of over 1,000 users seeks access to the data with the following requirements: unrestricted retrieval access to all data in compliance with security requirements ability to create and save data in permanent tables the same queries may or may not be repeated on a regular basis Workload management prevents users from concurrently submitting an excessive number of large queries. Which data access strategy meets these defined requirements?


Options are :

  • Unrestricted retrieval of data requires continuous tuning of the database and queries and therefore the full set of requirements cannot be achieved.
  • Create a set of views in compliance with security requirements, train the user community on both the data model and SQL, install SQL Assistant, and create databases for data storage.
  • Create a set of views in compliance with security requirements, train the user community on both the data model and SQL, and install SQL Assistant.
  • Teradata SQL does not permit users to save data and therefore the full set of requirements cannot be achieved.

Answer : Unrestricted retrieval of data requires continuous tuning of the database and queries and therefore the full set of requirements cannot be achieved.

The Teradata Parallel Transporter (TPT) LOAD driver attribute TD_PAUSE_ACQ allows a user to specify what?


Options are :

  • whether or not the load job will pause between the initial and acquisition phases
  • how much time the load job will pause between the acquisition and apply phases
  • whether or not to pause the load job between theacquisition and apply phases
  • how much time the load job will pause between the initial and acquisition phases

Answer : whether or not the load job will pause between the initial and acquisition phases

TE0-141 14 Teradata Basics Certified Practice Test Set 2

A customer has a requirement to export more than 1 GB of data to a file for use in an external Marketing application. There is a requirement to do this as quickly as possible. Which export tool or interface should be used to perform this job?


Options are :

  • ODBC
  • JDBC
  • CLI
  • FastExport

Answer : ODBC

A new application has been added to an already existing data warehouse. Which two are used to analyze performance opportunities for the new workload containing both the new and old queries that access existing tables? (Choose two.)


Options are :

  • DBQL
  • Priority Scheduler
  • Index Wizard
  • Access Log

Answer : DBQL Access Log

TPump is being used to support ADW event-driven load requirements and MultiLoad for periodic batch updates in support of the strategic BI data load requirements. Which two are considerations when developing an application that will utilize the active data? (Choose two.)


Options are :

  • TPump provides an opportunity to reduce resources when run in mini-batch mode.
  • TPump cannot support partitioned DML load optimization for loading multiple tables.
  • TPump is closer to real time and has the potential for minimal latency.
  • TPump is compatible with triggers, join indexes, or unique secondary indexes.

Answer : TPump provides an opportunity to reduce resources when run in mini-batch mode. TPump is compatible with triggers, join indexes, or unique secondary indexes.

TE0-125 Teradata 12 Solutions Development Practice Exam Set 1

Given the following SQL statement: SELECT EXTRACT (DAY FROM DATE '2009-09-24'); What is the correct output?


Options are :

  • 267
  • 9/24/2009
  • 24-Sep
  • Thursday
  • 24

Answer : 9/24/2009

Which three statements are true about loading a SET table in Teradata? (Choose three.)


Options are :

  • A NUPI may slow down INSERTs for a SET table
  • A duplicate row check is performed when a row is inserted into a SET table.
  • There are no limitations when loading to a SET table.
  • SET tables during aMultiLoad are limited to 16 indexes.
  • FastLoad performs a duplicate row check.

Answer : A NUPI may slow down INSERTs for a SET table SET tables during aMultiLoad are limited to 16 indexes. FastLoad performs a duplicate row check.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

A retailer needs to load large amounts of transaction data frequently to a table with a NUSI and referential integrity constraints. There is a requirement for relatively low latency (i.e., 5 minutes) for data to be available in the target table. Users access the target table during the day. Which load strategy should the customer use?


Options are :

  • perform frequent batch jobs usingFastLoad to load to a staging table and then apply to the target table with INSERT SELECT
  • perform frequent batch jobs usingMultiLoad to load directly to the target table
  • useTPump reading queues to continuously update the table
  • use the TPT LOAD operator to load to the staging table and then apply to the target table with INSERT SELECT

Answer : perform frequent batch jobs usingFastLoad to load to a staging table and then apply to the target table with INSERT SELECT

When planning to implement a new active application, what information should be provided to the warehouse administration team to plan for workload management?


Options are :

  • a presentation of the application user interface
  • a presentation of the service level agreements
  • a presentation of the metrics used by the application
  • a presentation of closed issuesraised during development

Answer : a presentation of the metrics used by the application

Which two are characteristics of a logical data model? (Choose two.)


Options are :

  • It is dependent upon the application it supports.
  • It should be in at least third normal form.
  • It is a subject-oriented, integrated view of the business

Answer : It is dependent upon the application it supports. It is a subject-oriented, integrated view of the business

TE0-141 14 Teradata Basics Certified Practice Test Set 4

A travel agency captures and keeps sensitive credit card data on file to book travel for frequent customers. When designing the application, which two items need to be provided to the security planning process? (Choose two.)


Options are :

  • the plan for encrypting credit card data
  • the plan for managing user PROFILE data
  • when notified, the security team will permit public access to credit card data
  • the plan for securing the encryption formula
  • the plan for charging users for use of the sensitive information

Answer : the plan for encrypting credit card data the plan for managing user PROFILE data

Which technique removes duplicate rows from a MultiSet table when duplicate rows exist?


Options are :

  • create a non unique secondary index on the table
  • create a unique index on the table
  • enable referential integrity
  • INSERT SELECT into a SET table

Answer : create a unique index on the table

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


Options are :

  • NUPI on the target table
  • fallback on the entire system
  • . DROP syntax on FIELD statements
  • conditional apply (APPLY WHERE)
  • NUSI on the target table

Answer : conditional apply (APPLY WHERE) NUSI on the target table

TE0-121 12 Teradata Basics Certification Practical Exam Set 5

Which two tools or features of Teradata enable the implementation and management of application security or data privacy? (Choose two.)


Options are :

  • DBQL
  • Create rights
  • Access rights
  • ResUsage

Answer : Create rights ResUsage

Which layer of the Active Data Warehouse provides data access flexibility?


Options are :

  • Security Layer
  • Physical Data Layer
  • Data Staging Layer
  • Semantic View Layer

Answer : Data Staging Layer

A batch load has been converted to a near real-time load strategy using TPump. The load performs better than the hourly loads yet is only processing a few transactions per second. Which strategy will improve performance?


Options are :

  • reduce the number of sessions
  • reorganize the target table
  • reduce the number of secondary indexes on the target table
  • reduce the FREESPACE value on the target table

Answer : reduce the FREESPACE value on the target table

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions