Fragma Data Systems Interview Questions, Process, and Tips for Freshers

Q1. Self introduction
Add your answer
Q2. Windows function and how you used
Ans. 
Window functions are used to perform calculations across a set of table rows that are related to the current row.
• Window functions are used in SQL to perform calculations on a specific subset of rows related to the current row.

• They are often used with aggregate functions like SUM, AVG, and COUNT to calculate running totals, moving averages, and rankings.

• Examples of window functions include ROW_NUMBER(), RANK(), LEAD(),
Answered by AI
Add your answer
Q3. Sql Coding questions. Window functions with joins.
Add your answer
Q4. Pyspark code for how you connect the data to ADLS with doing partition
Ans. 
Use PySpark code to connect data to ADLS with partitioning
• Use SparkSession to create a Spark application

• Set the configuration for ADLS storage account and container

• Read data from ADLS using Spark DataFrame API

• Partition the data based on a specific column while writing back to ADLS
Answered by AI
Add your answer

1.ETL Pipeline
2.PySpark Code
3.SQL

Q1. 1.sql easy question 2.pyspark easy code as I was fesher
Add your answer
Q2. 1.query related to group by
Add your answer

Q1. 1.One tricky sql query 2.What is sqoop?sqoop performs which job - map or reduce?
Add your answer

I was given a pdf file containing 3 Problem statements along with the output for which I had to write SQL queries.

Q1. Theoretical Questions related to SQL were asked like types of join, the difference between union and join, related to my project, and some behavioral questions.
Add your answer
Q2. What are different types of Joins?
Ans. 
Joins are used to combine data from two or more tables based on a related column between them.
• Inner Join: returns only the matching rows from both tables

• Left Join: returns all rows from the left table and matching rows from the right table

• Right Join: returns all rows from the right table and matching rows from the left table

• Full Outer Join: returns all rows from both tables

• Cross Join: returns the Cartesian product of b
Answered by AI
Add your answer
Q3. What is the Difference between Union and Joins
Ans. 
Joins combine rows from two or more tables based on a related column, while unions combine rows from two or more tables with the same structure.
• Joins are used to combine data from different tables based on a related column

• Unions are used to combine data from tables with the same structure

• Joins can be inner, left, right, or full, while unions are always a combination of all rows

• Joins can have multiple conditions, while ...read more
Answered by AI
Add your answer

Q1. Scenario-based questions on SQL
Add your answer

Q1. Questions related to me like what my parents do etc. and their company profile.
Add your answer