Tera Data Interview Questions and Answers
Question - 51 : - How can bottlenecks be identified?
Answer - 51 : -
There are basically four ways of identifying a bottleneck. These are: –
- Teradata Visual Explain
- Explain Request Modifier
- Teradata Manager
- Performance Monitor
Question - 52 : - In BTEQ, how are the session-mode parameters being set?
Answer - 52 : -
- .set session transaction BTET -> Teradata transaction mode
- .set session transaction ANSI -> ANSI mode
- These commands will work only when they are entered before logging into the session.
Question - 53 : - Highlight the limitations of TPUMP Utility.
Answer - 53 : -
Following are the limitations of TPUMP utility: –
- We cannot use SELECT statement.
- Data Files cannot be concatenated.
- Aggregate and Exponential operators are not supported.
- Arithmetic functions cannot be supported.
Question - 54 : - Name the five phases that come under MultiLoad Utility.
Answer - 54 : -
Preliminary Phase, DML Phase, Data Acquisition Phase, Application Phase and End Phase.
Question - 55 : - Highlight all the modes that are present under Confidence Level.
Answer - 55 : -
Low, No, High and Join are the four modes that are present under Confidence Level.
Question - 56 : - What is meant by a Highest Cost Plan?
Answer - 56 : -
As per Highest Cost Plan, the time taken to execute the process is more, and it takes the longest path available.
Question - 57 : - What is the true purpose of a Dispatcher in Teradata according to you?
Answer - 57 : -
Well, it is capable to be considered for performing multiple tasks. However, it is widely considered as best for taking and storing the requests in a queue. It can help in storing a very large number of requests in a defined manner. The multiple sets of responses can easily be created after this and the users can save time and effort both.
Question - 58 : - Name any two common ETL tools that you can use in the Teradata?
Answer - 58 : -
The two common ETL tools are Informatica and DataStage.
Question - 59 : - Is it possible to bypass or to send the Teradata jobs in the Unix Environment simply?
Answer - 59 : -
Yes, the same is possible and the users are free to do the same provided some basic conditions are fulfilled by them. This can be done by performing execution in UNIX.
Question - 60 : - Why managing the data is important
Answer - 60 : -
Well, data is the real source of deriving useful information and without data, many important tasks such as business management, decision making, problem formulation, and many other tasks that are useful cannot be accomplished easily. When the same is not managed, there are strong chances that the user will get errors in all of the above tasks. A well-managed data always enable users to save time and to locate things easily. There are a lot of other reasons as well due to which data management is important.