Practice Arena

Practice

Solved 0/1498
Streak 0 days
XP 0
0% Complete

All Practice Problems

1498 problems found

○ Maximum Product of Subsequences With an Alternating Sum Equ… medium Programming Unsolved
Programming • Implementation & Logic
○ Largest Of Three Numbers easy Programming Unsolved
Programming • Implementation & Logic
○ Student Class Display Details easy Programming Unsolved
Programming • Implementation & Logic
○ Swap Two Numbers By Reference easy Programming Unsolved
Programming • Implementation & Logic
○ Elevator Control System hard Programming Unsolved
Programming • Implementation & Logic
○ Simple Chatbot with Predefined Rules medium Programming Unsolved
Programming • Implementation & Logic
○ Sum Of Array Of 5 Integers easy Programming Unsolved
Programming • Implementation & Logic
○ Simple Interest Calculator easy Programming Unsolved
Programming • Implementation & Logic
○ Evacuate to Moon medium Programming Unsolved
Programming • Implementation & Logic
○ Library System Command Processor medium Programming Unsolved
Programming • Implementation & Logic
○ Bubble Shooter Problem easy Programming Unsolved
Programming • Implementation & Logic
○ Class Based Vending Machine Model easy Programming Unsolved
Programming • Implementation & Logic
○ Calendar Scheduler medium Programming Unsolved
Programming • Implementation & Logic
○ Wall Shooter easy Programming Unsolved
Programming • Implementation & Logic
○ Toggle Ratio easy Programming Unsolved
Programming • Implementation & Logic
○ Problem Tribonacci Trellis easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Pattern Matching with Wildcards hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Factorial Using Loop easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Project Manager Task Sorting hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Merge Overlapping Intervals easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Reorder By Absolute Value medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Longest Increasing Subsequence with Constraints medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Capitalize First Letter Of Each Word easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Ecommerce Deals hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Hospital Patient Priority easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Analysis Of Sorting Algorithm Performance Metrics easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Problem Bubble Sort Optimization easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Movie App Sort By Ratings easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Hr Portal Appraisal hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Meeting Scheduler hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Student Ranking easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Sort Employees By Salary And Age medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Remove Duplicates From A List easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Calendar Scheduler medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Ride Sharing Distance hard Programming Unsolved
Programming • Algorithmic Paradigms
○ Generalized K Nacci Sequence Summation easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Minimum Sum of Products medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Sort Meetings Merge Overlaps medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Arrange Tasks By Deadline Priority medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Sort Products By Discount medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Restaurant Orders Preparation Time easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Emirp Number Generation Within A Range easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Cube Transformation medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Product Price Sorting easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Toggle Ratio easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Check For Anagrams easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Directory Tree Lister easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Top K Frequent Elements medium Programming Unsolved
Programming • Algorithmic Paradigms
○ Minimum Holes easy Programming Unsolved
Programming • Algorithmic Paradigms
○ Library System Command Processor medium Programming Unsolved
Programming • Mathematics & Combinatorics
○ Uniform Data Partitioning Strategy easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Problem Emirp Numbers easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Matrix Spiral Traversal easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Product of Array Except Self medium Programming Unsolved
Programming • Mathematics & Combinatorics
○ Problem Prime Factor Sum easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Circulation easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Class Based Vending Machine Model easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Leap Year Checker easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Problem Tribonacci Trellis easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Factorial Using Loop easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Lowest Common Ancestor medium Programming Unsolved
Programming • Mathematics & Combinatorics
○ Wall Shooter easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Number of Islands medium Programming Unsolved
Programming • Mathematics & Combinatorics
○ Emirp Number Generation Within A Range easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Cube Transformation medium Programming Unsolved
Programming • Mathematics & Combinatorics
○ Toggle Ratio easy Programming Unsolved
Programming • Mathematics & Combinatorics
○ Pattern Matching with Wildcards hard Programming Unsolved
Programming • Advanced Topics
○ Circulation easy Programming Unsolved
Programming • Advanced Topics
○ Cube Transformation medium Programming Unsolved
Programming • Core Data Structures
○ Lowest Common Ancestor medium Programming Unsolved
Programming • Core Data Structures
○ Product Price Sorting easy Programming Unsolved
Programming • Core Data Structures
○ Toggle Ratio easy Programming Unsolved
Programming • Core Data Structures
○ Bubble Shooter Problem easy Programming Unsolved
Programming • Core Data Structures
○ Check For Anagrams easy Programming Unsolved
Programming • Core Data Structures
○ Balanced Brackets easy Programming Unsolved
Programming • Core Data Structures
○ Directory Tree Lister easy Programming Unsolved
Programming • Core Data Structures
○ Connected Components medium Programming Unsolved
Programming • Core Data Structures
○ Wall Shooter easy Programming Unsolved
Programming • Core Data Structures
○ Top K Frequent Elements medium Programming Unsolved
Programming • Core Data Structures
○ Number of Islands medium Programming Unsolved
Programming • Core Data Structures
○ Minimum Holes easy Programming Unsolved
Programming • Core Data Structures
○ Which function is used to join text with a separator automa… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =UPPER("excel") return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function converts text to lowercase? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =ABS(-25) return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which key is used to edit the active cell? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =MOD(10,3) return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function returns the current date and time? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =LEN("AI") return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which feature freezes rows or columns in Excel? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =SQRT(16) return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function checks if a value is text? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =CONCAT("Data"," ","AI") return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which tab contains the "Sort & Filter" option? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =ROUNDUP(2.1,0) return? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function returns the current year from a date? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will be the result of the formula =COUNT(A1:A5) if A1=… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which formula will return the last non-empty value from col… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What does the formula =IF(A1>10,"High",IF(A1>5,"Medium","Lo… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =SUMIF(A1:A5,">5",B1:B5) do? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What happens if you copy a formula with $A$1 reference? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will be the output of =LEFT("ExcelPro",5)? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function is best suited to remove extra spaces except… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =VLOOKUP(50,A1:C10,2,FALSE) return if 50 is not f… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ Which formula will count cells that contain text only? easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will be the result of =A1&B1 if A1="Data" and B1="Scie… easy MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =COUNTA(A1:A5) return if A1=10, A2="", A3="Text",… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function is used to return the row number of a cell r… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =RIGHT("Analytics",4) return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which formula finds the position of "A" in cell A1? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =IFERROR(1/0,"Error Found") return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function combines text from multiple cells? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What does =LEN("Excel 365") return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which formula extracts the month from a date in A1? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =ROUND(45.678,1) return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function looks up a value horizontally? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =AND(5>3,2>4) return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function returns current date? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =POWER(2,3) return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Which function replaces part of a text string? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ What will =ISNUMBER("123") return? medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A logistics company is analyzing warehouse dispatch efficie… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Welcome to the final round of the Stanford Advanced Analyti… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ Since we are down to the final 0.25% of the applicant pool,… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A high frequency trading firm maintains an Excel table name… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ The Scenario: Longitudinal Patient Outcome & Multi-Payer Re… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A large hospital network maintains a dataset of patient adm… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ You are the data analyst for a large urban school district … medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A national election commission analyst has a master dataset… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A revenue operations analyst at a global OTA (Online Travel… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A major Hollywood studio's financial analyst has built an E… medium MCQ Unsolved
Data Analytics & Tools • Excel
○ A regional automotive group tracks monthly performance acro… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A textile export house maintains a master workbook with thr… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A teacher at Decode Daya Institute manages student performa… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are managing backend analytics for a high traffic ecomm… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A digital marketing analyst at a Fortune 500 e-commerce com… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are a senior web analyst at a global e-commerce company… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A cybersecurity analyst is investigating a brute-force atta… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A police department uses Excel to manage a criminal records… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are a geospatial analyst at an alpine research institut… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are auditing a dataset for Amazon s "Last Mile" deliver… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are the Lead Data Architect for a global food delivery … hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A financial risk analyst at Goldman Sachs is running a two-… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A cab booking platform stores trip level data with columns … hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are a ML Engineer at a biotech firm working with gene e… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are working in a machine learning pipeline where raw ev… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ You are analyzing logs from an AI agent orchestration syste… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A global analytics team at a Marvel multiverse research lab… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ A large agri-tech company is analyzing satellite and IoT se… hard MCQ Unsolved
Data Analytics & Tools • Excel
○ Which SQL statement is used to retrieve data from a databas… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which clause is used to filter records in a SQL query? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL command is used to insert new data into a table? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which clause is used to sort the result of a SQL query? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to remove a table from a databa… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to update existing records in a… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL function is used to count the number of rows in a… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which keyword is used to remove duplicate records in a SELE… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL clause is used to group rows that have the same v… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to delete specific records from… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ You are given a table `Transactions` with the following str… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider the following schema: `Employees(emp_id INT, dep… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A fintech company stores transaction data in a table transa… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A logistics company tracks shipments in shipments(shipment_… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial institution maintains two tables: Transactions … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A logistics company tracks shipments in the following table… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial transactions table is defined as follows: CREAT… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A hospital database contains the following schema: CREATE T… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a hospital database with the following schema: app… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ An e-commerce company has the following tables: orders(orde… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A table orders has the following schema: order_id INT, cust… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider the following schema in a PostgreSQL database used… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A travel tech platform stores booking data in the following… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A police department maintains crime records in the followin… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A hotel management system tracks room bookings with the fol… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A defense procurement database tracks the following: acquis… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ In a cartoon streaming platform, each episode can have mult… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ In an IT company, employees apply to internal job postings.… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You are working with a cold drink manufacturing database. C… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You are designing a metadata store for an AI model registry… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A research facility studying fossilized dinosaurs reinforce… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A telecommunications company maintains the following schema… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A macroeconomic research team at RBI is analyzing India's G… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Domain: Dinosaur Taxonomy and Phylogenetic Lineage We have … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Domain: Industrial Metal Smelting and Alloy Grading A smelt… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A solar irradiance research facility maintains the followin… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ The orbital mechanics division of a space research center m… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial audit system tracks transactions across multipl… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Orders(order_id, customer_id, order_date, … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Employees(emp_id, dept_id, salary), which que… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have two tables: Students(student_id, name) and Marks(s… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a table Sales(region, product, revenue). Which que… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Logins(user_id, login_date), which query find… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Products(product_id, category_id, price). … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Employees(emp_id, manager_id), which query fi… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Transactions(trans_id, user_id, amount). W… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a table Attendance(student_id, date). Which query … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Orders(order_id, customer_id, amount). Whi… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table called candidates with two columns: candid… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table candidates(candidate_id INTEGER, skill VAR… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table tweets with columns: tweet_id (INTEGER), u… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ You have two tables. The pages table has columns: page_id (… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a posts table with columns: user_id (INTEGER), pos… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Compute CTR = clicks / impressions. Table events(event_type… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table tweets with columns: tweet_id (INTEGER), u… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find duplicates in a table. Which query is correct? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Compute cumulative sum. Which query is correct? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find 3rd highest salary. Which query is correct? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find employees who have managers. easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Find top spenders. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table reviews with columns: review_id, user_id, … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ A developer groups product ratings only by product_id, not … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have trades and users tables. Retrieve the top 3 cities… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ A developer forgets the completed-status filter when counti… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Return the number of unique users in a table events(user_id… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Find employees who manage at least one other employee. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find customers who placed more than one order on the same d… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find each user’s latest transaction row. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Return users who made at least 5 purchases. easy MCQ Unsolved
Data Analytics & Tools • SQL
○ When a grouped subquery identifies qualifying entities, how… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Which statement correctly explains why COUNT(DISTINCT compa… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ What is the key difference between ROW_NUMBER() and RANK()? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find top 2 salaries per department. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find first login per user. easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Count NULL values. easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which join returns only matching rows? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What does LEFT JOIN return? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What is a self join? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Key difference between window and aggregate functions? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find the second highest salary. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find employees earning above average salary. easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Delete duplicate rows keeping one. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Which statement about CASE is true? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Compute total spend per user. medium MCQ Unsolved
Data Analytics & Tools • SQL
○ When can DISTINCT replace GROUP BY? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Does GROUP BY require ORDER BY? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Find earliest month with highest opening price. hard MCQ Unsolved
Data Analytics & Tools • SQL
○ When should HAVING be used? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Difference between COUNT(*) and COUNT(col)? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What is LIMIT used for? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What is a subquery? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What is a correlated subquery? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find consecutive-week engagement streaks without breaking a… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ What does median represent? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ What does mode represent? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ How do you safely avoid divide-by-zero in SQL? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Which join can preserve unmatched rows from one side? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ What does PARTITION BY do in a window function? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ How does DENSE_RANK behave with ties? medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Find employees who manage at least one manager — meaning th… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Compute total server usage duration in days from start and … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have an transactions table with columns: user_id (INTEG… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table samples with columns value (INTEGER) and f… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have friendship(user_id, friend_id) and likes(user_id, … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a listening_history table with columns user_id, ar… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have an orders table with columns order_id, customer_id… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a monthly_cards_issued table with columns: issue_m… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have two tables: phone_calls(caller_id INTEGER, receive… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a callers table with columns: policy_holder_id (IN… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a user_actions table with columns: user_id (INTEGE… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a user_transactions table with columns: transactio… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Using the user_transactions table, consider a product with … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You have an inventory table with columns: item_id (INTEGER)… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to retrieve data from a databa… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which clause is used to filter records in a SQL query? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL command is used to insert new data into a table? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which clause is used to sort the result of a SQL query? easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to remove a table from a datab… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to update existing records in … easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL function is used to count the number of rows in … easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which keyword is used to remove duplicate records in a SEL… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL clause is used to group rows that have the same … easy MCQ Unsolved
Data Analytics & Tools • SQL
○ Which SQL statement is used to delete specific records fro… easy MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Orders(order_id, customer_id, order_date,… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Employees(emp_id, dept_id, salary), which qu… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have two tables: Students(student_id, name) and Marks(… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a table Sales(region, product, revenue). Which qu… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Logins(user_id, login_date), which query fin… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Products(product_id, category_id, price).… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Given a table Employees(emp_id, manager_id), which query f… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Transactions(trans_id, user_id, amount). … medium MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a table Attendance(student_id, date). Which query… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ You have a table Orders(order_id, customer_id, amount). Wh… medium MCQ Unsolved
Data Analytics & Tools • SQL
○ A fintech company stores transaction data in a table trans… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A logistics company tracks shipments in shipments(shipment… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial institution maintains two tables: Transactions… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A logistics company tracks shipments in the following tabl… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial transactions table is defined as follows: CREA… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A hospital database contains the following schema: CREATE … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider a hospital database with the following schema: ap… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ An e-commerce company has the following tables: orders(ord… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A table orders has the following schema: order_id INT, cus… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Consider the following schema in a PostgreSQL database use… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A travel tech platform stores booking data in the followin… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A police department maintains crime records in the followi… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A hotel management system tracks room bookings with the fo… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A defense procurement database tracks the following: acqui… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ In a cartoon streaming platform, each episode can have mul… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ In an IT company, employees apply to internal job postings… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You are working with a cold drink manufacturing database. … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ You are designing a metadata store for an AI model registr… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A research facility studying fossilized dinosaurs reinforc… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A telecommunications company maintains the following schem… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A macroeconomic research team at RBI is analyzing India's … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Domain: Dinosaur Taxonomy and Phylogenetic Lineage We have… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ Domain: Industrial Metal Smelting and Alloy Grading A smel… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A solar irradiance research facility maintains the followi… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ The orbital mechanics division of a space research center … hard MCQ Unsolved
Data Analytics & Tools • SQL
○ A financial audit system tracks transactions across multip… hard MCQ Unsolved
Data Analytics & Tools • SQL
○ What is Power BI mainly used for? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which file format is commonly used to import data into Pow… easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which Power BI component is used to create reports? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is a dashboard in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which of the following is a visualization in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is Power Query used for? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which feature allows filtering data in reports? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does DAX stand for? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which chart is best for showing trends over time? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Where can you publish Power BI reports online? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is used to establish relationships between tables in … easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option allows you to load data after transforming it? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which visual shows a single value in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the default file extension of Power BI reports? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option is used to share reports with others online? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which type of chart is used to show proportions? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is used to connect Power BI to different data sources? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option helps refresh data automatically in Power BI … easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which feature is used to save different report views? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which view is used to see summarized visuals, not raw data… easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which tab is used to add visuals in Power BI Desktop? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What will the following measure return? Total Sales All = … medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the purpose of the "Fields" pane in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does this measure compute? Sales LY = CALCULATE(SUM(S… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which visual is best to display a single KPI value? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the output of this calculated column? Flag = IF(Sa… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option allows you to rename a column in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does this measure do? Distinct Customers = DISTINCTCO… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does the "Refresh" button do in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What will this measure return? Filtered Sales = CALCULATE(… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which file extension is used for Power BI templates? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does this measure calculate? Avg Sales = AVERAGEX(Sal… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which chart is best for comparing categories? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What happens in this measure? Test = CALCULATE(SUM(Sales[A… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Where do you create calculated columns in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the result of this DAX? Rank = RANKX(ALL(Sales), S… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does a slicer do in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does this measure return? Related Value = RELATED(Cus… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option is used to change report colors and design? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What will this measure output? Running Total = CALCULATE( … medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is a table in Power BI? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ In Power BI, what happens when you create a relationship w… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which option helps you sort data in a visual? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which DAX function is best suited to override existing fil… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the purpose of the "Model view"? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the main difference between calculated columns and… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which Power BI feature allows drilling into detailed data? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ In Power Query, what does the "Close & Apply" button do? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which type of data can Power BI connect to? easy MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which storage mode allows real-time querying of the data s… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the purpose of the USERELATIONSHIP function in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ In a star schema, what type of table typically contains de… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which visual interaction option allows one visual to filte… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does the CALCULATE function primarily do in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the role of a slicer in Power BI? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ You have a Power BI model with a Sales table (Date, Produc… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does the VALUES() function return in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ A travel tech company has a Power BI model with a table Bo… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What will this measure return? Total Customers = COUNTROWS(… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ You are analyzing a stock market dataset in Power BI conta… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the purpose of KEEPFILTERS() in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ You are building a Power BI report for a coding platform t… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does ALLSELECTED() do in Power BI? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ In a hotel management Power BI model, you have two tables:… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the result of: Max Sales = MAX(Sales[Amount]) medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ In a flight analytics model, you have a Flights table with… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the use of DIVIDE() instead of / in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ You are analyzing an Olympics dataset with tables Athletes… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What happens when no relationship exists between two tables… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ In a car sales dataset, you have a table Sales with column… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which function is used to return the current row value in a… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ In a Power BI model containing a Movies table with columns… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does this measure compute? Total Orders = COUNT(Sales[… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ You have a Power BI model with an Employees table containi… hard MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does SELECTEDVALUE() return? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is the purpose of CROSSFILTER() in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What will this measure return? Sales Count = COUNTROWS(Sale… medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ Which function is used to replace null values in DAX? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What does REMOVEFILTERS() do? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What happens when you use SUMX() instead of SUM()? medium MCQ Unsolved
Data Analytics & Tools • Power BI
○ What is Tableau primarily used for? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which file format is commonly used to save Tableau workboo… easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is a Dashboard in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which of the following is used to connect Tableau to data? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is a Worksheet in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which feature allows you to filter data in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What type of data field contains numbers in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which chart is best for showing trends over time? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is a Dimension in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which Tableau feature tells a story using multiple dashboa… easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which tab is used to create visualizations in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What happens when you drag a Dimension to the Rows shelf a… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does dragging a field to the Filters shelf do? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which of the following best describes a “Context Filter”? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which color represents Continuous fields in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What will happen if you use a FIXED LOD expression? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What happens when you double-click a field in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which join type returns only matching records from both ta… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which type of chart is used to compare categories? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the default aggregation in Tableau for numeric fie… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does Drag and Drop mean in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the difference between a Live Connection and an Ex… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which shelf is used to create vertical charts? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ If you place a Measure on the Filters shelf, what can you … medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the default chart type when you add one dimension a… easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does “Show Me” feature do in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which feature allows you to highlight specific data? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ What will happen if you blend two data sources in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is a Pane in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which filter is applied last in Tableau (order of operatio… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which option helps you sort data? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ You have a FIXED LOD calculation:{ FIXED [Region] : SUM([S… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What happens when you convert a Dimension into a Measure in… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does the Label option in Marks card do? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ You place a Dimension on Rows and apply a Top N filter (To… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which feature allows users to dynamically change a value us… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which file contains both data and visualization in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ You blend two data sources on “Customer ID”. Some records … hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the main purpose of a Set in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does clicking Undo do in Tableau? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ A calculated field uses:IF SUM([Sales]) > 1000 THEN "High"… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What will happen if you remove all Dimensions from a view? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which option is used to change chart colors? easy MCQ Unsolved
Data Analytics & Tools • Tableau
○ You create a table calculation using RUNNING_SUM(SUM([Sale… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which shelf is used to control the level of detail in a vie… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ You use a Context Filter and then apply a FIXED LO D. What… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does ATTR() function return? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ You create a dual-axis chart but notice misalignment betwe… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the use of the Pages shelf in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ You use COUNTD(Customer ID) in a view and then apply a tab… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What happens when you create a hierarchy in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ You join two tables with a one-to-many relationship. What … hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which function is used to convert a string into a date? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ You create a calculated field using a parameter. When does… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does Discrete data represent in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculated field correctly classifies customers base… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the purpose of Groups in Tableau? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation safely computes Profit Ratio? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does the Size option in Marks card control? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which formula correctly returns sales for the latest year? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which operation combines data vertically? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation correctly computes running total of sale… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the default behavior of Tableau when multiple measu… medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation correctly identifies Top 5 customers by … hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What does Tooltip in Tableau do? medium MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation correctly computes Year-over-Year growth? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which formula correctly calculates % contribution of sales? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation correctly counts unique customers? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which formula correctly classifies weekend vs weekday? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ Which calculation avoids aggregation errors? hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You want to calculate each category’s contribution to tota… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You want to create a calculated field that returns “Top Pe… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You are building a dashboard for a retail company. Require… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You are working with hospital dat a. Requirement:For each … hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You are analyzing hotel booking dat a. Requirement:For eac… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ You are analyzing car sales dat a. Requirement:For each Ca… hard MCQ Unsolved
Data Analytics & Tools • Tableau
○ What is the standard convention for importing pandas in Pyt… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which of the following creates a pandas Series from a Pytho… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.DataFrame({'Name': ['Alice', 'Bob'], 'Age': [2… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function reads a CSV file into a pandas DataFrame? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given df = pd.DataFrame({'A': [1,2,3], 'B': [4,5,6], 'C': [… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given a DataFrame df with columns 'Name', 'Age', 'City', wh… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.head(3) return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method provides a concise summary including column na… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does len(df) return for a DataFrame df? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method returns a DataFrame of boolean values indicati… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.dropna() do by default? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you replace all NaN values in a DataFrame with the n… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you sort a DataFrame by the 'Price' column in descen… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.describe() return by default? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['City'].value_counts() return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between df['col'].unique() and df['c… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which is the correct way to rename column 'old_name' to 'ne… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you add a new column 'Total' to a DataFrame that is … easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.drop(columns=['A', 'B']) do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given df with a 'Score' column, what does df[df['Score'] > … easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which attribute shows the data type of each column in a Dat… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.reset_index() do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you set the 'Date' column as the index of a DataFram… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.concat([df1, df2]) do by default? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Department')['Salary'].mean() compute? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.to_csv('output.csv', index=False) do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which accessor is used to select rows by integer position? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which accessor is used to select rows by their index label? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function reads an Excel file into a pandas DataFrame? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you convert column 'Price' from float to integer? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you convert all values in a string column 'Name' to … easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you transpose a DataFrame (swap rows and columns)? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.sample(n=5) return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between df2 = df and df2 = df.copy()? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Price'].apply(lambda x: x * 1.1) do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.ndim return for a DataFrame? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you remove duplicate rows from a DataFrame? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method iterates over DataFrame rows as (index, Series… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method shows the memory consumption of each column in… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you replace all occurrences of 'Male' with 'M' in a … easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you compute the pairwise correlation between all num… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.tail(10) return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you select columns 'Name' and 'Age' from a DataFrame… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.isnull().sum() compute? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the .map() method do on a pandas Series? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the primary purpose of pd.pivot_table()? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.merge(df1, df2, on='ID') do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.columns return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What do df['Temperature'].min() and df['Temperature'].max()… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.DataFrame([{'a': 1, 'b': 2}, {'a': 3, 'b': 4}]… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Age'].between(18, 35) return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method saves a DataFrame to an Excel file? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you check the installed version of pandas? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the result of NaN + 5 in pandas? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the .name attribute of a Series represent? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you filter rows where Age > 25 AND City == 'London'? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Score'].agg(['mean', 'std', 'min', 'max']) re… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.nlargest(5, 'Revenue') return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you check if two DataFrames df1 and df2 are identica… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Stock_Price'].pct_change() compute? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Sales'].cumsum() return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.query('Age > 30 and Salary > 50000') do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Score'].clip(lower=0, upper=100) do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.nunique() return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given df with index [10, 20, 30, 40, 50], what does df.loc[… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Category').agg({'Price': 'mean', 'Qua… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ In pd.merge(df1, df2, on='Key', how='left'), what happens t… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which method creates a hierarchical index (MultiIndex) from… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Price'].rolling(window=7).mean() compute? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.melt() do to a DataFrame? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.apply(lambda x: x.max() - x.min()) compute by … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you find all rows where the 'Email' column contains … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.crosstab(df['Gender'], df['Department']) produ… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.to_datetime(df['Date_String']) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ If df['Date'] is a datetime column, how do you extract the … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given a DatetimeIndex DataFrame, what does df.resample('ME'… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.cut(df['Age'], bins=[0, 18, 35, 60, 100]) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How does pd.qcut() differ from pd.cut()? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ If a column contains lists like ['a','b','c'] in each cell,… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the purpose of the .pipe() method in pandas? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.assign(BMI=lambda x: x['Weight'] / (x['Height'… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.stack() do to a DataFrame? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Score'].where(df['Score'] >= 50, other=0) ret… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the benefit of converting a column to 'category' dt… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the indicator=True parameter do in pd.merge()? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How does .expanding() differ from .rolling()? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Group')['Value'].transform('mean') re… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.duplicated(subset=['Name', 'Date'], keep='last… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Starting in pandas 2.1, what is the recommended method for … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Status'].value_counts(normalize=True) return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Sales'].shift(1) produce? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Price'].ewm(span=20).mean() compute? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the key difference between df.pivot() and df.pivot_… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Full_Name'].str.split(' ', expand=True) retur… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Dept').agg(avg_salary=('Salary', 'mea… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you merge two DataFrames using their indices as join… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Score'].rank(method='dense') do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What issue does df.infer_objects() help resolve? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.merge(df1, df2, how='cross') produce? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the purpose of df.style in pandas? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you make pd.read_csv() treat the strings 'NA', 'N/A'… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Category').filter(lambda x: len(x) >=… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Timestamp'].dt.floor('H') do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ When is it beneficial to use a pandas SparseDtype? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the advantage of df.eval('C = A + B') over df['C'] … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between 'int64' and 'Int64' (capital… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why might you specify dtype={'ZipCode': str} in pd.read_csv… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.reindex(columns=['B', 'A', 'C', 'D']) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Category').ngroup() return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Revenue'].idxmax() return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Given a long-format DataFrame with columns [Date, Metric, V… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you convert a timezone-aware datetime column from UT… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Phone'].str.extract(r'(\d{3})-(\d{4})') retur… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.read_csv('large.csv', chunksize=10000) return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ For a MultiIndex DataFrame with levels ['Region', 'Year'], … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['col'].sparse.density return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between df['col'].any() and df['col'… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How does .apply() differ from .transform() in GroupBy conte… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is a PeriodIndex and when would you use it instead of … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does NaN == NaN evaluate to in pandas? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.factorize(df['City']) return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df1.update(df2) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.to_datetime(df['Date'], errors='coerce') do wi… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which of the following is NOT a valid pandas accessor? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function reads the result of a SQL query into a DataF… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.swaplevel(0, 1) do on a MultiIndex DataFrame? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you zero-pad a string column 'ID' to width 5 (e.g., … medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you get the top 3 highest-revenue products per categ… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.to_dict(orient='records') return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df1.combine_first(df2) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you select only numeric columns from a DataFrame? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Text'].str.replace(r'\d+', 'NUM', regex=True)… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the advantage of df.at[row_label, col_label] over d… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['col'].first_valid_index() return? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between groupby.size() and groupby.c… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How does df.mask(condition) differ from df.where(condition)? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you read a JSON Lines file (one JSON object per line… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Temperature'].interpolate(method='time') do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ When should you use pd.to_numeric() instead of .astype(floa… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df['Date'].dt.to_period('M').dt.to_timestamp() pr… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Can df.assign() create multiple new columns in a single cal… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What causes the SettingWithCopyWarning, and how do you fix … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pandas' Copy-on-Write mode (pd.options.mode.copy_… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Region').agg(lambda x: x.quantile(0.9… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why are .str accessor methods generally slower than equival… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why does iterating over rows of a DataFrame have poor cache… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When merging two DataFrames that share a column name 'Value… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How can you use Numba to speed up a custom rolling window c… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you create an ordered categorical column with custom… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ If s1 has index [0,1,2] and s2 has index [1,2,3], what does… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ In df.eval('Revenue > @threshold'), what does the @ prefix … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you pass additional arguments to a function in .pipe… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What are the advantages of Parquet format over CSV for stor… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does dtype_backend='pyarrow' in pd.read_csv() change? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ For a categorical column, what does groupby('Cat', observed… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How can you perform arithmetic on two Series with different… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('A').agg(**{'mean_B': pd.NamedAgg(colu… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which approach is fastest for creating a column based on co… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why doesn't pandas .apply() automatically parallelize acros… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When sorting a MultiIndex DataFrame with sort_index(), what… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the performance implication of merging on string ke… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is wrong with: df.drop('A', axis=1, inplace=True).fill… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why is building a DataFrame by appending rows in a loop (pd… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When does df.query() outperform boolean indexing (df[mask])? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When performing arithmetic on two sparse Series, is the res… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ In df.rolling(window=10, min_periods=3).mean(), what happen… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why is .loc[] on a sorted MultiIndex significantly faster t… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What causes internal fragmentation in a DataFrame, and how … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the practical impact of using pd.ArrowDtype(pa.stri… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Customer').cumcount() produce? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ For matrix multiplication of two DataFrame columns, which i… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is an ExtensionArray in pandas? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Can you resample a DataFrame indexed by Timedelta (elapsed … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which pandas operations are automatically accelerated by nu… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why does pandas check index.is_monotonic_increasing for mer… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why is inplace=True generally discouraged in modern pandas … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function should you use in tests to assert two DataFr… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you find rows in df1 that do NOT have a matching key… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Department')['Salary'].rank(pct=True)… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which combination of read_csv parameters maximizes read per… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When reading a large CSV file, what is the effect of specif… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.rolling(5, center=True).mean() do differently … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Customer').nth([0, -1]) return? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You have a pipeline: df.pipe(clean).pipe(transform).pipe(an… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the benefit of df.to_parquet('data/', partition_col… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('Group')['Value'].transform(lambda x: … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the advantage of using pd.BooleanDtype() over stand… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ After df.explode('Tags'), the index contains duplicates fro… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df1.compare(df2) return? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you resample a DatetimeIndex DataFrame to business m… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you apply multiple aggregation functions to the same… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Can you export a styled DataFrame (df.style) directly to Ex… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ A categorical column has categories ['A','B','C','D'] but t… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ How can you create a custom accessor (e.g., df.geo.plot_map… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does pd.merge_asof(trades, quotes, on='timestamp', dir… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which pattern is most efficient for checking if ANY value i… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the key difference between Feather and Parquet form… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Can you pass a function (not a column name) to df.groupby()? hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the recommended pandas approach for creating a time… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ In pandas' internal architecture, how are columns of the sa… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the converters parameter in read_csv() do that dt… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When processing a file too large for memory in chunks, how … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ For a DataFrame with MultiIndex columns (Level1, Level2), w… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Why might assert_frame_equal fail when comparing two DataFr… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ When localizing timestamps that fall during a DST transitio… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the purpose of the DataFrame Interchange Protocol (… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is Pandas mainly used for in Python? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which data structure is mainly used in Pandas? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function is used to read a CSV file in Pandas? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.head() do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ How do you select a column named "age" from a DataFrame df? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function is used to display basic information about … easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.shape return? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function is used to remove missing values? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.describe() do? easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function is used to sort data in a DataFrame by a co… easy MCQ Unsolved
Data Analytics & Tools • Pandas
○ What will be the output of the following code? import pand… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the following code return? df = pd.DataFrame({'A… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What is the difference between df.loc[] and df.iloc[]? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What will be the output? df = pd.DataFrame({'A': [1, 2, 3]… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does the following code do? df = pd.DataFrame({'A': [… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What will be the output of the following code? import pand… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.fillna(0) do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What will be the result of the following? df = pd.DataFram… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which function is used to combine two DataFrames verticall… medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ What does df.groupby('A').sum() do? medium MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working as a data analyst at an e-commerce company… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a large-scale ad-tech company analyzing… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a healthcare analytics company analyzin… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a ride-sharing company analyzing trip d… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a cybersecurity company analyzing login… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a quantitative finance firm analyzing s… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a supply chain analytics company. You a… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a large scale streaming platform analyz… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a fraud detection team at a digital pay… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in an IoT based smart grid company analyzi… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a recommendation system team for an onl… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a retail analytics company. You are giv… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a telecom company analyzing customer us… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a healthcare analytics company analyzin… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a healthcare analytics company analyzin… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a travel tech company analyzing hotel b… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a travel tech platform analyzing flight… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working in a travel tech company analyzing cab boo… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working as a cricket data analyst. You are given a… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing ball-by-ball cricket data for a T20 leag… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working with a movie streaming platform dataset wh… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing cinema hall booking data where each row … hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing a railway reservation system dataset whe… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing operational readiness data of Indian Arm… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are given logistics and mission deployment data of Ind… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing streaming performance data of a media pl… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing battle data from a fictional Marvel mult… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are working with a large bookstore analytics dataset w… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ You are analyzing logistics data where each row represents… hard MCQ Unsolved
Data Analytics & Tools • Pandas
○ Which of the following best describes a 'regression' proble… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does 'underfitting' mean in machine learning? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of a test set in machine learning? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does the ROC curve plot on its two axes? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Which of the following is an example of an unsupervised lea… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In the context of model evaluation, what does the term 'gen… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'feature engineering'? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'data leakage' in a machine learning pipeline? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does the term 'hyperparameter' mean in machine learnin… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does 'recall' (also called sensitivity or true positiv… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the output range of the hyperbolic tangent (tanh) a… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In a decision tree, what is a 'leaf node'? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does 'one-hot encoding' do to a categorical feature? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the main advantage of ensemble methods such as bagg… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the ReLU activation function's formula and output f… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of 'feature importance' in tree-based m… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In linear regression, what does 'ordinary least squares' (O… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What type of output does a logistic regression model produc… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a perceptron? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does 'weight initialization' refer to in neural networ… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In a CNN, what is the purpose of a max pooling operation? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between a 'shallow' and a 'deep' neu… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'fine-tuning' in the context of transfer learning? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the role of the output layer in a neural network fo… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a recurrent connection in an RNN? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What distinguishes a GAN (Generative Adversarial Network) g… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the primary purpose of batch normalization in a dee… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'transfer learning' most commonly motivated by? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.layers.Dense(64, activation='relu')` cr… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `model.predict(X_test)` return in a Keras model? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a `tf.keras.Sequential` model? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In `model.fit()`, what does the `epochs` parameter control? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.reshape(tensor, [2, 3, -1])` do? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a PyTorch `Tensor` and how does it differ from a Nu… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `nn.Module` in PyTorch used for? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.optim.SGD(model.parameters(), lr=0.01)` cr… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `.item()` do when called on a single-element PyTo… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.cat([tensor_a, tensor_b], dim=0)` do? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `cross_val_score(model, X, y, cv=5, scoring='accu… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `fit_transform(X_train)` do differently than call… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does sklearn's `LabelEncoder` do? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `MinMaxScaler` produce from a feature column? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the primary reason to use a `Pipeline` in sklearn i… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `model.score(X_test, y_test)` return for a classi… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a 'z-score' (standard score) for a data point? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does 'standard deviation' measure about a dataset? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does a heatmap visualize in exploratory data analysis? easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between a 'sample' and a 'population… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does a scatter plot reveal that a correlation coeffici… easy MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Given: TP = 45, FP = 15, FN = 25, TN = 115. Compute Precisi… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does an AUC-ROC value of 0.5 indicate about a binary c… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the bias-variance tradeoff, and how does model comp… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'stratified sampling' and when is it essential? medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between a parametric and a non-param… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'elbow method' used for when applying k-means c… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'regularization,' and how does adding a regularizat… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'class imbalance' and why does it cause problems fo… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'multi-label classification' and how does it differ… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of 'learning rate scheduling' (e.g., st… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Compute the Shannon entropy of a node with 60 samples from … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Given weights w = [0.5, −1.0], bias b = 0.3, and inputs x =… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the key difference between 'batch gradient descent,… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the gamma (γ) parameter in an RBF (Gaussian) kernel… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is DBSCAN and how does it handle cluster shapes that k… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In gradient boosting, a tree hₘ is fit to the negative grad… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ How does AdaBoost adjust the training weights of misclassif… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the curse of dimensionality's specific impact on KN… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the closed-form solution for Ridge regression (L2 r… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between 'hard margin' and 'soft marg… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the Naive Bayes classifier's 'naive' assumption, an… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A k-means algorithm has K=3 clusters with centroids μ₁=(1,1… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A neuron receives inputs x = [0.5, 0.8], weights w = [0.4, … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A fully connected network has layers: Input(50) → Dense(128… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'dying ReLU' problem and which variant of ReLU … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is He initialization (Kaiming initialization) and why … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'receptive field' of a neuron in a CNN, and how… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does the softmax function do to logits, and what prope… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the key structural difference between an LSTM and a… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A Conv2D layer receives input of shape 64×64×3, uses 32 fil… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'teacher forcing' in sequence-to-sequence (seq2seq)… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'positional encoding' in the Transformer architectu… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'mode collapse' in GAN training and what causes it? medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'knowledge distillation' and why might a student mo… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between BERT and GPT in terms of arc… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of 'gradient clipping' and when is it m… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is multi-task learning (MTL) and what is its primary a… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between image 'classification,' 'obj… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.regularizers.l2(0.01)` do when passed a… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.callbacks.ReduceLROnPlateau(monitor='va… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In TensorFlow, what is the Functional API used for that the… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between `model.save('model.keras')` … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between `nn.functional` (torch.nn.fu… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'gradient accumulation' in PyTorch and when would y… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `.detach()` do to a PyTorch tensor, and when is i… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `nn.CrossEntropyLoss()` expect as its two inputs … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.optim.lr_scheduler.CosineAnnealingLR(optim… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `ColumnTransformer` accomplish in a preprocessing… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `SelectKBest` in sklearn and how does it select fea… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `IsolationForest(contamination=0.05)` do and how … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the vanishing gradient problem, and why does it spe… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does the attention mechanism compute, given query Q, k… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is self-supervised learning and how does it differ fro… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is model 'quantization' in deep learning deployment an… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is an 'embedding layer' in deep learning and what does… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the key difference between batch normalization, lay… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.layers.Embedding(vocab_size=10000, embe… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.layers.GlobalAveragePooling2D()` do in … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.data.Dataset.map(preprocess_fn, num_parallel_… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.keras.layers.MultiHeadAttention(num_heads=8, … medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.utils.data.DataLoader(dataset, batch_size=… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Why is `nn.BCEWithLogitsLoss` preferred over applying `torc… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.optim.lr_scheduler.OneCycleLR` implement a… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `RFECV` (Recursive Feature Elimination with Cross… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ When `StandardScaler().transform(X_test)` is called after t… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `CalibratedClassifierCV(base_estimator, method='i… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What features does `PolynomialFeatures(degree=3, interactio… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ When should you choose Spearman's rank correlation over Pea… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Compute the population variance of the dataset [2, 4, 4, 4,… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'multicollinearity' in regression and what practica… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ How is a Q-Q (quantile-quantile) plot used to assess whethe… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the practical significance of the Central Limit The… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In hypothesis testing, what is the difference between a Typ… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the bootstrap method for estimating confidence inte… medium MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the VC (Vapnik-Chervonenkis) dimension and what doe… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does the No Free Lunch (NFL) theorem state, and what i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the posterior distribution P(θ|D) and how does full… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Why is minimising cross-entropy loss for classification equ… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between 'covariate shift' and 'conce… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the EM (Expectation-Maximization) algorithm and wha… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the Information Gain Ratio used in C4.5, and why do… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the kernel trick in SVMs and how does it achieve in… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is XGBoost's key algorithmic improvement over vanilla … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Linear Discriminant Analysis (LDA) as a dimensional… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the dual formulation of the SVM optimisation proble… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the exact mathematical form of the DBSCAN algorithm… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Bayesian optimisation and how does its acquisition … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Derive the gradient ∂L/∂zⱼ of the cross-entropy loss L = −Σ… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a Gaussian Process (GP) regression model, and what … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In a Random Forest with B=3 trees, the trees predict probab… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is spectral clustering and how does the graph Laplacia… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A 2-layer MLP has: a₁ = ReLU(W₁x), ŷ = W₂a₁, L = (1/2)(ŷ−y)… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is He initialisation, why is it specifically designed … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the full formulation of multi-head self-attention i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the Lottery Ticket Hypothesis and what are its impl… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is depthwise separable convolution (MobileNet's core i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is contrastive learning (e.g., SimCLR) and how does th… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is gradient checkpointing (activation recomputation) a… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is rotary positional embedding (RoPE) and why is it pr… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the full mathematical formulation of the LSTM cell … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ Derive the ELBO (Evidence Lower Bound) for VAEs and explain… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the Wasserstein distance and why does WGAN use it i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is a diffusion model (DDPM) and how does its generativ… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is LoRA (Low-Rank Adaptation) and how does it enable f… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Reinforcement Learning from Human Feedback (RLHF) a… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Flash Attention and what computational improvement … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is mixture-of-experts (MoE) and how does sparse gating… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the policy gradient theorem and what fundamental ch… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the CLIP training objective mathematically, and wha… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is speculative decoding and what speedup does it achie… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is 'catastrophic forgetting' and which continual learn… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between TensorFlow's `tf.keras.Model… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is mixed-precision training in TensorFlow and why does… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `tf.distribute.MirroredStrategy` implement, and w… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does XLA (Accelerated Linear Algebra) do to a TensorFl… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the role of `tf.keras.layers.Lambda` and why should… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `torch.autograd.Function` and when would you implem… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `torch.compile()` (PyTorch 2.0) and how does it dif… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is DistributedDataParallel (DDP) in PyTorch and how do… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What does `torch.cuda.amp.autocast()` combined with `torch.… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the KV-cache in Transformer inference, and what mem… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ In a custom GAN training loop using `tf.GradientTape`, why … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the role of `tf.keras.layers.Lambda` and why should… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `torch.autograd.Function` and when would you implem… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of `torch.compile()` (introduced in PyT… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is `torch.nn.parallel.DistributedDataParallel` (DDP) a… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the purpose of `torch.cuda.amp.autocast()` combined… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the KV-cache in Transformer inference and how does … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the full standard PyTorch training loop structure, … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the complete mathematical definition of the silhoue… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between `BaggingClassifier` and `Ran… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the `learning_curve` function in sklearn and what i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the mathematical objective of t-SNE's optimization … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the VotingClassifier with `voting='soft'` and `weig… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Simpson's Paradox and why is it particularly danger… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between a p-value and a confidence i… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'multiple comparisons problem' (multiple testin… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between causal inference and predict… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the Kolmogorov-Smirnov (KS) test and how is it used… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between MCAR, MAR, and MNAR (missing… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is propensity score matching and in what situation is … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the exact interpretation of a 95% confidence interv… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between L1 and L2 norm in the contex… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'imbalanced precision-recall tradeoff' in anoma… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ A dataset has two features: Salary ($) ranging from 30,000 … hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the mathematical definition of mutual information I… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is power analysis in experimental design, and how does… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the 'double descent' phenomenon in modern machine l… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is the difference between aleatoric and epistemic unce… hard MCQ Unsolved
Data Science & AI • Machine Learning (ML)
○ What is Generative AI mainly used for? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following is an example of Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What type of model is commonly used in Generative AI for t… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following can Generative AI create? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is the input given to a Generative AI model called? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which company developed the GPT series? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What does “GPT” stand for? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following is a Generative AI tool for images? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Generative AI models learn from: easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is a common risk of Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is the main goal of Generative AI models? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following tasks can Generative AI perform? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is a "training dataset" in Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following best describes a Generative AI mode… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which input would you give to generate an image using Gene… easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is one advantage of Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which field commonly uses Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What happens if a Generative AI model is trained on poor-q… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following is NOT a use of Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Why is Generative AI called "generative"? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is the main purpose of attention masking in transforme… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which scenario best demonstrates mode collapse in generati… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which technique helps reduce hallucinations in large langua… easy MCQ Unsolved
Data Science & AI • Generative AI
○ In a Variational Autoencoder (VAE), why is the KL divergen… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What does "fine-tuning with instruction data" primarily ach… easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is the main reason diffusion models generate higher-q… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which metric is commonly used to evaluate text generation q… easy MCQ Unsolved
Data Science & AI • Generative AI
○ In transformer-based generative models, what role does sel… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is the purpose of embeddings in NLP models? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following best explains temperature in text g… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which sampling method selects tokens based on cumulative pr… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Why is teacher forcing used during training of sequence mo… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is a prompt template in Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is a key limitation of GAN training? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is the key advantage of transformer models over RNNs? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which technique is commonly used to control the output sty… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which factor mainly affects model inference speed? easy MCQ Unsolved
Data Science & AI • Generative AI
○ In generative AI, what does latent space interpolation dem… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is "zero-shot learning" in Generative AI? easy MCQ Unsolved
Data Science & AI • Generative AI
○ Why are large language models considered autoregressive? medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which issue arises when a model is too sensitive to input p… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Which issue arises if a generative model memorizes trainin… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is the purpose of gradient clipping? easy MCQ Unsolved
Data Science & AI • Generative AI
○ In diffusion models, what happens during the forward proce… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which concept allows combining multiple models for better r… easy MCQ Unsolved
Data Science & AI • Generative AI
○ Why are embeddings important in generative AI models? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is a major challenge in training large generative mode… easy MCQ Unsolved
Data Science & AI • Generative AI
○ What is the main advantage of using pretrained generative … medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following is an example of text generated by A… easy MCQ Unsolved
Data Science & AI • Generative AI
○ In beam search decoding, what is the role of the beam widt… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which scenario best illustrates hallucination in large lan… medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is the purpose of fine-tuning a generative model? medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which factor primarily influences the diversity of outputs… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Why is positional encoding necessary in transformer models? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is a key benefit of using LoRA (Low-Rank Adaptation) … medium MCQ Unsolved
Data Science & AI • Generative AI
○ You fine-tune a large language model on a small medical da… hard MCQ Unsolved
Data Science & AI • Generative AI
○ What type of data is commonly used to train Generative AI? medium MCQ Unsolved
Data Science & AI • Generative AI
○ A GAN generator loss keeps decreasing, but generated image… hard MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following best describes an AI-generated image? medium MCQ Unsolved
Data Science & AI • Generative AI
○ You observe that increasing temperature from 0.7 to 1.5 in… hard MCQ Unsolved
Data Science & AI • Generative AI
○ What is the output of a Generative AI model? medium MCQ Unsolved
Data Science & AI • Generative AI
○ In a transformer, removing positional encoding leads to: hard MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following can be generated using AI? medium MCQ Unsolved
Data Science & AI • Generative AI
○ You are using top-p (nucleus) sampling with p = 0.9. What … hard MCQ Unsolved
Data Science & AI • Generative AI
○ What is a simple use of Generative AI in daily life? medium MCQ Unsolved
Data Science & AI • Generative AI
○ During training of a VAE, you observe that the KL divergen… hard MCQ Unsolved
Data Science & AI • Generative AI
○ Which input helps AI generate better results? medium MCQ Unsolved
Data Science & AI • Generative AI
○ A diffusion model produces blurry outputs even after long … hard MCQ Unsolved
Data Science & AI • Generative AI
○ What does AI learn during training? medium MCQ Unsolved
Data Science & AI • Generative AI
○ In LoRA-based fine-tuning, why does freezing the base mode… hard MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following is NOT created by Generative AI? medium MCQ Unsolved
Data Science & AI • Generative AI
○ You notice that your LLM repeats phrases excessively in lo… hard MCQ Unsolved
Data Science & AI • Generative AI
○ What is a chatbot powered by Generative AI used for? medium MCQ Unsolved
Data Science & AI • Generative AI
○ You train a generative model and find that validation loss… hard MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following improves AI output quality? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What kind of task is image generation? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What happens when you give unclear prompts to AI? medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following best describes AI-generated text? medium MCQ Unsolved
Data Science & AI • Generative AI
○ What is the purpose of gradient clipping? medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which concept allows combining multiple models for better r… medium MCQ Unsolved
Data Science & AI • Generative AI
○ Which of the following best describes ETL? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the purpose of the “Extract” phase in ETL? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following could be a target system in ETL? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following is a common transformation task? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ What type of data issue is handled during transformation? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ ETL is mainly used in which domain? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following best describes “data transformation… easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which format might data be extracted from? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Why is ETL important for businesses? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which step ensures data is ready for analysis? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ A company extracts customer data from multiple sources. So… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which ETL stage is MOST responsible for minimizing data tr… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A data warehouse requires all dates to be in YYYY-MM-DD fo… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which issue occurs if ETL loads data without enforcing con… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A pipeline processes only newly added records based on tim… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Why is a staging area used in ETL pipelines? medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A transformation aggregates daily sales into monthly total… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ If ETL jobs fail due to schema mismatch between source and… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which scenario BEST represents a drawback of batch ETL? medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which ETL approach is MOST suitable for real-time fraud de… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A company wants to track historical changes in customer ad… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ During ETL, a developer pushes filtering logic into the so… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which situation would MOST likely cause data skew during E… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A pipeline fails because late-arriving data updates alread… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which ETL strategy is BEST when dealing with APIs that hav… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the primary goal of data lineage in ETL systems? medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which issue arises when ETL jobs overwrite data instead of… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A company splits ETL workloads across multiple servers to … medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following BEST ensures that ETL jobs can reco… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ In ETL pipelines, what is the purpose of schema evolution … medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ An ETL pipeline implementing SCD Type 2 shows overlapping … hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ In an incremental load, some records are duplicated after … hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ A data warehouse query becomes extremely slow after adding… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ An ETL pipeline fails to capture late-arriving data in a f… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ A CDC pipeline incorrectly classifies updates as inserts. … hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ Why can replacing NULL values with default values in ETL b… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ A fact table is loaded before dimension tables are updated… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ An ETL pipeline using timestamps misses some records due t… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ When is ELT preferred over ETL in modern architectures? hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ Why are surrogate keys preferred over natural keys in dime… hard MCQ Unsolved
Data Engineering & Big Data • ETL
○ A company wants to remove duplicate customer records based … medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which technique helps reduce ETL processing time by dividin… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A pipeline loads data every night at 2 AM. What type of pro… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which method ensures that sensitive data like credit card n… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the purpose of using surrogate keys in ETL pipeline… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ If data is extracted from multiple sources with different s… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which operation converts categorical data into numerical fo… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the main benefit of incremental ETL over full load? medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following helps ensure data consistency during… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ A company needs to combine customer and order data into a s… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which challenge arises when ETL processes very large datase… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ What does data validation ensure in ETL pipelines? medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which technique is used to combine multiple records into su… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ What happens if ETL processes run without proper error hand… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which ETL component is responsible for delivering processed… medium MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which phase of ETL is responsible for moving data into the … easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following is an example of a data source in ET… easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the main purpose of ETL pipelines? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which file type is commonly used to store structured data f… easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which step involves removing unwanted records from data? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which system is typically used to store processed ETL data? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following describes raw data ? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which phase prepares data for analysis by applying rules? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following tools is commonly used in ETL? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which operation removes duplicate records from a dataset? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which ETL phase collects data from multiple sources? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following ensures data is correctly formatted? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ What is the final step in a typical ETL process? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which of the following is used to visualize ETL output data? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ Which term refers to combining data from different sources? easy MCQ Unsolved
Data Engineering & Big Data • ETL
○ In a shop, the profit is 320% of the cost. If the cost incr… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ In a certain code language, 'CHURCH' is code for 'SXIFSX'. … easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Passage interpretation easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Fill in the missing value. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Faculty office allocation preferences (P by lab, Q by lift,… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Passage interpretation easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ A man walks at 3 km/h and runs at 9 km/h. In 4 hours, ratio… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Group figures into 3 classes. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Which data structure works on FIFO? easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Time complexity of linear search in an unsorted array. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Data structure using LIFO order. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Max number of nodes at level l in a binary tree. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Sorting algorithm with best average case among given. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Man gains 20%; at Rs. 5 more, gain is 25%. Find cost price. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Covariance sign between hours studied and test scores (incr… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Statistical test with n=25 patients, population variance un… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Overfitting: 98% train accuracy, 75% validation. First step? easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Bank needs explanations for loan denial. Choose model. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ SQL—Select first & last names in 'Sales' with salary > 5000… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Customers + Orders—count orders per customer. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Products & Categories—count products per category > 10, sor… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ DSA—time complexity of ComputeValue(n) with doubling recurs… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Alternating edge types shortest path. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Unbounded knapsack DP for ad campaigns. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ AVL insertion of 45—final balanced structure. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Find unique element where others appear thrice. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Streaming median—best data structure approach. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Probability—P(CS | Grade A) from table. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Exponential memoryless—P(T ≥ 1000 | T ≥ 500). easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Mayor's conclusion depends on which assumption? easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Work-rate problem—days Carl works. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Floor-language assignment logic—who is on Floor 4? easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Five-number summary—most defensible conclusion. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Correlation between session duration and purchase amount—va… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ A/B test CTR—p=0.04 at alpha=0.05—business conclusion. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ SQL—Departments with >5 employees and avg salary > 75000. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Top 2 products per category by quantity sold. easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ Total purchase per customer assisted by New York salesperso… easy MCQ Unsolved
Aptitude & Reasoning • Quantitative Aptitude
○ The 16th century was an age of great ______ exploration. easy MCQ Unsolved
Verbal Ability • Reading Comprehension
○ Scenario: StartupTech has 20 developers who want to build m… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: A law firm wants email, document storage, video c… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: GameDev Studio needs complete control over their … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: MedTech company uses Salesforce for CRM, Google W… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: University IT department manages 1000 student com… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: E-commerce company needs: web hosting infrastruct… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: DataCorp processes sensitive financial data and n… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: RetailChain stores customer data on private cloud… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Software company offers their application to cust… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Government agencies want to share cloud infrastru… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Online banking system needs to securely exchange … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Social media platform stores user passwords and n… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Email system needs to ensure that emails haven't … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: File sharing service wants to verify file integri… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company needs to distribute software updates secu… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: IoT devices with limited processing power need to… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Legal firm needs to ensure that signed contracts … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Two companies want to securely communicate but ha… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Database stores customer credit card information.… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Cloud storage service wants to encrypt user files… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Employees receive emails claiming to be from IT s… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: E-commerce website becomes completely inaccessibl… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Security audit reveals that an attacker has been … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: User downloads what appears to be a legitimate an… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Hospital's computer systems are encrypted by atta… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Web application allows users to search products. … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Corporate WiFi appears to be working normally, bu… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Attacker tries thousands of password combinations… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Software vulnerability is discovered that has no … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Attacker calls employees pretending to be from IT… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company network needs protection from unauthorize… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: IT team wants to detect when attackers are scanni… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Remote employees need secure access to company re… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company implements security system that not only … easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Organization wants employees to use strong authen… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Network administrator needs to monitor all traffi… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company discovers that sensitive data is being ac… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Organization needs to ensure that security softwa… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company wants to segment their network so that if… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Security team needs to respond quickly to inciden… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Web application experiences slow performance. Inv… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Company needs to ensure that data sent between of… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Network technician needs to troubleshoot why comp… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Email system needs to translate between different… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Network device needs to forward data packets base… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Hospital's computer systems are hit by ransomware… medium MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Global company must comply with GDPR (Europe), HI… hard MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: E-commerce company's main data center floods duri… hard MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Financial services firm needs to demonstrate to r… hard MCQ Unsolved
Company Specific Preparation • Capgemini
○ Scenario: Manufacturing company needs to ensure business op… easy MCQ Unsolved
Company Specific Preparation • Capgemini
○ What is the universally accepted convention for importing N… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which of the following correctly creates a 1-D NumPy array … easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.ones((3, 4)) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the output of np.arange(2, 10, 2)? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ How many elements does np.linspace(0, 1, 5) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.zeros((4, 3, 2)), what is a.shape? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does the ndim attribute of a NumPy array represent? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the default dtype when you call np.array([1, 2, 3])? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.ones((3, 4)), what is a.size? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.array([10, 20, 30, 40, 50]), what is a[2]? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.array([10, 20, 30, 40, 50]), what is a[-1]? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.arange(10), what does a[2:7:2] return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the shape of np.array([[1, 2, 3], [4, 5, 6]])? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the default dtype when you call np.array([1.0, 2.0,… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does the following produce?a = np.array([1.7, 2.9, 3.1… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.arange(12), what is a.reshape(3, 4).shape? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the result of np.array([1, 2, 3]) + np.array([4, 5,… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.array([1, 2, 3]) * 3 return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.sqrt(np.array([4, 9, 16])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.zeros_like(np.array([[1.0, 2.0], [3.0, 4.0]]))… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.eye(3) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.full((2, 3), 7) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.sum(np.array([[1, 2], [3, 4]])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([3, 1, 4, 1, 5, 9, 2, 6]), what does np.mi… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is np.mean(np.array([2.0, 4.0, 6.0, 8.0]))? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the key difference between b = a and b = a.copy() w… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.abs(np.array([-3, -1, 0, 2, -5])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.floor(np.array([1.2, 2.7, -1.2, -2.7])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([[1,2,3],[4,5,6]]) with shape (2,3), what … easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.diag(np.array([1, 2, 3])) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the purpose of np.random.seed(42)? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What range of values does np.random.rand(3, 3) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.sort(np.array([3, 1, 4, 1, 5])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([10, 50, 30, 80, 20]), what does np.argmax… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.unique(np.array([3, 1, 4, 1, 5, 9, 2, 6, 5, 3]… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the difference between a.flatten() and a.ravel()? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.log(np.e) return (where np.e ≈ 2.718)? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does (np.array([1, 5, 3, 8, 2]) > 3) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.concatenate([np.array([1,2]), np.array([3,4])]… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.where(np.array([1,-2,3,-4]) > 0) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([[1,2,3],[4,5,6],[7,8,9]]), what is a[1, 2… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.arange(12).reshape(3,4), what does a[:, 1] retur… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.clip(np.array([1, 5, 10, 15, 20]), 3, 12) retu… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.cumsum(np.array([1, 2, 3, 4])) return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.array_equal(np.array([1,2,3]), np.array([1,2,3… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.any(np.array([False, False, True, False])) ret… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ How do you count the number of elements greater than 5 in a… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the correct statement about np.linspace vs np.arang… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.dot(np.array([1, 2, 3]), np.array([4, 5, 6])) … easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the dtype of np.array([True, False, True])? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What issue can arise with np.arange(0, 1, 0.1)? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.array([42.0]).item() return? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the key property of np.empty((3, 3))? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.arange(24).reshape(4, -1) produce? easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.logical_and(np.array([True, True, False]), np.… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given Z = np.arange(50), which expression reverses the vect… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which code correctly normalizes a matrix Z (min-max scaling… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a random vector Z of size 10, what is the idiomatic N… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.ndenumerate(Z) yield for Z = np.arange(4).resh… easy MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([10, 20, 30, 40, 50]), what does a[a > 25]… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([10, 20, 30, 40, 50]), what does a[[0, 2, … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which pair of shapes can be broadcast together in NumPy? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.array([[1],[2],[3]]) + np.array([10, 20, 30]) … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a = np.array([[1,2],[3,4]]) and b = np.array([[5,6],[… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.split(np.arange(10), 5) produce? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([2.0, 4.0, 4.0, 4.0, 5.0, 5.0, 7.0, 9.0]),… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.median(np.array([3, 1, 4, 1, 5, 9, 2, 6])) ret… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.percentile(np.arange(101), 75) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given A = np.ones((3,4)) and B = np.ones((4,2)), what is th… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.det(np.array([[3,8],[4,6]])) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the key property of np.linalg.inv(A) for a square m… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What distribution does np.random.randn(1000) sample from? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([30, 10, 50, 20, 40]), what does np.argsor… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.where(np.array([1,-2,3,-4]) > 0, 1, -1) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.mean(np.array([1.0, 2.0, np.nan, 4.0])) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the correct way to find NaN values in a NumPy array… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.nanmean(np.array([1.0, 2.0, np.nan, 4.0, np.na… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Consider: a = np.arange(5); b = a[1:3]; b[0] = 99. What is … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([1, 2, 3]) with shape (3,), what is np.exp… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does a[:, np.newaxis] do if a has shape (5,)? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.tile(np.array([1, 2, 3]), 3) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.repeat(np.array([1, 2, 3]), [2, 3, 1]) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([[1,2,3],[4,5,6]]), what does np.sum(a, ax… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.cov(np.array([1,2,3,4,5])) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the range of values in the output of np.corrcoef(x,… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.norm(np.array([3.0, 4.0])) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.solve(A, b) compute? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the purpose of np.meshgrid(x, y)? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.diff(np.array([1, 3, 6, 10, 15])) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a sorted array a = np.array([1, 3, 5, 7, 9]), what does… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.pad(np.array([1,2,3]), pad_width=1, mode="cons… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.flip(np.array([[1,2,3],[4,5,6]]), axis=1) retu… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.roll(np.array([1,2,3,4,5]), shift=2) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.squeeze(np.zeros((1, 3, 1, 5))).shape return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.apply_along_axis(np.mean, 0, np.array([[1,2],[… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the primary purpose of np.vectorize()? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.lexsort((np.array([3,1,2,1]), np.array([2,2,1,… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For np.histogram(np.array([1,2,3,4,5,6,7,8,9,10]), bins=5),… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.nan_to_num(np.array([1.0, np.nan, np.inf, -np.… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([[1,2],[3,4]]), what does np.cumsum(a, axi… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.outer(np.array([1,2,3]), np.array([4,5,6])) pr… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.allclose(np.array([1.0, 2.0]), np.array([1.000… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.einsum("ij,jk->ik", A, B) compute? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.random.choice(np.array([10,20,30,40]), size=3,… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ How do you create a NumPy structured array with fields "nam… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.interp(2.5, np.array([1,2,3,4]), np.array([10,… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which operation normalizes array values to [0, 1] (min-max … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the purpose of np.piecewise()? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which code generates 1000 samples from N(mean=5, std=2)? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the rank of np.array([[1,2,3],[4,5,6],[7,8,9]])? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.ix_([0,2],[1,3]) return and how is it used? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.broadcast_to(np.array([1,2,3]), (3,3)) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is np.nditer() primarily used for? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([1, -2, 3, -4, 5]), after a[a < 0] = 0, wh… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.gradient(np.array([1.0, 4.0, 9.0, 16.0, 25.0])… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.take(np.array([[1,2],[3,4],[5,6]]), [0,2], axi… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.digitize(np.array([0.5, 1.5, 2.5, 3.5]), np.ar… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is np.kron() used for? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given a=np.array([1,2,3]) and b=np.array([4,5,6]), what doe… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.lstsq(A, b, rcond=None) solve? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the purpose of numpy.ma (masked arrays)? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.cross(np.array([1,0,0]), np.array([0,1,0])) re… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.rot90(np.array([[1,2],[3,4]])) produce by defa… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.roots(np.array([1, -3, 2])) return? (Represent… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the key difference between np.ogrid[0:3, 0:3] and n… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.arange(9).reshape(3,3), what does a[[0,2], [1,2]… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.array([1,2,3,4,5,6]), how do you select elements… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the primary use of np.fft.fft()? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.convolve(np.array([1,2,3]), np.array([0,1,0.5]… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.broadcast_arrays(np.array([[1],[2],[3]]), np.a… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.eig(A) return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the key difference between np.random.shuffle(a) and… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a matrix A of shape (m, n), what shapes do the componen… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.char.upper(np.array(["hello", "world"])) retur… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What are the results of the following four expressions?0 * … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does (0.3 == 3 * 0.1) return in NumPy? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the output of the following script?print(sum(range(… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the most concise way to create a 10×10 array with 1… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.diag(1 + np.arange(4), k=-1) produce? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the output of the following code?Z = np.zeros((8,8)… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a shape (6, 7, 8) array, what is the index (x, y, z) of… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the most efficient NumPy way to find the most frequ… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ The cumsum-based moving average implementation is:ret = np.… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does X - X.mean(axis=1, keepdims=True) accomplish for … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ How do you sort a 2-D array Z by its second column (index 1… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the most efficient NumPy way to find the closest va… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For Z = np.random.randint(0,3,(3,10)), how do you check if … medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.iinfo(np.int8).max return? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ Given Z = np.random.random((10,2)) representing (x,y) point… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.fromiter(gen, dtype=float, count=-1) do? medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ How do you insert 3 zeros between each element of Z = np.ar… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ How do you multiply a (5,5,3) array A by a (5,5) array B el… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ The 2-D Gaussian array is computed as:X, Y = np.meshgrid(li… medium MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.zeros((3, 4), dtype=np.float64), what does a.str… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the output of np.arange(6).reshape(2,3).flags["C_CO… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.lib.stride_tricks.as_strided create, and what … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which of the following returns True from np.shares_memory(a… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does 0.1 + 0.2 == 0.3 return in NumPy and why? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.int8(127) + np.int8(1) return? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ When should you use np.linalg.eigh() instead of np.linalg.e… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.fft.fftfreq(8, d=0.1) return? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.zeros((2,3,4,5)), what is a[..., 0].shape? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.add.reduce(np.array([1, 2, 3, 4, 5])) return? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.multiply.outer(np.array([1,2,3]), np.array([10… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.qr(A) return and what property do the f… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the requirement for np.linalg.cholesky(A) to succee… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.einsum("ii->", A) compute? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.linalg.matrix_power(np.array([[1,1],[1,0]]), 1… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ When is np.linalg.pinv() (Moore-Penrose pseudoinverse) pref… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the difference between np.frompyfunc(func, nin, nou… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ How can np.lib.stride_tricks.as_strided be used to create a… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For ma = np.ma.array([1,2,3,4,5], mask=[0,0,1,0,1]), what d… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the primary advantage of np.memmap for very large d… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.array([1.0, 0.0, -1.0]) / 0.0 return in NumPy … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which shapes can be broadcast together: a.shape=(5,1,4), b.… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.testing.assert_array_almost_equal(a, b, decima… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.frexp(np.array([4.0, 0.5])) return? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Why does a.T.copy() sometimes improve performance over a.T? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does a.base return for a NumPy array a? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What shape does np.linalg.svd(np.zeros((10,5)), full_matric… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For summing a 10-million element array, approximately how m… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Why is np.linalg.lstsq(X, y) preferred over (X.T @ X)^(-1) … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.einsum("bij,bjk->bik", A, B) compute for A.sha… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.fromfunction(lambda i,j: i==j, (3,3), dtype=in… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For dt = np.dtype([('x', np.float64), ('y', np.float64)]) a… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the preferred way to create reproducible random num… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.poly1d([1, -3, 2])(2.0) compute? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the time and space complexity of broadcasting a.sha… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For A = np.array([[0,-1],[1,0]]) (90° rotation matrix), wha… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ A signal is sampled at 1000 Hz. What is the maximum frequen… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the primary use of a.ctypes.data? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the difference between np.poly1d and np.polynomial.… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does the return_inverse=True parameter in np.unique() … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a = np.arange(12).reshape(3,4), np.argmax(a) returns 11… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.gradient(Z) return when Z is a 2-D array? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Which np.einsum call is most efficient for computing the tr… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does a condition number > 1e15 for a matrix A indicate… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does it mean that NumPy arrays support the Python buff… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What do the following expressions return?np.array(0) // np.… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Consider integer vector Z = np.arange(5). Which of the foll… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ The following uses stride_tricks to build a sliding window … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For Z = np.arange(1,15,dtype=np.uint32), what does as_strid… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a 16×16 array of ones, how does np.add.reduceat compute… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the most idiomatic NumPy way to swap rows 0 and 1 o… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For A = np.random.randint(0,10,(3,4,3,4)), how do you compu… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.bincount([1,3,9,3,4,1], weights=[1,2,3,4,5,6])… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ Using np.bincount, how do you efficiently compute the mean … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ np.add.reduce(Z) vs np.sum(Z): which is faster and why? hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For x = np.random.rand(50000000), rank these from FASTEST t… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For a shuffled array of 10000 elements, how do you efficien… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does np.subtract.outer(X, Y) compute for X = np.arange… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What does ((I.reshape(-1,1) & (2**np.arange(8))) != 0).asty… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ What is the trick used in the "extract unique rows" exercis… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For p=10 matrices M of shape (n,n) and p vectors V of shape… hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ For an RGB image I of shape (h,w,3) with dtype=uint8, what … hard MCQ Unsolved
Data Analytics & Tools • NumPy
○ A dataset of seven employees' salaries (in thousands) is: 4… easy MCQ Unsolved
Data Science & AI • Statistics
○ Which of the following best describes the interquartile ran… easy MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist rescales every value in a dataset by multi… easy MCQ Unsolved
Data Science & AI • Statistics
○ In a right-skewed (positively skewed) unimodal distribution… easy MCQ Unsolved
Data Science & AI • Statistics
○ A quality control team tests 80 randomly chosen light bulbs… easy MCQ Unsolved
Data Science & AI • Statistics
○ A distribution has a kurtosis value significantly greater t… medium MCQ Unsolved
Data Science & AI • Statistics
○ An analyst compares the variability of two investments. Inv… medium MCQ Unsolved
Data Science & AI • Statistics
○ Using the Tukey fence rule, a value is flagged as a potenti… medium MCQ Unsolved
Data Science & AI • Statistics
○ What is the variance of the constant dataset {5, 5, 5, 5, 5… easy MCQ Unsolved
Data Science & AI • Statistics
○ Which measure of central tendency is most appropriate for s… easy MCQ Unsolved
Data Science & AI • Statistics
○ A student scores at the 85th percentile on a standardized e… easy MCQ Unsolved
Data Science & AI • Statistics
○ Why does the formula for sample variance use (n − 1) in the… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist applies a log transformation to a right-sk… medium MCQ Unsolved
Data Science & AI • Statistics
○ A student scores 78 on a test where the class mean is 70 an… easy MCQ Unsolved
Data Science & AI • Statistics
○ The covariance between two variables X and Y is found to be… medium MCQ Unsolved
Data Science & AI • Statistics
○ A fair six-sided die is rolled. What is the probability of … easy MCQ Unsolved
Data Science & AI • Statistics
○ The probability that it rains on any given day in a city is… easy MCQ Unsolved
Data Science & AI • Statistics
○ In a group of 200 people, 80 exercise regularly and 40 of t… easy MCQ Unsolved
Data Science & AI • Statistics
○ Two events A and B are called statistically independent if … easy MCQ Unsolved
Data Science & AI • Statistics
○ A medical test for a rare disease has 99% sensitivity (true… hard MCQ Unsolved
Data Science & AI • Statistics
○ A spam filter has learned that P(word 'free' | spam) = 0.60… hard MCQ Unsolved
Data Science & AI • Statistics
○ Events A and B are mutually exclusive and both have positiv… hard MCQ Unsolved
Data Science & AI • Statistics
○ A lottery ticket costs $5. It pays $50 with probability 0.0… easy MCQ Unsolved
Data Science & AI • Statistics
○ Random variable X has mean μ = 4 and Var(X) = 9. A new vari… medium MCQ Unsolved
Data Science & AI • Statistics
○ The Law of Large Numbers states that: easy MCQ Unsolved
Data Science & AI • Statistics
○ A quality inspector examines 10 products, each independentl… medium MCQ Unsolved
Data Science & AI • Statistics
○ A call center receives an average of 8 calls per hour. Assu… medium MCQ Unsolved
Data Science & AI • Statistics
○ According to the empirical rule (68-95-99.7 rule), approxim… easy MCQ Unsolved
Data Science & AI • Statistics
○ A server processes requests with an average wait time of 4 … medium MCQ Unsolved
Data Science & AI • Statistics
○ A random number generator produces values uniformly distrib… easy MCQ Unsolved
Data Science & AI • Statistics
○ The Central Limit Theorem (CLT) states that: easy MCQ Unsolved
Data Science & AI • Statistics
○ A population has standard deviation σ = 20. An analyst take… easy MCQ Unsolved
Data Science & AI • Statistics
○ A researcher measures the income of 400 randomly sampled ho… medium MCQ Unsolved
Data Science & AI • Statistics
○ In the famous 1936 U.S. presidential poll, the Literary Dig… easy MCQ Unsolved
Data Science & AI • Statistics
○ An online satisfaction survey is sent to all customers of a… medium MCQ Unsolved
Data Science & AI • Statistics
○ During WWII, the Allies wanted to add armor to aircraft usi… medium MCQ Unsolved
Data Science & AI • Statistics
○ A survey aims to estimate average monthly spending for thre… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist has 30 observations and wants to estimate … medium MCQ Unsolved
Data Science & AI • Statistics
○ A pollster estimates a candidate's support with a margin of… medium MCQ Unsolved
Data Science & AI • Statistics
○ A product team assigns users to Control or Treatment by fli… medium MCQ Unsolved
Data Science & AI • Statistics
○ A study finds that children who own more books at home have… hard MCQ Unsolved
Data Science & AI • Statistics
○ Hospital A has a higher overall patient survival rate than … hard MCQ Unsolved
Data Science & AI • Statistics
○ In classical hypothesis testing, what does the null hypothe… easy MCQ Unsolved
Data Science & AI • Statistics
○ The p-value in a hypothesis test is best defined as: easy MCQ Unsolved
Data Science & AI • Statistics
○ A researcher obtains p = 0.03 and states: 'There is only a … hard MCQ Unsolved
Data Science & AI • Statistics
○ A Type I error in hypothesis testing is best described as: easy MCQ Unsolved
Data Science & AI • Statistics
○ A clinical trial has 70% statistical power at the chosen si… medium MCQ Unsolved
Data Science & AI • Statistics
○ Study 1 (n = 100,000) finds statistically significant weigh… medium MCQ Unsolved
Data Science & AI • Statistics
○ A researcher tests whether a new drug changes blood pressur… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data analyst runs 20 independent hypothesis tests, each a… medium MCQ Unsolved
Data Science & AI • Statistics
○ An analyst runs 10 hypothesis tests and applies a Bonferron… easy MCQ Unsolved
Data Science & AI • Statistics
○ A poll reports a candidate's support at 52%, with a 95% con… easy MCQ Unsolved
Data Science & AI • Statistics
○ Which of the following changes would NARROW a 95% confidenc… easy MCQ Unsolved
Data Science & AI • Statistics
○ An analyst wants to test whether the mean delivery time equ… medium MCQ Unsolved
Data Science & AI • Statistics
○ With n = 500,000 users, a company finds a new website desig… medium MCQ Unsolved
Data Science & AI • Statistics
○ A churn prediction model has 90% precision and 85% recall. … hard MCQ Unsolved
Data Science & AI • Statistics
○ An analyst wants to test whether mean customer satisfaction… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data analyst wants to test whether customer preference fo… medium MCQ Unsolved
Data Science & AI • Statistics
○ A Pearson correlation of r = −0.85 between weekly study hou… easy MCQ Unsolved
Data Science & AI • Statistics
○ A researcher finds that cities with more ice cream shops ha… easy MCQ Unsolved
Data Science & AI • Statistics
○ A regression model for predicting house price (in $000s) fr… medium MCQ Unsolved
Data Science & AI • Statistics
○ A regression model achieves R² = 0.72. Which statement accu… medium MCQ Unsolved
Data Science & AI • Statistics
○ A multiple regression model predicting house price includes… hard MCQ Unsolved
Data Science & AI • Statistics
○ After fitting a linear regression, a data scientist plots r… medium MCQ Unsolved
Data Science & AI • Statistics
○ A sports team finished last in the league. The following ye… hard MCQ Unsolved
Data Science & AI • Statistics
○ When should Spearman's rank correlation be preferred over P… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist fits a degree-20 polynomial to 25 data poi… medium MCQ Unsolved
Data Science & AI • Statistics
○ Why should a data scientist prefer adjusted R² over R² when… medium MCQ Unsolved
Data Science & AI • Statistics
○ A model exhibits high bias and low variance. Which descript… medium MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist fits a StandardScaler on the entire datase… medium MCQ Unsolved
Data Science & AI • Statistics
○ Why is k-fold cross-validation generally preferred over a s… medium MCQ Unsolved
Data Science & AI • Statistics
○ A fraud detection model achieves 99.5% accuracy. The fraud … hard MCQ Unsolved
Data Science & AI • Statistics
○ In a fraud detection system, increasing the decision thresh… medium MCQ Unsolved
Data Science & AI • Statistics
○ A logistic regression model outputs P(disease) = 0.85 for a… hard MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist trains 500 models on 500 independently res… hard MCQ Unsolved
Data Science & AI • Statistics
○ An AUC-ROC of 0.72 for a binary classifier means: medium MCQ Unsolved
Data Science & AI • Statistics
○ A linear regression model suffers from high variance. How d… medium MCQ Unsolved
Data Science & AI • Statistics
○ A gradient-boosted model predicting churn shows 'account ag… hard MCQ Unsolved
Data Science & AI • Statistics
○ A data scientist builds a loan default predictor and engine… hard MCQ Unsolved
Data Science & AI • Statistics
○ In Maximum Likelihood Estimation (MLE), the goal is to: hard MCQ Unsolved
Data Science & AI • Statistics
○ For a highly imbalanced dataset with a 1% positive rate, wh… hard MCQ Unsolved
Data Science & AI • Statistics
○ A loan default model trained on 2019–2021 data degrades sig… hard MCQ Unsolved
Data Science & AI • Statistics
○ A researcher selects features by their correlation with the… hard MCQ Unsolved
Data Science & AI • Statistics
○ As regularization strength λ in Ridge regression increases … hard MCQ Unsolved
Data Science & AI • Statistics
○ A 2×2 contingency table shows the relationship between smok… medium MCQ Unsolved
Data Science & AI • Statistics
○ In a case-control study, the odds of prior exposure are 3:1… hard MCQ Unsolved
Data Science & AI • Statistics
○ A logistic regression model for credit default outputs coef… hard MCQ Unsolved
Data Science & AI • Statistics
○ DNA evidence shows a 1-in-1-million chance of a random pers… hard MCQ Unsolved
Data Science & AI • Statistics
○ A Bayesian analyst models a coin's bias using a Beta(2, 2) … hard MCQ Unsolved
Data Science & AI • Statistics
○ A study finds that countries with higher average chocolate … hard MCQ Unsolved
Data Science & AI • Statistics
○ A QQ plot of a dataset against the normal distribution show… medium MCQ Unsolved
Data Science & AI • Statistics
○ A population has a Cauchy distribution, which has no finite… hard MCQ Unsolved
Data Science & AI • Statistics
○ An A/B test shows the new checkout design increases overall… hard MCQ Unsolved
Data Science & AI • Statistics
○ An analyst runs 1,000 hypothesis tests in a gene expression… hard MCQ Unsolved
Data Science & AI • Statistics
○ A company reports its 'average employee salary' as $95,000.… easy MCQ Unsolved
Data Science & AI • Statistics
○ A business decides whether to launch a product. Success (pr… easy MCQ Unsolved
Data Science & AI • Statistics
○ When performing cross-validation on a highly imbalanced dat… medium MCQ Unsolved
Data Science & AI • Statistics
○ An A/B test gives p = 0.06. The frequentist conclusion is '… hard MCQ Unsolved
Data Science & AI • Statistics
○ A study regresses police spending on crime rates and finds … hard MCQ Unsolved
Data Science & AI • Statistics
○ A contestant picks one of three doors (one hides a car, two… hard MCQ Unsolved
Data Science & AI • Statistics
○ What is the primary goal of data analytics? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is an example of structured data? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which tool is commonly used for data visualization? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What does ETL stand for in data analytics? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which type of analytics answers “What happened?” easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which language is widely used for data analysis? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What is a dataset? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following represents unstructured data? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the role of data cleaning? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is a measure of central tendency? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is used to store large volumes of d… easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What does a bar chart represent? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is a relational database management… easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What does “big data” refer to? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which type of analytics predicts future outcomes? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is a data visualization tool? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the purpose of a histogram? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following is NOT a type of data? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which function is used to calculate average in Excel? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the main purpose of data visualization? easy MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following best describes data granularity in … medium MCQ Unsolved
Data Analytics & Tools • Basic
○ In a dataset, if the mean is significantly higher than the… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which technique is most appropriate to reduce dimensionali… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the main purpose of using a confusion matrix? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following scenarios indicates overfitting? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which measure is most robust to outliers? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ In SQL-based analytics, which clause is used to filter agg… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What does ETL stand for in data pipelines? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which visualization is best for showing the relationship b… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the primary goal of A/B testing? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following best explains data normalization? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What happens when multicollinearity exists in a regression… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which metric is best suited for evaluating imbalanced clas… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ In data analytics, what does data wrangling involve? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following indicates a strong negative correla… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which technique is used to handle missing numerical data? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What does a box plot primarily display? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which SQL operation combines rows from two tables based on… medium MCQ Unsolved
Data Analytics & Tools • Basic
○ Which of the following best describes feature engineering? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the role of a data warehouse? medium MCQ Unsolved
Data Analytics & Tools • Basic
○ In a high-dimensional dataset, why might Principal Compone… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ Which scenario best explains Simpson’s Paradox in data ana… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ Why can multicollinearity inflate variance in regression c… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ In A/B testing, what is the most subtle consequence of pee… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ Why might a model with high R² still perform poorly in rea… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ Which condition invalidates the assumption of independence… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the primary risk of using mean imputation for miss… hard MCQ Unsolved
Data Analytics & Tools • Basic
○ Why is log transformation often applied to skewed data? hard MCQ Unsolved
Data Analytics & Tools • Basic
○ In clustering, why can K-Means fail on non-spherical data? hard MCQ Unsolved
Data Analytics & Tools • Basic
○ What is the hidden danger of high accuracy in an imbalance… hard MCQ Unsolved
Data Analytics & Tools • Basic