MauryaHub PYQ Practice

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

Tools in Data Science · End Term · Jan 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 / 35 published solutions

Question 399 MCQ · 1.0 marks

You have a spreadsheet with values containing leading zeros (e.g., "001234"). What's the most effective way to preserve these zeros during Text-to-Columns?
A.
Save as CSV before applying Text-to-Columns
B.
Format cells as Text before using Text-to-Columns
C.
Change the delimiter to semicolons
D.
Manually change the affected cells back to numbers

A published solution is not available for this question yet.

Report a correction for Q399

Question 400 MCQ · 1.0 marks

What is the correct order of execution in a Python try-except-finally block if no exception occurs?
A.
try → finally
B.
try → except → finally
C.
try only
D.
finally → try

A published solution is not available for this question yet.

Report a correction for Q400

Question 401 MCQ · 1.0 marks

A data scientist needs to count non-null values in each column of a DataFrame. Which pandas method should they use?
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 Q401

Question 402 MCQ · 1.0 marks

What Git command would you use to discard changes in your working directory and revert to the last committed state?
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 Q402

Question 403 MCQ · 1.0 marks

To debug a memory leak in a JavaScript application, which Chrome DevTools panel is most useful?
A.
Network
B.
Application
C.
Memory
D.
Console

A published solution is not available for this question yet.

Report a correction for Q403

Question 404 MCQ · 1.0 marks

A data scientist is analyzing the relationship between advertising spend and sales. Which statistical test would be most appropriate to determine if there's a linear relationship?
A.
Chi-square test
B.
Pearson correlation coefficient
C.
ANOVA
D.
Kolmogorov-Smirnov test

A published solution is not available for this question yet.

Report a correction for Q404

Question 405 MCQ · 1.0 marks

Which OpenRefine feature allows you to track and reapply the same cleaning operations to similar datasets?
A.
Clustering history
B.
Extraction of operations as JSON
C.
Project templates
D.
Snapshot management

A published solution is not available for this question yet.

Report a correction for Q405

Question 406 MCQ · 1.0 marks

A web developer wants to analyze the load time and resources of a webpage. Which Chrome DevTools feature provides comprehensive network request information?
A.
Console tab
B.
Network tab
C.
Elements tab
D.
Sources tab

A published solution is not available for this question yet.

Report a correction for Q406

Question 407 MCQ · 1.0 marks

Which of the following is NOT typically a built-in feature of modern IDEs?
A.
Git integration
B.
Code completion
C.
Automated code review and security scanning
D.
Terminal access

A published solution is not available for this question yet.

Report a correction for Q407

Question 408 MCQ · 1.0 marks

In Kumu, what feature allows you to highlight specific parts of your visualization based on element properties?
A.
Decorators
B.
Focus filters
C.
Clustering algorithms
D.
Color palettes

A published solution is not available for this question yet.

Report a correction for Q408

Question 409 MCQ · 2.0 marks

Which HTTP method is considered safe because it doesn't modify server state?
A.
DELETE
B.
PUT
C.
GET
D.
POST

A published solution is not available for this question yet.

Report a correction for Q409

Question 410 MSQ · 2.0 marks

If a researcher needs to perform advanced spatial analysis and calculate the distance between geometric objects, which library is most appropriate?
A.
Geopandas
B.
Shapely
C.
Matplotlib
D.
Pillow

A published solution is not available for this question yet.

Report a correction for Q410

Question 411 MCQ · 1.0 marks

**Scenario 1:** Aisha is a medical student researching the latest advancements in cancer treatments for her thesis. She decides to use an LLM to help organize her research and generate draft sections. Based on the above data, answer the given subquestions.
Aisha prompts the LLM: "Provide a detailed analysis of immunotherapy developments for cancer treatment." What aspect of the system prompt most significantly impacts how the LLM formulates its response?
A.
The character limit set by the system prompt
B.
The knowledge domain and expertise level that the system prompt instructs the LLM to adopt
C.
The formatting requirements specified in the system prompt
D.
The language model version identified in the system prompt

A published solution is not available for this question yet.

Report a correction for Q411

Question 412 MSQ · 2.0 marks

**Scenario 1:** Aisha is a medical student researching the latest advancements in cancer treatments for her thesis. She decides to use an LLM to help organize her research and generate draft sections. Based on the above data, answer the given subquestions.
When Aisha uses the LLM for her medical research, which of the following statements are TRUE regarding LLM capabilities and limitations?
A.
LLMs can directly access and cite the most recent peer-reviewed medical studies published after their training cutoff
B.
LLMs may generate plausible-sounding but incorrect medical information if not properly prompted
C.
LLMs have real-time access to patient data to provide personalized medical advice
D.
The quality of LLM responses is unaffected by how specific or vague the user's prompt is
E.
LLMs can evaluate the statistical validity of medical research methodologies when properly prompted

A published solution is not available for this question yet.

Report a correction for Q412

Question 413 MCQ · 1.0 marks

**Scenario 1:** Aisha is a medical student researching the latest advancements in cancer treatments for her thesis. She decides to use an LLM to help organize her research and generate draft sections. Based on the above data, answer the given subquestions.
Aisha needs to gather information about a specific cancer treatment approach. Which of these prompts would likely generate the most accurate and useful response?
A.
"Tell me about cancer treatments"
B.
"What is immunotherapy?"
C.
"Summarize the clinical outcomes, mechanism of action, and patient selection criteria for CAR T-cell therapy in treating B-cell lymphomas, citing key studies from 2018-2023 where possible"
D.
"Write a paragraph about new cancer treatments researchers are excited about"

A published solution is not available for this question yet.

Report a correction for Q413

Question 414 MCQ · 1.0 marks

**Scenario 2:** **Hospital Emergency Response to Mass Casualty Incident** Background: A major traffic accident involving multiple vehicles has occurred on a highway near a metropolitan area, resulting in mass casualties. Nearby hospitals must coordinate emergency response efforts to manage the influx of patients, ensure adequate medical supplies, and maintain operational continuity. The Emergency Operations Center (EOC) at the main hospital will oversee coordination between healthcare facilities, ambulance services, and emergency responders. Key locations: ● Main Hospital (EOC): Coordinates response efforts. ● Satellite Clinics: Provide overflow care. ● Accident Site: Initial triage and stabilization. Based on the above data, answer the given subquestions.
During the emergency response, multiple teams are updating patient intake records. Which Git command would a team member use to get the latest updates?
A.
git commit
B.
git checkout
C.
git pull
D.
git add

A published solution is not available for this question yet.

Report a correction for Q414

Question 415 MCQ · 1.0 marks

**Scenario 2:** **Hospital Emergency Response to Mass Casualty Incident** Background: A major traffic accident involving multiple vehicles has occurred on a highway near a metropolitan area, resulting in mass casualties. Nearby hospitals must coordinate emergency response efforts to manage the influx of patients, ensure adequate medical supplies, and maintain operational continuity. The Emergency Operations Center (EOC) at the main hospital will oversee coordination between healthcare facilities, ambulance services, and emergency responders. Key locations: ● Main Hospital (EOC): Coordinates response efforts. ● Satellite Clinics: Provide overflow care. ● Accident Site: Initial triage and stabilization. Based on the above data, answer the given subquestions.
An administrator needs to search through patient records to find all entries related to "Accident Site Triage". Which command would be most useful?
A.
find -name "Accident Site Triage"
B.
grep "Accident Site Triage" patient-records.txt
C.
ls "Accident Site Triage"
D.
cat patient-records.txt

A published solution is not available for this question yet.

Report a correction for Q415

Question 416 MCQ · 1.0 marks

**Scenario 2:** **Hospital Emergency Response to Mass Casualty Incident** Background: A major traffic accident involving multiple vehicles has occurred on a highway near a metropolitan area, resulting in mass casualties. Nearby hospitals must coordinate emergency response efforts to manage the influx of patients, ensure adequate medical supplies, and maintain operational continuity. The Emergency Operations Center (EOC) at the main hospital will oversee coordination between healthcare facilities, ambulance services, and emergency responders. Key locations: ● Main Hospital (EOC): Coordinates response efforts. ● Satellite Clinics: Provide overflow care. ● Accident Site: Initial triage and stabilization. Based on the above data, answer the given subquestions.
In a resource-constrained hospital environment, which deployment method would be MOST appropriate for the patient management system?
A.
Running scripts locally on a single emergency responder's laptop
B.
Distributing Python source code to all emergency personnel
C.
Containerized deployment with Docker for consistent execution across multiple devices
D.
Full cloud migration requiring constant internet connectivity

A published solution is not available for this question yet.

Report a correction for Q416

Question 417 MCQ · 1.0 marks

**Scenario 2:** **Hospital Emergency Response to Mass Casualty Incident** Background: A major traffic accident involving multiple vehicles has occurred on a highway near a metropolitan area, resulting in mass casualties. Nearby hospitals must coordinate emergency response efforts to manage the influx of patients, ensure adequate medical supplies, and maintain operational continuity. The Emergency Operations Center (EOC) at the main hospital will oversee coordination between healthcare facilities, ambulance services, and emergency responders. Key locations: ● Main Hospital (EOC): Coordinates response efforts. ● Satellite Clinics: Provide overflow care. ● Accident Site: Initial triage and stabilization. Based on the above data, answer the given subquestions.
Which computational tool would be MOST APPROPRIATE for optimizing ambulance routes to transport patients efficiently?
A.
Microsoft Excel for manual distance calculations
B.
Google Maps for route visualization
C.
Python libraries like NetworkX or OR-Tools for route optimization
D.
QGIS for static route mapping

A published solution is not available for this question yet.

Report a correction for Q417

Question 418 MCQ · 1.0 marks

**Scenario 2:** **Hospital Emergency Response to Mass Casualty Incident** Background: A major traffic accident involving multiple vehicles has occurred on a highway near a metropolitan area, resulting in mass casualties. Nearby hospitals must coordinate emergency response efforts to manage the influx of patients, ensure adequate medical supplies, and maintain operational continuity. The Emergency Operations Center (EOC) at the main hospital will oversee coordination between healthcare facilities, ambulance services, and emergency responders. Key locations: ● Main Hospital (EOC): Coordinates response efforts. ● Satellite Clinics: Provide overflow care. ● Accident Site: Initial triage and stabilization. Based on the above data, answer the given subquestions.
What is the primary advantage of using the Haversine formula in ambulance route planning?
A.
Calculating exact road distances
B.
Determining travel time under specific conditions
C.
Computing great-circle distances on a spherical Earth
D.
Measuring elevation changes in mountainous terrain

A published solution is not available for this question yet.

Report a correction for Q418

Question 419 MSQ · 2.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Which of the following is a valid log entry based on the provided format?
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 Q419

Question 420 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Which of the following fields are necessary to filter "POST requests made for pages under /images/ from 15:00 to 18:00 on Mondays"?
A.
Time, Request, Method, URL
B.
Time, Method, Status, Size
C.
Time, Method, URL, Referer
D.
Time, Status, URL, Server

A published solution is not available for this question yet.

Report a correction for Q420

Question 421 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Source diagram or notation
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 Q421

Question 422 MCQ · 2.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Which method is best for identifying if a log entry’s timestamp corresponds to a Saturday?
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 Q422

Question 423 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
How would you identify log entries where the time is between 14:00 and 16:59 on Fridays?
A.
Check if 14 <= timestamp.hour < 16
B.
Check if 14 <= timestamp.hour < 17
C.
Check if 14 < timestamp.hour < 17
D.
Check if timestamp.hour in range(14, 18)

A published solution is not available for this question yet.

Report a correction for Q423

Question 424 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
How would you extract the HTTP protocol version (e.g., HTTP/1.1) from the Request field "GET /blog/ HTTP/1.1"?
A.
Use request.split('/')[1]
B.
Use request.split(' ')[2]
C.
Use request.split(' ')[1]
D.
Use request.split('/')[2]

A published solution is not available for this question yet.

Report a correction for Q424

Question 425 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Source diagram or notation
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 Q425

Question 426 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
Source diagram or notation
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 Q426

Question 427 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
How would you identify if the log entry’s HTTP status code indicates a redirection request? **(Assume that status is correctly stored in the variable ‘status’)**
A.
status in [301, 302, 303]
B.
200 < status < 400
C.
300 <= status < 400
D.
status in range(299, 400)

A published solution is not available for this question yet.

Report a correction for Q427

Question 428 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
After filtering the log entries (in a list filtered_entries), which of the following is the best way to count the number of requests with a 404 status code for pages under /error/?
A.
Use len(filtered_entries)
B.
Use len(entries)
C.
Use sum(1 for entry in entries)
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q428

Question 429 MCQ · 1.0 marks

**Scenario 3:** You are provided with a Gzipped Apache log file from a website having the below data in each row.
Source diagram or notation
The fields are separated by spaces and quoted by double quotes ("). Unlike CSV files, quoted fields are escaped via " and not". All data is in the GMT-0500 timezone and the questions were based in this same time zone. Use the information and answer the given sub-questions. Note: Assume that you are using Python codes for log analysis
If the count of log entries appears much larger than expected, which of the following could be the reason?
A.
The filter for Monday is incorrect.
B.
The filter for time range is incorrect.
C.
The filter for HTTP method is incorrect.
D.
Any of these could be the reason.

A published solution is not available for this question yet.

Report a correction for Q429

Question 430 MCQ · 1.0 marks

**Scenario 4:** A professor in computational biology is designing an AI-powered assistant called BioTutor to help students understand bioinformatics concepts and computational techniques for analyzing genomic data. The assistant aims to foster critical thinking, independent learning, and hands-on problem-solving skills. Guidelines for BioTutor: ● Engage students with exploratory and reflective questions. ● Avoid providing direct answers; instead, guide students to discover solutions themselves. ● Focus on building conceptual understanding and technical skills. ● Encourage students to apply bioinformatics tools and algorithms independently. Based on the above data, answer the given subquestions.
What is the primary purpose of the system prompt in controlling an AI learning assistant's behavior?
A.
To create a fixed set of predetermined responses for every possible student query
B.
To define the core communication strategy, learning approach, and interaction guidelines
C.
To replace the need for human instructor guidance completely
D.
To limit the AI's ability to understand complex scientific concepts

A published solution is not available for this question yet.

Report a correction for Q430

Question 431 MCQ · 1.0 marks

**Scenario 4:** A professor in computational biology is designing an AI-powered assistant called BioTutor to help students understand bioinformatics concepts and computational techniques for analyzing genomic data. The assistant aims to foster critical thinking, independent learning, and hands-on problem-solving skills. Guidelines for BioTutor: ● Engage students with exploratory and reflective questions. ● Avoid providing direct answers; instead, guide students to discover solutions themselves. ● Focus on building conceptual understanding and technical skills. ● Encourage students to apply bioinformatics tools and algorithms independently. Based on the above data, answer the given subquestions.
Choose the best system prompt that achieves the instructor's goals.
A.
"You are a bioinformatics assistant. Provide direct answers and complete solutions whenever students ask."
B.
"You are an interactive learning assistant for bioinformatics. Guide students through complex concepts by asking reflective questions. Avoid giving direct solutions. Encourage independent thinking and help students develop problem-solving skills."
C.
"You are a simple computational tool for bioinformatics. Provide exact numerical answers and full code implementations for any genomic analysis question."
D.
"You are a bioinformatics assistant. Help students and tell them to consult research papers or textbooks for all information."

A published solution is not available for this question yet.

Report a correction for Q431

Question 432 MCQ · 1.0 marks

**Scenario 4:** A professor in computational biology is designing an AI-powered assistant called BioTutor to help students understand bioinformatics concepts and computational techniques for analyzing genomic data. The assistant aims to foster critical thinking, independent learning, and hands-on problem-solving skills. Guidelines for BioTutor: ● Engage students with exploratory and reflective questions. ● Avoid providing direct answers; instead, guide students to discover solutions themselves. ● Focus on building conceptual understanding and technical skills. ● Encourage students to apply bioinformatics tools and algorithms independently. Based on the above data, answer the given subquestions.
A student asks: "How do I identify open reading frames (ORFs) in a DNA sequence?" Choose the most pedagogically effective response:
A.
"To identify ORFs, you need to scan the DNA sequence in all six reading frames (three forward and three reverse) and locate start codons (ATG) and stop codons (TAA, TAG, TGA). Here's the Python code to do it: [provides full code]."
B.
"Open reading frames (ORFs) are stretches of DNA that can be translated into proteins. They start with a start codon like ATG and end with a stop codon like TAA, TAG, or TGA."
C.
"Interesting question! What do you already know about codons and their role in protein synthesis? Have you thought about how you might systematically search for start and stop codons in a sequence?"
D.
"I cannot help you with this task. Please refer to your bioinformatics textbook or online tutorials."

A published solution is not available for this question yet.

Report a correction for Q432

Question 433 MCQ · 1.0 marks

**Scenario 4:** A professor in computational biology is designing an AI-powered assistant called BioTutor to help students understand bioinformatics concepts and computational techniques for analyzing genomic data. The assistant aims to foster critical thinking, independent learning, and hands-on problem-solving skills. Guidelines for BioTutor: ● Engage students with exploratory and reflective questions. ● Avoid providing direct answers; instead, guide students to discover solutions themselves. ● Focus on building conceptual understanding and technical skills. ● Encourage students to apply bioinformatics tools and algorithms independently. Based on the above data, answer the given subquestions.
Assume that BioTutor uses a RAG (Retrieval-Augmented Generation) system to assist students with bioinformatics queries. The system works as follows: 1. Bioinformatics Data Storage: Comprehensive genomic research materials (e.g., papers, notes, tutorials) are split into smaller chunks, which are vectorized using an embedding model. 2. Vector Database: The vectorized chunks are stored in a FAISS or Weaviate vector database. 3. Retriever: When a student asks a question, the system retrieves relevant content from the database based on semantic similarity to the query. 4. LLM Contextualization: The retrieved content is added as context in the assistant's prompt, enabling the LLM to generate a personalized response. Which of the following correctly describes the process flow of a RAG-based system for BioTutor?
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 Q433