XimKart Production Analyst Interview Questions and Answers

Q1. Which is more efficient: Common Table Expressions (CTEs) or Subqueries?
Ans. 
CTEs are generally more efficient than subqueries due to their ability to be reused and optimized by the query planner.
• CTEs can be referenced multiple times within a query, reducing the need to repeat the same subquery logic.

• CTEs can improve query readability and maintainability by breaking down complex logic into smaller, more manageable parts.

• CTEs can be optimized by the query planner, potentially leading to better p
Answered by AI
Add your answer
Q2. What is the difference between relational and non-relational databases, and can you provide examples of each?
Ans. 
Relational databases store data in tables with predefined relationships, while non-relational databases store data in flexible, schema-less formats.
• Relational databases use structured query language (SQL) for querying data

• Non-relational databases are more flexible and can store data in various formats like key-value pairs, documents, graphs, etc.

• Examples of relational databases include MySQL, Oracle, and SQL Server

• Exam...read more
Answered by AI
Add your answer
Q3. What is the method to obtain a running total per month for a given sales data set, and how can the three-month moving average of total sales be calculated?
Ans. 
Running total per month can be obtained by summing the sales data for each month. Three-month moving average can be calculated by averaging the total sales for the current month and the two previous months.
• To obtain a running total per month, sum the sales data for each month.

• To calculate the three-month moving average of total sales, average the total sales for the current month and the two previous months.

• Example: Ru...read more
Answered by AI
Add your answer

A client is experiencing frequent stockouts and resulting revenue loss. How would you conduct a root cause analysis to identify the bottlenecks in the supply chain? What model would you choose to create a predictive sales model and enhance the process of calculating reorder points to avoid stockouts?