Quiz Space

Tools in Data Science · End Term · 31 Aug 2025 · May 2025 term · Set QIA3

Question 5: For a MySQL database storing e-commerce analytics with co…

Question 5

+2 marksOne correct option

For a MySQL database storing e-commerce analytics with complex joins and time-based queries, which indexing approach optimizes query performance?

  1. A

    Single primary key index per table

  2. B

    Composite indexes on frequently joined columns, covering indexes for common queries, and partitioning by date ranges

  3. C

    Unique indexes on all columns

  4. D

    No indexes to avoid write overhead

Show answer

Correct answer

  • B

    Composite indexes on frequently joined columns, covering indexes for common queries, and partitioning by date ranges

See the whole paperTake it as a mock test

Question 5 of 34 in the IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 31 Aug 2025, in the May 2025 term (IIT M IMPROVEMENT AN EXAM QIA3 31 Aug 2025). It carries 2 marks.

More questions from this paper

  1. Q1In a data science team using Git with feature branches, what is the recommended approach for integrating experimental a…
  2. Q2A retail analyst wants to find the total sales per store from a Pandas DataFrame df with columns store_id and sales_amo…
  3. Q3A team is troubleshooting why a page loads slowly due to an API call taking a long time. Which Chrome DevTools tab shou…
  4. Q4When standardizing inconsistent date formats in a dataset using OpenRefine, which\ transformation approach is most effe…
  5. Q6When processing a streaming data source that generates CSV files every minute, which approach handles the data most eff…
  6. Q7When working with uv in a team environment, which approach ensures reproducible dependency management across different …
  7. Q8For analyzing urban traffic patterns using GPS coordinate data, which combination of Python libraries provides the most…
  8. Q9For a web scraper that encounters 429 (Too Many Requests) status codes, which response strategy demonstrates ethical be…
  9. Q10A data scientist accidentally committed sensitive credentials to a Git repository. Which sequence of commands safely re…
  10. Q11For analyzing a massive time-series dataset that exceeds available RAM, which pandas strategy optimizes memory usage du…
  11. Q12For a machine learning API serving models with inconsistent response times, which monitoring strategy provides the most…
  12. Q13When designing prompts for a clinical AI assistant, which approach best balances medical accuracy with regulatory compl…
  13. Q14Which factors most significantly impact computational costs when processing large-scale clinical datasets with LLMs?(Se…
  14. Q15Which prompt engineering approach generates the most clinically valuable insights for patient care optimization?
  15. Q16When a critical defect pattern is identified requiring immediate production line adjustment, which Git workflow ensures…
  16. Q17Quality engineers need to analyze sensor data to identify equipment performance degradation patterns. Which command-lin…
  17. Q18For deploying the quality control system across geographically distributed manufacturing plants with strict latency and…
  18. Q19When detecting defects in real-time during high-speed production, which algorithmic approach best balances accuracy wit…
  19. Q20The system uses GPS coordinates to optimize supply chain logistics between plants. What is the computational advantage …
  20. Q21Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  21. Q22Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  22. Q23Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  23. Q24Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  24. Q25Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  25. Q26Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  26. Q27Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  27. Q28Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  28. Q29Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  29. Q30Scenario 3: Gaming Platform User Behavior Analysis\ You're analyzing server logs from a multiplayer gaming platform dur…
  30. Q31What is the primary advantage of multi-modal RAG systems for supply chain management compared to traditional ERP system…
  31. Q32Which system prompt design best supports strategic supply chain decision-making across multiple stakeholders?
  32. Q33A supply chain manager asks: "Given current semiconductor shortages, rising fuel costs, and new sustainability regulati…
  33. Q34Which processing sequence correctly describes the supply chain RAG system's comprehensive optimization workflow?