TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 3

Which two benefits does data oriented metadata provide when designing a data warehouse? (Choose two.)


Options are :

  • fewerback up and recovery related problems (Correct)
  • improved system performance
  • reduced redundant data
  • improved ability to deliver business value quickly (Correct)

Answer : fewerback up and recovery related problems improved ability to deliver business value quickly

Two business units have requested their data be loaded and accessible to their end users. They will work with the data modeling team to map the data. Their requirements include having ad hoc access to the data and training their business analysts on the selected end user tool. Which data warehouse implementation supports these requirements?


Options are :

  • Avoid implementation until the business units clarify their reporting requirements.
  • Load the data into a normalized data model, summarize it, and export it to a server. (Correct)
  • Load the data into summarized tables and implement a BI tool that directly accesses the summarized tables.
  • Load the data into a normalized data model and implement a BI tool that directly accesses the relational tables.

Answer : Load the data into a normalized data model, summarize it, and export it to a server.

An analytical application uses session pooling to submit tactical requests. Session pooling hides the identity of the end user and the type of request, making it difficult to manage the requests and meet Service Level Agreements (SLAs). What can be done to identify the tactical requests and classify them into the correct workload?


Options are :

  • Use local exceptions to move the query to the proper workload after it begins execution.
  • UseSessionNo to classify the request.
  • Use filters to classify the request based on resource consumption. (Correct)
  • Use query banding to classify the request.

Answer : Use filters to classify the request based on resource consumption.

TE0-121 12 Teradata Basics Certification Practical Exam Set 3

The current perm usage by database DBC is growing. The administration team notices the growth in ResUsage and DBQL tables. Which practice should be employed to manage growth in these tables?


Options are :

  • Delete theResUsage and DBQL tables.
  • TerminateResUsage and DBQL logging.
  • Extend the logging period onResUsage and restrict DBQL logging to summary logging. (Correct)
  • Move theResUsage tables and DBQL tables to history tables then delete from the ResUsage and DBQL tables.

Answer : Extend the logging period onResUsage and restrict DBQL logging to summary logging.

An insurance company loads data from multiple sources throughout the day with each source having a different time variance. The claims 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 claim to be opened in one location but updated in another. The corporate customer data comes in monthly from one source while the individual customer data comes in weekly from 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 claims 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 claims data
  • the changed data capture strategy for the customer data
  • a set of rules for determining the most authoritative claims source
  • a set of rules for determining the most authoritative customer source (Correct)
  • the frequency of update of the CRM application (Correct)

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

A database administrator is configuring a sandbox environment on a production system. Which two options should be considered? (Choose two.)


Options are :

  • default sandbox tables and databases to FALLBACK
  • remove query limits for the sandbox users (Correct)
  • require account strings, separate users and profiles
  • use roles and views (Correct)

Answer : remove query limits for the sandbox users use roles and views

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which three statements are true about network client connectivity to the Teradata Database? (Choose three.)


Options are :

  • The client must be connected to the AWS to gain access to the database. (Correct)
  • The client must have multiple TCP/IP connections for all-AMP database operations. (Correct)
  • The client must be connected to the same Ethernet LAN as theTeradata Database. (Correct)
  • The client must be connected to a node that is attached to theTeradata Database through the BYNET.

Answer : The client must be connected to the AWS to gain access to the database. The client must have multiple TCP/IP connections for all-AMP database operations. The client must be connected to the same Ethernet LAN as theTeradata Database.

What is considered part of the semantic layer of the data warehouse?


Options are :

  • entities, relationships, and attributes (Correct)
  • analytical business views
  • security tables
  • primary and secondary indexes

Answer : entities, relationships, and attributes

A new web application with a two-second service level goal (SLG) is being added to the workload. The current mixed workload on the platform during the day includes occasional data mining, many BI queries, a large number of business reports, and continuous loading. The CPU usage during the day is generally in the 85% to 95% range. There are occasional rollbacks taking place during the day, and AWT exhaustion is being seen between 10 AM to 3 PM Monday and Wednesday. What provides the most effective additional step to take to ensure the web queries meet their SLGs in addition to giving a high priority to the allocation group used by the web queries?


Options are :

  • Define CPU limits on the non-tactical resource partitions. (Correct)
  • Place utility throttles on continuous load jobs.
  • Reserve AWTs for the tactical resource partition.
  • Reserve AWTs for the web query allocation group.

Answer : Define CPU limits on the non-tactical resource partitions.

TE0-141 14 Teradata Basics Certified Practice Test Set 3

Users are reporting general system slow down but have been vague about specific details such as time frame and activity. Which two dictionary objects may provide insight into the issue at a system level? (Choose two.)


Options are :

  • QryLog
  • ResUsageSawt
  • ResUsageSpma (Correct)
  • SessionInfo (Correct)

Answer : ResUsageSpma SessionInfo

A system has high I/O demand due to the mix of queries that are being executed against a very large partitioned table at a particular time every day. Which action can be taken to reduce the I/O demand?


Options are :

  • Increase the datablocksize for the very large table to reduce the number of I/O.
  • Implement a filter to delay any queries performing Full Table Scans (FTS) against the very large table.
  • Drop any indexes on the very large table to reduce the number of data blocks that need to be read.
  • Change the table to non-partitioned to enable synchronized scanning. (Correct)

Answer : Change the table to non-partitioned to enable synchronized scanning.

An account management application needs to have two additional columns added to the 200 million row TRANS table. The columns will be populated during the launch of a new application feature in two months. An INTEGER column ACC_LEVEL and a DECIMAL(38,2) column CUST_VALUE will need to be added to the table during an application maintenance window. The database administrator would like to add these columns as efficiently as possible and has enough space to create another copy of the table in the database. Which statement is true about the most efficient way to implement these columns in the TRANS table?


Options are :

  • Alter the table and add the columns with compression which will be the most efficient I/O operation.
  • Alter the table and add the additional columns which will result in block and cylinder splits.
  • Create a new table and INSERT SELECT the data from the existing table which will be the most efficient I/O operation but will incur a severe CPU penalty (Correct)
  • Create a new table and INSERT SELECT the data from the existing table which will be the most efficient CPU operation but will incur a severe I/O penalty.

Answer : Create a new table and INSERT SELECT the data from the existing table which will be the most efficient I/O operation but will incur a severe CPU penalty

NR0-015 Teradata Design Architecture V2R5 Practice Test Set 1

A database administrator is asked for a complete list of database logon attempts for the month. The administrator is also asked to generate a list of database logons that failed. Which method should be used to gather the data?


Options are :

  • queryDBC.SessionInfo (Correct)
  • queryDBC.LogOnOff
  • query DBQL data
  • queryDBC.Sessions

Answer : queryDBC.SessionInfo

A user calls the administrator to report that the new system is extremely slow. The administrator investigates and notices an extremely large Transient Journal. Which two reasons might explain the large Transient Journal? (Choose two.)


Options are :

  • AMultiLoad job is loading 100,000,000 rows into a transaction table. (Correct)
  • The WAL log did not purge properly. (Correct)
  • A large number of tactical queries have been submitted, taking up all AWTs.
  • A large table is being duplicated using CREATE TABLE AS.

Answer : AMultiLoad job is loading 100,000,000 rows into a transaction table. The WAL log did not purge properly.

A customer has a requirement to load a high volume of data from a single message queue into a Sales table that is part of an active data warehouse. The Sales table has both NUSIs and Join Indexes. The data latency requirements are less than 15 minutes and the arrival rate into the queue is continuous. What is the most effective approach to supporting this requirement?


Options are :

  • Pull the data from the queue into a file and useMultiLoad to insert the data from the file. (Correct)
  • 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.
  • UseTPump to continuously read from the queue and insert the data.
  • Pull the data from the queue using a CLI program and insert the data.

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

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

An organization is evaluating data integration suites to replace the existing architecture. The old architecture is an ELT strategy, where data files are typically loaded into staging tables, then transformed into the target tables. What are three advantages of changing to an ETL strategy? (Choose three.)


Options are :

  • uses less network bandwidth (Correct)
  • uses less spool space in the database
  • uses less I/O in the database (Correct)
  • uses less CPU on index maintenance (Correct)
  • uses less perm space in the database

Answer : uses less network bandwidth uses less I/O in the database uses less CPU on index maintenance

A retailer would like to ensure that the latest sales data, from all touchpoints, is available in their data warehouse so associates can identify additional opportunities and provide premium customer service. The data needs to be available within 20 minutes of a sales transaction. Both the base transaction table and the join index built upon it have NUPI duplicates being inserted and their primary index columns are different from one other. Which approach should be used for loading the transaction data into the data warehouse?


Options are :

  • TPump without the SERIALIZE option
  • stored procedure fed via replication services
  • directMultiLoad to the target (Correct)
  • periodic batch to staging, then apply with SQL

Answer : directMultiLoad to the target

A strategic application seeks to execute 60 concurrent queries. Currently, the average response time of these queries is 90 seconds and the Service Level Agreement (SLA) is 60 seconds. Which workload management approach can be used to assist in meeting this SLA?


Options are :

  • Decrease the concurrency of any ad hoc users.
  • Increase the number of sessions used by each strategic query
  • Decrease the workload concurrency throttle.
  • Increase the Priority Scheduler weight for strategic queries. (Correct)

Answer : Increase the Priority Scheduler weight for strategic queries.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two workload management techniques should be applied to a sandbox environment on the production system? (Choose two.)


Options are :

  • Remove query limits or throttles from the sandbox resource partition. (Correct)
  • Create a dedicated resource partition or allocation group for sandbox users. (Correct)
  • Place a CPU limit on the sandbox resource partition.
  • Remove CPU limits on the sandbox resource partition during peak hours.

Answer : Remove query limits or throttles from the sandbox resource partition. Create a dedicated resource partition or allocation group for sandbox users.

Which two options provide for system availability? (Choose two.)


Options are :

  • Transient Journal (Correct)
  • fallback
  • RAID 0
  • hot standby nodes (Correct)

Answer : Transient Journal hot standby nodes

Which two benefits does Master Data Management provide in the enterprise intelligence area? (Choose two.)


Options are :

  • increased transactional data delivery rates (Correct)
  • regulatory compliance and risk management (Correct)
  • increased visibility to business issues and results
  • improved data models

Answer : increased transactional data delivery rates regulatory compliance and risk management

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

A number of different departments of a company are being integrated into a warehouse. Each department shares much of the data, but treat the shared data differently. When will this issue get resolved?


Options are :

  • during the logical design
  • during the physical design
  • during application develop (Correct)
  • while loading the data

Answer : during application develop

An event table was created without monthly partitions. Since implementation, the table has grown to an excessive amount of history. The application using this table has evolved into a 24 X 7 active application. The oldest month of data needs to be archived to improve table scan performance. How can a month of history be archived and deleted with minimal impact to the active application?


Options are :

  • Use the ARC utility to archive the month and delete the month with a SQL DELETE request. (Correct)
  • Use the ARC utility to archive the month from the event table then delete the month from the application table using aMultiLoad DELETE task.
  • Issue a BT, INSERT SELECT the event table into a new table minus the month to be deleted, rename both tables, issue the ET,FastExport the month from the old event table, then drop the old event table.
  • INSERT SELECT the month to an empty table, delete the month from the application table, then archive the month table.

Answer : Use the ARC utility to archive the month and delete the month with a SQL DELETE request.

A system is currently consuming all available AWTs causing high priority queries to be placed on the AMP message queue. Which option is available to prevent the high priority queries from being queued?


Options are :

  • Assign the lower priority queries to a workload with an expedited allocation group.
  • Assign the high priority queries to a workload with an allocation group that has a higher weight.
  • Assign the high priority queries to a workload with an expedited allocation group.
  • Assign the lower priority queries to a workload with an allocation group that has a CPU limit. (Correct)

Answer : Assign the lower priority queries to a workload with an allocation group that has a CPU limit.

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

A retailer would like to ensure that the latest sales data is available in their data warehouse so associates can identify additional up-sell opportunities and provide premium customer service. The data needs to be available within five minutes of a sales transaction. Both the base transaction table and the join index built upon it have NUPI duplicates being inserted and their primary index columns are different from one another. Which approach should be used for loading the transaction data into the data warehouse?


Options are :

  • TPump with the SERIALIZE option on
  • directMultiLoad to the target
  • stored procedure fed via replication services
  • periodic batch to staging, then apply with SQL (Correct)

Answer : periodic batch to staging, then apply with SQL

TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 4

Which two can be done to protect confidential data? (Choose two.)


Options are :

  • Use encryption on the data transmitted between theTeradata Database and the application.
  • Use access logging to determine the requesting user, type of access, and the referenced object. (Correct)
  • Use stored procedures to limit the actions the user can take on the table and view columns and rows. (Correct)
  • Use multi-factor authentication to provide strong access control and enhance the safety of data stored in the database.

Answer : Use access logging to determine the requesting user, type of access, and the referenced object. Use stored procedures to limit the actions the user can take on the table and view columns and rows.

A system administrator is asked to look into deterioration of Service Level Agreement (SLA) statistics. Upon researching DBC.ResUsageSawt, non-zero values are discovered in the column FlowControlled. Which action could be done to improve the SLA goals?


Options are :

  • Use views with locking for access. (Correct)
  • Use stored procedures.
  • Use macros.
  • Use concurrency throttles.

Answer : Use views with locking for access.

A new workload management practice is being established without the involvement of application or user communities. What information should the administration teams collect to establish the workload management policy?


Options are :

  • ResUsageSpma
  • DBQL.QryLog
  • AMPUsage (Correct)
  • Metadata services

Answer : AMPUsage

TE0-141 14 Teradata Basics Certified Practice Test Set 2

An administrator is asked to keep a daily backup of a very large transaction table. The table is defined with a PPI with a daily partitioning expression on insert date and the table is insert only. There is not enough of a window to backup the entire table each night. In this situation, which backup strategy is the best approach?


Options are :

  • Implement a cluster backup of the table.
  • Implement an online archive of the table.
  • Implement an all-AMP backup of the table. (Correct)
  • Implement partition backup for the previous day.

Answer : Implement an all-AMP backup of the table.

A mini-batch is being used to transform the data on the database side. What are two advantages of using ELT mini-batches over ETL? (Choose two.)


Options are :

  • Teradata parallelism can help transform the data faster. (Correct)
  • An error table can be created on the target table to trap failures and prevent rollbacks.
  • People can access the data while it's being loaded (Correct)
  • It is safer to transform the data on the database.

Answer : Teradata parallelism can help transform the data faster. People can access the data while it's being loaded

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions