EMT Practice Test

1. Question Content...

---

Question1: Which QueryGrid connector can only be a target?

Question2: What is a use case for Data Mover?

Question3: The Administrator is receiving complaints that a business application is taking a very long time to refresh the screen. After analyzing the WD-Report workload, the Administrator notices that several short select statements, with estimated processing time of less than 0.5 seconds, are waiting in the delay queue. The workload WD-Report is placed in Time Share Medium and managed by TIWM.
How should the Administrator solve this performance issue?

Question4: Which table identifies whether a particular workload is suffering from a shortage of AMP Worker Tasks?

Question5: An Administrator notices that a system appears to be near capacity and needs to get information about Input/Output Token Allocations (IOTA) for each workload.
How can this information be obtained?

Question6: Which workload management technique should the Administrator use to reject all QueryGrid queries during a pre-defined critical batch state?

Question7: Which statement accurately characterizes privileges?

Question8: The Administrator has just created a new database object on a Vantage system.
Which privilege is NOT automatically granted to that database on itself?

Question9: An application is consuming very high I/O on Teradata Vantage. The Administrator has been asked to identify the queries that are consuming more than 100 million IOs and are suspected of completing Full Table Scans or Large Redistribution.
Which metrics should be examined for high values to identify the queries?

Question10: BATCH_USER submits stored procedures, utility jobs, and other requests. All BATCH_USER work classifies into workload WD-Batch based on username criterion.
System performance has slowed due to AWT exhaustion during the batch window. The Administrator determined the AWT exhaustion is due to high concurrency of stored procedure calls from BATCH_USER.
How can the Administrator effectively throttle these stored procedures?

Question11: A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries.
Which action should be taken by the Administrator to assist this client?

Question12: On a Vantage system, the data load process has recently become much slower than normal and is now running for two hours in low concurrency. During the time the process is running, the Administrator measured the following average values from ResUsage:
System CPU busy = 75%
WIO = 25%
Inter-AMP parallelism = 90%
Average BYNET usage = 10%
Which resource is most constrained?

Question13: An Administrator manages a Vantage system that experiences large loads and updates during the night, on weekdays. On Saturday night, significant analytical processing occurs using the data from the prior weeks. The results of this processing are saved to support rapid reporting in the following week.
The business requires this Vantage system to be available as soon as possible in case of a catastrophic system failure.
Which backup strategy meets this need?

Question14: An Administrator needs to provide end users access to data in a Native Object Store using shared credentials.
How can this be accomplished?

Question15: How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?

Question16: An Administrator needs to restrict developers from accessing the Vantage system during the night, between 11:00PM and 05:00AM, but they are permitted to have limited access during the rest of the day.
How should the Administrator accomplish this goal?

Question17: A Vantage customer is using the Hive Connector in QueryGrid to access a foreign server and push the processing onto the Hadoop Cluster. The Vantage Administrator is concerned about the performance implication of the temporary space that is consumed by these queries during execution.
What must the Vantage Administrator investigate?

Question18: An Administrator has been presented with these performance metrics from the DBQLOGTBL table for four queries:

The Administrator needs to identify which query is suspected to be causing a full table scan or large redistribution.
Which query is producing this result?

Question19: A system in Viewpoint is regularly reported as being in a critical state due to a lack of available AWT. No flow control is observed on the system. The Administrator identified that this is due to a recently completed cloud migration for the system that increased the number of available AWT from 80 to 120.
Which process task is required to set up the system in Viewpoint to address this problem?

Question20: An Administrator has set up security constraints on columns holding sensitive data through the use of profiles. A user, with an appropriate profile, then issues a select against this sensitive data.
Which type of privilege is being used?

Question21: An Administrator has been given a task to generate a list of users who have not changed their password in the last 90 days.
Which DBC view should be used to generate this list?

Question22: Which portlets contain detailed information about QueryGrid requests?

Question23: An Administrator wants to see the list of foreign servers and their parameters in a Teradata QueryGrid configuration for a Vantage system.
Which database shows this information?

Question24: What is the maximum payload size for CSV and JSON data formats that the NOS_READ function can read, when it is based on the LATIN character set?

Question25: An update of a very large table was in progress when the system experienced an unplanned restart. After restarting, the system is available, but Recovery Manager shows it may be many hours before a large table is available for use. The Administrator needs to make the table available sooner.
Which option should be used to achieve this goal?

Question26: Which description accurately characterizes the use of external authentication for Vantage?

Question27: Which data type could support an index definition on a table?

Question28: A capacity planner wants to keep a record of the number of rows that are added and deleted from certain tables over time and would like to obtain this information without having to change the application itself.
Which DBQL option should be enabled?

Question29: Which view contains privilege checks for user requests?

Question30: Which privilege category is granted to a user on a newly created object?

Question31: An Administrator is configuring an alert service on a Vantage system and must define threshold levels and triggers for the alerts.
Match the Administrator's portlet to the correct use definition.
(Each answer is used once.)

Question32: A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has failed and requires urgent investigation.
Which Viewpoint portlet should be used to initially investigate the reason for this problem?
A group of batch queries that rely on QueryGrid to source data from a cloud Vantage system has failed and requires urgent investigation.
Which Viewpoint portlet should be used to initially investigate the reason for this problem?

Question33: An Administrator is working through a set of tasks to set up a new Vantage system. The current task is to set up alerts to trigger BTEQ scripts to run when certain conditions are met.
Which action should an Administrator take?