AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Tredence Interview Questions and Answers
93 Interview questions
An inner join combines rows from two or more tables based on a related column, returning only matching records.
An inner join retrieves records that have matching values in both tables.
Example: If Table A has IDs 1, 2, 3 and Table B has IDs 2, 3, 4, an inner join on ID returns rows with IDs 2 and 3.
It is commonly used in SQL queries to filter data from multiple tables.
Syntax in SQL: SELECT * FROM TableA INNER JOIN ...
Container orchestration with Docker automates deployment, scaling, and management of containerized applications.
Docker Swarm: Native clustering and orchestration tool for Docker, allowing easy management of multiple containers.
Kubernetes: A powerful orchestration platform that manages containerized applications across a cluster of machines.
Scaling: Automatically adjust the number of running containers based on loa...
CI/CD pipelines using YAML streamline software development by automating testing and deployment processes.
YAML (YAML Ain't Markup Language) is a human-readable data serialization format often used for configuration files.
In CI/CD, YAML files define the steps for continuous integration and continuous deployment, such as build, test, and deploy stages.
Example of a simple CI pipeline in YAML: ```yaml stages: - bui...
Learn how to add Kubernetes services using Azure Kubernetes Service (AKS) effectively.
Create an AKS cluster using Azure CLI: `az aks create --resource-group myResourceGroup --name myAKSCluster --node-count 1 --enable-addons monitoring`
Use `kubectl` to deploy services: `kubectl apply -f service.yaml` where service.yaml defines your service configuration.
Expose your service using LoadBalancer type: `apiVersion: v1 k...
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include inner join, left join, right join, and full outer join
Inner join returns rows when there is at least one match in both tables
Left join returns all rows from the left table and the matched rows from the right table
Right join returns all rows from the right table and the matched rows from the left tab...
Partitioning divides data into distinct segments, while clustering groups similar data points based on characteristics.
Partitioning creates non-overlapping segments, e.g., dividing a database by region.
Clustering groups similar items, e.g., customer segmentation based on purchasing behavior.
Partitioning is often used for performance optimization in databases.
Clustering is used in machine learning for pattern recog...
Copy activity in Azure Data Factory (ADF) facilitates data transfer between various data stores.
Enables data movement from source to destination, e.g., SQL Database to Blob Storage.
Supports various data formats like CSV, JSON, and Parquet.
Can be scheduled or triggered by events, allowing for automation.
Utilizes integration runtime for data movement, which can be Azure or Self-hosted.
Allows for data transformation ...
Deadlocks occur when two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlocks happen in multitasking environments where processes compete for resources.
Four conditions must hold for a deadlock to occur: mutual exclusion, hold and wait, no preemption, and circular wait.
Example: Process A holds Resource 1 and waits for Resource 2, while Process B holds Resourc...
SQL window function is used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, moving averages, rank, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), etc.
Optimizing code involves identifying bottlenecks, improving algorithms, using efficient data structures, and minimizing resource usage.
Identify and eliminate bottlenecks in the code by profiling and analyzing performance.
Improve algorithms by using more efficient techniques and data structures.
Use appropriate data structures like hash maps, sets, and arrays to optimize memory usage and access times.
Minimize resour...
Tredence Interview Experiences
137 interviews found
Anonymous
I appeared for an interview in Jun 2017.
Interview Questionnaire
12 Questions
- Q1. Write the annotation for controller?
- Ans.
An annotation for controller in software engineering.
The annotation for controller is used to define the class as a controller in a software application.
It is typically used in frameworks like Spring MVC or ASP.NET MVC.
The annotation helps in mapping the incoming requests to the appropriate controller methods.
It can also be used to specify the URL path for the controller.
Example: @Controller in Spring MVC, [ApiControll...
- Q2. Write the annotation for request mapping?
- Ans.
The annotation for request mapping is used to map HTTP requests to specific methods in a controller class.
The annotation is @RequestMapping
It can be used at the class level to specify a common base URL for all methods in the class
It can also be used at the method level to specify the URL path and HTTP method for a specific method
Additional attributes can be used to further customize the mapping, such as specifying requ...
- Q3. What is front controller from context in spring mvc?
- Ans.
Front controller is a design pattern used in Spring MVC to handle incoming requests and route them to appropriate handlers.
Front controller acts as a central point of control for handling requests in Spring MVC.
It receives all incoming requests and delegates them to appropriate handlers called controllers.
Front controller provides a consistent way to handle requests and perform common tasks like authentication, logging...
- Q4. Write the css box model?
- Ans.
The CSS box model describes the layout and sizing of elements on a web page.
The box model consists of content, padding, border, and margin.
Content refers to the actual content of the element, such as text or images.
Padding is the space between the content and the border.
Border is a line that surrounds the padding and content.
Margin is the space outside the border, separating the element from other elements.
The width an...
- Q5. Select all div using jquery
- Ans.
Select all div using jQuery
Use the jQuery selector $('div') to select all div elements
This will return a jQuery object containing all the selected div elements
You can then perform operations on the selected div elements using jQuery methods
- Q6. Change all ul element to blue background color using jquery
- Ans.
Use jQuery to change the background color of all ul elements to blue.
Use the jQuery selector to select all ul elements
Use the css() method to change the background color to blue
- Q7. Change first li element to yellow background color using jquery
- Ans.
Use jQuery to change the background color of the first li element to yellow.
Use the :first-child selector to select the first li element
Use the css() method to change the background color to yellow
- Q8. Output of this var arr=[1,2,3,4,5] arr.push(6) arr.unshift(1) arr.pop() arr.shift()
- Ans.
The output of the given code is [1, 2, 3, 4, 5, 6].
The 'push' method adds an element to the end of the array.
The 'unshift' method adds an element to the beginning of the array.
The 'pop' method removes the last element from the array.
The 'shift' method removes the first element from the array.
- Q9. What are the uses of final in java
- Ans.
The 'final' keyword in Java is used to declare constants, prevent method overriding, and ensure thread safety.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden by subclasses
Final classes cannot be extended by other classes
Final parameters ensure that they cannot be modified within a method
Final fields can be used to achieve thread safety
- Q10. Public static void getsum(int a,int b){System.out.println("a b method");}public static void getsum(int a,int b,int c){System.out.println("a b c method");}public static void getsum(int a,int ...b){System.o...
- Ans.
The question is about method overloading in Java.
Method overloading allows multiple methods with the same name but different parameters.
The method to be called is determined at compile-time based on the arguments passed.
In the given code, there are three overloaded methods with the same name 'getsum'.
The first method takes two integers as arguments.
The second method takes three integers as arguments.
The third method ta...
- Q11. Output of this program public static int floating(int x){ return x*floating(x-1); } public static void main(String[] args){ floating(10); }
- Ans.
The program will result in a StackOverflowError due to infinite recursion.
The 'floating' method is recursively calling itself without a base case to stop the recursion.
Each recursive call multiplies the input parameter by the result of the recursive call with a decremented parameter.
This will continue indefinitely until the stack overflows and an error is thrown.
- Q12. What is the output of this int i=0; int j=10;do{ if(i++ < --j){ } }while(i
- Ans.
The output of the code is 9.
The code initializes i as 0 and j as 10.
Inside the do-while loop, i is incremented by 1 and j is decremented by 1.
The loop continues until i becomes greater than or equal to j.
Since i is incremented before the comparison and j is decremented before the comparison, the loop runs 9 times.
Therefore, the output is 9.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview in Dec 2024, where I was asked the following questions.
- Q1. Related to python programming
- Q2. Data science question
Vinay Gundam
I applied via Campus Placement
1 good coding question and 33 mcqs
(2 Questions)
- Q1. Easy questions are asked
- Q2. Like create a database of the collages composes of students and professors
- Ans.
Create a database to store information about colleges, students, and professors.
Create tables for colleges, students, and professors
Include columns for relevant information such as name, ID, courses, etc.
Establish relationships between the tables using foreign keys
Use SQL queries to insert, update, and retrieve data
Consider normalization to avoid data redundancy
(2 Questions)
- Q1. Some hr questions
- Q2. Project discussions
(1 Question)
- Q1. Hr questions about family
(2 Questions)
- Q1. Use lambda function in a python code.
- Ans.
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used with functions like map(), filter(), and reduce().
Example: double = lambda x: x * 2
- Q2. Define precision, recall and f1 score.
- Ans.
Precision, recall, and F1 score are metrics used to evaluate the performance of classification models.
Precision is the ratio of correctly predicted positive observations to the total predicted positive observations.
Recall is the ratio of correctly predicted positive observations to the all observations in actual class.
F1 score is the harmonic mean of precision and recall, providing a balance between the two metrics.
Pre...
(2 Questions)
- Q1. What is the significance of elbow curve in clustering?
- Ans.
Elbow curve helps in determining the optimal number of clusters in a dataset.
Elbow curve is a plot of the number of clusters against the within-cluster sum of squares (WCSS).
The point where the rate of decrease of WCSS sharply changes is considered as the optimal number of clusters.
It helps in finding the balance between having too few or too many clusters.
For example, if the elbow point is at 3 clusters, it suggests t...
- Q2. What is the significance of support, confidence and lift in market basket analysis?
- Ans.
Support, confidence, and lift are key metrics in market basket analysis to identify relationships between items in a transaction.
Support measures how frequently an itemset appears in the dataset.
Confidence measures the likelihood that an item B is purchased when item A is purchased.
Lift measures how much more likely item B is purchased when item A is purchased compared to when item B is purchased independently of item ...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(3 Questions)
- Q1. What is data bricks
- Ans.
Data bricks is a unified analytics platform that provides a collaborative environment for data scientists, engineers, and analysts.
Data bricks simplifies the process of building data pipelines and training machine learning models.
It allows for easy integration with various data sources and tools, such as Apache Spark and Delta Lake.
Data bricks provides a scalable and secure platform for processing big data and running ...
- Q2. How do you optimize your code?
- Ans.
Optimizing code involves identifying bottlenecks, improving algorithms, using efficient data structures, and minimizing resource usage.
Identify and eliminate bottlenecks in the code by profiling and analyzing performance.
Improve algorithms by using more efficient techniques and data structures.
Use appropriate data structures like hash maps, sets, and arrays to optimize memory usage and access times.
Minimize resource us...
- Q3. What is SQL window function?
- Ans.
SQL window function is used to perform calculations across a set of table rows related to the current row.
Window functions operate on a set of rows related to the current row
They can be used to calculate running totals, moving averages, rank, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), etc.
(2 Questions)
- Q1. Salary expectations?
- Q2. When can you join
- Ans.
I can join immediately or at a mutually convenient date, depending on your needs and my current commitments.
I am available to start immediately if needed.
If you prefer a specific start date, I can accommodate that as well.
I can discuss my current commitments to find a suitable start time.
For example, if you need someone to start within a week, I can make that work.
Skills evaluated in this interview
sujay GR
Selected
I applied via Approached by Company and was interviewed in Sep 2024. There were 3 interview rounds.
You will be getting questions on the tech stack you have experience with, in depth questions on Node js and React js, real time challenges faced, two coding questions (1 easy and 1 medium)
F2f round for about 1.5 hrs, you be given a task to create a functionality using frontend tech stack you have chosen, more coding questions medium level, framework related ij depth questions
(2 Questions)
- Q1. Previous experience and questions related to that
- Q2. More questions on how to approach a problem
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. How to handle missing values
- Ans.
Handle missing values by imputation, deletion, or using algorithms that can handle missing data.
Impute missing values using mean, median, mode, or predictive modeling
Delete rows or columns with missing values if they are insignificant
Use algorithms like XGBoost, Random Forest, or LightGBM that can handle missing data
- Q2. Linear equations model metrics
(2 Questions)
- Q1. Precession vs recall?
- Ans.
Precision measures the accuracy of positive predictions, while recall measures the ability to find all positive instances.
Precision is the ratio of correctly predicted positive observations to the total predicted positives.
Recall is the ratio of correctly predicted positive observations to all actual positives.
Precision is important when the cost of false positives is high, while recall is important when the cost of fa...
- Q2. Clustering evaluation metrics
Skills evaluated in this interview
Selected
I appeared for an interview in Feb 2025, where I was asked the following questions.
- Q1. 1. asked about CDC and CDT difference 2. Transient table Vs temp table 3. SCD type 2 & Type 3 diff 4. A window function based question to found the latest updated designations on employee table on basi...
- Q2. Rest questions were on basis of Azure Databricks , Deltalake , ADF on basis of experience
Sathish Kumar
(1 Question)
- Q1. What is joins and types?
Archita Ravi
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. What is an inner join in the context of database management?
- Ans.
An inner join combines rows from two or more tables based on a related column, returning only matching records.
An inner join retrieves records that have matching values in both tables.
Example: If Table A has IDs 1, 2, 3 and Table B has IDs 2, 3, 4, an inner join on ID returns rows with IDs 2 and 3.
It is commonly used in SQL queries to filter data from multiple tables.
Syntax in SQL: SELECT * FROM TableA INNER JOIN Table...
- Q2. What is Madalian architecture?
- Ans.
Madalain architecture is a design framework for scalable and efficient data processing systems.
Focuses on modularity and scalability in data systems.
Utilizes microservices for independent data processing tasks.
Supports real-time data processing and analytics.
Example: Using Madalian architecture in a healthcare app for patient data analysis.
Venkatesh Naik
The first round was mix of apti and coding
(2 Questions)
- Q1. What is deadlocks?
- Ans.
Deadlocks occur when two or more processes are unable to proceed because each is waiting for the other to release a resource.
Deadlocks happen in multitasking environments where processes compete for resources.
Four conditions must hold for a deadlock to occur: mutual exclusion, hold and wait, no preemption, and circular wait.
Example: Process A holds Resource 1 and waits for Resource 2, while Process B holds Resource 2 a...
- Q2. A puzzles from gfg
Skills evaluated in this interview
Top trending discussions
Tredence Interview FAQs
Some of the top questions asked at the Tredence interview -
The duration of Tredence interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Tredence Interviews By Designations
- Tredence Analyst Interview Questions
- Tredence Data Analyst Interview Questions
- Tredence Consultant Interview Questions
- Tredence Data Engineer Interview Questions
- Tredence Data Scientist Interview Questions
- Tredence Business Analyst Interview Questions
- Tredence Associate Manager Interview Questions
- Tredence Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 109 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Tredence Reviews and Ratings
based on 571 reviews
Rating in categories
|
Associate Manager
440
salaries
|  ₹11 L/yr - ₹36.5 L/yr |
|
Consultant
427
salaries
| ₹11.5 L/yr - ₹20 L/yr |
|
Data Engineer
303
salaries
| ₹6.4 L/yr - ₹18.5 L/yr |
|
Analyst
292
salaries
| ₹6 L/yr - ₹10.4 L/yr |
|
Senior Business Analyst
250
salaries
| ₹6.5 L/yr - ₹17 L/yr |
ITC Infotech
CitiusTech
HTC Global Services
Xoriant
- Home >
- Interviews >
- Tredence Interview Questions
