TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 2

Which two benefits does Master Data Management provide to business agility? (Choose two.)


Options are :

  • common understanding reduces new application development timelines
  • manages the multiple definitions for key data entities
  • increased IT ability to adapt to, and to enable, rapid business change (Correct)
  • allows for operational metadata to be maintained (Correct)

Answer : increased IT ability to adapt to, and to enable, rapid business change allows for operational metadata to be maintained

Which two connectivity protocols are designed for network attachment? (Choose two.)


Options are :

  • .NET
  • CLIv2 (Correct)
  • COP
  • TDP (Correct)

Answer : CLIv2 TDP

A marketing application is being developed which will utilize event-based active warehouse features, including a trigger on all rows being inserted into a transaction table, in order to issue coupons to customers who purchase various products. The application has passed user acceptance in the testing environment with an initial set of 20 queries and is about to enter into production. Which performance criteria will be most critical to the application?


Options are :

  • query skewing
  • data skewing (Correct)
  • query concurrency
  • space utilization

Answer : data skewing

What are two drawbacks of a physical design process using the 3NF LDM as one of the inputs into developing a PDM? (Choose two.)


Options are :

  • increased number of fact tables
  • decreased performance in loads (Correct)
  • an increased number of redistributions for large tables in joins
  • a request can exceed the maximum number of joins (Correct)

Answer : decreased performance in loads a request can exceed the maximum number of joins

An administrator is saving a crashdump to the database by running CSP. Which three factors will impact the time it will take to save the crashdump to the database? (Choose three.)


Options are :

  • the current system load (Correct)
  • the fragmentation level of the disks
  • frequent deadlocks
  • the number of loader slots that are available (Correct)
  • a large update query is rolling back (Correct)

Answer : the current system load the number of loader slots that are available a large update query is rolling back

An active application is leveraging a dual-active system that is being updated in near realtime. Which component is required to support mission critical tactical queries?


Options are :

  • Teradata Query Director
  • Teradata Director Program (Correct)
  • Teradata Query Scheduler
  • Teradata Replication Server

Answer : Teradata Director Program

A sales reporting application has a set of four base tables that are heavily accessed by the Product Management group through three sets of views. The base tables include a 200 million row ORDER table, a CUSTOMER table, and two small reference tables that contain data about the company's PRODUCT_IDs and its internal SALES_ORGANIZATION. On top of the base tables, there is set of security views which limit access to base table rows based on the SALES_ORGANIZATION of the person submitting the query. On top of the security views, there is a set of privacy views which mask the personally identifiable information of the CUSTOMER through CASE logic based on the user's role or department. On top of the privacy views, there is a set of application views which combine all three of the CUSTOMER, ORDER, and PRODUCT views to allow the users to view orders by customer, month, or product. An application developer is recommending the denormalization of the privacy and security view layers into the application layer to reduce the number of database objects that are referenced in the queries. Which statement is true about eliminating these view layers from the database architecture while maintaining the necessary data protection?


Options are :

  • The reduction in the number of database objects will dramatically improve application performance because nested views will be eliminated.
  • The number of application views will increase to incorporate all potential combinations of security and privacy protection that need to be employed. (Correct)
  • The application views will be more complex negating any potential benefit from the reduction in database objects.
  • The application view layer change will necessitate indexing changes at the table level to assure the most optimal data access path.

Answer : The number of application views will increase to incorporate all potential combinations of security and privacy protection that need to be employed.

An administrator is asked to keep a daily backup of an application database. Updates are occurring to the tables in the database 24x7. What can be implemented so that a backup window is not needed?


Options are :

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

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

There is a system problem of excess page swapping due to a shortage of free memory. As a result, all queries are experiencing slower response times. Which action can be taken to improve response time?


Options are :

  • Increase the Page Swap percentage.
  • Increase the FSG cache percentage.
  • Decrease the FSG cache percentage.
  • Decrease the Page Swap percentage. (Correct)

Answer : Decrease the Page Swap percentage.

Which are the two most important characteristics for developing a good physical design with large tables when dependable demographics are available? (Choose two.)


Options are :

  • primary index selection based on number of NULLs (Correct)
  • primary index selection based upon join strategies
  • primary index selection based upon the primary key (Correct)
  • secondary index selection based on value access

Answer : primary index selection based on number of NULLs primary index selection based upon the primary key

An extended LDM needs to be updated to document the rationale for NUSI choices. Which two are more helpful for providing information about this rationale? (Choose two.)


Options are :

  • typical number of rows per value
  • number of non-nulls (Correct)
  • columns used for join access
  • columns used for value access (Correct)

Answer : number of non-nulls columns used for value access

A site has a very large order table consisting of 100 million rows and an order detail table consisting of 10 billion rows. There is a requirement to report the total of each order with an access frequency of 100 queries per hour. What is the most efficient way to report the order total?


Options are :

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

Answer : Store the total of each order in the order table.

Which method would be the quickest for migrating data from one very large table on a Teradata system to an empty table on another Teradata system?


Options are :

  • FastExport / FastLoad
  • FastExport / TPump (Correct)
  • FastExport / MultiLoad
  • BTEQ Export / Import

Answer : FastExport / TPump

Which two benefits does Master Data Management provide to IT productivity? (Choose two.)


Options are :

  • ability to adapt to change (Correct)
  • streamlined data processes
  • more and better decisions (Correct)
  • eliminates need for metadata

Answer : ability to adapt to change more and better decisions

Which utilities would move a large number of rows from one system directly into a large populated table on another system in the shortest amount of time?


Options are :

  • FastExport / FastLoad
  • ARC Archive / Copy
  • FastExport / MultiLoad
  • FastExport / TPump (Correct)

Answer : FastExport / TPump

A new production system was developed and deployed with two non-TPA nodes. The customer decides to implement a test environment on the production system. The production system is running out of perm space. Which two activities will enable a test environment to be built on the production system? (Choose two.)


Options are :

  • Create the test environment on the non-TPA nodes. (Correct)
  • Apply multi-value compression to test and production data. (Correct)
  • Denormalize the production application to save space.
  • Populate test tables with a percentage of production data.

Answer : Create the test environment on the non-TPA nodes. Apply multi-value compression to test and production data.

Which version of client tools is supported with a given database version and how are those versions determined?


Options are :

  • The previous version client tools are designed and tested to work with the current database version. (Correct)
  • Ensure client and database versions are compatible by running the client tools on nonTPA nodes.
  • Supportability is determined by installing the client tool version and running acceptance testing.
  • The Client Capability Matrix defines the supported mix of database and client versions.

Answer : The previous version client tools are designed and tested to work with the current database version.

Which two communication protocols can be used by Teradata's SQL Assistant to connect to a Teradata environment? (Choose two.)


Options are :

  • .NET
  • CLI (Correct)
  • SQL*Net
  • ODBC (Correct)

Answer : CLI ODBC

A client securities application queries data from the customer table and calculates a set of complex, aggregate metrics on the analytics server to be used in making credit decisions. These metrics are then loaded back into the database. Initially the application performed well, but as the data levels have grown the calculations on the analytics server have become increasingly slow. Which change to the application architecture might be made to improve the performance of the application?


Options are :

  • Create a set of application views to dynamically calculate the metrics.
  • Create a set of application macros to calculate the metrics and load them into the database.
  • Create an external stored procedure to dynamically calculate the metrics. (Correct)
  • Create a user defined function to calculate the metrics during data loading.

Answer : Create an external stored procedure to dynamically calculate the metrics.

Summary views are part of which database design layer?


Options are :

  • Logical
  • Semantic
  • Summary
  • Physical (Correct)

Answer : Physical

The 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 20% while the new application will add 10% to the overall system size. A data compression project will result in a space recovery of 20% across all applications. Assuming the same access patterns will exist, which statement is true about the changes required to maintain the same system performance after the new applications are placed into production?


Options are :

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

Answer : The hardware configuration does not need to be changed.

An administrator is asked to transfer one database daily from one system to another in another location. This will provide a second copy of the data in case of a disaster. There is network connectivity between the two systems, but no tape drive on the second system. Which approach can accomplish this without having to land the data?


Options are :

  • Copy the data usingArcmain Named Pipes.
  • Archive data to tape then restore via the network to the second system.
  • Copy the data usingTeradata Administrator. (Correct)
  • FastExport the data then FastLoad it to the second system.

Answer : Copy the data usingTeradata Administrator.

A system will be upgraded to add four nodes and the users are interested in learning how much better their queries will run. Which two tools would they use to discover the performance gains? (Choose two.)


Options are :

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

Answer : Teradata System Emulation Tool Teradata Statistics Wizard

The database administrator has applied multi-value compression to a set of heavily accessed tables which reduced CurrentPerm usage by 50%. Almost all of the columns in the largest tables have some level of compression applied. Which statement is true concerning the improvement in system performance that may occur from compression?


Options are :

  • Any compression columns that participate in Referential Integrity relationships must either be compressed on both tables or uncompressed on both tables or a severe CPU and I/O is incurred.
  • Indexsubtables will be smaller because of the compressed bits saving on both CPU and I/O costs. (Correct)
  • The benefit of reducedCurrentPerm must be weighed against the increase in CPU and I/O costs of decompressing the value during row retrieval.
  • Compressed bits are copied into the spool file saving on both CPU and I/O costs.

Answer : Indexsubtables will be smaller because of the compressed bits saving on both CPU and I/O costs.

Given the following: ?The report schedule that was just implemented is taking twice as long as it should. ?A report metric is an SQL statement that determines a specific piece of information. ?Each report has an average of 25 metrics. ?Metrics are shared on hundreds of reports. ?Filters affect the result of a metric. ?If a single run of the metric SumLocLW uses 2,000 CPU seconds, then 1,000 executions of the metric will use 2,000,000 CPU seconds. ?If the SumLocLW metric is tuned to only use 200 CPU seconds, then 1,000 executions of the metric will use 200,000 CPU seconds, hopefully freeing up 1,800,000 CPU seconds to be used by other processes. Which views need to be accessed to identify poorly performing metrics and to determine how much overall CPU will be saved after tuning the metric?


Options are :

  • QrySummary and QryObjects
  • QrySummary and QryLogSQL
  • QryObjects and QryLogSQL (Correct)
  • QryLog and QryLogSQL

Answer : QryObjects and QryLogSQL

An active 7 x 24 application uses active updating and batch processes to modify significant amounts of data across multiple current partitions. The application needs both select and update access to all data in the partitioned detail table. The detail table is partitioned on month. Which technique has minimal impact on the application for archiving and deleting the oldest month while preserving data integrity?


Options are :

  • Use ARC to create a backup copy of the partition and use SQL DELETE to remove the oldest month.
  • UseFastExport to copy the partition to a client file and alter the table to drop the oldest month.
  • Use INSERT SELECT with a READ lock to copy the partition to an empty temporary table, archive the temporarytable, and use alter table to drop the oldest month.
  • Use INSERT SELECT to copy the partition to a temporary table, archive the temporary table, and use SQL DELETE to remove the oldest month. (Correct)

Answer : Use INSERT SELECT to copy the partition to a temporary table, archive the temporary table, and use SQL DELETE to remove the oldest month.

A manager is concerned with the extremely large number of rows in DBC.AccessRights and asks the database administrator to see which options are available to decrease the number of rows. Which three options are available? (Choose three.)


Options are :

  • grant rights at the database level instead of at the table level (Correct)
  • implement roles
  • implement profiles (Correct)
  • run queries to look for orphaned access rights (Correct)

Answer : grant rights at the database level instead of at the table level implement profiles run queries to look for orphaned access rights

Which two statements are true about access rights granted to the creator of an object? (Choose two.)


Options are :

  • The creator always gets ownership access rights.
  • They are implied but there are no rows in access rights. (Correct)
  • They exist in data dictionary tables. (Correct)
  • They are automatically generated.

Answer : They are implied but there are no rows in access rights. They exist in data dictionary tables.

What are two ways a good PDM reduces I/O consumption? (Choose two.)


Options are :

  • maximizes single and group-AMP operations
  • minimizes local spooling (Correct)
  • maximizes efficiency of all-AMP operations
  • maximizes single AMP redistribution and sorting (Correct)

Answer : minimizes local spooling maximizes single AMP redistribution and sorting

A table has two years of call detail data and is partitioned by day. The latest week needs to be archived at the end of the week. The customer continuously inserts new data and needs 24x7 user access to the data except for a yearly maintenance window that can be used for partition maintenance and deleting old data. Which archive strategy best meets the customer's requirements?


Options are :

  • Use ARC's online and partition archive options to save the latest week.
  • INSERT SELECT the latest week to an empty history table and archive the history table.
  • Fast Export the latest week to a data file thenuse ARC to archive the data file.
  • Use ARC's partition archive options to archive the latest week. (Correct)

Answer : Use ARC's partition archive options to archive the latest week.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions