Cyanous Software Interview Questions and Answers

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Q1. Internal working of hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To retrieve a value, the key is hash...read more
Answered by AI
Add your answer
Q2. Find Anagram from string array
Ans. 
Find anagrams from a string array
• Iterate through each string in the array

• Sort the characters of each string to create a key for comparison

• Use a hashmap to group anagrams together

• Return the grouped anagrams as arrays
Answered by AI
Add your answer

Q1. Top view of binary Tree
Ans. 
A top view of a binary tree shows the nodes visible when looking at the tree from the top.
• The top view of a binary tree is the set of nodes visible when looking at the tree from the top.

• Nodes at the same horizontal distance from the root are considered at the same level.

• Use a map to store the horizontal distance of each node and only keep the first node encountered at each horizontal distance.
Answered by AI
Add your answer
Q2. Java based questions
Add your answer

Q1. Hight of binary tree
Ans. 
Height of a binary tree is the maximum number of edges on the longest path from the root node to a leaf node.
• Height of an empty tree is -1

• Height of a tree with only one node is 0

• Height of a binary tree can be calculated recursively by finding the height of left and right subtrees and adding 1 to the maximum of the two heights
Answered by AI
Add your answer
Q2. Garbage Collector
Add your answer

Q1. Library Management System
Add your answer

Q1. DSA Array, String and Hashmap questions
Add your answer
Q2. Functional programming java questions
Add your answer

Q1. Spring and spring boot related
Add your answer
Q2. HLD scenario level questions
Add your answer
Q3. SQL queries nested and joins
Add your answer
Q4. DB related questions and experience level questions and previous project situations related questions
Add your answer
Q5. Security level questions like XSS vulnerability and SQL injection
Add your answer

Q1. Exception hierarchy
Add your answer
Q2. Factory vs abstract factory design patterns
Ans. 
Factory pattern creates objects without exposing the instantiation logic, while Abstract Factory pattern provides an interface for creating families of related objects.
• Factory pattern is a creational design pattern that provides a way to create objects without specifying the exact class of object that will be created.

• Abstract Factory pattern is a creational design pattern that provides an interface for creating familie...read more
Answered by AI
Add your answer
Q3. Design a systems for large millions of users
Ans. 
Design a scalable system for millions of users
• Use microservices architecture to break down the system into smaller, independent services

• Implement load balancing to distribute traffic evenly across servers

• Utilize caching mechanisms to reduce database load and improve performance

• Use horizontal scaling by adding more servers to handle increased traffic

• Implement monitoring and alerting systems to track system performance a
Answered by AI
Add your answer

Q1. Kafka implemenation in spring boot
Ans. 
Kafka implementation in Spring Boot allows for easy integration of Kafka messaging system in Java applications.
• Use Spring Kafka to configure Kafka properties in Spring Boot application

• Create Kafka producer and consumer beans to send and receive messages

• Use @KafkaListener annotation to listen for messages on specific topics
Answered by AI
Add your answer
Q2. How Kafka delete messages
Ans. 
Kafka deletes messages based on retention policies and compaction
• Kafka deletes messages based on retention policies set at topic level

• Messages can also be deleted through log compaction process

• Retention policies can be based on time or size of messages
Answered by AI
Add your answer
Q3. Kafka configuration
Ans. 
Kafka configuration involves setting up properties like broker, topic, partitions, replication factor, etc.
• Configure Kafka broker properties in server.properties file

• Create topics using kafka-topics.sh script

• Set up partitions and replication factor for fault tolerance

• Adjust consumer and producer configurations as needed
Answered by AI
Add your answer
Q4. Structured vs unstructured logs
Ans. 
Structured logs have a predefined format for easy parsing, while unstructured logs do not.
• Structured logs are easier to search, filter, and analyze compared to unstructured logs.

• Unstructured logs can be harder to parse and may require more manual effort to extract useful information.

• Examples of structured logs include JSON or CSV format, while unstructured logs may be plain text or free-form messages.
Answered by AI
Add your answer
Q5. How micro services communicate each others
Ans. 
Microservices communicate through lightweight protocols like HTTP, messaging queues, and RPC.
• Microservices can communicate over HTTP using RESTful APIs.

• Message queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.

• Remote Procedure Calls (RPC) can be used for synchronous communication between microservices.

• Service discovery mechanisms like Eureka or Consul help microservices loca...read more
Answered by AI
Add your answer

Q1. Salary structure discussion
Add your answer
Q2. Why choice this company
Ans. 
I chose this company because of its innovative projects, strong team culture, and opportunities for growth.
• Innovative projects that challenge me to learn and grow

• Strong team culture that fosters collaboration and support

• Opportunities for career growth and advancement
Answered by AI
Add your answer
Q3. Why looking for new opportunities
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking to expand skill set and knowledge in Java development

• Interested in working on innovative projects and technologies

• Seeking a more collaborative and supportive work culture
Answered by AI
Add your answer

Q1. Java springboot basic to intermediate question
Add your answer
Q2. Java stream questions
Add your answer

Q1. Easy level DSA questions
Add your answer
Q2. Project based questions
Add your answer

Online test for aptitude and technical questions which is quite easy you need above 12 marks i guess , only then you will be considered for technical interview

Q1. Introduction about yourself
Add your answer
Q2. About yardi products, and yardi company
Add your answer
Q3. Where do you live and are you able to relocate to the respective location?
Add your answer
Q4. Why don't you planning for higher education
Add your answer
Q5. Tell me about your family
Add your answer

Q1. What is oops concepts?
Ans. 
Object-oriented programming concepts that focus on classes, objects, inheritance, encapsulation, and polymorphism.
• Classes: Blueprint for creating objects with attributes and methods.

• Objects: Instances of classes that contain data and behavior.

• Inheritance: Ability for a class to inherit attributes and methods from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorp...read more
Answered by AI
Add your answer
Q2. What is method overriding and overloading with code explanation? (i was prepared but they were asking me tricky questions about it which is difficult to answer)
Add your answer
Q3. Write a code to print numbers in pyramid shape all patterns
Ans. 
Print numbers in pyramid shape patterns using SQL code.
• Use a loop to iterate through rows and columns to print the numbers in pyramid shape.

• Increment the numbers in each row to create the pyramid effect.

• Consider the spacing and alignment to create a visually appealing pyramid pattern.
Answered by AI
Add your answer
Q4. Write a code to sort array without sort function
Ans. 
Code to sort array without sort function
• Iterate through the array and compare each element with the rest to find the smallest element

• Swap the smallest element with the first element in the unsorted portion of the array

• Repeat the process for the remaining unsorted portion of the array until fully sorted
Answered by AI
Add your answer
Q5. Difference between list, string array... etc?

Ans. 

List is a collection of objects, string array is an array of strings, etc. Each has its own characteristics and uses.

• List: dynamic collection of objects, can grow/shrink in size. Example: List numbers = new ArrayList<>();

• String array: fixed-size array containing strings. Example: String[] names = new String[3];

• Array: fixed-size collection of elements of the same type. Example: int[] scores = new int[5];

Add your answer