AGS Health Softwaretest Engineer Interview Questions and Answers

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

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'])

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

PV ratio is the ratio of contribution to sales. Accrual expenses are recognized but not yet paid, while prepaid expenses are paid but not yet recognized.

• PV ratio is calculated by dividing contribution by sales.

• It helps in determining the break-even point and the impact of changes in sales volume on profit.

• Accrual expenses are expenses that have been incurred but not yet paid, such as salaries or interest.

• Prepaid expens...read more