Quiz Space

Tools in Data Science · End Term · 21 Dec 2025 · September 2025 term

Question 9: When joining datasets from different time zones, you disc…

Question 9

+1 markOne correct option

When joining datasets from different time zones, you discover that some timestamps lack timezone information. What is the safest approach?

  1. A

    Assume all missing timestamps are in UTC for simplicity

  2. B

    Infer timezone from metadata or location, document assumptions, and flag inferred values

  3. C

    Reject any records that do not have explicit timezone information

  4. D

    The code fails because the data contains timestamps in a non-UTC time zone that pandas cannot parse.

Show answer

Correct answer

  • B

    Infer timezone from metadata or location, document assumptions, and flag inferred values

See the whole paperTake it as a mock test

Question 9 of 36 in the IIT Madras BS Tools in Data Science (Tools in Data Science (TDS)) End Term paper sat on 21 Dec 2025, in the September 2025 term (Tools In Data Science 18 Dec 25). It carries 1 mark.

More questions from this paper

  1. Q1Which data serialization format is most efficient for storing large numeric arrays with minimal overhead?
  2. Q2In Git, which command shows the differences between your working directory and the last commit?
  3. Q3What does HTTP status code 429 indicate?
  4. Q4Which Python library is primarily designed for exploratory data analysis and statistical visualization?
  5. Q5What is the main purpose of using environment variables in production systems?
  6. Q6When validating incoming data from external APIs, which validation strategy prevents downstream pipeline failures most …
  7. Q7You are building a daily ETL pipeline that processes customer orders. Orders can arrive late or be updated. Which desig…
  8. Q8Your analytics dashboard queries a large dataset that updates hourly but is queried every few seconds by users. Which c…
  9. Q10You maintain a data pipeline that transforms raw logs into analytics tables. The transformation logic changes frequentl…
  10. Q11When aggregating financial transaction data across multiple currencies, why is it important to store both the original …
  11. Q12Your team builds a recommendation system that suggests products to users. After deployment, you notice that recommendat…
  12. Q13Your data pipeline uses a third-party library that has known security vulnerabilities in older versions. The latest ver…
  13. Q14For ensuring long-term reproducibility of data analysis notebooks that depend on external data sources and multiple lib…
  14. Q15When implementing data lineage tracking for a complex pipeline with multiple data sources, transformations, and outputs…
  15. Q16Your pipeline processes personally identifiable information (PII). A privacy audit requires you to implement data minim…
  16. Q17Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  17. Q18Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  18. Q19Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  19. Q20Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  20. Q21Scenario 1: Restaurant Review Data Analysis\ Context\ A food delivery platform wants to analyze restaurant reviews to i…
  21. Q22After making changes to your code, what is the correct sequence to save your work and upload it to GitHub?
  22. Q23Two team members both modify the same line in analysis.py on different branches. When the second person tries to merge …
  23. Q24Before pushing your changes, you want to make sure your branch has the latest updates from the main branch. Which comma…
  24. Q25What is the main purpose of creating a pull request (PR) instead of directly merging your branch into main?
  25. Q26When starting work on a new feature, what is the correct Git command sequence to create and switch to a new branch call…
  26. Q27Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  27. Q28Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  28. Q29Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  29. Q30Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  30. Q31Scenario 3 : Deploying a Data Dashboard with Docker\ Context\ A team built a Python dashboard using Streamlit that visu…
  31. Q32Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  32. Q33Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  33. Q34Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  34. Q35Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…
  35. Q36Scenario 4 : OpenRefine for Data Cleaning\ Context\ A researcher has a dataset of company names from different sources.…