Equity Data Science Senior Data Engineer Interview Questions and Answers for Experienced

Limitations of AWS Lambda service

• Limited execution time (15 minutes maximum)

• Limited memory allocation (up to 3GB)

• Cold start latency can impact performance

• Limited support for long-running processes

• Difficulty in debugging and monitoring

Parallel data processing using AWS services involves distributing data processing tasks across multiple resources for faster and more efficient processing.

• Use AWS Glue for ETL (Extract, Transform, Load) tasks in parallel

• Leverage AWS EMR (Elastic MapReduce) for processing large amounts of data in parallel using Hadoop or Spark

• Utilize AWS Lambda for serverless parallel processing of small tasks

• Implement AWS Batch for par...read more

Snowflake is a cloud-based data warehousing platform that allows users to store and analyze large amounts of data.

• Snowflake is a fully managed service that works on a pay-as-you-go model

• It separates storage and compute resources, allowing users to scale each independently

• Snowflake supports SQL queries and has built-in support for semi-structured data like JSON and Avro

Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

• Window functions are used to calculate values based on a set of rows related to the current row

• They can be used with aggregate functions like SUM, AVG, COUNT, etc.

• Common window functions include ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, etc.