Cedar Management Consulting Marketing Interview Questions and Answers

Q1. What is spark,explain its ecosystem
Add your answer
Q2. What are transformations, and how many types of transformations exist?
Add your answer
Q3. Explain about spark job process and its planning
Add your answer
Q4. What are the concepts of coalesce and repartition in data processing?
Add your answer
Q5. Explain about oom and driverhead memory
Add your answer
Q6. What is data skewness
Add your answer

Q1. Sql order of execution
Ans. 
SQL order of execution determines the sequence in which different clauses are processed in a query.
• SQL query is parsed and validated first

• Next, the query optimizer creates an execution plan

• Execution plan includes steps like table scans, index scans, joins, etc.

• Finally, the query is executed and results are returned
Answered by AI
Add your answer
Q2. Sql question on finding highest salary for each employee where employees and department table are given in each department.
Add your answer

Some multiple choice, 2 sql and 2 python questions were asked

Q1. Tell me about you project
Ans. 
Developed a real-time data processing system for analyzing customer behavior
• Used Apache Kafka for streaming data ingestion

• Implemented data pipelines using Apache Spark for processing and analysis

• Utilized Elasticsearch for storing and querying large volumes of data

• Developed custom machine learning models for predictive analytics
Answered by AI
Add your answer
Q2. Optimising technique that you have used
Ans. 
I have used partitioning and indexing to optimize query performance.
• Implemented partitioning on large tables to improve query performance by limiting the data scanned

• Created indexes on frequently queried columns to speed up data retrieval

• Utilized clustering keys to physically organize data on disk for faster access
Answered by AI
Add your answer

Q1. Window partition question was asked
Add your answer
Q2. Project related question
Add your answer

Q1. Project related discussions
Add your answer
Q2. Meduim level SQl and DSA
Add your answer

Q1. This was data modelling round
Add your answer
Q2. Design a uber data model
Ans. 
Uber data model design for efficient storage and retrieval of ride-related information.
• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance
Answered by AI
Add your answer

Q1. Project explaining
Add your answer
Q2. Write code to generate csv file with note pad data
Ans. 
Code to generate a CSV file with notepad data
• Open a text file and read the data

• Parse the data and write it to a CSV file

• Use libraries like pandas in Python for easier CSV handling
Answered by AI
Add your answer

Maxium sub string and reverse a string

Q1. Data warehouse concepts
Add your answer

Round 1 was online Test where one basic coding question was there and few aptitiude , verbal ability and python based question.

Q1. What is Data WareHouse..?
Ans. 
A Data Warehouse is a centralized repository that stores integrated data from multiple sources for analysis and reporting.
• Data Warehouses are designed for query and analysis rather than transaction processing.

• They often contain historical data and are used for decision-making purposes.

• Data Warehouses typically use a dimensional model with facts and dimensions.

• Examples of Data Warehouse tools include Amazon Redshift, Sn
Answered by AI
Add your answer
Q2. Nested Queries in Bigquery..?
Ans. 
Nested queries in BigQuery allow for querying data from within another query, enabling complex data analysis.
• Nested queries are queries that are embedded within another query

• They can be used to perform subqueries to filter, aggregate, or manipulate data

• Nested queries can be used in SELECT, FROM, WHERE, and HAVING clauses
Answered by AI
Add your answer