(SEM V ) THEORY EXAMINATION 2022-23 BUSINESS INTELLIGENCE AND ANALYTIC

Course: B.Tech (Semester V)                                                          Subject Code: KDS-051

Subject Name: Business Intelligence and Analytics                      Time: 3 Hours

Total Marks: 100

Section A – Short Answer Questions (2 × 10 = 20 Marks)

Attempt all questions briefly:

Limitations of mathematical modeling                   Factors that influence rational choice in decision-making

Define evolution and deviation analysis             Meaning of OLTP and OLAP

Purpose of data validation                                   Is PCS used for data reduction?

Four types of business analytics                          Types of variables in a dataset

What is a data repository?                                   When should root cause analysis be conducted?

Section B – Descriptive Questions (10 × 3 = 30 Marks)

Attempt any three:

Draw and explain business intelligence architecture.

Explain types of Data Marts, define Fact Table and Mapplet.

Explain tools and important steps for Data Validation.

Describe Monte Carlo and Regression Analysis.

Compare Complex Event Processing (CEP) and Business Activity Monitoring (BAM) — when to use each.

Section C – Long Answer Questions (10 × 5 = 50 Marks)

Question 3

(a) How does BI architecture influence business intelligence purpose?
or
(b) Factors responsible for successful Business Intelligence (BI) projects.

Question 4

(a) Differentiate between Star Schema and Snowflake Schema with examples.
or
(b) Explain steps in the ETL process and its role in data warehousing.

Question 5

(a) Write the function to find the day of the week for a given date.
or
(b) Define Data Validation, its working, and importance.

Question 6

(a) How to determine accuracy in an Iris Dataset?
or
(b) Explain data mining techniques and their business applications.

Question 7

(a) Relationship between Business Glossary and Metadata Management.
or
(b) Explain how Complex Event Processing (CEP) and Business Activity Monitoring (BAM) benefit companies.