SriniTera

Teradata Architectural Questions  QUESTION No:1 An administrator is trying to manage resources on the system because there is a business critical reporting requirement. The reporting workload starts at 9AM and is required to finish by 10AM. At the same time, ad hoc users are allowed to access the system. The administrator is building a Query Resource Throttle in TDWM to better manage the resources. Which two are available as options for building the throttle? (Choose two.) A. Index Scan Types Allowed B. Throttle All-AMP Queries Only C. No Aggregate Functions Allowed D. Only limit queries with Step Time Threshold Answer: C,D QUESTION NO: 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? A. Implemen...

#Top Teradata Interview Questions and Answers: The teradata interview questions of second set. What is the usage of Fallback? A) When a table is fallback protected the rows are duplicated on other AMPs. Fallback is similar to mirroring, but different. The similarities is that both provide a duplicate copy, but the difference is that Fallback places copies of its rows on multiple AMPs so if a failure occurs Teradata can use the parallelism to help the failed AMP. Teradata+Interview +Questions-Part-1 How many primary keys we will apply on a table? A) Only one How does rows store in Teradata? A) It spreads the rows across all AMPs Tell me the types of Indexes? A) PI - Primary index NoPI-No primary index UPI-Unique primary index NUPI-Non unique primary index USI-Unique secondary index NUSI-Non unique secondary index Difference between UPI and NUPI and the situation where exactly? We will use these? Teradata indexes The role of SI in teradata and...

1. Difference between Teradata and Other RDBMS? The following advantages Teradata  is having over other RDBMS: - Parallel processing - Shared nothing architecture - Super fast data retrieval - TASM-Teradata active control system controls traffic efficiently - Teradata VIEWPOINT gives DBA and users their own view of data - Excellent data processing options-JOINS, Secondary Indexes, Hash index, Portioned Tables for range queries, 2. Draw the picture of Teradata warehouse? Refer the diagram 3. What are the differences between Star schema and Snow flake schema? Star Schema: In a star schema every dimension will have a primary key. In a star schema, a dimension table will not have any parent table. Whereas in a snowflake schema, a dimension table will have one or more parent tables. Hierarchies for the dimensions are stored in the dimensional table itself in star schema. Whereas hierarchies are broken into separate tables in snowflake schema. These hierarch...

Usage-1 It returns a rows randomly from Teradata database. Syntax for SAMPLE function: SAMPLE [WITH REPLACEMENT]    [RANDOMIZED ALLOCATION]                  [WHEN <condition>  THEN]                  {<number-of-rows> | <percentage>}    […,<number-of-rows> | <percentage>]                  [ELSE {<number-of-rows> |    <percentage }   END] Usage 2 It allows the user to get absolute number of rows or percentage of rows. Usage 3 It also allows the rows to get from multiple samples How to get random rows from a table: SELECT * from sample_table SAMPLE 5; How to get certain percentage of rows: SELECT * from sample_table SAMPLE .30; How to get multiple SAMPLE data from a single tables with out duplicates: SELECT * from sample_...

1. Difference between Teradata and Other RDBMS? 2. Draw the picture of Teradata warehouse? 3. What are the differences between Star schema and Snow flake schema? 4. Differentiate Dimension table and Fact table? 5. What is Fact less fact table? 6. Describe the different types of dimension tables? And explain with Examples? 7. Explain Teradata important components with architecture? 8. Difference between SMP and MPP? 9. Explain the Shared nothing architecture? 10.What is a set table? When we will use multiset table? 11.What is the usage of Fallback? 12.How many primary keys we will apply on a table? 13.How does rows store in Teradata? 14.Tell me the types of Indexes? 15.Difference between UPI and NUPI and the situation where exactly We will use these.? 16.The role of SI in teradata and explain the types? 17. How do we create a join and hash indexes and explain the scenerios? When we will use exactly? 18.What is the meaning of Transient journal overhead? 19.Wha...