ZoomRx Data Associate Interview Questions and Answers

HANA is an in-memory database and application development platform developed by SAP.

• HANA stands for High-Performance Analytic Appliance.

• It allows real-time processing of large amounts of data.

• It can be used for data warehousing, analytics, and application development.

• HANA is used by businesses to gain insights from their data and make better decisions.

• Examples of companies using HANA include Coca-Cola, Nestle, and Merc

Answers to questions related to Docker, AWS firewall types, and ELK Stack

• To create a Docker file, start with a base image and add necessary dependencies and configurations

• AWS has two types of firewalls: Network ACLs and Security Groups

• ELK Stack is a combination of Elasticsearch, Logstash, and Kibana used for log management and analysis

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