MauryaHub PYQ Practice

Tools in Data Science · End Term · Sep 2025 · AN

Tools in Data Science · End Term · Sep 2025 AN

← Course papers · Start practice / exam

Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.

0 / 36 published solutions

Question 2 MCQ · 1.0 marks

Which data serialization format is most efficient for storing large numeric arrays with minimal overhead?
A.
XML
B.
Parquet
C.
JSON
D.
Plain text CSV

A published solution is not available for this question yet.

Report a correction for Q2

Question 3 MCQ · 1.0 marks

In Git, which command shows the differences between your working directory and the last commit?
A.
git status
B.
git diff
C.
git log
D.
git show

A published solution is not available for this question yet.

Report a correction for Q3

Question 4 MCQ · 1.0 marks

What does HTTP status code 429 indicate?
A.
Internal server error
B.
Rate limit exceeded
C.
Unauthorized access
D.
Resource not found

A published solution is not available for this question yet.

Report a correction for Q4

Question 5 MCQ · 1.0 marks

Which Python library is primarily designed for exploratory data analysis and statistical visualization?
A.
NumPy
B.
Seaborn
C.
Django
D.
Flask

A published solution is not available for this question yet.

Report a correction for Q5

Question 6 MCQ · 1.0 marks

What is the main purpose of using environment variables in production systems?
A.
To speed up code execution
B.
To store configuration and secrets separately from code
C.
To replace all function parameters
D.
To automatically test applications

A published solution is not available for this question yet.

Report a correction for Q6

Question 7 MCQ · 1.0 marks

When validating incoming data from external APIs, which validation strategy prevents downstream pipeline failures most effectively?
A.
Check only that the data is not empty
B.
Validate data types, required fields, value ranges, and fail fast with clear error messages
C.
Accept all data and let downstream processes handle errors
D.
Log warnings but process all data regardless

A published solution is not available for this question yet.

Report a correction for Q7

Question 8 MCQ · 1.0 marks

You are building a daily ETL pipeline that processes customer orders. Orders can arrive late or be updated. Which design pattern ensures you don't miss late-arriving data while avoiding duplicate processing?
A.
Process only data from the current day and ignore anything older
B.
Use lookback windows with deduplication based on unique order IDs and update timestamps
C.
Reprocess all historical data every day to ensure completeness
D.
Process data as it arrives without tracking what has been processed

A published solution is not available for this question yet.

Report a correction for Q8

Question 9 MCQ · 1.0 marks

Your analytics dashboard queries a large dataset that updates hourly but is queried every few seconds by users. Which caching strategy improves performance while maintaining reasonable freshness?
A.
Never cache and always query the live dataset directly
B.
Cache results with a TTL matching update frequency and invalidate on updates
C.
Cache results permanently without refreshing them for future queries
D.
Disable the dashboard whenever the dataset is updated to prevent queries

A published solution is not available for this question yet.

Report a correction for Q9

Question 10 MCQ · 1.0 marks

When joining datasets from different time zones, you discover that some timestamps lack timezone information. What is the safest approach?
A.
Assume all missing timestamps are in UTC for simplicity
B.
Infer timezone from metadata or location, document assumptions, and flag inferred values
C.
Reject any records that do not have explicit timezone information
D.
The code fails because the data contains timestamps in a non-UTC time zone that pandas cannot parse.

A published solution is not available for this question yet.

Report a correction for Q10

Question 11 MCQ · 1.0 marks

You maintain a data pipeline that transforms raw logs into analytics tables. The transformation logic changes frequently. How should you version and test these transformations?
A.
Keep all transformation logic in a single script and update it directly
B.
Version transformations with git, write unit tests, test on sample data before production
C.
Manually document changes in a shared document
D.
Avoid making changes to prevent breaking existing processes

A published solution is not available for this question yet.

Report a correction for Q11

Question 12 MCQ · 1.0 marks

When aggregating financial transaction data across multiple currencies, why is it important to store both the original currency amount and the exchange rate used for conversion?
A.
It's unnecessary; storing only the converted amount is sufficient
B.
Enables auditing, recalculation with updated rates, and transparency
C.
It wastes storage with no practical benefit
D.
Regulatory requirements mandate it for all data types

A published solution is not available for this question yet.

Report a correction for Q12

Question 13 MCQ · 1.0 marks

Your team builds a recommendation system that suggests products to users. After deployment, you notice that recommendations for certain user segments are significantly worse than others. What is the best systematic approach to diagnose and fix this?
A.
Retrain the model with more data and hope it improves
B.
Analyze performance by segment, identify biases in training data, add segment-specific tests, and validate fixes
C.
Disable recommendations for poorly performing segments
D.
Manually override recommendations for affected users

A published solution is not available for this question yet.

Report a correction for Q13

Question 14 MCQ · 2.0 marks

Your data pipeline uses a third-party library that has known security vulnerabilities in older versions. The latest version includes breaking API changes. What should you do?
A.
Stay on the older vulnerable version to avoid breaking existing code
B.
Assess vulnerability severity, test the new version in staging, and plan migration or patches
C.
Update to the latest version immediately without any testing
D.
Replace the library entirely with custom code regardless of complexity

A published solution is not available for this question yet.

Report a correction for Q14

Question 15 MCQ · 2.0 marks

For ensuring long-term reproducibility of data analysis notebooks that depend on external data sources and multiple libraries, which approach is most comprehensive?
A.
Save only the final notebook with outputs
B.
Use containers, pin dependencies, archive input data, version-control notebooks, and document environment
C.
Share notebooks via email with verbal instructions
D.
Rely on cloud platforms to maintain compatibility

A published solution is not available for this question yet.

Report a correction for Q15

Question 16 MCQ · 2.0 marks

When implementing data lineage tracking for a complex pipeline with multiple data sources, transformations, and outputs, which metadata is most critical to capture?
A.
Capture only the final output location of the pipeline for reference
B.
Capture source IDs, transformation versions, timestamps, data quality metrics, and dependencies
C.
Capture only the names of users who executed the pipeline for auditing
D.
Capture only storage costs and query performance metrics for monitoring

A published solution is not available for this question yet.

Report a correction for Q16

Question 17 MCQ · 2.0 marks

Your pipeline processes personally identifiable information (PII). A privacy audit requires you to implement data minimization. Which strategy best balances utility and privacy?
A.
Encrypt all data and continue processing it without changes
B.
Keep only necessary fields, anonymize or aggregate data, enforce access controls, and document retention
C.
Delete all PII immediately without considering business requirements
D.
Move PII to a separate database while keeping the same access patterns

A published solution is not available for this question yet.

Report a correction for Q17

Question 18 MCQ · 1.0 marks

**Scenario 1: Restaurant Review Data Analysis** **Context** A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps. **Sample Data (restaurants.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
The dataset has some missing values in the review_text column (some customers left ratings but no comment). Before analyzing review text for common words, what should you do?
A.
Ignore missing values and let pandas handle them automatically
B.
Remove rows with missing review text using df.dropna(subset=['review_text'])
C.
Replace all missing review text entries with the word "missing"
D.
Delete the entire review_text column from the dataset

A published solution is not available for this question yet.

Report a correction for Q18

Question 19 MCQ · 1.0 marks

**Scenario 1: Restaurant Review Data Analysis** **Context** A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps. **Sample Data (restaurants.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
To identify the most common words in negative reviews (rating < 3.0), which approach correctly combines filtering and text analysis?
A.
Count all words in all reviews regardless of rating
B.
Filter for low ratings, then extract and count words from the review_text column
C.
Sort reviews by rating and manually read the bottom ones
D.
Use only the rating numbers without looking at text

A published solution is not available for this question yet.

Report a correction for Q19

Question 20 MCQ · 1.0 marks

**Scenario 1: Restaurant Review Data Analysis** **Context** A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps. **Sample Data (restaurants.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
After completing the analysis, which file format is most appropriate for sharing summary results (e.g., average rating by cuisine) with non-technical stakeholders?
A.
Python pickle file (.pkl)
B.
CSV file that can be opened in Excel
C.
JSON with nested structures
D.
Binary database file

A published solution is not available for this question yet.

Report a correction for Q20

Question 21 MCQ · 1.0 marks

**Scenario 1: Restaurant Review Data Analysis** **Context** A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps. **Sample Data (restaurants.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
Which Python library is most commonly used for loading and analyzing tabular CSV data like this restaurant reviews dataset?
A.
requests
B.
pandas
C.
BeautifulSoup
D.
Flask

A published solution is not available for this question yet.

Report a correction for Q21

Question 22 MCQ · 1.0 marks

**Scenario 1: Restaurant Review Data Analysis** **Context** A food delivery platform wants to analyze restaurant reviews to identify trending cuisines and customer satisfaction patterns. They have review data in CSV format with ratings, text comments, and timestamps. **Sample Data (restaurants.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
To find the average rating for each cuisine type (Indian, Italian, Japanese), which pandas operation is most appropriate?
A.
df.sort_values('cuisine')
B.
df.groupby('cuisine')['rating'].mean()
C.
df.filter('cuisine')
D.
df.merge('cuisine', 'rating')

A published solution is not available for this question yet.

Report a correction for Q22

Question 23 MCQ · 1.0 marks

**Scenario 2: Automated Git Workflow for Team Project** **Context** A data science team uses Git for version control on a shared project. Multiple team members work on different features simultaneously. They follow a workflow where everyone works on separate branches and merges into the main branch through pull requests. Current Setup: • **main branch**: Production-ready code • **dev branch**: Development/testing code • **Feature branches**: Individual work (e.g., feature-data-cleaning, feature-visualization) Based on the above data, answer the given subquestions.
After making changes to your code, what is the correct sequence to save your work and upload it to GitHub?
A.
git push → git add → git commit
B.
git commit → git add → git push
C.
git add → git commit → git push
D.
git merge → git push

A published solution is not available for this question yet.

Report a correction for Q23

Question 24 MCQ · 1.0 marks

**Scenario 2: Automated Git Workflow for Team Project** **Context** A data science team uses Git for version control on a shared project. Multiple team members work on different features simultaneously. They follow a workflow where everyone works on separate branches and merges into the main branch through pull requests. Current Setup: • **main branch**: Production-ready code • **dev branch**: Development/testing code • **Feature branches**: Individual work (e.g., feature-data-cleaning, feature-visualization) Based on the above data, answer the given subquestions.
Two team members both modify the same line in analysis.py on different branches. When the second person tries to merge their branch, what will happen?
A.
Git automatically keeps the newer change
B.
Git creates a merge conflict that must be resolved manually by choosing which change to keep
C.
Git deletes both changes
D.
Git randomly picks one change

A published solution is not available for this question yet.

Report a correction for Q24

Question 25 MCQ · 1.0 marks

**Scenario 2: Automated Git Workflow for Team Project** **Context** A data science team uses Git for version control on a shared project. Multiple team members work on different features simultaneously. They follow a workflow where everyone works on separate branches and merges into the main branch through pull requests. Current Setup: • **main branch**: Production-ready code • **dev branch**: Development/testing code • **Feature branches**: Individual work (e.g., feature-data-cleaning, feature-visualization) Based on the above data, answer the given subquestions.
Before pushing your changes, you want to make sure your branch has the latest updates from the main branch. Which command downloads and integrates those updates?
A.
git commit main
B.
git pull origin main (while on your feature branch)
C.
git delete main
D.
git init main

A published solution is not available for this question yet.

Report a correction for Q25

Question 26 MCQ · 1.0 marks

**Scenario 2: Automated Git Workflow for Team Project** **Context** A data science team uses Git for version control on a shared project. Multiple team members work on different features simultaneously. They follow a workflow where everyone works on separate branches and merges into the main branch through pull requests. Current Setup: • **main branch**: Production-ready code • **dev branch**: Development/testing code • **Feature branches**: Individual work (e.g., feature-data-cleaning, feature-visualization) Based on the above data, answer the given subquestions.
What is the main purpose of creating a pull request (PR) instead of directly merging your branch into main?
A.
Pull requests are faster than merging
B.
Pull requests allow team members to review your code, suggest changes, and approve before merging
C.
Pull requests automatically fix bugs
D.
Pull requests are only for documentation

A published solution is not available for this question yet.

Report a correction for Q26

Question 27 MCQ · 1.0 marks

**Scenario 2: Automated Git Workflow for Team Project** **Context** A data science team uses Git for version control on a shared project. Multiple team members work on different features simultaneously. They follow a workflow where everyone works on separate branches and merges into the main branch through pull requests. Current Setup: • **main branch**: Production-ready code • **dev branch**: Development/testing code • **Feature branches**: Individual work (e.g., feature-data-cleaning, feature-visualization) Based on the above data, answer the given subquestions.
When starting work on a new feature, what is the correct Git command sequence to create and switch to a new branch called feature-analysis?
A.
git commit feature-analysis
B.
git branch feature-analysis then git checkout feature-analysis
C.
git push feature-analysis
D.
git merge feature-analysis

A published solution is not available for this question yet.

Report a correction for Q27

Question 28 MCQ · 1.0 marks

**Scenario 3 : Deploying a Data Dashboard with Docker** **Context** A team built a Python dashboard using Streamlit that visualizes sales data. They want to deploy it so anyone can access it via a web browser. They decide to use Docker to package the application with all its dependencies.
Source diagram or notation
Based on the above data, answer the given subquestions.
After building the Docker image, which command correctly runs the container and makes the dashboard accessible on port 8501?
A.
docker build -t dashboard .
B.
docker run -p 8501:8501 dashboard
C.
docker push dashboard
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q28

Question 29 MCQ · 1.0 marks

**Scenario 3 : Deploying a Data Dashboard with Docker** **Context** A team built a Python dashboard using Streamlit that visualizes sales data. They want to deploy it so anyone can access it via a web browser. They decide to use Docker to package the application with all its dependencies.
Source diagram or notation
Based on the above data, answer the given subquestions.
The dashboard application crashes when deployed. Which Docker command shows the application's error messages and logs?
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q29

Question 30 MCQ · 1.0 marks

**Scenario 3 : Deploying a Data Dashboard with Docker** **Context** A team built a Python dashboard using Streamlit that visualizes sales data. They want to deploy it so anyone can access it via a web browser. They decide to use Docker to package the application with all its dependencies.
Source diagram or notation
Based on the above data, answer the given subquestions.
What is the main advantage of using Docker to deploy the dashboard?
A.
Docker makes the code run faster
B.
Docker packages the application with all dependencies in a container, ensuring it runs consistently across different machines
C.
Docker automatically writes code for you
D.
Docker provides free hosting

A published solution is not available for this question yet.

Report a correction for Q30

Question 31 MCQ · 1.0 marks

**Scenario 3 : Deploying a Data Dashboard with Docker** **Context** A team built a Python dashboard using Streamlit that visualizes sales data. They want to deploy it so anyone can access it via a web browser. They decide to use Docker to package the application with all its dependencies.
Source diagram or notation
Based on the above data, answer the given subquestions.
In the Dockerfile, which command specifies which Python packages should be installed in the container?
A.
RUN pip install -r requirements.txt
B.
COPY dashboard.py
C.
EXPOSE 8501
D.
FROM python:3.11

A published solution is not available for this question yet.

Report a correction for Q31

Question 32 MCQ · 1.0 marks

**Scenario 3 : Deploying a Data Dashboard with Docker** **Context** A team built a Python dashboard using Streamlit that visualizes sales data. They want to deploy it so anyone can access it via a web browser. They decide to use Docker to package the application with all its dependencies.
Source diagram or notation
Based on the above data, answer the given subquestions.
The Dockerfile includes the line EXPOSE 8501. What does this do?
A.
Automatically makes the application accessible to anyone on the internet
B.
Documents the listen port; you must still publish it using -p 8501:8501
C.
Closes port 8501 for security
D.
Changes the application code to use port 8501

A published solution is not available for this question yet.

Report a correction for Q32

Question 33 MCQ · 1.0 marks

**Scenario 4 : OpenRefine for Data Cleaning** **Context** A researcher has a dataset of company names from different sources. The same companies are spelled differently across sources, making analysis difficult. **Sample Messy Data (companies.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
You want to standardize all company names to lowercase, then to title case (First Letter Capitalized). Which OpenRefine transformation approach is correct?
A.
Manually retype each company name
B.
Apply transformations value.toLowercase() then value.toTitlecase()
C.
Delete the column and recreate it
D.
Export to Excel and use find-replace

A published solution is not available for this question yet.

Report a correction for Q33

Question 34 MCQ · 1.0 marks

**Scenario 4 : OpenRefine for Data Cleaning** **Context** A researcher has a dataset of company names from different sources. The same companies are spelled differently across sources, making analysis difficult. **Sample Messy Data (companies.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
After standardizing names, you have multiple rows for the same company (multiple revenue entries). What should you do to combine them?
A.
Delete all rows that appear to be duplicates
B.
Use faceting to group names and then aggregate or sum the revenue values
C.
Manually total the revenue values using an external calculator
D.
Leave all duplicated company rows exactly as they currently are

A published solution is not available for this question yet.

Report a correction for Q34

Question 35 MCQ · 1.0 marks

**Scenario 4 : OpenRefine for Data Cleaning** **Context** A researcher has a dataset of company names from different sources. The same companies are spelled differently across sources, making analysis difficult. **Sample Messy Data (companies.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
OpenRefine saves your data cleaning steps as operations. What is the main benefit of this feature?
A.
It automatically cleans new data
B.
You can export the operations as JSON and replay them on similar datasets.
C.
It makes the software run faster
D.
It deletes your original data

A published solution is not available for this question yet.

Report a correction for Q35

Question 36 MCQ · 1.0 marks

**Scenario 4 : OpenRefine for Data Cleaning** **Context** A researcher has a dataset of company names from different sources. The same companies are spelled differently across sources, making analysis difficult. **Sample Messy Data (companies.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
What type of data quality issue does this dataset have?
A.
Missing values
B.
Inconsistent naming and capitalization for the same entities
C.
Wrong and unrelated data types
D.
Too much data

A published solution is not available for this question yet.

Report a correction for Q36

Question 37 MCQ · 1.0 marks

**Scenario 4 : OpenRefine for Data Cleaning** **Context** A researcher has a dataset of company names from different sources. The same companies are spelled differently across sources, making analysis difficult. **Sample Messy Data (companies.csv):**
Source diagram or notation
Based on the above data, answer the given subquestions.
In OpenRefine, which feature automatically groups similar text values like "Microsoft Corp" and "MICROSOFT CORPORATION" so you can merge them?
A.
Filter
B.
Sort
C.
Text clustering
D.
Delete rows

A published solution is not available for this question yet.

Report a correction for Q37