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

Which Teradata Dynamic Query Manager (TDQM) rule type is used to prevent a query from running if it uses a specific join type?


Options are :

  • query access
  • object access
  • workload limits
  • query resource (Correct)

Answer : query resource

TE0-141 14 Teradata Basics Certified Practice Test Set 1

Which two attributes are copied for a CREATE TABLE from a source table (not a subquery) to the table being created? (Choose two.)


Options are :

  • data types (Correct)
  • triggers
  • REFERENCES constraints
  • FALLBACK option (Correct)

Answer : data types FALLBACK option

In an equality join on primary index columns between a non-partitioned primary index (NPPI) table and a partitioned primary index (PPI) table, there is a very large number of surviving partitions after applying constraints. Which two statements are true about the NPPI to PPI join compared to an NPPI to NPPI join? (Choose two.)


Options are :

  • Disk I/Os are higher. (Correct)
  • Memory requirements are the same.
  • CPU utilization is higher. (Correct)
  • Disk I/Os are fewer.
  • CPU utilization is the same.

Answer : Disk I/Os are higher. CPU utilization is higher.

Which statement is true about sampling?


Options are :

  • The default sampling option is sampling WITH REPLACEMENT.
  • Sampling five groups WITH REPLACEMENT ensures a mutually exclusive set within each sample.
  • For large sample sizes, proportional allocation is faster than RANDOMIZED ALLOCATION. (Correct)
  • The default row allocation method is sampling with RANDOMIZED ALLOCATION.

Answer : For large sample sizes, proportional allocation is faster than RANDOMIZED ALLOCATION.

TE0-121 Teradata Basics Practice Test Set 3

Which two characteristics do join indexes and secondary indexes have in common? (Choose two.)


Options are :

  • They eliminate the need to directly access the base table.
  • . They eliminate the need to perform the join step.
  • The index access is transparent to the user. (Correct)
  • They are maintained by the system. (Correct)

Answer : The index access is transparent to the user. They are maintained by the system.

Which statement about referential integrity (RI) is true?


Options are :

  • All forms of RI require the creation of an error table.
  • All forms of RI require a unique index on the referenced column list. (Correct)
  • Integrity is only enforced if the WITH CHECK OPTION is specified.
  • The Optimizer can only utilize join elimination for RI when the WITH NO CHECK OPTION is specified.

Answer : All forms of RI require a unique index on the referenced column list.

Which Teradata tool or facility should be used to restrict query access to production tables during scheduled batch loading and update operations?


Options are :

  • Teradata Manager - session management
  • Teradata Dynamic Query Manager (TDQM) - query resource restrictions
  • Teradata Dynamic Query Manager (TDQM) - workload limits
  • Priority Scheduler - resource partition limit parameters
  • Teradata Dynamic Query Manager (TDQM) - object access restrictions (Correct)

Answer : Teradata Dynamic Query Manager (TDQM) - object access restrictions

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

Which two can potentially eliminate join steps? (Choose two.)


Options are :

  • matching primary index columns on the join conditions
  • multi-table join index (Correct)
  • single-table join index
  • referential integrity (RI) constraints (Correct)

Answer : multi-table join index referential integrity (RI) constraints

Which two components in the join index definition allow the join index to be used for partial covering? (Choose two.)


Options are :

  • the unique index of the underlying base table (Correct)
  • the phrase ORDER BY HASH
  • the keyword ROWID (Correct)
  • the non-unique primary index (NUPI) of the underlying base table

Answer : the unique index of the underlying base table the keyword ROWID

Which two statements are true about a CALL statement? (Choose two.)


Options are :

  • A CALL statement initiates a transaction.
  • A macro can contain multiple CALL statements.
  • A CALL statement can only be executed in the same session mode in which the stored procedure was created. (Correct)
  • A CALL statement cannot be part of a multi-statement request. (Correct)

Answer : A CALL statement can only be executed in the same session mode in which the stored procedure was created. A CALL statement cannot be part of a multi-statement request.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

What is a benefit of assigning account strings at the profile level?


Options are :

  • enables you to grant privileges to a group of users based on their account string
  • enables you to save space by reducing the number of rows inserted into DBC.AMPUsage
  • enables you to change account strings once for many users (Correct)
  • enables you to save space by reducing the number of rows inserted into DBC.AccessRights

Answer : enables you to change account strings once for many users

Which Teradata tool or facility should be used to restrict query access to production tables during scheduled batch loading and update operations?


Options are :

  • Teradata Dynamic Query Manager (TDQM) - query resource restrictions
  • Teradata Dynamic Query Manager (TDQM) - workload limits
  • Priority Scheduler - resource partition limit parameters
  • Teradata Manager - session management
  • Teradata Dynamic Query Manager (TDQM) - object access restrictions (Correct)

Answer : Teradata Dynamic Query Manager (TDQM) - object access restrictions

Which two may be captured by both access logging and Database Query Logging (DBQL)? (Choose two.)


Options are :

  • SQL text (Correct)
  • query elapsed time
  • specific access rights granted and/or denied
  • session logon date and time (Correct)

Answer : SQL text session logon date and time

TE0-121 Teradata Basics Practice Test Set 2

Which two does the Teradata System Emulation Tool (TSET) utility allow? (Choose two.)


Options are :

  • import workloads from other Teradata utilities
  • import data demographics from one system to another (Correct)
  • import sample data from one system to anothe
  • import system characteristics from one system to another (Correct)

Answer : import data demographics from one system to another import system characteristics from one system to another

Which two functions does the Teradata Statistics Wizard perform? (Choose two.)


Options are :

  • displays current versus captured statistics information
  • executes the statistics collection recommendations (Correct)
  • recommends secondary indexes
  • reproduces Optimizer-related issues in a test environment
  • recommends recollection of statistics based on table skew (Correct)

Answer : executes the statistics collection recommendations recommends recollection of statistics based on table skew

Which three statements about a partitioned primary index (PPI) are true? (Choose three.)


Options are :

  • Query constraints on the partitioning column avoid full-table scans. (Correct)
  • Join performance can be impacted when there are many partitions. (Correct)
  • A PPI table can be altered to change the range of an existing partition.
  • The need for a secondary index could be eliminated. (Correct)

Answer : Query constraints on the partitioning column avoid full-table scans. Join performance can be impacted when there are many partitions. The need for a secondary index could be eliminated.

TE0-121 Teradata Basics Practice Test Set 5

What are two ways to reduce TPump's impact on the system? (Choose two.)


Options are :

  • reduce the RATE parameter in the TPump job (Correct)
  • lower the number of TPump sessions (Correct)
  • add a TENACITY parameter to the TPump job
  • modify a SLEEP parameter in the TPump job

Answer : reduce the RATE parameter in the TPump job lower the number of TPump sessions

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


Options are :

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

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

Consider the following macro: CREATE MACRO dept_budget (deptno INT, budgamt DEC(10,2)) AS (MERGE INTO department USING (SELECT :deptno, dept_name, :budgamt FROM dept_name_assignment WHERE department_number = :deptno) AS Dept(deptnum, deptname, budget) ON Dept.deptnum = department.department_number WHEN MATCHED THEN UPDATE SET budget_amount = Dept.budget, department_name = Dept.deptnameWHEN NOT MATCHED THENINSERT VALUES (Dept.deptnum, Dept.deptname, Dept.budget, NULL););Which three statements about executing the macro are true? (Choose three.)


Options are :

  • The ON clause must contain the primary index of the target table (Correct)
  • The primary index of the target table must be unique.
  • If zero rows are returned by the subquery, neither the update nor the insert occurs. (Correct)
  • The USING subquery may return at most a single row. (Correct)

Answer : The ON clause must contain the primary index of the target table If zero rows are returned by the subquery, neither the update nor the insert occurs. The USING subquery may return at most a single row.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

To use the Teradata System Emulation Tool (TSET), Target Level Emulation must first be enabled on a test system using which utility?


Options are :

  • Ferret
  • Teradata Performance Monitor
  • Vproc Manager
  • DBSControl (Correct)

Answer : DBSControl

Assume the following stored procedure partial definition: CREATE PROCEDURE test_set (IN a INT, INOUT b INT, OUT c INT) Which two statements are valid constructs within the stored procedure? (Choose two.)


Options are :

  • SET c = b + 1 (Correct)
  • SET c = b + a (Correct)
  • SET c = c + 1
  • SET a = b + c

Answer : SET c = b + 1 SET c = b + a

Teradata Visual Explain supports the comparison of how many plans?


Options are :

  • 16
  • unlimited (Correct)
  • 3
  • 4

Answer : unlimited

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which two profile parameters take effect immediately when changed? (Choose two.)


Options are :

  • temporary space limits (Correct)
  • password attributes
  • spool space limits (Correct)
  • . permanent space limits

Answer : temporary space limits spool space limits

Which two statements about hash indexes are true? (Choose two.)


Options are :

  • They can be defined on a journal table
  • They can be defined in a different database than the base table they reference. (Correct)
  • They can be defined on a temporary table.
  • They can be defined with FALLBACK protection. (Correct)
  • They can be defined on a view.

Answer : They can be defined in a different database than the base table they reference. They can be defined with FALLBACK protection.

The Priority Scheduler can be used for which two activities? (Choose two.)


Options are :

  • scheduling queries based on user-defined production schedules
  • modifying users' priorities based on query behavior (Correct)
  • setting limits on resources available to users or groups of users (Correct)
  • scheduling high-priority maintenance operations

Answer : modifying users' priorities based on query behavior setting limits on resources available to users or groups of users

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which statement is true about a partially covering join index?


Options are :

  • The index includes all columns of a unique index or rowID of a table containing noncovered columns. (Correct)
  • The index is used if the primary index of one table is in the covering index.
  • The index is an aggregate join index.
  • The index includes most of the selected columns.

Answer : The index includes all columns of a unique index or rowID of a table containing noncovered columns.

You are evaluating the possible use of a join index on a multi-terabyte table. Which two factors complicate the implementation of a join index on such a table? (Choose two.)


Options are :

  • A large number of users access the table.
  • Triggers are defined on the table. (Correct)
  • A partitioned primary index (PPI) is defined on the table.
  • The maintenance job for the table is MultiLoad. (Correct)

Answer : Triggers are defined on the table. The maintenance job for the table is MultiLoad.

What are two functions of the Teradata Index Wizard? (Choose two.)


Options are :

  • allows importing of workload from Teradata Manager
  • allows for "what-if" analysis (Correct)
  • allows for a visual explanation of the index creation plan
  • allows you to schedule index creation (Correct)

Answer : allows for "what-if" analysis allows you to schedule index creation

TE0-141 14 Teradata Basics Certified Practice Test Set 2

Which three default options are available as built-in physical actions to a triggered alert within Teradata Manager? (Choose three.)


Options are :

  • raise the priority of a session
  • execute a program (Correct)
  • send an email (Correct)
  • increase spool space
  • abort a session (Correct)

Answer : execute a program send an email abort a session

When might a partially covering join index be used to access the non-covered columns in the base table? (Choose two.)


Options are :

  • when the join index contains all of the columns of a unique index of the base table (Correct)
  • when a unique secondary index (USI) is defined on the base table
  • when the join index contains all of the columns of a non-unique primary index (NUPI) of the base table
  • when the join index references the rowID column of the base table (Correct)

Answer : when the join index contains all of the columns of a unique index of the base table when the join index references the rowID column of the base table

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions