TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two statements are true about FastLoad capabilities regarding error handling, return codes, and handling statistics about the load job? (Choose two.)


Options are :

  • Notify Exit routines specify a predefined action to be performed whenever a failure occurs in the utility. The action only handles return codes. (Correct)
  • The predefined system variables, prefixed with &SYS, are not implemented inFastLoad.
  • Predefined system variables, prefixed with &SYS, are used to capture load statistics and can be used to determine if the process ran successfully. (Correct)
  • Notify Exit routines specify a predefined action to be performed whenever a failure occurs in the utility. The action can handle return codes and loadstatistics.

Answer : Notify Exit routines specify a predefined action to be performed whenever a failure occurs in the utility. The action only handles return codes. Predefined system variables, prefixed with &SYS, are used to capture load statistics and can be used to determine if the process ran successfully.

TE0-141 14 Teradata Basics Certified Practice Test Set 4

An administrator needs to establish a data warehouse architecture for a user community of 2000 end-users and a data integration group of 20 users. Which three considerations are important for data integrity and protection for these two groups of users? (Choose three.)


Options are :

  • workload definitions and priorities (Correct)
  • roles and access rights (Correct)
  • fallback
  • Permanent Journals
  • profiles (Correct)

Answer : workload definitions and priorities roles and access rights profiles

A programmer has executed a query and wants to know performance statistics. Upon investigating DBQL the query is not found. The programmer wants to see the query. Which two administrative options are available for making DBQL available sooner? (Choose two.)


Options are :

  • End logging on any user will flush the cache.
  • End logging onsystemfe is the only user that will allow the cache to be flushed manually.
  • Reduce the setting of thedbscontrol parameter dbscachectrl. (Correct)
  • Reduce the setting of thedbscontrol parameter dbqlflushrate (Correct)

Answer : Reduce the setting of thedbscontrol parameter dbscachectrl. Reduce the setting of thedbscontrol parameter dbqlflushrate

New applications are consistently being added to the current system. The administrator plans to analyze the workload to determine if adding indexes will be beneficial to the existing applications and to what extent the system can handle the additional work. Which tool should be used along with the Teradata Index Wizard to assist in the analysis?


Options are :

  • Teradata Visual Explain
  • Teradata Statistics Wizard (Correct)
  • Teradata System Emulation Tool
  • Query Capture Database

Answer : Teradata Statistics Wizard

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

A site has an Order table consisting of 100 million rows and an Order_Detail table consisting of 10 billion rows. There are 10,000 orders loaded per hour. There are requirements to report the line items of each order and the order total with an access frequency of 100 per hour. What is the most efficient way to report the order total?


Options are :

  • Create a global temporary table with the order total. (Correct)
  • Store the total of each order in the Order table.
  • Create an Aggregate Join Index.
  • Calculate the order total each time the report is run.

Answer : Create a global temporary table with the order total.

Which benefit does report-based metadata provide to IT organizations when analyzing an application's capacity trends?


Options are :

  • opportunity to improve system performance
  • opportunity to decrease IT-related problems (Correct)
  • opportunity to improve business decisions
  • opportunity to deliver applications quickly

Answer : opportunity to decrease IT-related problems

An administrator needs to establish a data warehouse architecture for a user community of 2000 end-users and a data integration group of 20 users. Which three items are important when creating the database hierarchy to support these two groups of users? (Choose three.)


Options are :

  • priorities (Correct)
  • permanent space allocation
  • roles and profiles
  • access and DBQL logging (Correct)
  • implicit access rights
  • archive and restore operations (Correct)

Answer : priorities access and DBQL logging archive and restore operations

TE0-121 Teradata Basics Practice Test Set 5

A critical customer identification application is used by all end users. Several sets of tactical queries have been created and deployed which select and transform the application data to support day-to-day credit extension, account management, and offer delivery decisions. Over time, 15 single and multi-table join indexes have been created on the critical tables to attempt to cover these tactical queries. A new set of tactical queries is being developed to support a mandated fraud reporting initiative required by the government. The application development team recommends adding another two multitable join indexes to the application tables. The ETL team is consistently missing the required load window for this data which has resulted in financial penalties to the company for unmet Service Level Agreements (SLAs). The database administrator has been asked to review the database architecture and recommend potential solutions. Which statement is true about using join indexes in the existing database architecture?


Options are :

  • As new rows are added to the base tables, multiple join indexes can be updated as part of the same transaction so the incremental cost of adding new join indexes is mitigated.
  • There is a limit of 16 join indexes per table so the addition of the two new join indexes may necessitate the removal of at least one of the existing join indexes.
  • The new set of tactical queries might use more than one of the existing join indexes and therefore not require the new join indexes. (Correct)
  • The number of times a query (for which a join index was designed) must be executed to offset the creation and maintenance time of the join index should be calculated.

Answer : The new set of tactical queries might use more than one of the existing join indexes and therefore not require the new join indexes.

An administrator needs to establish a data warehouse architecture for a user community of 2000 end-users and a data integration group of 20 users. Which three items are important considerations in establishing security controls for these two groups of users? (Choose three.)


Options are :

  • locks (Correct)
  • roles (Correct)
  • database hierarchy (Correct)
  • user priorities
  • profiles

Answer : locks roles database hierarchy

Which method can be used to address the privacy requirements of an application that accesses personal information?


Options are :

  • Use multi-factor authentication to provide strong access control and enhance the safety of data stored in the database.
  • Create a user defined function that can only be accessed from within the application to encrypt and decrypt the personal data.
  • Use Access Logging to determine the requesting user, type of access, and the referenced object. (Correct)
  • Extract the data, define a masking algorithm, and insert the data, with masking, into the response.

Answer : Use Access Logging to determine the requesting user, type of access, and the referenced object.

TE0-121 12 Teradata Basics Certification Practical Exam Set 8

To migrate an entire Teradata system to a new hardware platform, with the two systems in the same location, what is the quickest way to migrate all the data to the new system?


Options are :

  • NPARC
  • FastExport / FastLoad
  • TPump (Correct)
  • ARC

Answer : TPump

The administrator has implemented a highly normalized model for an application. In review of the DBQL data, the administrator has determined that to facilitate performance, multitable join indexes must be implemented. Why would the administrator make a decision to use a sparse multi-table join index versus other types of advanced indexes? (Choose two.)


Options are :

  • In order to bypass a CPU intensive join.
  • In order to create a vertical and horizontal partition on a section of the data
  • In order to bypass aggregate processing. (Correct)
  • The filter columns are highly selective. (Correct)

Answer : In order to bypass aggregate processing. The filter columns are highly selective.

A new tactical application is repetitive and highly-tuned with very short queries. This application needs to be proactively managed. The goal is to identify potential problems that could compromise response time early-on and make adjustments before the problem becomes highly visible. Which approach is likely to help reach this goal?


Options are :

  • Closely monitor the delay queues for the tactical application and release queries from the queue if the queue length exceeds a reasonable length. (Correct)
  • Enable DBQL and access logging in summary mode for the tactical application.
  • Set up a canary or a heartbeat query to simulate and run in the same workload as the tactical application, monitor response times carefully, and investigate if response times peak.
  • Implement a state change that will automatically raise the throttle limits for the low priority work when the number of available AWTs falls below five.

Answer : Closely monitor the delay queues for the tactical application and release queries from the queue if the queue length exceeds a reasonable length.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

A new application is being developed which will leverage data from customer-centric data. The new application's interface to the customer-centric data is a series of seven views which are referenced by several existing applications. The application will join three base tables to three of the seven views which provide access for the end users via SQL Assistant. Which performance concern might be a risk as the new application moves into production?


Options are :

  • There is no method for determining how often the underlying objects are accessed so lock contention may occur.
  • The underlying view DDL can be hidden from the end users and can change at any time without the users' knowledge. (Correct)
  • Nested views require excessive translation time in the database catalog tables.
  • Even with adequate locking access in the view layer, the other applications leveraging the views can impact the performance of the new application.

Answer : The underlying view DDL can be hidden from the end users and can change at any time without the users' knowledge.

A database administrator is preparing a capacity forecast for several new and existing applications. The additional applications will increase the number of users on the system by 30% with the maximum number of concurrent users increasing by 10%. The estimated data growth in the existing applications is 30% while the new application will add 5% to the overall system size. A data compression project will result in a space recovery of 40% across all applications. Which statement is true about the changes required to maintain the same system performance after the new applications are placed into production assuming the same access patterns will exist?


Options are :

  • The entire hardware configuration will need to expand by 5%.
  • The hardware configuration does not need be changed.
  • The entire hardware configuration will need to expand by 10%
  • The entire hardware configuration will need to expand by 15% (Correct)

Answer : The entire hardware configuration will need to expand by 15%

Which type of physical device, in addition to Enterprise System Connection (ESCON), is required to allow a mainframe in one city to connect to a Teradata Database in another city?


Options are :

  • ESCON Director (Correct)
  • Block Multiplexer
  • BYNET Optical Extension (BYOX)
  • Channel Extender

Answer : ESCON Director

TE0-121 Teradata Basics Practice Test Set 5

An active application requires uninterrupted access to tables. The Teradata support team wants an eight hour maintenance window every month. What two solutions will support these requirements? (Choose two.)


Options are :

  • Use a dual systems approach using Query Director.
  • Use a hot standby node to replace the node undergoing maintenance.
  • Use a dual systems approach usingTeradata Replication Server (Correct)
  • Set up a disaster-recovery system and allow user access (Correct)

Answer : Use a dual systems approach usingTeradata Replication Server Set up a disaster-recovery system and allow user access

A customer has a requirement to load data from a single message queue into a Sales table that is part of an active data warehouse. The Sales table has no additional indexes. The data latency requirements are daily. What is the most effective approach to support this requirement?


Options are :

  • Pull the data from the queue into a file and useFastLoad to load the data into a staging table and then use SQL INSERT SELECT.
  • Pull the data from the queue into a file and useMultiLoad to insert the data from the file.
  • Pull the data from the queue into a file and useTPump to insert the data from the file. (Correct)
  • UseTPump to continuously read from the queue and insert the data.

Answer : Pull the data from the queue into a file and useTPump to insert the data from the file.

An administrator is trying to manage resources on the system because there is a business critical reporting requirement. The reporting workload starts at 9AM and is required to finish by 10AM. At the same time, ad hoc users are allowed to access the system. The administrator is building a Query Resource Throttle in TDWM to better manage the resources. Which two are available as options for building the throttle? (Choose two.)


Options are :

  • Throttle All-AMP Queries Only
  • Only limit queries with Step Time Threshold (Correct)
  • Index Scan Types Allowed
  • No Aggregate Functions Allowed (Correct)

Answer : Only limit queries with Step Time Threshold No Aggregate Functions Allowed

TE0-121 12 Teradata Basics Certification Practical Exam Set 1

An application is being migrated from another platform without any redesign. Which two concerns are more likely to become an issue as the application goes into production? (Choose two.)


Options are :

  • data skew
  • query mix (Correct)
  • space requirements (Correct)
  • I/O usage

Answer : query mix space requirements

NR0-012 Teradata Physical Implementation V2R5 Practice Exam Set 4

It is critical that a developer generate payroll reports without being able to see employee names. The PAYROLL table and the EMPLOYEE table are used to generate the reports. The developer has no access to the base tables and needs views to both create a report and update information in PAYROLL. Which two scenarios would address these needs? (Choose two.)


Options are :

  • Create a view that joins the EMPLOYEE table and the PAYROLL table for the report and create a view of the PAYROLL table and update using the view.
  • Create a view that joins the EMPLOYEE table and the PAYROLL table and use the view for both the report and to update the PAYROLL table.
  • Create a view of the PAYROLL table andand use the view for both the report and to update the PAYROLL table. (Correct)
  • Create a view of EMPLOYEE for the report, create a view of the PAYROLL table, and update the PAYROLL table using the view. (Correct)

Answer : Create a view of the PAYROLL table andand use the view for both the report and to update the PAYROLL table. Create a view of EMPLOYEE for the report, create a view of the PAYROLL table, and update the PAYROLL table using the view.

The Software Event Log is showing multiple cylpack operations occurring throughout the day. The database administrator is concerned that the system is running out of space. Which statement is true about knowing when the system is running out of perm space?


Options are :

  • Thecylpack operation is the first step the system can take to recover space in order to perform a write operation so it is very frequently found in the log (Correct)
  • If the database administrator submits aminicylpack job and the operation fails, it is an indication that the table FreeSpace is set correctly.
  • When PACKDISK automatically starts, it is a good indication that the system is running out of perm space.
  • Minicylpacks are not an accurate signal that the system is out of space because they may occur on queries if the data is skewed.

Answer : Thecylpack operation is the first step the system can take to recover space in order to perform a write operation so it is very frequently found in the log

A retail company loads data from multiple sources throughout the day with each source having a different time variance. The sales data comes in on an hourly basis from two independent data collection servers from a single source. One server is in the USA and the other one in Europe. It is possible for a sale to be opened in one location and returned in another. The customer data comes in monthly from one source and weekly from the other two sources. A set of referential data is loaded monthly from the CRM application which contains cleansed customer contact data. A new application is being developed which needs to leverage data from the most current customer data along with the combined sales data. Which two data inputs are critical for developing a load strategy for the new application? (Choose two.)


Options are :

  • the changed data capture strategy for the customer data
  • a set of rules for determining the most authoritative customer source
  • a set of rules for determining the most authoritative sales source (Correct)
  • the changed data capture strategy for the sales data
  • the frequency of update of the CRM application (Correct)

Answer : a set of rules for determining the most authoritative sales source the frequency of update of the CRM application

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 1

A company makes details of a customer's past 20 purchases available to their staff. To support this, the data warehouse is active with near real-time data loads. Additionally, the company performs in-depth analysis of customer buying behavior using purchase history from the past three years. For the current purchase detail, the maximum time before unacceptable business consequences arise, is four hours. Historic data needs to be available within 12 hours of a failure and the data must not be greater than 24 hours old. A full system archive takes six hours. Which two approaches can be used to backup the data and meet the business requirements for recovery? (Choose two.)


Options are :

  • implement the tables with FALLBACK (Correct)
  • use online ARC to tape (Correct)
  • backup data up to disk
  • use hot standby nodes

Answer : implement the tables with FALLBACK use online ARC to tape

A user belongs to the following two roles: ROLEDEVELOPER ROLEADMINISTRATOR Which command would the user invoke to gain access to both roles simultaneously?


Options are :

  • SET ROLE ROLEDEVELOPER, ROLEADMINISTRATOR;
  • SET ROLE ACTIVE;
  • SET ROLE ROLEDEVELOPER; SET ROLE ROLEADMINISTRATOR; (Correct)
  • SET ROLE ALL;

Answer : SET ROLE ROLEDEVELOPER; SET ROLE ROLEADMINISTRATOR;

Which Referential Integrity feature will negatively impact performance?


Options are :

  • the creation of a Reference Indexsubtable
  • the need for Referential Integrity to create an error table
  • the need for the existence of a referenced table at the time Referential Integrity is defined (Correct)
  • the requirement for the referenced column to be uniquely indexed

Answer : the need for the existence of a referenced table at the time Referential Integrity is defined

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two Teradata features can be used to control password expiration? (Choose two.)


Options are :

  • security roles (Correct)
  • access rights (Correct)
  • settings inDBC.SysSecDefaults
  • user profiles

Answer : security roles access rights

Which statement is true about exporting data in a Teradata environment?


Options are :

  • FastExport can automatically export data in CSV format.
  • It is better to use a single session to do an export in BTEQ when doing a full table scan.
  • SQL Assistant cannot be used to export data. (Correct)
  • ANSI session mode improves BTEQ export performance.

Answer : SQL Assistant cannot be used to export data.

A securities application receives data from two main sources. One source is loaded daily into the CUSTOMER table (with primary index of CUSTOMER ID) while the other source is loaded on an hourly basis into the SECURITIES table (with primary index of SECURITY_ID) which contains CUSTOMER_ID and information about the securities owned. The tables are joined together for many queries by CUSTOMER ID in order to provide a snapshot of the securities the customer currently owns. Many reports query the data specifying a particular CUSTOMER_ID. The business intelligence data architect wants to change the data model to combine the two tables into a single table, apply compression to the CUSTOMER data, then drop the two original tables. Which statement is true about the potential change to the data model?


Options are :

  • Compression of the redundant CUSTOMER data will improve access to data.
  • The ETL processing changes that are required will significantly impact row retrieval because of lock contention.
  • Access to the SECURITIES data will be improved.
  • Updates to the compressed CUSTOMER data can lock the table for a significant period of time while the row updates are completed. (Correct)

Answer : Updates to the compressed CUSTOMER data can lock the table for a significant period of time while the row updates are completed.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

A system is equally shared between a set of tactical, active queries and the ad hoc user community. No workload management policies have been established. An increase in ad hoc users is anticipated over the next quarter which greatly concerns the owner of the tactical application. The database administrator is beginning to research which workload management options could be selected to allow the workloads to coexist and reduce the contention between active and ad hoc queries. Which input should the database administrator request?


Options are :

  • the number of database locks held by the ad hoc users during a peak utilization window
  • the maximum number of AWTs in use during the last month
  • the amount of spool space concurrently used by ad hoc users
  • the number of ad hoc queries submitted during the last month (Correct)

Answer : the number of ad hoc queries submitted during the last month

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions