Sparecode Consulting Interview Questions and Answers

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

Q1. DC DC power supply and their details
Add your answer
Q2. Inductor and common mode choke parameters and usage
Add your answer

PEN PAPER round consisting of three coding and c/c++ output based questions.

Q1. OOPS concepts , javascript
Add your answer
Q2. Projects related questions
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Resume , internship related questions
Add your answer

Q1. What is your work experience in gaming
Ans. 
I have 5 years of experience working as a Game Artist in the gaming industry.
• Worked on creating 2D and 3D assets for various game projects

• Collaborated with game designers and developers to ensure visual consistency

• Experience with game engines like Unity and Unreal Engine

• Created concept art, character designs, and environment assets

• Knowledge of animation and visual effects for games
Answered by AI
Add your answer
Q2. What is your salary expectation
Ans. 
My salary expectation is based on industry standards, my experience, and the responsibilities of the role.
• Research industry standards for Game Artists salaries

• Consider my level of experience and skills

• Factor in the responsibilities and requirements of the specific role

• Be open to negotiation based on benefits and other perks offered
Answered by AI
Add your answer

Design a character and Royal symbol (fully rendered in realistic style) and one Mid Pay concept sketch for slot game.

Q1. About yourself and experience
Add your answer
Q2. About assignment related questions
Add your answer
Q3. Some unprofessional questions
Add your answer

There were basic questions asked related to the profile

There were some questions and an ER diagram to create.

Q1. Tell me about yourself
Add your answer
Q2. They started asking about the projects
Add your answer

Q1. Basic Debugging skills
Add your answer

Q1. About the Technical debugging Skills
Add your answer
Q2. 2 hrs of interview - document would be provided and you will have to go through the document and answer the basic task given in the document
Add your answer