Straive Softwaretest Engineer Interview Questions and Answers

Q1. Javascript questions
Add your answer

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. What is Sql?, and performance tuneing
Ans. 
SQL is a domain-specific language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating data, and creating databases

• Performance tuning in SQL involves optimizing queries, indexes, and database design to improve speed and efficiency

• Examples of performance tuning techniques include using ind...read more
Answered by AI
Add your answer
Q2. About power bi dax filter and dashboard
Add your answer

Q1. About your technical skills
Add your answer
Q2. About your previous work profile
Add your answer

Q1. What is EV and its formulae
Ans. 
EV stands for Enterprise Value, which is the total value of a company's equity and debt.
• EV = Market Capitalization + Total Debt - Cash and Cash Equivalents

• It is used to determine the total value of a company, including its debt

• EV/EBITDA is a common valuation metric that compares a company's EV to its EBITDA

• EV/Sales is another common valuation metric that compares a company's EV to its annual sales

• EV can be used to comp...read more
Answered by AI
Add your answer
Q2. Format of income statement
Ans. 
The income statement shows a company's revenues and expenses over a specific period of time.
• The income statement is also known as the profit and loss statement.

• It includes revenues, cost of goods sold, gross profit, operating expenses, and net income.

• Revenues are the money a company earns from selling its products or services.

• Cost of goods sold is the cost of producing or purchasing the products or services sold.

• Gross ...read more
Answered by AI
Add your answer

Basic aptitude+logical reasoning test with a duration of1 hr

Q1. Guesstimate on how many red cars are there in the city you are staying currently?
Add your answer
Q2. Tell me in detail about the projects you have done?
Add your answer

Q1. Basic introduction
Add your answer

Q1. Job related questions
Add your answer