1 $Which of the following best defines 'data' in the context of digital information?$

A.

Visual charts and graphs

B.

Software applications used for analysis

C.

Processed information ready for decision making

D.

Raw, unorganized facts and figures

2 $Which type of data resides in fixed fields within a record or file, such as Relational Database Management Systems (RDBMS)?$

A.

Structured Data

B.

Unstructured Data

C.

Abstract Data

D.

Semi-structured Data

3 $Emails, videos, and social media posts are primarily examples of which type of data?$

A.

Normalized Data

B.

Semi-structured Data

C.

Structured Data

D.

Unstructured Data

4 $XML and JSON files are classic examples of which data category?$

A.

Structured Data

B.

Semi-structured Data

C.

Raw Data

D.

Unstructured Data

5 $What is a major limitation of traditional databases (RDBMS) when dealing with modern big data?$

A.

They cannot perform mathematical calculations

B.

They cannot handle structured data

C.

Difficulty in scaling horizontally and handling unstructured data

D.

They lack security features

6 $OLTP stands for:$

A.

Online Text Processing

B.

Online Transaction Processing

C.

Offline Transaction Protocol

D.

Online Analytical Processing

7 $What is the primary goal of an OLTP system?$

A.

Historical data archiving

B.

Complex data analysis

C.

Generating executive dashboards

D.

Fast query processing and data integrity for transactions

8 $Which system is primarily used for decision support, planning, and problem-solving?$

A.

RDBMS

B.

ATM Systems

C.

OLAP

D.

OLTP

9 $In the context of data volatility, how do OLTP and OLAP differ?$

A.

Both are non-volatile

B.

Both are highly volatile

C.

OLTP data is static; OLAP data is volatile

D.

OLTP data is volatile; OLAP data is non-volatile

10 $Business Intelligence (BI) can best be described as:$

A.

A method for securing network connections

B.

A specific software tool for writing SQL queries

C.

The process of backing up database files

D.

Strategies and technologies used for data analysis and management

11 $Which of the following is an early predecessor to modern BI, designed for middle managers?$

A.

IoT (Internet of Things)

B.

AI (Artificial Intelligence)

C.

EIS (Executive Information Systems)

D.

MIS (Management Information Systems)

12 $What is the primary function of an Executive Information System (EIS)?$

A.

To provide senior executives with easy access to internal and external data

B.

To process daily operational transactions

C.

To manage customer support tickets

D.

To compile code for software developers

13 $What is a Digital Dashboard?$

A.

A hardware component in a server

B.

A data visualization tool that displays the current status of metrics and KPIs

C.

A type of unstructured data

D.

A database backup utility

14 $Why is BI needed at the Operational Level of an organization?$

A.

To optimize daily workflows and immediate decision making

B.

To plan 5-year strategies

C.

To design the company logo

D.

To analyze ten years of historical data

15 $Descriptive Analytics in BI answers which question?$

A.

What happened?

B.

How can we make it happen?

C.

What will happen?

D.

Why did it happen?

16 $Predictive Analytics is associated with which time frame?$

A.

None of the above

B.

Future

C.

Present

D.

Past

17 $Which data type accounts for the largest percentage of data growth in the modern world?$

A.

Unstructured Data

B.

Boolean Data

C.

Structured Data

D.

Numeric Data

18 $In an OLAP system, 'Drill-down' capability allows a user to:$

A.

Summarize data to a higher level

B.

Export data to a text file

C.

Delete data permanently

D.

View data at a more detailed level

19 $Which of the following is NOT a characteristic of Structured Data?$

A.

Easy to query using SQL

B.

Stored in tables

C.

High degree of organization

D.

Flexible, schema-less format

20 $Which BI component is responsible for extracting, transforming, and loading data?$

A.

Data Mining

B.

ETL

C.

Dashboard

D.

OLAP Cube

21 $Diagnostic Analytics focuses on:$

A.

Raw data collection

B.

Understanding why something happened

C.

Forecasting future trends

D.

Real-time monitoring

22 $Prescriptive Analytics attempts to:$

A.

Visualize static data

B.

Diagnose the present

C.

Describe the past

D.

Suggest a course of action

23 $What is a 'Data Silo'?$

A.

A visualization tool

B.

A secure type of database

C.

A cloud storage solution

D.

An isolated collection of data not accessible to other parts of the organization

24 $Which represents the hierarchy of data understanding from bottom to top?$

A.

Data -> Information -> Knowledge -> Wisdom

B.

Knowledge -> Wisdom -> Data -> Information

C.

Wisdom -> Knowledge -> Information -> Data

D.

Information -> Data -> Wisdom -> Knowledge

25 $Tactical BI is primarily used by:$

A.

CEOs only

B.

Clerks

C.

External Customers

D.

Business Analysts and Line Managers

26 $Metadata is best described as:$

A.

Data about data

B.

Large volumes of data

C.

Deleted data

D.

Corrupted data

27 $The evolution of BI moved from Mainframe reporting to:$

A.

None of the above

B.

Client-Server based BI

C.

Abacus calculation

D.

Paper-only records

28 $Which of the following is a key feature of a Digital Dashboard?$

A.

Text-only output

B.

Requires SQL coding to view

C.

Visual presentation of Key Performance Indicators (KPIs)

D.

Slow data refresh rates

29 $In the context of RDBMS limitations, what is the 'Variety' problem?$

A.

Traditional databases struggle to manage diverse data formats (video, text, sensor data)

B.

Databases represent too many colors

C.

There are too many brands of databases

D.

SQL has too many commands

30 $OLTP systems are generally characterized by:$

A.

Low concurrency

B.

Complex queries involving aggregations

C.

Read-mostly operations

D.

Short, atomic transactions

31 $The term 'Latency' in BI refers to:$

A.

The cost of the software

B.

The size of the hard drive

C.

The time lag between data generation and actionable insight

D.

The number of users logged in

32 $Which of the following creates a bridge between the 'Past' and 'Future' in BI analysis?$

A.

Data Deletion

B.

Data Entry

C.

Trend Analysis

D.

System Reboot

33 $Spreadsheets (like Excel) generally handle which type of data best?$

A.

Real-time streaming audio

B.

Large-scale Big Data

C.

Structured Data

D.

Unstructured Video

34 $What is the main role of a Data Warehouse in BI?$

A.

To act as an email server

B.

To host the company website

C.

To process live transactions

D.

To store centralized, historical data for analysis

35 $Semi-structured data often contains:$

A.

Only binary code

B.

Fixed length fields

C.

Purely random noise

D.

Tags or markers to separate elements

36 $Which level of management is most concerned with Strategic BI?$

A.

Middle Management

B.

Top-level Executives

C.

IT Support

D.

Operational Staff

37 $What limits a standard database's ability to handle 'Velocity'?$

A.

The speed of light

B.

The number of columns allowed

C.

The color of the server

D.

I/O bottlenecks when writing massive amounts of high-speed data

38 $Querying a NoSQL database is often required for:$

A.

Fixed asset registers

B.

Unstructured or Semi-structured Big Data

C.

Highly relational financial ledgers

D.

Small address books

39 $Which is an example of 'Present' BI?$

A.

Sales forecast for next year

B.

Real-time stock market monitoring

C.

Audit of last month's logs

D.

Year-end financial report

40 $What distinguishes Information from Data?$

A.

Information is processed data with context and meaning

B.

Information is digital; Data is analog

C.

There is no difference

D.

Data is always larger than Information

41 $Decision Support Systems (DSS) primarily rely on:$

A.

Strict transaction processing

B.

Manual paper filing

C.

Guesswork

D.

Models and data to solve semi-structured problems

42 $The 'Roll-up' operation in OLAP performs what function?$

A.

Aggregates data (e.g., Daily to Monthly)

B.

Deletes the cube

C.

Increases detail

D.

Rotates the axis

43 $Why is 'Data Quality' a limitation in real-world databases?$

A.

Databases automatically fix all errors

B.

Quality is not important

C.

Computers never make mistakes

D.

Inconsistent, duplicate, or missing data reduces trust in the database

44 $A CSV (Comma Separated Values) file is best described as:$

A.

Proprietary code

B.

Structured (but usually stored as a flat file)

C.

Executable software

D.

Unstructured

45 $Which of the following is NOT a benefit of BI?$

A.

Improved operational efficiency

B.

Identified market trends

C.

Faster decision making

D.

Guaranteed 100% profit increase

46 $Data Mining is most closely associated with:$

A.

Designing web pages

B.

Backing up data to tape

C.

Entering data manually

D.

Discovering hidden patterns and relationships in large datasets

47 $Which type of user typically uses OLTP systems?$

A.

Data Analysts

B.

Clerks / Database Administrators

C.

Strategic Planners

D.

CEO / Executives

48 $In the evolution of BI, what role did the 'Mainframe' play?$

A.

It provided the first centralized computing for generating static reports

B.

It utilized cloud computing

C.

It introduced mobile dashboards

D.

It created the internet

49 $Key Performance Indicators (KPIs) are essential components of:$

A.

Unstructured text

B.

Network cables

C.

OLTP transactions

D.

Digital Dashboards

50 $Why is 'Context' important in BI?$

A.

It encrypts the data

B.

It is not important

C.

It increases the file size

D.

It turns raw numbers into meaningful information

Unit 1 - Practice Quiz