Infosys Certified Teradata Developer
Practice with real exam-pattern questions for Infosys Certified Teradata Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Teradata Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Teradata Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Coalesce function needs atleast how many arguments
- ✓ 2 Correct
- B 3
- C 1
- D 4
- Question 2
In Non-Fallback table, when two or more AMPs down in different clusters
- ✓ data partially available Correct
- B data fully available
- C system halts
- D none of the choices
- Question 3
What protects table from amp failure?
- ✓ Rowhash Correct
- B Fallback
- C None
- D Database lock
- Question 4
Say it True or False:
All nodes in a clique must be able to access all vdisks for all AMPs in the clique- ✓ TRUE Correct
- B FALSE
- Question 5
Match the stages in Data analysis:
Stage 1: a. Pre-defined reports - 1. What will happen?
Stage 2: b. Ad Hoc Queries - 2. Making it Happen
Stage 3: c. Analytical Modeling - 3.Why did it happen?
Stage 4: d. Continuous Update - 4. What happened?
Stage 5: e. Event Based Triggering - 5. What is happening?"- ✓ a-4, b-3, c-1, d-5, e-2 Correct
- B a-1, b-2, c-4, d-3, e-2
- C a-3, b-4, c-1, d-2, e-5
- D a-2, b-3, c-5, d-1, e-4
- Question 6
RAID 5 is:
- ✓ Good performance with disk failures Higher cost in terms of disk space Correct
- B Reduced performance with disk failures Lower cost in terms of disk space
- C Good performance with disk failures Lower cost in terms of disk space
- D Reduced performance with disk failures Higher cost in terms of disk space
- Question 7
What is the use of Primary index in the Teradata Database?
- ✓ To support efficient data access Correct
- B To enable compression on the data to improve query performance
- C To provide a constraint to ensure referntial integrity
- D To ensure enough AMPs are involved to reduce the query processing time for data distribution
- Question 8
Volatile Tables does
a. holds information for intermediate results of queries
b. valid for a session only
c. data can be accessed by any session
d. stored in database schema- ✓ a, b Correct
- B b, c, d
- C a, b, d
- D a, c, d
- Question 9
A user has no Perm Space assigned. What objects could be found in its space?
A. Tables
B. Views
C. Macros
D. Triggers- ✓ B, C, D Correct
- B A, B, C
- C A, B
- D ONLY C
- Question 10
Say it True or False:
Whenever administrator user creates additional users and databases, space assigned to those objects will be subtracted from the administrative user’s space.- ✓ TRUE Correct
- B FALSE
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.