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.
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.
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.
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.
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.
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.
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.
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.
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.
**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):**
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.
**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):**
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.
**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):**
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.
**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):**
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.
**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):**
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.
**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.
**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.
**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.
**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.
**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.
**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.
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.
**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.
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.B.C.D.
A published solution is not available for this question yet.
**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.
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.
**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.
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.
**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.
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.
**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):**
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.
**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):**
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.
**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):**
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.
**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):**
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.
**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):**
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.