ZS Associate Engineer Interview Questions, Process, and Tips

Sql questions and mcq

Q1. Sql window functions
Add your answer
Q2. Sql theory
Add your answer

Q1. What is Spark What is hadoop
Ans. 
Spark is a fast and general-purpose cluster computing system.
• Spark is designed for speed and ease of use in data processing.

• It can run programs up to 100x faster than Hadoop MapReduce.

• Spark provides high-level APIs in Java, Scala, Python, and R.

• It supports various workloads such as batch processing, interactive queries, streaming analytics, and machine learning.

• Spark can be used standalone, on Mesos, or on Hadoop YARN
Answered by AI
Add your answer
Q2. What is hive in big data
Ans. 
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
• Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop

• It allows users to write complex queries to analyze and process data

• Hive organizes data into tables, partitions, and buckets for efficient querying

• It is commonly used for data warehousing, data analysis, and da
Answered by AI
Add your answer
Q3. Which file format is best
Ans. 
There is no one-size-fits-all answer to which file format is best, as it depends on the specific use case and requirements.
• Consider the type of data being stored or transmitted (e.g. text, images, videos, etc.)

• Take into account compatibility with software and devices that will be used to access the files

• Evaluate factors such as file size, compression, and quality requirements

• Common file formats include PDF for document...read more
Answered by AI
Add your answer

Q1. How will you design ingestion pipeline
Ans. 
Designing ingestion pipeline involves defining data sources, data processing steps, data storage, and data delivery mechanisms.
• Identify data sources such as databases, APIs, files, etc.

• Define data processing steps like data extraction, transformation, and loading (ETL).

• Choose appropriate data storage solutions like databases, data lakes, or data warehouses.

• Implement data delivery mechanisms for downstream applications ...read more
Answered by AI
Add your answer