Tarangsoft Solutions 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

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. React basic questions
Add your answer
Q2. Javascript and api
Add your answer

Q1. Software relate
Add your answer
Q2. What is diffrent maya and blender
Ans. 
Maya and Blender are both 3D modeling software, but Maya is more commonly used in professional settings while Blender is open-source and free.
• Maya is more commonly used in professional settings due to its advanced features and industry recognition.

• Blender is open-source and free, making it more accessible to beginners and hobbyists.

• Maya has a steeper learning curve compared to Blender.

• Blender has a more active online c...read more
Answered by AI
Add your answer
Q3. Are you know about unity and unreal engin
Add your answer
Q4. Are you use unity
Ans. 
Yes, I use Unity for creating 3D art and animations.
• I use Unity for creating 3D models, animations, and visual effects.

• Unity provides a user-friendly interface and powerful tools for 3D artists.

• I have experience with Unity's lighting and shading features to enhance the visual quality of my work.
Answered by AI
Add your answer
Q5. Are you using unreal engin ?
Ans. 
Yes, I am using Unreal Engine for my 3D projects.
• I use Unreal Engine for creating realistic environments and characters.

• Unreal Engine offers powerful tools for creating interactive experiences.

• I have experience with Unreal Engine's Blueprint visual scripting system.
Answered by AI
Add your answer
Q6. Tell me about your self
Add your answer

Q1. Asked Scenario based question
Add your answer
Q2. Scenario based question asked
Add your answer

Q1. Total experience
Add your answer
Q2. How will you update client on regular basis?
Ans. 
I will update clients through regular progress reports, meetings, emails, and phone calls.
• Provide regular progress reports detailing project status and milestones

• Schedule regular meetings to discuss project updates and address any concerns

• Send frequent emails with updates on project progress and next steps

• Communicate via phone calls to provide immediate updates or address urgent issues
Answered by AI
Add your answer

Question based on dsa

Q1. General questions
Add your answer

Setup a cluster and find the bottleneck of performance.

Q1. Ways to deal with latency in Cassandra
Ans. 
Ways to optimize latency in Cassandra
• Use appropriate data modeling to reduce the number of queries needed

• Optimize queries by using appropriate indexes and clustering keys

• Tune the Cassandra configuration settings for better performance

• Use caching mechanisms like Memcached or Redis to reduce latency

• Consider using partitioning strategies to distribute data evenly across nodes
Answered by AI
Add your answer