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

Which three can be used to define an aggregate join index? (Choose three.)


Options are :

  • COUNT (Correct)
  • GROUP BY (Correct)
  • SUM (Correct)
  • COUNT DISTINCT
  • ORDER BY

Answer : COUNT GROUP BY SUM

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Updatable cursors are permitted in which two types of application implementation? (Choose two.)


Options are :

  • stored procedures (Correct)
  • triggers
  • applications that use a Teradata preprocessor (Correct)
  • macros

Answer : stored procedures applications that use a Teradata preprocessor

Which two methods can be used to update a table that has a join index without dropping the index? (Choose two.)


Options are :

  • MultiLoad
  • TPump (Correct)
  • FastLoad into an empty table and INSERT/SELECT into the target table (Correct)
  • Teradata Dynamic Query Manager (TDQM)

Answer : TPump FastLoad into an empty table and INSERT/SELECT into the target table

Which three statements are true about roles? (Choose three.)


Options are :

  • Changes are effective immediately. (Correct)
  • Roles help reduce the number of rows in DBC.AccessRights. (Correct)
  • Roles are viewed as a pseudo-user with privileges on objects. (Correct)
  • Changes are not effective until the next logon.
  • Roles are a set of common user parameters applied to a group of users.

Answer : Changes are effective immediately. Roles help reduce the number of rows in DBC.AccessRights. Roles are viewed as a pseudo-user with privileges on objects.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

What are three ways that a join index can improve performance? (Choose three.)


Options are :

  • A sparse join index can reduce the number of rows scanned. (Correct)
  • A join index with a different primary index than the base table can reduce re-hashing overhead in queries. (Correct)
  • Referencing the join index means the SQL no longer needs to reference the base table.
  • A multi-table join index can eliminate the need to enforce referential integrity (RI).
  • An aggregate join index can reduce aggregation overhead in queries. (Correct)

Answer : A sparse join index can reduce the number of rows scanned. A join index with a different primary index than the base table can reduce re-hashing overhead in queries. An aggregate join index can reduce aggregation overhead in queries.

Consider the following Database Query Log (DBQL) request: BEGIN QUERY LOGGING ON ALL; How many characters of SQL text are captured by default?


Options are :

  • 10000
  • 200 (Correct)
  • 1000000
  • 128
  • 8192

Answer : 200

Which three filters are available within Teradata Manager's Session Status report? (Choose three.)


Options are :

  • unusual (Correct)
  • blocked (Correct)
  • logging on
  • responding (Correct)

Answer : unusual blocked responding

NR0-016 NCR Teradata Application Development V2R5 Exam Set 3

Which two characteristics differentiate a sparse join index from other single-table join indexes? (Choose two.)


Options are :

  • supports updates from TPump
  • contains a WHERE clause predicate (Correct)
  • limits the number of rows in the index (Correct)
  • limits the number of columns in the index

Answer : contains a WHERE clause predicate limits the number of rows in the index

Which statement is true if the Optimizer chooses to use random AMP sampling?


Options are :

  • The RANDOM option has been specified.
  • The SAMPLE option has been used specifying WITHOUT REPLACEMENT.
  • The SAMPLE option has been used specifying WITH REPLACEMENT.
  • No statistics have been collected on the table. (Correct)

Answer : No statistics have been collected on the table.

What are three functions of Priority Scheduler Administrator? (Choose three.)


Options are :

  • views sessions in each performance group (Correct)
  • views parameters currently in use (Correct)
  • charts real-time CPU usage by process
  • charts real-time CPU usage by allocation group (Correct)

Answer : views sessions in each performance group views parameters currently in use charts real-time CPU usage by allocation group

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which ordered analytic function can be used to compute the cumulative, group, or moving average of a particular expression?


Options are :

  • ALLAVG
  • AVG (Correct)
  • GAVG
  • MAVG

Answer : AVG

Which ordered analytic function can be used to compute the cumulative, group, or moving average of a particular expression?


Options are :

  • GAVG
  • MAVG
  • ALLAVG
  • CAVG
  • AVG (Correct)

Answer : AVG

Which three capabilities are available to the Teradata Dynamic Query Manager (TDQM) Administrator for managing scheduled requests? (Choose three.)


Options are :

  • modify scheduled request text
  • modify a job start time (Correct)
  • delete a job or request from the queue (Correct)
  • modify results
  • drop results (Correct)

Answer : modify a job start time delete a job or request from the queue drop results

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which two access modules facilitate continuous loads using Teradata utilities? (Choose two.)


Options are :

  • Java Messaging Service
  • MQ-Series (Correct)
  • named-pipes (Correct)
  • .NET framework bridge

Answer : MQ-Series named-pipes

What are two key advantages of using a stored procedure to feed the Active Data Warehouse? (Choose two.)


Options are :

  • runs on all AMPs, which adds parallelism to the load process
  • allows control of the data flow with Teradata Manager
  • can enforce cross-table transactional integrity (Correct)
  • keeps the transformation work inside the database (Correct)

Answer : can enforce cross-table transactional integrity keeps the transformation work inside the database

Which two can the SHOW statement be used to display? (Choose two.)


Options are :

  • the CREATE statements for any indirectly referenced views (Correct)
  • the last ALTER statement for any tables referenced
  • the CREATE statements for any directly referenced views (Correct)
  • a list of locks being held by sessions
  • the list of privileges needed to execute a query

Answer : the CREATE statements for any indirectly referenced views the CREATE statements for any directly referenced views

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

What three utilities can be run from Teradata Manager's remote console? (Choose three.)


Options are :

  • Crashdump Manager
  • Ferret (Correct)
  • CheckTable (Correct)
  • DBSControl (Correct)
  • Node Manager

Answer : Ferret CheckTable DBSControl

Which two statements are true about soft referential integrity (RI)? (Choose two.)


Options are :

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

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

What are three benefits of roles? (Choose three.)


Options are :

  • reduce dictionary contention during DDL operations (Correct)
  • allow more concurrent users
  • simplify access rights administration (Correct)
  • set user parameters
  • reduce size of DBC.AccessRights (Correct)

Answer : reduce dictionary contention during DDL operations simplify access rights administration reduce size of DBC.AccessRights

TE0-121 Teradata Basics Practice Test Set 2

What is an advantage of using the WITH NO CHECK OPTION instead of the WITH CHECK OPTION?


Options are :

  • No unique index is required on the referenced column list.
  • Join elimination is possible.
  • There is no extra cost for inserting rows into the referencing table. (Correct)
  • There is no extra cost for deleting rows from the referencing table.

Answer : There is no extra cost for inserting rows into the referencing table.

Which three filters are available within Teradata Manager's Session Status report? (Choose three.)


Options are :

  • parceling
  • blocked (Correct)
  • logging on
  • unusual (Correct)
  • responding (Correct)

Answer : blocked unusual responding

For which three can imported data be used within Teradata System Emulation Tool (TSET)? (Choose three.)


Options are :

  • perform "what-if" modeling (Correct)
  • generate query plans that emulate those created on a production system (Correct)
  • recreate the Optimizer performance characteristics of a production system (Correct)
  • estimate a service-level agreement (SLA) for existing applications

Answer : perform "what-if" modeling generate query plans that emulate those created on a production system recreate the Optimizer performance characteristics of a production system

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Under which two conditions would collecting multi-column statistics be beneficial? (Choose two.)


Options are :

  • if a secondary index was previously defined to allow statistics collection (Correct)
  • if the combination of columns will be using multi-value compression
  • when the columns frequently appear together in a GROUP BY clause
  • when the columns frequently appear together in join conditions (Correct)

Answer : if a secondary index was previously defined to allow statistics collection when the columns frequently appear together in join conditions

How can the load utilities benefit from partitioned primary indexes (PPIs)?


Options are :

  • Fewer TPump sessions are required if the data being updated reside in a single partition.
  • Inserting into a single partition may result in a higher number of rows inserted per data block, resulting in fewer disk reads and writes. (Correct)
  • Using the TPump PARTITION option allows you to explicitly specify the target partition, which results in lower utility CPU consumption.
  • Load utilities are not impacted by having a PPI on a table.

Answer : Inserting into a single partition may result in a higher number of rows inserted per data block, resulting in fewer disk reads and writes.

The Query Capture Database (QCD) is used by which three Teradata tools? (Choose three.)


Options are :

  • Statistics Wizard (Correct)
  • Database Query Log (DBQL)
  • Index Wizard (Correct)
  • Priority Scheduler
  • Visual Explain (Correct)

Answer : Statistics Wizard Index Wizard Visual Explain

TE0-121 Teradata Basics Practice Test Set 5

When using Priority Scheduler to balance resource usage among workloads, what are two usage considerations? (Choose two.)


Options are :

  • when possible, maintain user activity at a HIGH or RUSH priority within resource partition 0 (RP0) to keep the users flowing through the system
  • create a "penalty box" for runaway queries using the IMMEDIATE policy to limit the amount of CPU they can consume
  • tailor resource partitions with different weightings to suit different applications and users (Correct)
  • maintain development or test users in a separate allocation group and possibly a separate resource partition (Correct)

Answer : tailor resource partitions with different weightings to suit different applications and users maintain development or test users in a separate allocation group and possibly a separate resource partition

In order to count the number of rows in various tables, which object should be used to pass the tablename as a parameter?


Options are :

  • stored procedure (Correct)
  • cursor
  • view
  • macro

Answer : stored procedure

What are three advantages of using MERGE INTO rather than UPDATE ELSE INSERT for Upsert processing? (Choose three.)


Options are :

  • The UPDATE and INSERT portions need not reference the same row. (Correct)
  • The UPDATE operation may specify a different partition than the INSERT operation. (Correct)
  • The primary index column may be an identity column. (Correct)
  • The UPDATE operation may be a non-primary index operation.

Answer : The UPDATE and INSERT portions need not reference the same row. The UPDATE operation may specify a different partition than the INSERT operation. The primary index column may be an identity column.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

For the following table definition: CREATE TABLE t7 (d1 DATE, i1 INTEGER) PRIMARY INDEX (i1); Which statement creates an empty table with the same table definition?


Options are :

  • CREATE TABLE t9 AS t7 WITH NO DATA; (Correct)
  • CREATE TABLE t9 AS t7;
  • CREATE TABLE t9 AS t7 WITHOUT DATA;
  • CREATE TABLE t9 AS (SELECT * FROM t7) WITH NO DATA;

Answer : CREATE TABLE t9 AS t7 WITH NO DATA;

Which three tasks can be performed by an authorized user of the Teradata Performance Monitor? (Choose three.)


Options are :

  • identify a blocked user (Correct)
  • purge ResUsage tables
  • display system efficiency measurements (Correct)
  • reset peak utilization values
  • abort user sessions (Correct)

Answer : identify a blocked user display system efficiency measurements abort user sessions

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions