Cognizant Associate Interview Questions, Process, and Tips

Q1. Question based on the role and not much easy nor tough
Add your answer
Q2. Based on SQL and ETL
Add your answer

Q1. Basic salary discussion
Add your answer

Q1. Asked to explain End to End Project Architecture
Add your answer
Q2. Why Parquet words faster on Spark ?
Ans. 
Parquet words faster on Spark due to its columnar storage format and efficient compression techniques.
• Parquet is a columnar storage format that organizes data by columns rather than rows.

• Columnar storage allows for better compression and efficient data retrieval.

• Parquet uses compression techniques like run-length encoding and dictionary encoding.

• Spark leverages the columnar storage format of Parquet to perform predicat...read more
Answered by AI
Add your answer
Q3. Difference between ORC vs Parquet
Ans. 
ORC and Parquet are file formats used for storing and processing big data. They have differences in compression, performance, and compatibility.
• ORC (Optimized Row Columnar) is a columnar file format that provides high compression and fast read performance.

• Parquet is also a columnar file format that offers efficient compression and query performance.

• ORC is optimized for Hive and provides better support for complex data ...read more
Answered by AI
Add your answer
Q4. Question on Cartesian join
Add your answer
Q5. Difference between rank and dense_rank, with examples
Ans. 
Rank assigns unique numbers to each row, while dense_rank assigns consecutive numbers to rows with the same values.
• Rank function assigns a unique number to each row based on the order specified.

• Dense_rank function assigns consecutive numbers to rows with the same values.

• Rank and dense_rank are used in SQL queries to rank rows based on certain criteria.

• Rank and dense_rank can be used to find top N records or identify du
Answered by AI
Add your answer

Q1. Joining strategy of table A - table B
Ans. 
The joining strategy of table A and table B is the method used to combine the data from both tables based on a common column.
• The joining strategy can be specified using different types such as inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables based on the common column.

• Left join returns all the rows from the left table and the matching rows from the right ...read more
Answered by AI
Add your answer
Q2. How do you find if table has any duplicates
Ans. 
To find if a table has any duplicates, you can use the GROUP BY clause with the COUNT function.
• Use the GROUP BY clause to group the rows by the columns that you want to check for duplicates.

• Use the COUNT function to count the number of occurrences of each group.

• If the count is greater than 1, it means there are duplicates in the table.
Answered by AI
Add your answer
Q3. Alternative join strategy for full outer join
Ans. 
An alternative join strategy for full outer join is to use a combination of left and right outer joins.
• Perform a left outer join to include all rows from the left table and matching rows from the right table

• Perform a right outer join to include all rows from the right table and matching rows from the left table

• Combine the results of the left and right outer joins to get the full outer join
Answered by AI
Add your answer

Q1. What is your professional background?
Add your answer

Q1. What is your name and your experience
Add your answer

Questions on Dynamic Programming

Questions on Linked List

Q1. Basic Java Questions
Add your answer
Q2. Basic SQL Questions
Add your answer

It covered all aptitude and reasoning topics

Q1. The questions were regarding c, java, sql
Add your answer
Q2. Write pattern program in C language
Ans. 
Pattern program in C language using loops and conditional statements.
• Use nested loops to print the desired pattern

• Utilize conditional statements to control the pattern output

• Experiment with different loop structures to create various patterns
Answered by AI
Add your answer
Q3. Types of joins in SQL
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: returns rows when there is a 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 table

• Full outer join: returns rows when there is a match in either table
Answered by AI
Add your answer
Q4. Difference between abstraction and encapsulation
Ans. 
Abstraction focuses on hiding the implementation details while encapsulation focuses on bundling the data and methods that operate on the data into a single unit.
• Abstraction is the concept of hiding the complex implementation details and showing only the necessary features of an object. For example, a car can be abstracted as a vehicle with properties like speed and color, without showing the internal working of the en...read more
Answered by AI
Add your answer

Q1. It was regarding the general topics
Add your answer