Appperfect Corp Softwaretest Engineer Interview Questions and Answers

Intermediate DSA questions on strings

It's bit about the case study related to continuos data and need to find the n highest number at any given time .

Q1. What is a bloom filter in hbase ?
Ans. 
A bloom filter in HBase is a data structure used to test whether a given element is a member of a set.
• Bloom filters are used to reduce the number of disk reads in HBase by quickly determining if a row may exist in a table.

• They are implemented as a compact array of bits, with multiple hash functions used to map elements to bits.

• Bloom filters can produce false positives but not false negatives, making them useful for pre...read more
Answered by AI
Add your answer
Q2. Write a query to remove duplicate rows in pyspark based on primary key.
Ans. 
Use dropDuplicates() function in pyspark to remove duplicate rows based on primary key.
• Use dropDuplicates() function on the DataFrame with the primary key column specified.

• Specify the subset parameter in dropDuplicates() to specify the primary key column.

• Example: df.dropDuplicates(['primary_key_column'])
Answered by AI
Add your answer

Q1. Javascript related
Add your answer

Q1. Javascript related concepts
Add your answer

Q1. Some basic inheritance and overloading questions
Add your answer
Q2. Prepare for interface with same methods in one base class
Add your answer

Q1. Phone interview
Add your answer

Q1. Project technical questions
Add your answer

Q1. Project technical based question
Add your answer

Q1. Behavioural based questions
Add your answer

In the coding test, there were 2 problems based on arrays and hashing (easy to medium level leetcode)

Q1. Several OOP questions were asked.... like, Can we have a class inside an interface? Can we have a static constructor? Can we have multiple main methods?
Add your answer
Q2. DBMS question: Normalization questions and keys concepts.
Add your answer

Q1. DSA question (stack based) You have a stack full of numbers, you have to arrange them in ascending order in the same stack without using any other data structure.
Add your answer
Q2. OS and DBMS questions(sharding, semaphores, etc.)
Add your answer

Q1. Questions based on Consultadd principles.
Add your answer

Q1. How does consumer, producer work in kafka
Ans. 
Consumers read data from topics, while producers write data to topics in Kafka.
• Consumers subscribe to topics to read messages from them

• Producers publish messages to topics for consumers to read

• Consumers can be part of a consumer group to scale out consumption

• Producers can specify key for messages to control partitioning
Answered by AI
Add your answer

Q1. Role check
Add your answer
Q2. Tech stackP
Add your answer

Q1. Project based questions
Add your answer
Q2. AWS related questions
Add your answer