Tekion Application Support Engineer 2 Interview Questions and Answers

Auto complete Input Search box with Dropdown

Q1. Machine coding round for SQL
Add your answer

Q1. In memory sql db
Ans. 
In-memory SQL databases store data in memory for faster access and processing.
• In-memory databases keep all data in RAM for quicker retrieval compared to disk-based databases.

• Examples include SQLite in-memory database and Redis.

• They are commonly used for caching, real-time analytics, and temporary data storage.
Answered by AI
Add your answer

Asked to do coding for RDBMS using any programing language

Q1. Machine coding: Design in-memory document search
Add your answer

Q1. HLD: Design a ad-click aggregation service
Ans. 
Design an ad-click aggregation service for tracking and analyzing ad clicks.
• Use a distributed system to handle high volume of ad click data

• Implement real-time processing for immediate insights on ad performance

• Utilize a database to store aggregated ad click data for reporting and analysis
Answered by AI
Add your answer

Q1. Design a in-memory cache
Ans. 
Design a high-performance in-memory cache system for storing and retrieving data efficiently.
• Use a hash table or a key-value store to store data in memory

• Implement caching strategies like LRU (Least Recently Used) or LFU (Least Frequently Used) to manage cache eviction

• Consider using a distributed cache for scalability and fault tolerance

• Optimize cache size and expiration policies based on the application's data access
Answered by AI
Add your answer

Q1. Rating Service Low level design
Add your answer

It was an online assessment. Some coding questions. Some cs fundamental mcqs. SQL query, Rest Api question.

An assignment to create a game using nodejs/ go lang/ java.

Q1. Discussion related to Assignment. Told some changes and told to add some more functionalities.
Add your answer
Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
Add your answer