TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 1

Which benefit does data oriented metadata provide to business organizations when researching data elements in master data for ad hoc reporting?


Options are :

  • fewer IT related problems (Correct)
  • improved system performance
  • reduced redundant data
  • improved business decision making

Answer : fewer IT related problems

A customer has a requirement to load a high volume of data with limited session availability from a single message queue into a Sales table that is part of an active data warehouse. The Sales table has only NUSIs defined. The data latency requirements are approximately 20 minutes. What is the most effective approach to supporting this requirement?


Options are :

  • UseTPump to continuously read from the queue and insert the data
  • UseFastLoad to load the data into a staging table and then use SQL MERGE.
  • UseMultiLoad to insert the data from the file.
  • UseTPump to insert the data from the file. (Correct)

Answer : UseTPump to insert the data from the file.

A system has traditionally been used for ad hoc queries and now an active workload is being added to the operational requirements. Which two factors should be considered as part of building a workload management policy? (Choose two.)


Options are :

  • AWT availability
  • perm space availability
  • I/O counts
  • ad hoc query complexity (Correct)
  • row counts (Correct)

Answer : ad hoc query complexity row counts

Which two statements are true of ownership access rights? (Choose two.)


Options are :

  • They are explicit. (Correct)
  • They are implicit (Correct)
  • They provide the CREATE access right.
  • Ownership rights are granted to parents of the owner.

Answer : They are explicit. They are implicit

Which two characteristics are the most useful for developing a good physical design? (Choose two.)


Options are :

  • identification of constraint requirements (Correct)
  • columns used in a GROUP BY (Correct)
  • data volatility
  • columns on which to collect statistics

Answer : identification of constraint requirements columns used in a GROUP BY

Which three benefits are likely to be gained by an effective data governance approach within an expanding data warehouse environment? (Choose three.)


Options are :

  • It aligns priorities and resources with business strategy and needs. (Correct)
  • It allows users to leverage the data to its potential. (Correct)
  • It permits the business units to take more responsibility for their own BI requirements. (Correct)
  • It assigns metadata maintenance to the EDW group.
  • . It paves the way for users to trust and value the corporate data.

Answer : It aligns priorities and resources with business strategy and needs. It allows users to leverage the data to its potential. It permits the business units to take more responsibility for their own BI requirements.

A system supports a mixed workload environment with Service Level Goals (SLGs) on the high priority workloads that must be maintained. Lower priority workloads do not have any service level requirements. Which workload management rule can be implemented with a system event definition to maintain the high priority service levels?


Options are :

  • Activate a global exception rule to abort any low priority queries (Correct)
  • Activate a local exception rule to limit the number of low priority queries.
  • Activate workload query limits to reduce the number of concurrent queries in the lower priority workloads.
  • Activate the AWT reserve pool for the high priority queries.

Answer : Activate a global exception rule to abort any low priority queries

An application, for which there is only 18 months of data, is moving into production and will eventually contain ten years of data. The table is loaded monthly and access is ad hoc DSS with heavy reporting being performed. Which two concerns may become the most critical with the increase of data in production? (Choose two.)


Options are :

  • spool usage
  • number of users (Correct)
  • data skew
  • CPU usage (Correct)

Answer : number of users CPU usage

A MultiLoad job is processing against several tables. The MultiLoad job is running on a non-TPA node and the entire cabinet fails. The Teradata Database restarts and the administrator must manually restart the MultiLoad job on a non-TPA node in a different cabinet. Which three items are true about recovering this MultiLoad job? (Choose three.)


Options are :

  • If the job was stopped during the application phase, the job must be restarted and allowed to run to completion. (Correct)
  • If any work or error tables are missing or corrupted whenMultiLoad is restarted, MultiLoad aborts the restart attempt with an error message. (Correct)
  • f any of the target tables are missing or corrupted whenMultiLoad is restarted, drop only the target tables and restore them from the backup files and restart the job. (Correct)
  • If the job was stopped during the acquisition phase and new data is added to the data file before restartingMultiLoad, MultiLoad recognizes that the new data is not valid and will abort.

Answer : If the job was stopped during the application phase, the job must be restarted and allowed to run to completion. If any work or error tables are missing or corrupted whenMultiLoad is restarted, MultiLoad aborts the restart attempt with an error message. f any of the target tables are missing or corrupted whenMultiLoad is restarted, drop only the target tables and restore them from the backup files and restart the job.

Which two Teradata features can be used to control a batch application userid which should be used only from a specific server (i.e., a load server)? (Choose two.)


Options are :

  • TDWM
  • user profiles
  • GRANT/REVOKE LOGON (Correct)
  • Teradata Gateway IP restrictions (Correct)

Answer : GRANT/REVOKE LOGON Teradata Gateway IP restrictions

How many AMPs in a cluster provide maximum protection against system loss?


Options are :

  • 8
  • 4 (Correct)
  • 16
  • 2

Answer : 4

A system currently has eight nodes with four nodes per clique. The applications on the system are used in support of front office applications. Degraded performance due to failed nodes is unacceptable. The current upgrade proposal adds a two node clique. What should be included with that upgrade to improve performance during node outages in that new two node clique?


Options are :

  • a hot standby clique
  • AutomaticVProc Migration (AVM) (Correct)
  • a hot standby node
  • a hot standby AMP

Answer : AutomaticVProc Migration (AVM)

An international shipping company has shipments that move between countries. The natural key consists of three columns (orig, bill nbr, dest), two components (orig and dest) may be null on events. Events with different orig and/or dest but the same bill_nbr can be matched to a shipment. Two event types will change the shipment date. bill nbr should not repeat within a 13 month period, but investigation of the data has shown that it will be recycled sooner. Duplicate bill_nbr values eventually are corrected. Which type of primary index should be implemented?


Options are :

  • Natural key (bill_nbr , orig, dest) as a NUPI
  • bill_nbr as a NUPI (Correct)
  • Concatenated (bill_nbr, orig, dest) as a NUPI
  • surrogate key

Answer : bill_nbr as a NUPI

An active application is used by front-office representatives. The application is intended to be available 7 x 24 with no outages. Which database architecture offers the highest availability with the least performance impact in case of an outage?


Options are :

  • dual systems
  • hot standby nodes (Correct)
  • fallback
  • large cliques

Answer : hot standby nodes

Which method should be used to tell when a user was denied access to a specific data object?


Options are :

  • queryDBC.AccessRights
  • queryDBC.AccessLog
  • queryDBC.EventLog
  • queryDBC.LogOnOff (Correct)

Answer : queryDBC.LogOnOff

What is an expected benefit of an effective data governance practice in an EDW environment?


Options are :

  • Master Data Management will be employed to integrate disparate master data.
  • Fewer data owners will be required. (Correct)
  • Metadata requirements will be simplified.
  • Effective indexing schemes will be implemented.

Answer : Fewer data owners will be required.

A TPump job is processing against several tables in an active data warehouse environment. A database restart occurs and a node remains down. If the TPump job has processed the END LOAD statement in the script, which three statements are true about how the TPump job recovers from a database restart? (Choose three.)


Options are :

  • If the restart log is missing,TPump starts recovery from the beginning of the job
  • During the recovery processTPump uses table locks until recovery is complete (Correct)
  • If theTPump macros are missing, TPump will automatically recreate the macros from the DML statements as part of the recovery process. (Correct)
  • The restart log table has information that allowsTPump to determine if an IMPORT has completed or not completed. (Correct)

Answer : During the recovery processTPump uses table locks until recovery is complete If theTPump macros are missing, TPump will automatically recreate the macros from the DML statements as part of the recovery process. The restart log table has information that allowsTPump to determine if an IMPORT has completed or not completed.

A company has two tactical workloads in production where tables are continuously loaded using TPump. The first tactical workload is a mix of single-AMP queries (80%) and all-AMP queries (20%). The second tactical workload is composed of only single-AMP queries. Hundreds of thousands of these queries run each day. The arrival rates are consistent across the day. They also have a low priority workload with varying arrival rates. At times, CPU usage will register 100%. What can be done to maintain consistency of all the workloads?


Options are :

  • Set a CPU limit at the system level. (Correct)
  • Use the step time threshold option to split out single-AMP and all-AMP queries.
  • Use CPU limits along with query limits on the low priority workload.
  • Use a global exception to delay low priority queries when CPU usage exceeds 90%.

Answer : Set a CPU limit at the system level.

The high water mark for concurrency for a tactical application started at 10 queries per node per second when the application was first introduced. Due to the success of this application, it is expected that concurrency will increase over the next month up as high as 250 queries per node per second at peak processing time. The application is a mix of 70% single-AMP queries and 30% all-AMP queries, and all the queries make use of parameterized SQL and cached plans. Which optimization technique will create a more stable overall response time for these tactical queries in the face of increasing concurrency?


Options are :

  • SetDBSControl DisablePeekUsing = TRUE to make better use of generic cached plans for the single-AMP tactical queries. (Correct)
  • Re-engineer the application to use stored procedures instead of macros.
  • Add database structures or change the application to convert all-AMP queries to singleAMP queries.
  • Redesign the application to take advantage of multi-statement requests.

Answer : SetDBSControl DisablePeekUsing = TRUE to make better use of generic cached plans for the single-AMP tactical queries.

A system is being upgraded to a new release of database software and the marketing department is concerned that the query performance of their tactical product management application will suffer after the upgrade. The testing coordinator has attempted to address their concerns by suggesting a subset of queries to run before and after the upgrade to estimate performance. Which tool would allow the database administrator to determine if any change in query performance has occurred?


Options are :

  • Teradata System Emulation Tool
  • Teradata Visual Explain
  • Teradata Index Wizard
  • Teradata Query Analyzer (Correct)

Answer : Teradata Query Analyzer

Which benefit does event based metadata captured for data integration processes provide for IT organizations?


Options are :

  • reduces ETL-related problems
  • improves decision making (Correct)
  • reduces redundant data
  • improves ability to deliver business value quickly

Answer : improves decision making

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 Filter in TDWM to better manage the resources. Which two options are available for building the filter? (Choose two.)


Options are :

  • No Aggregate Functions Allowed
  • Maximum Processing Time
  • Index Scan Types Allowed (Correct)
  • Restricted Table Joins (Correct)

Answer : Index Scan Types Allowed Restricted Table Joins

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


Options are :

  • IF ERRORCODE<>0 .THEN QUIT 65; will provide a meaningful return code to the program that executed the utility script. (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 load statistics. (Correct)
  • Predefined system variables, prefixed with &SYS, are used to capture load statistics and can be used to determine if the process ran successfully.
  • Notify Exit routines specify a predefined action to be performed whenever a failure occurs in the utility. The action only handles return codes.

Answer : IF ERRORCODE<>0 .THEN QUIT 65; will provide a meaningful return code to the program that executed the utility script. Notify Exit routines specify a predefined action to be performed whenever a failure occurs in the utility. The action can handle return codes and load statistics.

Given an LDM, which three need to be added in order to provide an extended LDM that helps in determining an appropriate primary index assignment? (Choose three.)


Options are :

  • maximum number of rows for a value (Correct)
  • join access frequency
  • columns used for Referential Integrity enforcement (Correct)
  • volatility
  • minimum number of rows for a value (Correct)

Answer : maximum number of rows for a value columns used for Referential Integrity enforcement minimum number of rows for a value

An existing personnel application is utilizing 300 GB spread out over five base tables as follows. The OURGUYS table is 50 GB containing employee data. The LEARNING table is 150 GB containing the training records for all employees. The STAFFING table is 50 GB containing data on prospective new employees. The VENDORS table is 40 GB containing data on contractors. The HIERARCHY table is 10 GB containing both financial and organization hierarchies. The training department is launching a new course that all employees will need to complete which will increase the training records by 20%. The database administrator is working on compressing the data within the application and estimates that 40% compression will be achieved across all employee tables. What would be the space estimate for the personnel application after the changes?


Options are :

  • 230 GB (Correct)
  • 198 GB
  • 218 GB
  • 180 GB

Answer : 230 GB

An application stores transactional history for 48 months. After 48 months, the administrative staff is given the responsibility each month to archive one month of data with the expectation that this data will be restorable for an additional 10 years. Which strategy is the most optimal?


Options are :

  • Use the Archive/Restore Utility to archive the monthly data.
  • Create separate tables for each month and UNION the tables together for application use. (Correct)
  • FastExport each month to a client file and archive the file.
  • Move the monthly data to a separate table and use the Archive/Restore Utility to archive the data.

Answer : Create separate tables for each month and UNION the tables together for application use.

A system is failing to meet Service Level Agreement (SLA) goals due to users submitting badly formed queries with product joins. What can be done through workload management to catch and manage those queries?


Options are :

  • Define an environment event. (Correct)
  • Define a throttle rule.
  • Define a state matrix.
  • Define a filter rule.

Answer : Define an environment event.

Given an existing eight-node system with two four node cliques, a system expansion is installed to add a two node clique with a hot standby node. Which statement is true of the hot standby node in the two node clique?


Options are :

  • During node failure the hot standby node receives migratingVProcs from the failing node, maintaining the service level of the system. (Correct)
  • The hot standby node has to be at the same hardware level as the other nodes in the clique.
  • The hot standby node has access to all the data in the system.
  • The hot standby node has access to all the data in the two node clique.

Answer : During node failure the hot standby node receives migratingVProcs from the failing node, maintaining the service level of the system.

Which two statements are true for a table with Batch RI? (Choose two.)


Options are :

  • It allows more efficient streaming loads than with Standard RI. (Correct)
  • The table may be loaded usingMultiLoad. (Correct)
  • Performance of the MERGE feature is more efficient than with Standard RI.
  • It can provide the Optimizer with an opportunity to avoid performing joins.

Answer : It allows more efficient streaming loads than with Standard RI. The table may be loaded usingMultiLoad.

Which two primary benefits are provided by the data steward function of data governance? (Choose two.)


Options are :

  • the function helps manage database space
  • the function operates as liaisons between IT purchasing and BI vendors (Correct)
  • the function helps manage technical metadata and physical attributes (Correct)
  • the function operates as liaisons between IT and Business to resolve data quality issues

Answer : the function operates as liaisons between IT purchasing and BI vendors the function helps manage technical metadata and physical attributes

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions