TE0-125 Teradata 12 Solutions Development Practice Exam Set 2

Given the following EXPLAIN text: "6) We do an all-AMPs RETRIEVE step ... If one or more rows are inserted into Spool 3, then go to step 4." What does this EXPLAIN text indicate?


Options are :

  • This is a Multi-statement transaction.
  • This is a recursive query.
  • This is an insert select.
  • This is a correlatedsubquery.

Answer : This is a correlatedsubquery.

What important information is required for security planning purposes when moving an application from test to production?


Options are :

  • list of users requiring temporary space
  • list of users requiring access to Linux user root
  • list of users requiring sensitive data access
  • list of users requiring access to the AWS

Answer : list of users requiring access to Linux user root

An application integrates character data from a non-relational database system. Requirements include loading the following data types: date time date/timestamp byte numeric character Application requirements include validating data types prior to loading to prevent row rejection. Which data type validations are required?


Options are :

  • All data types need validation.
  • All data types need validation except for byte.
  • Invalid content will result in null columns.
  • All data types need validation except for character.

Answer : All data types need validation except for character.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

Which BTEQ command is utilized to specify whether transaction boundaries are determined by Teradata SQL semantics or ANSI semantics?


Options are :

  • indicdata
  • sessioncharset
  • sessions
  • session semantics
  • recordmode

Answer : recordmode

What is a characteristic of a semantic layer?


Options are :

  • It can compressTeradata table data.
  • It can enforce efficient joins.
  • It can store data across transactional boundaries and sessions.
  • It can be used in place of user access tools, such as SQL Assistant.

Answer : It can store data across transactional boundaries and sessions.

When designing a solution that accesses sensitive information, which type of logging may be required by the security teams?


Options are :

  • access to objects containing privileged information
  • access to privileged processes
  • access to privileged constraints
  • access to constraint objects

Answer : access to constraint objects

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

A query is developed and tested on a test system. Capacity planning requires the query to consume less than 10 CPU seconds. Testing demonstrates an average execution time of less than 10 CPU seconds. The test system is a different hardware generation than the production system. Based on requirements and test results, will the query meet the service level goal of less than 10 CPU seconds on the production system?


Options are :

  • Yes, because the results on the test system are within the specified requirements.
  • No, CPU seconds on the test system are not the same metric on the production system and metrics do not exist to normalize CPU seconds between two unlike systems.
  • Yes, CPU seconds between two systems of different hardware generations are identical and the results are within requirements.
  • Unknown, the problem does not state the normalization factor to convert CPU seconds on the test system to those of the production system.

Answer : No, CPU seconds on the test system are not the same metric on the production system and metrics do not exist to normalize CPU seconds between two unlike systems.

A user needs to create a Partitioned Primary Index (PPI) column on a table. Which two types of tables can be used? (Choose two.)


Options are :

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

Answer : Global Temporary Table Queue Table

Which three physical objects enhance active event processing? (Choose three.)


Options are :

  • triggers
  • Workload Definition
  • Workflow Group
  • Queue Tables
  • query banding

Answer : Workload Definition Queue Tables query banding

NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 3

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


Options are :

  • It identifies the primary index for each table.
  • It provides an understanding of the data by abstracting it from the physical aspects of storage.
  • It includes the semantics of an organization.
  • It may include vertical or horizontal partitioning.

Answer : It provides an understanding of the data by abstracting it from the physical aspects of storage. It includes the semantics of an organization.

Which BTEQ command assigns severity levels to errors?


Options are :

  • errorcode
  • errorlevel
  • errorout
  • maxerror
  • exit

Answer : errorcode

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

A customer with a very busy system loads empty partitions of a PPI table that is partitioned by day. There is a requirement to do UPSERT processing against the partition as the day progresses. There is the possibility that duplicate rows may be loaded. Which load utility should be used?


Options are :

  • BTEQ
  • FastLoad
  • MultiLoad
  • TPT LOAD operator

Answer : FastLoad

A retailer has a need to constantly load transaction data from its stores and a requirement for extremely low latency. Data is streamed through multiple message queues, where it is transformed, re-queued, and sent to TPump. The primary index is fully specified in the DML statement in the TPump script. Which three statements are true regarding locking and TPump? (Choose three.)


Options are :

  • A query against the table can do a full table scan without an access lock without blockingTPump.
  • If a query is selecting one or a few rows in the table against a UPI, a read lock will not affect it.
  • A singleTPump request with pack >1 will lock multiple row hashes.
  • TPump obtains row hash write locks on the rows it is inserting/updating/deleting.
  • TPump puts a table write lock during the application phase.

Answer : A query against the table can do a full table scan without an access lock without blockingTPump. If a query is selecting one or a few rows in the table against a UPI, a read lock will not affect it. A singleTPump request with pack >1 will lock multiple row hashes.

A user wants to create a table for an event processing application which runs a SELECT AND CONSUME TOP 1 statement. Which type of table should be used?


Options are :

  • Queue Table
  • Global Temporary Trace Table
  • Derived Table
  • Event Log Table

Answer : Derived Table

NR0-015 Teradata Design Architecture V2R5 Practice Exam Set 2

A new application has been developed on the test system with the following characteristics: the test database is proportionally sized at 25% the size of the production system the test machine is 4 nodes the production machine is 16 nodes the hardware type and software levels of both machines are identical operating as the only application on the test machine, it operates at 1,000 transactions per second What is the maximum expected performance when the new application goes into production?


Options are :

  • 4,000 transactions per second
  • 1,000 transactions per second
  • 16,000 transactions per second
  • 8,000 transactions per second

Answer : 16,000 transactions per second

A telecommunications company is in the process of building a data warehouse. Most of the tables they will be loading have already been validated for referential integrity in their originating system. Disk space is not a problem for them, however they are concerned about the join performance on some of their larger tables. Which referential integrity option would satisfy the requirements for their large tables?


Options are :

  • . Batch RI
  • Soft RI
  • Standard RI
  • No RI

Answer : Standard RI

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


Options are :

  • Roles
  • Profiles
  • Access Logging
  • ResUsage EventLog

Answer : Profiles ResUsage EventLog

TE0-141 14 Teradata Basics Certified Practice Test Set 1

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


Options are :

  • It represents people, places, things, and events.
  • It provides information for table relationships.
  • It includes the definitions for the identified views.
  • It incorporates derived data for integration and efficiency.

Answer : It represents people, places, things, and events. It incorporates derived data for integration and efficiency.

When using continuous TPump updates to integrate data, which statement is true when the table is partitioned by transaction date?


Options are :

  • Partitioning by day is always a benefit to this type of data integration strategy.
  • The Join Indexes must always be dropped and rebuilt after adding data to the base table.
  • If multi-sessionTPump is used, the partitions should be defined with fairly coarse granularity.
  • Serialization of multi-sessionTPump (or BTEQ) inserts is always achieved.

Answer : Partitioning by day is always a benefit to this type of data integration strategy.

Which statement is true regarding Standard RI and Soft RI?


Options are :

  • Standard RI and Soft RI both utilize a reference indexsubtable.
  • Standard RI and Soft RI both can be used withMultiLoad.
  • Standard RI and Soft RI both enable join elimination optimization.
  • Standard RI and Soft RI both enforce referential integrity.

Answer : Standard RI and Soft RI both enforce referential integrity.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

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


Options are :

  • It takes into account the demographics for the data to be loaded in the data warehouse.
  • It represents the way the business sees the information.
  • It is optimized for the site-specific implementation.
  • It declares physical space for users, UDFs, and stored procedures.

Answer : It represents the way the business sees the information. It is optimized for the site-specific implementation.

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


Options are :

  • It includes unique and non-unique primary index definitions based on how rows will be most frequently accessed.
  • It may includedenormalizations to enhance performance of a particular application.
  • It presents the data in a standard framework that supports direct table access for the business users.
  • It has the dimensionsdenormalized with each dimension being represented by multiple tables.

Answer : It includes unique and non-unique primary index definitions based on how rows will be most frequently accessed. It presents the data in a standard framework that supports direct table access for the business users.

TE0-122 12 Teradata SQL Certification Practice Exam Set 3

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


Options are :

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

Answer : DBC.AccessLog DBC.ResUsageScpu

Prior to implementing an active application, which capacity planning metric must be planned for before the application achieves full production status?


Options are :

  • the number of views used by the application
  • maximum query text size used by the application
  • the number of users
  • the number of macros used by the application

Answer : the number of macros used by the application

Which component of a dual systems architecture provides query routing between systems?


Options are :

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

Answer : Teradata Dynamic Workload Manager

TE0-122 12 Teradata SQL Certification Practice Exam Set 4

Which MultiLoad syntax element specifies that a MultiLoad job should continue to attempt to logon when the maximum number of load jobs is already running?


Options are :

  • errlimit
  • tablewait
  • sleep
  • notify
  • tenacity

Answer : sleep

A user wants to store data and collect statistics on that data. Which type of table should be used?


Options are :

  • Spool Table
  • Global Temporary Table
  • Journal Table
  • Derived Table

Answer : Journal Table

There is a requirement to process a data file to update or insert 10% of the rows in a very large table. Which two strategies will offer fastest run times? (Choose two.)


Options are :

  • use the TPT LOAD operator to load a new table and use a custom written stored procedure to open the cursor of transactions, looping through the fetched rows updating the existing rows and inserting the new rows
  • use TPT UPDATE operator to update or insert the rows
  • use single session BTEQ to import all the rows into an INSERT statement, then import the rows again using an UPDATE statement
  • use the TPT LOAD operator to load a new table and use the SQL MERGE statement to update the target table

Answer : use the TPT LOAD operator to load a new table and use a custom written stored procedure to open the cursor of transactions, looping through the fetched rows updating the existing rows and inserting the new rows use the TPT LOAD operator to load a new table and use the SQL MERGE statement to update the target table

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 2

Given the following join plan: 1) Identify the smaller relation of a pair to be joined 2) The Optimizer pursues the following steps only if it is necessary to place qualified rows into the spool file A) Place the qualified rows from one or both relations into the spool file B) Relocate the qualified spool rows to their target AMPs based on the hash of the join column set C) Sort the qualified spool rows on their join column row hash values 3) Compare the relocated row set with matching join column row hash values in the other relation Which type of join plan does this represent?


Options are :

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

Answer : Nested Join

What could improve data access performance but adversely affect the data integration utility?


Options are :

  • Aggregate Join Index
  • Soft Referential Integrity
  • multi-column statistics
  • Multi-Value Compression (MVC)

Answer : Soft Referential Integrity

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions