Reliance Retail Sales Interview Questions and Answers

Q1. Why would you like to work with us ?
Ans. I am eagerly looking forward to serve a world class organisation with my knowledge and skills, and to learn and grow with the organisation, by upgrading my self to increase productivity for myself and the organisation.
Answered Anonymously
Add your answer
Q2. Tell me something about the company?
Add your answer

Q1. Wxaplinnyour project
Add your answer
Q2. How would you build a pipeline to connect http source and bring data in adls
Ans. 
Build a pipeline to connect http source and bring data in adls
• Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source

• Transform the data as needed using tools like Apache Spark or Azure Databricks

• Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
Answered by AI
Add your answer
Q3. Dimension and fact tabel difference
Ans. 
Dimension tables store descriptive attributes while fact tables store quantitative data.
• Dimension tables contain attributes that describe the business entities, such as customer, product, or time.

• Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.

• Dimension tables are denormalized and have a one-to-many relationship with fact tables.

• Fact table...read more
Answered by AI
Add your answer
Q4. Write slq query to get employee having 2manager
Ans. 
Use a self join to find employees with 2 managers in SQL query.
• Use a self join on the employee table to join the table with itself.

• Count the number of distinct managers for each employee.

• Filter the results to only include employees with 2 managers.
Answered by AI
Add your answer
Q5. Get second highest salary usingSQL
Add your answer

Sql questions and python logics

Q1. About sql and python
Add your answer
Q2. Hadoop and kinit
Add your answer

Basic details of Pyspark optimization question

Q1. Job optimization is pyspark
Add your answer

Q1. Round 1 was with manager, he asked questions about current project and some questions based on spark.
Add your answer
Q2. Lazy Evaluation, configuration for running a spark jobs
Add your answer

Q1. This is where the nightmare started, 1 scenario based coding questions and 3 sql questions were asked. The questions were of hacker rank level, its not that I couldn't solve those but for a guy who have wo...read more
Add your answer
Q2. 1. Design and code a scheduler for allocating meeting rooms for the given input of room counts and timestamps: Input : No of rooms : 2 Time and dutation: 12pm 30 min Output: yes. Everytime th...read more
Ans. 
Design and code a scheduler for allocating meeting rooms based on input of room counts and timestamps.
• Create a table with columns for room number, start time, and end time

• Use SQL queries to check for available slots and allocate rooms

• Consider edge cases such as overlapping meetings and room availability

• Use a loop to continuously check for available slots and allocate rooms

• Implement error handling for invalid input
Answered by AI
Add your answer