BitGo Senior Software Engineer Interview Questions and Answers

Q1. What are TMG events?
Ans. 
TMG events refer to events related to Threat Management Gateway, a Microsoft network security product.
• TMG events are generated by Threat Management Gateway (TMG), a network security product developed by Microsoft.

• These events provide information about network traffic, security threats, and system health.

• Examples of TMG events include firewall rule violations, malware detection, and system errors.
Answered by AI
Add your answer
Q2. Events in interactive report?
Ans. 
Events in interactive report refer to user interactions like clicking, hovering, or scrolling.
• Events can trigger actions or functions in the report.

• Common events include click, hover, scroll, keypress, etc.

• Events can be used to enhance user experience and interactivity.

• Examples: Clicking on a data point to view more details, hovering over a chart to see tooltips.
Answered by AI
Add your answer
Q3. Difference between RFC and BAPI
Ans. 
RFC is a protocol for requesting services from a server, while BAPI is a specific type of RFC used in SAP systems.
• RFC stands for Remote Function Call and is a protocol used to request services from a server over a network.

• BAPI stands for Business Application Programming Interface and is a specific type of RFC used in SAP systems for integrating external applications with SAP.

• RFC can be used in various systems and techn...read more
Answered by AI
Add your answer
Q4. What is ABAP on HANA
Ans. 
ABAP on HANA is a programming language that combines ABAP with the in-memory database technology of SAP HANA.
• ABAP on HANA allows developers to leverage the speed and power of SAP HANA for their ABAP-based applications.

• It enables real-time analytics, predictive modeling, and faster data processing.

• Developers can use ABAP on HANA to optimize existing ABAP code for better performance.

• It provides a seamless integration bet...read more
Answered by AI
Add your answer
Q5. Limitations of CDs Views
Ans. 
CDs Views have limitations in terms of performance and scalability.
• Limited support for complex queries and joins

• Performance degradation with large datasets

• Scalability issues when handling high volume of data

• Difficulty in maintaining and updating views as database schema changes
Answered by AI
Add your answer

Related to Dp and other questions is related to array like reverse and find duplicate in an array, String matching Questions

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Q1. Longest Palindromic Substring
Ans. 
Find the longest palindromic substring in a given string.
• Use dynamic programming to check if substrings are palindromes.

• Start with single characters as potential palindromes and expand outwards.

• Keep track of the longest palindrome found so far.
Answered by AI
Add your answer
Q2. Find the Kth largest integer in the Array
Ans. 
Find the Kth largest integer in the Array
• Sort the array in descending order

• Return the element at index K-1
Answered by AI
Add your answer

Q1. Design youtube live streaming
Ans. 
Design a system for live streaming on YouTube platform.
• Use RTMP protocol for streaming live video to YouTube servers

• Implement a live chat feature for viewers to interact with the streamer

• Include options for viewers to like, share, and subscribe during the live stream

• Provide analytics for streamers to track viewership and engagement

• Ensure scalability to handle high traffic during popular live streams
Answered by AI
Add your answer