Systems Technology Group Inc. Software Engineer Trainee Interview Questions and Answers

Q1. Closures, hostings, react js, redux, hooks basic
Add your answer
Q2. Html5, css3, basic javascript stuff
Add your answer

60mintues DSA level coding exam

Q1. React js, ReactHooks, es67 features, bootstrap
Add your answer

Q1. What is HashMap?
Ans. 
HashMap is a data structure that stores key-value pairs and provides constant time complexity for basic operations.
• HashMap allows quick access to values based on their keys

• Keys must be unique and values can be duplicated

• HashMap is not thread-safe and requires synchronization for concurrent access

• Java's HashMap implementation uses hashing to distribute keys across buckets
Answered by AI
Add your answer
Q2. It’s a collection framework.
Add your answer

Q1. How to tune synapse tables
Ans. 
Synapse tables can be tuned by optimizing query performance and adjusting table properties.
• Identify frequently used queries and optimize them for better performance

• Adjust table properties such as partitioning, indexing, and compression

• Regularly monitor and analyze table performance to identify areas for improvement

• Consider using caching mechanisms to reduce query times

• Collaborate with database administrators and other
Answered by AI
Add your answer
Q2. How to tune slow reports
Ans. 
Slow reports can be tuned by optimizing queries, indexing tables, and reducing data retrieval.
• Identify the slowest queries and optimize them

• Index the tables to improve query performance

• Reduce the amount of data retrieved by filtering or aggregating

• Consider caching frequently accessed data

• Use query profiling tools to identify bottlenecks

• Upgrade hardware or database software if necessary
Answered by AI
Add your answer