Stats Perform Support Engineer Interview Questions and Answers

Hackerrank test on dsa and some mcq questions

Machine coding round on some Cricbuzz functionality

Q1. Techinical interview on machine coding
Add your answer

Initially first was HackerRank assessment then first round was of DSA. Asked 3 questions
1) Find max sum of substrings of length k
2) Find whether 2 strings are anagram or not
3) There is a Array and Find the max sum of subsequence. If you take element index at 1 in array then you are not suppose to take element index at 0 & 2 -> I solved it with Recursion then applied DP.

Cracked Round 1.

This was a machine coding round where I have to create 3 API of Cricbuzz feature.
1) Post API which will take Match Details and we have to create points table like we have in IPL
2) Get API to fetch Point table based on total Points
3) Get API to fetch last 3 matchs of a team and there results.

This was Code review round. Interviewer first asked about my project in my current company and multiple questions like hiw many team member and how many juniors u are handling. Then we move to code review and he checked extensibility of code by asking if I have to add year wise point table then How will you add then If there are many Tournament then how you will implement.

Q1. What is remote backend in terraform
Ans. 
Remote backend in Terraform is a method of storing Terraform state files in a remote location instead of locally.
• Remote backend allows for collaboration and sharing of infrastructure state files among team members.

• It provides a centralized location for storing and managing Terraform state files, reducing the risk of file corruption or loss.

• Popular remote backends include Amazon S3, Azure Blob Storage, and HashiCorp Ter...read more
Answered by AI
Add your answer
Q2. How to lock statefile
Ans. 
Statefile can be locked using state locking mechanisms to prevent concurrent access and ensure consistency.
• Use state locking mechanisms provided by the infrastructure as code tool being used (e.g. Terraform state locking)

• Implement locking strategies such as DynamoDB locking, Consul locking, or file-based locking

• Ensure only one user or process can modify the statefile at a time to prevent conflicts
Answered by AI
Add your answer

Q1. Introducing your self
Add your answer
Q2. Aptitude test
Add your answer

Q1. Say about yourself
Add your answer

HACKERANK CODING TEST

Q1. BASIC STUFF ABOUT DBMS, OOPS, SYSTEM DESIGN
Add your answer

MACHINE LEARNING - HAD TO DESIGN ONE OF CRICBUZZ FEATURE