uiz Space

May 2025 term · Business Data Management · BSMS2001

Business Data Management End Term: 31 August 2025, Set QDF3 (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 QDF3: 22 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
22
Marks
30
Duration
180 min
MCQ
19
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

What happens to the demand curve when consumer income increases for a normal good?

  1. A

    Shifts to the left

  2. B

    Shifts to the right

  3. C

    Remains unchanged

  4. D

    Becomes steeper

Show answer

Correct answer

  • B

    Shifts to the right

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 primarily used as a surrogate indicator?

  1. A

    Direct sales data

  2. B

    Number of vehicle registrations to estimate automobile market size

  3. C

    Customer survey responses

  4. D

    Company financial statements

Show answer

Correct answer

  • B

    Number of vehicle registrations to estimate automobile market size

Question 3 on its own page

Question 4

+1 markOne correct option

A niche market strategy focuses on:

  1. A

    Broad customer segments with general needs

  2. B

    Specific customer groups with specialized needs

  3. C

    Mass production for cost efficiency

  4. D

    Geographic expansion

Show answer

Correct answer

  • B

    Specific customer groups with specialized needs

Question 4 on its own page

Question 5

+1 markOne correct option

For a company facing declining market share, which strategy would be most appropriate?

  1. A

    Maintain current pricing

  2. B

    Reduce marketing spend

  3. C

    Analyze competitors and differentiate offerings

  4. D

    Exit the market immediately

Show answer

Correct answer

  • C

    Analyze competitors and differentiate offerings

Question 5 on its own page

Question 6

+1 markOne correct option

ABC Analysis primarily categorizes inventory based on:

  1. A

    Physical size of items

  2. B

    Alphabetical order

  3. C

    Annual monetary usage/value

  4. D

    Storage location

Show answer

Correct answer

  • C

    Annual monetary usage/value

Question 6 on its own page

Question 7

+1 markOne correct option

Which is NOT a benefit of implementing an ERP system?

  1. A

    Improved data accuracy

  2. B

    Increased data redundancy

  3. C

    Better process efficiency

  4. D

    Enhanced business visibility

Show answer

Correct answer

  • B

    Increased data redundancy

Question 7 on its own page

Question 8

+1 markOne correct option

For analyzing seasonal sales patterns, which approach is most effective?

  1. A

    Maintain constant inventory levels

  2. B

    Adjust inventory based on historical seasonal trends

  3. C

    Ignore seasonal variations

  4. D

    Focus only on peak season data

Show answer

Correct answer

  • B

    Adjust inventory based on historical seasonal trends

Question 8 on its own page

Question 9

+1 markOne correct option

In an A/B test for a mobile app redesign, the control group should receive:

  1. A

    The new app design

  2. B

    The current/original app design

  3. C

    A mix of old and new designs

  4. D

    No app access

Show answer

Correct answer

  • B

    The current/original app design

Question 9 on its own page

Question 10

+1 markOne correct option

A document outlining job requirements, budget, and skills needed is called:

  1. A

    Job Description

  2. B

    Indent

  3. C

    Appraisal Form

  4. D

    Performance Review

Show answer

Correct answer

  • B

    Indent

Question 10 on its own page

Question 11

+1 markOne correct option

When should A/B testing ideally be conducted?

  1. A

    After full deployment to all users

  2. B

    Before developing the solution

  3. C

    Before full deployment to validate changes

  4. D

    Only during system maintenance

Show answer

Correct answer

  • C

    Before full deployment to validate changes

Question 11 on its own page

Question 12

+1 markOne correct option

E-commerce platforms use scarcity nudges by:

  1. A

    Showing unlimited stock availability

  2. B

    Displaying 'Only 3 left in stock' messages

  3. C

    Hiding product information

  4. D

    Removing time limits on offers

Show answer

Correct answer

  • B

    Displaying 'Only 3 left in stock' messages

Question 12 on its own page

Question 13

+1 markOne correct option

If a company identifies a strong seasonal pattern in sales data, the optimal inventory approach is to:

  1. A

    Keep inventory constant all year

  2. B

    Increase inventory uniformly

  3. C

    Adjust safety stock and reorder levels based on seasonal forecasts

  4. D

    Eliminate safety stock entirely

Show answer

Correct answer

  • C

    Adjust safety stock and reorder levels based on seasonal forecasts

Question 13 on its own page

Question 14

+2 marksOne correct option

Smartphone Sales Analysis (Units in thousands):

Based on the above data, answer the given subquestions.

Which brand has the highest total annual revenue?

  1. A

    Samsing

  2. B

    Orange

  3. C

    TwoPlus

  4. D

    Ziome

Show answer

Correct answer

  • B

    Orange

Question 14 on its own page

Question 15

+1 markOne correct option

Smartphone Sales Analysis (Units in thousands):

Based on the above data, answer the given subquestions.

What is Orange's market share by revenue?

  1. A

    18.5%

  2. B

    21.2%

  3. C

    32.0%

  4. D

    36.4%

Show answer

Correct answer

  • C

    32.0%

Question 15 on its own page

Question 16

+2 marksNumerical answer

TechCorp Manufacturing Data for March 2024:
Week 1: Planned 500 units, Produced 480 units, Defects 24
Week 2: Planned 520 units, Produced 500 units, Defects 20
Week 3: Planned 480 units, Produced 465 units, Defects 18
Week 4: Planned 550 units, Produced 530 units, Defects 25
Based on the above data, answer the given subquestions.

Calculate the overall Quality percentage for March (in %)

Show answer

Correct answer: 95.5 (accepted within ±0.5)

Question 16 on its own page

Question 17

+2 marksOne correct option

TechCorp Manufacturing Data for March 2024:
Week 1: Planned 500 units, Produced 480 units, Defects 24
Week 2: Planned 520 units, Produced 500 units, Defects 20
Week 3: Planned 480 units, Produced 465 units, Defects 18
Week 4: Planned 550 units, Produced 530 units, Defects 25
Based on the above data, answer the given subquestions.

Which week had the best Performance percentage?

  1. A

    Week 1

  2. B

    Week 2

  3. C

    Week 3

  4. D

    Week 4

Show answer

Correct answer

  • C

    Week 3

Question 17 on its own page

Question 18

+2 marksNumerical answer

TechCorp Manufacturing Data for March 2024:
Week 1: Planned 500 units, Produced 480 units, Defects 24
Week 2: Planned 520 units, Produced 500 units, Defects 20
Week 3: Planned 480 units, Produced 465 units, Defects 18
Week 4: Planned 550 units, Produced 530 units, Defects 25
Based on the above data, answer the given subquestions.

What is the average Availability assuming 8-hour shifts with 0.5 hours lost time per day? (in %)

Show answer

Correct answer: 93.7 (accepted within ±0.5)

Question 18 on its own page

Question 19

+2 marksOne correct option

For the given data, which formula correctly calculates total sales for 'Electronics' category sold by 'John'?
Data Range A2:C10 contains:
Column A: Salesperson names
Column B: Category
Column C: Sales amount

  1. A

    =SUMIFS(C2:C10,A2:A10,"John",B2:B10,"Electronics")

  2. B

    =SUMIF(A2:A10,"John",C2:C10)+SUMIF(B2:B10,"Electronics",C2:C10)

  3. C

    =VLOOKUP("John",A2:C10,3,FALSE)

  4. D

    =COUNTIFS(A2:A10,"John",B2:B10,"Electronics")

Show answer

Correct answer

  • A

    =SUMIFS(C2:C10,A2:A10,"John",B2:B10,"Electronics")

Question 19 on its own page

Question 20

+2 marksOne correct option

E-commerce A/B Test Results:
Version A (Control): 1000 visitors, 50 purchases, Avg order value Rs.1,200
Version B (Treatment): 1000 visitors, 65 purchases, Avg order value Rs.1,150
Which metric shows improvement in Version B?

  1. A

    Conversion rate only

  2. B

    Average order value only

  3. C

    Both conversion rate and total revenue

  4. D

    Neither metric improved

Show answer

Correct answer

  • C

    Both conversion rate and total revenue

Question 20 on its own page

Question 21

+2 marksOne correct option

Rank the following candidates based on composite score (higher is better for all factors):

CandidateExperience (yrs)SkillsProjectsLeadershipTime to Join (months)
Raj4.03421
Priya4.54332
Sam3.52541
Nina5.03323

Weightage: Experience(25%), Skills(30%), Projects(25%), Leadership(20%)

Note: Lower time to join is better

Correct ranking:

  1. A

    Priya > Raj > Nina > Sam

  2. B

    Priya > Sam >Raj >Nina

  3. C

    Sam > Priya > Raj > Nina

  4. D

    Nina > Priya > Raj > Sam

Show answer

Correct answer

  • B

    Priya > Sam >Raj >Nina

Question 21 on its own page

Question 22

+2 marksNumerical answer

DigitalPay earns revenue as follows:
- 2.5% transaction fee on all payments
- 15% annual interest on credit transactions
- 8% loss rate on credit (unpaid amounts)
March transactions:
Debit payments: Rs.10,00,000
Credit payments: Rs.5,00,000
Credit defaults: Rs.40,000
Calculate net profit for March:

Show answer

Correct answer: 40550

Question 22 on its own page