Skip to content
InsemMar 20252019 patternBE Comp

Business Intelligence SPPU Insem Question Paper Mar 2025

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
410253C
Pattern
2019 pattern
Exam
Insem
Session
Mar 2025
Max. marks
30
Time
1 Hour
Semester
VIII
Paper code
[6411]-48

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

Instructions to the candidates

  1. Answer Q.1 or Q.2, Q.3 or Q.4.
  2. Figures to the right indicate full marks.
  3. Assume suitable data, if necessary.

Questions

  1. Q1

    1. a)

      Discuss the phases in the development of a decision support system.

      Also asked:May 2025 ·Mar 2024

      [5]
    2. b)

      Explain the main components of a business intelligence system with a suitable diagram.

      [5]
    3. c)

      What are several reasons for implementing a data warehouse separately from the databases supporting OLTP applications in an enterprise?

      [5]

  2. Q2

    1. a)

      Discuss the ethical problems that should not be overlooked during the adoption of business intelligence methodologies.

      [5]
    2. b)

      Discuss the Cycle of a business intelligence analysis.

      [5]
    3. c)

      Discuss the different types of decisions.

      [5]

  3. Q3

    1. a)

      Differences between OLTP and OLAP systems.

      Also asked:Mar 2024

      [5]
    2. b)

      Explain the dice or rotation operation in OLAP.

      [5]
    3. c)

      Explain the Fact Constellation Schema with a diagram.

      [5]

  4. Q4

    1. a)

      What is a digital dashboard? What are its types? Discuss anyone with an example.

      [5]
    2. b)

      What is the Star Schema? Explain the advantages and disadvantages of it.

      [5]
    3. c)

      Discuss the three main functions of ETL tools. eeee

      [5]