uiz Space

May 2025 term · Business Data Management · BSMS2001

Business Data Management End Term: 31 August 2025, Set QDD1 (May 2025 term)

The IIT Madras BS Business Data Management (BDM) End Term paper sat on 31 Aug 2025, in the May 2025 term, set QDD1: 23 questions for 30 marks in 180 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions
23
Marks
30
Duration
180 min
MCQ
19
MSQ
1
Numerical
3
Take as mock testPractise with answers

Updated

Official paper: IIT M FOUNDATION AN EXAM QDF3 31 Aug 2025 · No negative marking.

Question 1

+1 markOne correct option

In the context of economic circular flow, what do firms primarily provide to the factor market?

  1. A

    Goods and services

  2. B

    Wages and rent

  3. C

    Raw materials

  4. D

    Capital investment

Show answer

Correct answer

  • B

    Wages and rent

Question 1 on its own page

Question 2

+1 markOne correct option

Which Excel function would you use to find a value in the first column of a table and return a value from a specified column?

  1. A

    INDEX

  2. B

    MATCH

  3. C

    VLOOKUP

  4. D

    HLOOKUP

Show answer

Correct answer

  • C

    VLOOKUP

Question 2 on its own pageAlso asked in End Term 31 Aug 2025

Question 3

+1 markOne correct option

Which of the following is a non-government source of economic data in India?

  1. A

    National Sample Survey (NSS)

  2. B

    Economic Census

  3. C

    Centre for Monitoring Indian Economy (CMIE)

  4. D

    Annual Survey of Industries (ASI)

Show answer

Correct answer

  • C

    Centre for Monitoring Indian Economy (CMIE)

Question 3 on its own page

Question 4

+1 markOne correct option

What does a bimodal distribution in consumer spending data typically indicate?

  1. A

    Uniform spending across all consumers

  2. B

    Two distinct consumer groups with different spending patterns

  3. C

    Random spending behavior

  4. D

    Declining consumer confidence

Show answer

Correct answer

  • B

    Two distinct consumer groups with different spending patterns

Question 4 on its own page

Question 5

+1 markOne correct option

In a saturated market where 75% of existing customers show upgrade interest but new customer acquisition is limited, what should companies prioritize?

  1. A

    Aggressive new customer acquisition campaigns

  2. B

    Geographic expansion to untapped markets

  3. C

    Upgrade incentives and retention programs for existing customers

  4. D

    Price reduction strategies

Show answer

Correct answer

  • C

    Upgrade incentives and retention programs for existing customers

Question 5 on its own page

Question 6

+1 markOne correct option

Days Sales Outstanding (DSO) primarily measures:

  1. A

    Average time to convert inventory to sales

  2. B

    Average time to collect accounts receivable

  3. C

    Average time to pay suppliers

  4. D

    Average production cycle time

Show answer

Correct answer

  • B

    Average time to collect accounts receivable

Question 6 on its own page

Question 7

+1 markOne correct option

Which chart type is most appropriate for showing the relationship between two continuous variables?

  1. A

    Bar chart

  2. B

    Pie chart

  3. C

    Scatter plot

  4. D

    Histogram

Show answer

Correct answer

  • C

    Scatter plot

Question 7 on its own page

Question 8

+1 markOne correct option

Internal Pool Sourcing refers to:

  1. A

    Hiring external consultants

  2. B

    Filling positions from within the organization

  3. C

    Outsourcing recruitment processes

  4. D

    Creating talent pools for future hiring

Show answer

Correct answer

  • B

    Filling positions from within the organization

Question 8 on its own page

Question 9

+1 markOne correct option

To reduce credit losses, a FinTech company should:

  1. A

    Decrease credit score approval threshold

  2. B

    Increase credit score approval threshold

  3. C

    Eliminate credit checks

  4. D

    Approve all applications

Show answer

Correct answer

  • B

    Increase credit score approval threshold

Question 9 on its own page

Question 10

+1 markOne correct option

A customer purchases on ClipKart using HFCD Credit Card via PayBlade.
What is the correct payment flow sequence?

  1. A

    Customer → HFCD → ClipKart

  2. B

    Customer → HFCD → PayBlade → ClipKart

  3. C

    Customer → PayBlade → HFCD → ClipKart

  4. D

    Customer → ClipKart → HFCD → PayBlade

Show answer

Correct answer

  • C

    Customer → PayBlade → HFCD → ClipKart

Question 10 on its own page

Question 11

+1 markOne correct option

Personalized recommendations on e-commerce platforms primarily aim to:

  1. A

    Increase website traffic

  2. B

    Reduce server load

  3. C

    Improve conversion rates based on user behavior

  4. D

    Standardize user experience

Show answer

Correct answer

  • C

    Improve conversion rates based on user behavior

Question 11 on its own page

Question 12

+1 markOne correct option

Which of the following best describes a lead indicator?

  1. A

    A metric that reflects past performance

  2. B

    A measure used to predict future trends

  3. C

    A statistic that measures current output

  4. D

    A financial result already realized

Show answer

Correct answer

  • B

    A measure used to predict future trends

Question 12 on its own page

Question 13

+1 markOne correct option

Which Excel function would you use to calculate the average of a filtered range, ignoring hidden rows?

  1. A

    AVERAGE

  2. B

    SUBTOTAL

  3. C

    AGGREGATE

  4. D

    FILTER

Show answer

Correct answer

  • B

    SUBTOTAL

Question 13 on its own page

Question 14

+1 markOne correct option

What is the primary objective of conducting an A/B test?

  1. A

    To test system scalability

  2. B

    To compare performance of two or more variants

  3. C

    To validate data quality

  4. D

    To measure user satisfaction

Show answer

Correct answer

  • B

    To compare performance of two or more variants

Question 14 on its own page

Question 15

+2 marksOne or more correct options

Which of the following is NOT a typical function of pivot tables?

Select all that apply.

  1. A

    Summarizing large datasets

  2. B

    Creating new records in source data

  3. C

    Grouping data by categories

  4. D

    Calculating aggregated values

Show answer

Correct answer

  • B

    Creating new records in source data

Question 15 on its own page

Question 16

+2 marksOne correct option
  1. A

    Treatment improved both metrics

  2. B

    Treatment improved conversion but reduced transaction value

  3. C

    Control performed better on all metrics

  4. D

    No significant difference between groups

Show answer

Correct answer

  • B

    Treatment improved conversion but reduced transaction value

Question 16 on its own page

Question 17

+2 marksOne correct option
  1. A

    Campus Hiring

  2. B

    Job Portal

  3. C

    Employee Referral

  4. D

    Social Media

Show answer

Correct answer

  • C

    Employee Referral

Question 17 on its own page

Question 18

+2 marksOne correct option

Based on the following sales data, answer the given subquestions
Product Sales Data (Rs. in thousands):
Product A: 45,000
Product B: 32,000
Product C: 58,000
Product D: 28,000
Product E: 37,000

What is the market share of Product C as a percentage?

  1. A

    27.5%

  2. B

    29.0%

  3. C

    30.5%

  4. D

    32.0%

Show answer

Correct answer

  • B

    29.0%

Question 18 on its own page

Question 19

+1 markOne correct option

Based on the following sales data, answer the given subquestions
Product Sales Data (Rs. in thousands):
Product A: 45,000
Product B: 32,000
Product C: 58,000
Product D: 28,000
Product E: 37,000

Which product has the second-highest market share?

  1. A

    Product A

  2. B

    Product B

  3. C

    Product D

  4. D

    Product E

Show answer

Correct answer

  • A

    Product A

Question 19 on its own page

Question 20

+2 marksNumerical answer

What is the total monthly revenue?

Show answer

Correct answer: 1088000

Question 20 on its own page

Question 21

+1 markOne correct option

Which product has the highest Days of Inventory?

  1. A

    Alpha

  2. B

    Beta

  3. C

    Gamma

  4. D

    Delta

Show answer

Correct answer

  • B

    Beta

Question 21 on its own page

Question 22

+2 marksNumerical answer

Based on the following product data, answer the given subquestions:
Planned Production Hours: 480
Lost Time Hours: 48
Design Speed: 200 units/hour
Actual Speed: 180 units/hour
Total Units Produced: 77,760
Good Units: 74,772

Calculate Availability (in %)

Show answer

Correct answer: 90

Question 22 on its own page

Question 23

+2 marksNumerical answer

Based on the following product data, answer the given subquestions:
Planned Production Hours: 480
Lost Time Hours: 48
Design Speed: 200 units/hour
Actual Speed: 180 units/hour
Total Units Produced: 77,760
Good Units: 74,772

Calculate Overall Equipment Effectiveness (OEE) (in %)

Show answer

Correct answer: 77.5 (accepted within ±0.5)

Question 23 on its own page