Tredence Interview Questions and Answers

Aptitude + Technical Questions

Coding Questions of SQL and DSA

Q1. Transpose a matrix in python and machine learning questions
Ans. 
To transpose a matrix in Python, use numpy.transpose() or the T attribute.
• Use numpy.transpose() function to transpose a matrix.

• Alternatively, use the T attribute of a numpy array.

• Example: np.transpose(matrix) or matrix.T
Answered by AI
Add your answer
Q2. What are numpy and pandas
Ans. 
NumPy is a library for numerical computing in Python, while Pandas is a data manipulation and analysis tool.
• NumPy provides support for large, multi-dimensional arrays and matrices, along with a collection of mathematical functions to operate on these arrays.

• Pandas offers data structures like DataFrame for easy data manipulation and analysis, with tools for reading and writing data from various file formats.

• Both librari...read more
Answered by AI
Add your answer
Q3. Visualization libraries in python
Ans. 
Python has various visualization libraries like Matplotlib, Seaborn, Plotly, and Bokeh.
• Matplotlib is a widely used library for creating static, interactive, and animated plots.

• Seaborn is built on top of Matplotlib and provides a high-level interface for creating attractive and informative statistical graphics.

• Plotly is great for creating interactive plots and dashboards.

• Bokeh is another interactive visualization librar...read more
Answered by AI
Add your answer
Q4. Object Oriented Programing
Add your answer

1 good coding question and 33 mcqs

Q1. Easy questions are asked
Add your answer
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
Answered by AI
Add your answer

Q1. Some hr questions
Add your answer
Q2. Project discussions
Add your answer

Q1. Hr questions about family
Add your answer

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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

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
Answered by AI
Add your answer
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 ...read more
Answered by AI
Add your answer

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 ...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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.
Answered by AI
Add your answer

Q1. Salary expectations?
Add your answer
Q2. When can you join
Add your answer