TCS Teradata Developer Interview Questions and Answers

Q1. Teradata architecture, sql commands, utilities
Add your answer

Q1. They were asking very logical and technical questions on interview time
Add your answer
Q2. They were test our skills and time punctuation
Add your answer

Q1. They were discussed with some technical questions and based on knowledge
Add your answer

Q1. Questions related to the current and past projects.
Add your answer
Q2. Aws related questions.
Add your answer
Q3. Data warehousing basics
Add your answer

Q1. Explain about the roles and responsibilities.
Add your answer
Q2. Discussion about the role in Genpact.
Add your answer

Q1. Asked about expectated salary
Add your answer
Q2. Why are you switching
Add your answer

Q1. Start up parameters of sql server
Ans. 
Start up parameters are used to configure the behavior of SQL Server when it starts up.
• Start up parameters are specified in the SQL Server Configuration Manager.

• Common start up parameters include -d (database files location), -e (error log location), -m (single user mode), -T (trace flags), etc.

• Start up parameters can be modified to customize the behavior of SQL Server during startup.

• Example: -dC:\Program Files\Microso...read more
Answered by AI
Add your answer
Q2. Differential backup query
Add your answer
Q3. Sql server statics
Add your answer
Q4. Log file architecture
Add your answer

Q1. Project work currently working
Ans. 
Currently working on developing a real-time data processing pipeline for a financial services company.
• Designing and implementing data ingestion processes using Apache Kafka

• Building data processing workflows with Apache Spark

• Optimizing data storage and retrieval with Apache Hadoop

• Collaborating with data scientists to integrate machine learning models into the pipeline
Answered by AI
Add your answer
Q2. Sql,python and other data warehousing concept
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

Test your algorithmic thinking and problem solving skills

Q1. Communications,clearity of answers
Add your answer

Q1. Discussion about packages,joining date
Add your answer

Q1. Given a DataFrame df with columns 'A', 'B','C' how would you group the data by the values in column 'A' and calculate the mean of column 'B' for each group, while also summing the values in column 'C' ?
Ans. 
Group data by column 'A', calculate mean of column 'B' and sum values in column 'C' for each group.
• Use groupby() function in pandas to group data by column 'A'

• Apply mean() function on column 'B' and sum() function on column 'C' for each group

• Example: df.groupby('A').agg({'B':'mean', 'C':'sum'})
Answered by AI
Add your answer
Q2. Explain the difference deepcopy() and copy() methods in Python's copy module. Provide a scenario where you would use deepcopy() over copy().
Ans. 
deepcopy() creates a new object with completely independent copies of nested objects, while copy() creates a shallow copy.
• deepcopy() creates a new object and recursively copies all nested objects, while copy() creates a shallow copy of the top-level object only.

• Use deepcopy() when you need to create a deep copy of an object with nested structures, to avoid any references to the original object.

• Use copy() when you only ...read more
Answered by AI
Add your answer
Q3. Discuss the concept of Python decorators and provide an example of how you would use decorators to measure the execution time of a function.
Ans. 
Python decorators are functions that modify the behavior of other functions. They are commonly used for adding functionality to existing functions without modifying their code.
• Decorators are defined using the @ symbol followed by the decorator function name.

• They can be used to measure the execution time of a function by wrapping the function with a timer decorator.

• Example: def timer(func): def wrapper(*args, **kwargs...read more
Answered by AI
Add your answer