Glorious Insight Interview Questions and Answers

2 medium hard level questions. We just have to code and explain it. Platform doesn't have compilers.

Q1. Given an array Reverse array
Ans. 
Reverse array of strings
• Iterate through the array and swap elements from start to end

• Use two pointers, one at the beginning and one at the end, and swap elements until they meet
Answered by AI
Add your answer
Q2. Giaven a string Reverse string
Ans. 
Reverse a given string
• Use built-in functions like reverse() or loop through the string in reverse order

• Create a new string and append characters from the original string in reverse order

• Convert the string to an array of characters, reverse the array, and then join it back into a string
Answered by AI
Add your answer
Q3. Given array find sum of all elements
Ans. 
Calculate sum of all elements in a given array of strings
• Iterate through the array and convert each element to integer before adding to sum

• Handle edge cases like empty array or non-numeric elements

• Return the final sum after iterating through all elements
Answered by AI
Add your answer

Good Knowledge of DSA is required

Q1. SQL and domain - Use case scenarios and real time examples
Ans. 
SQL is used in various domains for data analysis and reporting. Use cases include financial analysis, inventory management, and customer relationship management.
• Financial analysis - using SQL to analyze revenue, expenses, and profitability

• Inventory management - tracking stock levels, orders, and shipments

• Customer relationship management - analyzing customer data, preferences, and interactions
Answered by AI
Add your answer
Q2. SQL questions and domain related questions.
Add your answer

Test of SQL, Tableau and other skills based on your resume on Skillate

Q1. SQL and other skills technical questions
Add your answer

Q1. Manager round / 2nd technical round
Add your answer

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Q1. Simple questions on SQL were asked.
Add your answer

Q1. What is pivot table in Excel?
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

• You can easily rearrange the layout of the data to view it from different perspectives.

• Pivot tables can perform functions like sum, average, count, and more on the data.

• They are useful for creating reports...read more
Answered by AI
Add your answer
Q2. What is 'Data Validation' in Excel?
Ans. 
Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.
• Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

• Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

• Data ...read more
Answered by AI
Add your answer
Q3. What is the order of execution of an SQL query?
Ans. 
The order of execution of an SQL query involves multiple steps to retrieve data from a database.
• 1. Parsing: The SQL query is first parsed to check for syntax errors.

• 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

• 3. Compilation: The optimized query is compiled into an executable form.

• 4. Execution: The compiled query is executed by the database engine t...read more
Answered by AI
Add your answer
Q4. What is the difference between Tree Map and Heatmap in Tableau?
Ans. 
Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.
• Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

• Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

• Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...read more
Answered by AI
Add your answer
Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
Ans. 
Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.
• Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

• Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

• Extract Data can improve per...read more
Answered by AI
Add your answer

Q1. SQL Questions on Aggregations
Add your answer