Open Financial Technologies Private Limited Data Analyst Interview Questions and Answers

MongoDB database algorithms are used for efficient data storage, retrieval, and processing.

• MongoDB uses various algorithms for indexing, sharding, and aggregation.

• Indexing algorithms include B-tree, hash, and text search indexes.

• Sharding algorithms include range-based, hash-based, and zone-based sharding.

• Aggregation algorithms include map-reduce and aggregation pipeline.

• MongoDB also uses algorithms for query optimizati

Aadhaar card is a unique identification card issued by the Indian government to residents of India.

• Aadhaar card is a 12-digit unique identification number issued by the Unique Identification Authority of India (UIDAI).

• It serves as proof of identity and address for Indian residents.

• Aadhaar card contains biometric and demographic information of the cardholder, including fingerprints and iris scans.

• It is used for various ...read more

Window functions like lag and lead are used to analyze data over a specific range or window.

• Lag function can be used to calculate the difference between current and previous values in a time series data.

• Lead function can be used to calculate the difference between current and future values in a time series data.

• Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.

• Fo...read more