TE0-126 Teradata 12 Enterprise Architecture Practice Exam Set 5

An application is implemented on a 200-AMP system. The query mix consists of 60% single-AMP queries and 40% all-AMP queries. The all-AMP queries utilize a NUSI which returns an average of three rows. This application has a high volume of tactical queries and all the queries make use of parameterized SQL and cached plans. Which optimization technique will improve the overall response time for these tactical queries?


Options are :

  • Redesign the application to take advantage of multi-statement requests (Correct)
  • Consider breaking the query into several smaller requests and encapsulating the SQL in a stored procedure.
  • Create a sparse join index for the common NUSI values.
  • Create a global join index to replace the NUSI.

Answer : Redesign the application to take advantage of multi-statement requests

A system is running at maximum CPU utilization. The database administrator believes that terminating badly written queries will reduce wasted system resources. Which metric can be collected that would improve available system resources when acted upon by workload management?


Options are :

  • the number of CPUs in the total system
  • the average number of processes in the lock queue
  • the number of concurrent jobs running (Correct)
  • the quantity of CPU seconds consumed by badly skewed queries

Answer : the number of concurrent jobs running

A system operates multiple applications. One application is exceeding its performance forecast. The performance forecast estimates CPU and I/O for the previous 12 months and for the next 12 months. Which two data sources should be used to isolate application performance? (Choose two.)


Options are :

  • ResCPUUsageByAMPView (Correct)
  • DBQL
  • ResGeneralInfoView (Correct)
  • AMPUsage

Answer : ResCPUUsageByAMPView ResGeneralInfoView

Given the following Service Level Agreements (SLAs) in a mixed workload environment: ?Data from batch processes will be available at 8AM ?Report/ad hoc individual requests will be no more than 60 seconds ?Data latency for continuous loads will be no more than three minutes ?Tactical requests will be no more than three seconds What could degrade TPump performance if it is used for continuous loading (inserts and updates)? (Choose two.)


Options are :

  • MLPPI where the higher partition level has fewer partitions than the lower partition level
  • access logging
  • index maintenance on join and secondary indexes (Correct)
  • use of macros to load data (Correct)

Answer : index maintenance on join and secondary indexes use of macros to load data

What can be done to ensure that personal data is accessible only to authorized users?


Options are :

  • Document the personal data in a data privacy catalog for protection and compliance management.
  • Utilize theanonymization feature to disconnect data from the person to whom it relates. (Correct)
  • Mask the data during the loading process.
  • Use conditional logic to mask the data from unauthorized users.

Answer : Utilize theanonymization feature to disconnect data from the person to whom it relates.

An administrator who administers a Teradata on Linux system runs the following command: csp - mode save -target table -force The CSP program appeared to complete, but it was later determined that the crashdump was incomplete. What would explain why the crashdump was incomplete?


Options are :

  • There was insufficient spool space for database CRASHDUMPS. (Correct)
  • There was insufficient perm space for DBC.
  • The keyword 'dump' was left off the switch -force.
  • There was insufficient perm space for database CRASHDUMPS.

Answer : There was insufficient spool space for database CRASHDUMPS.

Which two statements are true when considering a data mart solution? (Choose two.)


Options are :

  • The data is required to be consistent with the data in the data warehouse.
  • The data is a subset of the organization's data. (Correct)
  • The data is used by individual departments or groups of users.
  • The data is a complete picture of the organization. (Correct)

Answer : The data is a subset of the organization's data. The data is a complete picture of the organization.

An active application is used by front-office customer interactions. The application availability does not directly impact the interactions with customers and can therefore suffer infrequent, short outages of 10 minutes or less. The system normally needs 100% of available resources. Which hardware feature should be considered?


Options are :

  • large cliques (Correct)
  • hot standby nodes
  • fallback
  • RAID 1

Answer : large cliques

A system is I/O-bound. A large extract job that runs every afternoon at 2 PM has been identified as a contributor to the I/O problem. Which action can be taken to minimize the impact on other workloads?


Options are :

  • Use Multi-Value Compression (MVC) to reduce row size.
  • Implement a filter to reschedule the extract job to off hours.
  • Reduce the datablocksize to limit the amount of data per I/O.
  • Assign the extract job to a workload with a lower priority. (Correct)

Answer : Assign the extract job to a workload with a lower priority.

A new Teradata customer is planning to merge all of the data from their applications into an integrated EDW with a plan to eliminate existing data marts. Under which circumstances should surrogate keys be assigned in the EDW?


Options are :

  • Natural keys in the application systems are inconsistent.
  • Enterprise masters for product, customer, vendor, employee and account are accessed by the application systems.
  • There are a consistent set of natural keys for similar objects in the application systems but there are overlaps in values.
  • System generated keys exist in the application systems and are used in queries and reports. (Correct)

Answer : System generated keys exist in the application systems and are used in queries and reports.

An existing application is evolving from overnight loading to near real-time updating. The existing hardware platform operates on a single-node server. Which two configuration changes could improve availability? (Choose two.)


Options are :

  • add a hot standby node
  • add nodes (Correct)
  • convert to a faster 64-bit system
  • add a hot standby clique (Correct)

Answer : add nodes add a hot standby clique

What are two ways a good Physical Data Model (PDM) will facilitate performance for tactical queries? (Choose two.)


Options are :

  • It avoids join indexes on the tables. (Correct)
  • It maximizes the use of single-AMP operations.
  • It uses NUSI access where possible to avoid Full Table Scans (FTS).
  • It defines business metrics. (Correct)

Answer : It avoids join indexes on the tables. It defines business metrics.

An existing system has the following characteristics: ?UNIX MP-RAS 10-node system with Teradata 12.0 ?4 GB of memory per node ?160 AMPs ?20 TB of CurrentPerm; 30 TB of MaxPerm The customer wishes to upgrade to Linux that will hold the same amount of data and have similar performance. What two factors must be considered when upgrading the system to Linux? (Choose two.)


Options are :

  • The Linux nodes will require more memory than the MP-RAS nodes. (Correct)
  • The existing data will use more permanent space on the Linux system
  • The Linux system will require fewer nodes for the same number of AMPs (Correct)
  • The Linux system will require hot standby nodes.

Answer : The Linux nodes will require more memory than the MP-RAS nodes. The Linux system will require fewer nodes for the same number of AMPs

Which three tasks are important in performing housekeeping and database maintenance? (Choose three.)


Options are :

  • Clean out frequently updated dictionary tables. (Correct)
  • ResetPeakSpool space utilization. (Correct)
  • Execute aminicylpack operation. (Correct)
  • Refresh stale collected statistics.

Answer : Clean out frequently updated dictionary tables. ResetPeakSpool space utilization. Execute aminicylpack operation.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions