Skip to content
InsemMar 20242019 patternBE Comp

Business Intelligence SPPU Insem Question Paper Mar 2024

All 4 questions from this SPPU insem paper, as printed. Read them here or open the PDF.

Open the PDFMost repeated Business Intelligence questions
Subject code
410253(C)
Pattern
2019 pattern
Exam
Insem
Session
Mar 2024
Max. marks
30
Time
1 Hour
Semester
VIII
Paper code
[6270]-58

Printed for: B.E. (Computer Engineering) (Insem)

Instructions to the candidates

  1. Answer Question No. 1 or 2 and 3 or 4.
  2. Neat diagram must be drawn whenever necessary.
  3. Figures to the right indicate fall marks.
  4. Assume suitable data, if necessary.

Questions

  1. Q1

    1. a)

      Define Business Intelligence. Explain Architecture of BI.

      Also asked:May 2025 ·Feb 2023

      [5]
    2. b)

      What kind of ethics are required in business intelligence? Why?

      Also asked:May 2025 ·Feb 2023

      [5]
    3. c)

      What are the advantages of making decision using business intelligence over making decision without business intelligence?

      [5]

  2. Q2

    1. a)

      State and explain with example stages of Simon’s decision-making process.

      [5]
    2. b)

      Draw and explain schematic view of Decision Support System.

      Also asked:May 2025 ·Mar 2025

      [5]
    3. c)

      Explain role of mathematical models in BI.

      Also asked:May 2025 ·Feb 2023

      [5]

  3. Q3

    1. a)

      Draw and Explain Data Warehouse Tier Architecture.

      [5]
    2. b)

      Compare with diagram ROLAP versus MOLAP.

      [5]
    3. c)

      Write down example of Example of Fact Constellation.

      [5]

  4. Q4

    1. a)

      State the difference between Difference between OLAP and OLTP.

      Also asked:Mar 2025

      [5]
    2. b)

      Draw and Explain Star Schema. Also state which is Better: Snowflake Schema Or Star Schema?

      [5]
    3. c)

      Explain Extraction, Transformation, and Loading (ETL) 

      [5]