COPES Tech Interview Questions and Answers

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Introduction, be prepared to have knowledge on your resume
Add your answer
Q2. Mathematical questions like percentage
Add your answer
Q3. Critical thinking. They asked a question with a given situation what you'll do .
Add your answer
Q4. The past 4 days been climate be stroming . And current was cut off due to rain and flood , you have a important assignment to finish, what you'll do
Add your answer

During the coding test, I was asked to write a program to check the frequency of characters in a string.

Q1. What is Java , what are the four pillars of java
Ans. 
Java is a popular programming language known for its platform independence and object-oriented approach.
• Java is platform-independent, meaning it can run on any device with a Java Virtual Machine (JVM)

• Object-oriented programming is a key feature of Java, allowing for code reusability and modularity

• The four pillars of Java are: Inheritance, Encapsulation, Abstraction, and Polymorphism

• Inheritance allows a class to inherit...read more
Answered by AI
Add your answer
Q2. Related to collection framework
Add your answer
Q3. What is recursion, write a code for it
Ans. 
Recursion is a programming technique where a function calls itself to solve a problem.
• Recursion involves breaking down a problem into smaller subproblems and solving them recursively.

• A base case is needed to stop the recursion and prevent infinite loops.

• Example: Factorial calculation using recursion - function factorial(n) { return n === 0 ? 1 : n * factorial(n-1); }
Answered by AI
Add your answer
Q4. Why we don't use pointers in java
Ans. 
Java doesn't use pointers for security and simplicity reasons.
• Java uses references instead of pointers to avoid direct memory manipulation.

• Pointers can lead to memory leaks and security vulnerabilities.

• Java's garbage collection manages memory automatically, reducing the need for pointers.
Answered by AI
Add your answer
Q5. What are the difference between array and arraylist
Ans. 
Array is a fixed-size data structure while ArrayList is a dynamic-size data structure in Java.
• Array is a fixed-size collection of elements of the same data type, while ArrayList is a dynamic-size collection that can grow or shrink.

• Arrays can store primitive data types and objects, while ArrayList can only store objects.

• Arrays require a specified size at the time of declaration, while ArrayList can dynamically resize it...read more
Answered by AI
Add your answer

Q1. Types of Chunking in data preparation in RAG
Add your answer
Q2. How Embedding works in Vector Databases
Add your answer
Q3. Explain ARIMA model
Add your answer
Q4. How can we decide to choose Linear Regression for a business problem
Add your answer

Q1. What is token and it's limit for Open Source LLMs
Add your answer
Q2. Difference of a Regression and Time Series problem
Add your answer
Q3. Advantage of LSTM over RNN
Add your answer
Q4. Performance Metrics for Logistic Regression
Add your answer

The test will comprise a total of 60 questions, divided as follows: 70% of the questions will focus on finance and accounting, while the remaining questions will cover aptitude and English.

Q1. Zero coupon bonds, long-term liabilities, return on equity, debt-equity ratio, captial budgeting and techniques, bonds and its types, debt instruments meaning, collateral, mortgage, spin off, demerger, mer...read more
Add your answer

Q1. Write your own implementation for shared pointer. How it will handle if it get assigned by another one. How will you use it in main method. How will you overload -> operator and dereferencing operator in t...read more
Ans. 
Implementation of shared and unique pointers in C++ with operator overloading.
• Implement a class for shared pointer with reference counting.

• Handle assignment by incrementing reference count and decrementing old pointer's count.

• Overload -> and * operators to access underlying object.

• Use shared pointer in main method by creating instances and passing them around.

• For unique pointer, implement a class that transfers ownersh
Answered by AI
Add your answer
Q2. Simple problem for binary search but input values are double not integer
Add your answer

Q1. Given bst find two values from tree which will give you required sum. In two pointer is it better to use middle-out instead of starting from both end probabilistically
Add your answer
Q2. Design splitwise like add and explain
Add your answer

Q1. Write signature of shared pointer
Add your answer
Q2. Design system similar to load balancer where if request comes again with same id it should go to server it went for first time. with constant space complexity
Add your answer
Q3. Design system where there is org hierarchy and you should be able to find all sub-ordinates Optimize is using array of pointer
Ans. 
Design a system with org hierarchy to find all sub-ordinates using array of pointers.
• Create a class for each employee with a pointer to their manager

• Use an array of pointers to store all employee objects

• Traverse the array to find all sub-ordinates of a given employee
Answered by AI
Add your answer
Q4. Write lambda function and it's signature
Add your answer
Q5. Do you know about template Class and function template
Add your answer
Q6. How does auto work internally?
Add your answer

Q1. Are you ready to shift to bengaluru
Ans. 
Yes, I am ready to shift to Bengaluru for the c++ associate position.
• I am excited about the opportunity to work in Bengaluru.

• I have researched the city and am comfortable with the relocation.

• I am flexible and adaptable to new environments.

• I have friends/family in Bengaluru who can support me during the transition.
Answered by AI
Add your answer