Font size
S
M
L
XL
WorksheetsBI mt 202607
Total questions: 100
Worksheet time: 50mins
Name
Class
Date
1.
BI can be used by the Human Resource Department to analyze staff profile data to understand __________.
a)
profit and loss
b)
employee performance
c)
national economy
d)
marketing strategies
2.
BI can be used on customer feedback to understand customer______________.
a)
fitness level
b)
loans
c)
statisfaction
d)
marriage status
3.
Predictive analytics enables organizations to anticipate potential problems and take preventive measures proactively.
a)
True
b)
False
4.
Which of these is NOT a key component of the BI process?
a)
Data Analysis
b)
Data Selling
c)
Data Storage
d)
Data Collection
5.
What does 'unstructured' data mean in BI?
a)
Data that has no mistakes
b)
Data like emails or social media posts
c)
Data in neat rows and columns
d)
Data that is easy to put in a database
6.
A business wants to know what customers think. Which BI step helps them get this data?
a)
Data Collection
b)
Data Analysis
c)
Data Reporting
d)
Data Storage
7.
A company wants to store all its sales data in one place. Which BI step helps them do this?
a)
Data Collection
b)
Data Analysis
c)
Data Reporting
d)
Data Storage
8.
Which of these is a BI tool for data analysis?
a)
SAS
b)
Calculator
c)
Paint Program
d)
Notepad
9.
A business wants to see how many customers bought a product last year. Which BI step helps them do this?
a)
Data Reporting
b)
Data Collection
c)
Data Storage
d)
Data Analysis
10.
A company uses BI to see if sales go up after a TV ad. Which BI benefit is this?
a)
Identifying Trends
b)
Data Collection
c)
Improving Efficiency
d)
Informed Decision-Making
11.
A dashboard shows sales numbers in real-time. Which BI step is this part of?
a)
Reporting
b)
Data collection
c)
Data analysis
d)
Data integration
12.
Which BI tool helps a grocery store know if organic food is popular?
a)
Competitive intelligence
b)
Market intelligence
c)
Customer sentiment
d)
Environmental scanning
13.
A company uses BI to see if a new technology will change its business. What BI tool is it using?
a)
Environmental scanning
b)
Competitive intelligence
c)
Market intelligence
d)
Customer sentiment
14.
A company wants to forecast future sales trends. Which BI component helps them do this?
a)
Data Sources
b)
Data Warehousing
c)
Data Analysis
d)
Reporting and Visualization
15.
A company uses BI to find out the most popular features of its software. What BI process helps them find this?
a)
Data Collection
b)
Data Presentation
c)
Data Analysis
d)
Data Preparation
16.
A company wants to improve its customer experience. Which BI process helps them start by getting feedback?
a)
Data Collection
b)
Data Preparation
c)
Data Analysis
d)
Data Presentation
17.
A restaurant uses BI to show customer satisfaction trends on a dashboard. What BI process is this?
a)
Data Presentation
b)
Data Preparation
c)
Data Collection
d)
Data Analysis
18.
A company has sales data in one file and customer data in another. Which BI layer helps combine these different data types?
a)
Data Source Layer
b)
Data Integration Layer
c)
Data Analysis Layer
d)
Presentation Layer
19.
What does 'ETL' stand for in the context of business intelligence?
a)
Enter, Track, Learn
b)
Extract, Transform, Load
c)
Explain, Target, List
d)
Edit, Test, Link
20.
What is the name for a smaller data storage area for one business part?
a)
Data Source
b)
Data Report
c)
Data Mart
d)
Data Warehouse
21.
A sales team needs to see how their sales changed each month. Which BI layer would show them this information?
a)
Presentation Layer
b)
Data Analysis Layer
c)
Data Storage Layer
d)
Data Source Layer
22.
Which BI component helps move data from different places into one central storage?
a)
Data Warehousing
b)
ETL Tools
c)
Data Mining Tools
d)
Reporting and Query Tools
23.
A company wants to get data from its website and put it into its main data storage. Which BI component helps with this 'pulling' of data?
a)
Data Warehousing
b)
ETL Tools
c)
Reporting and Query Tools
d)
Data Mining Tools
24.
Which BI component is like a big brain that finds hidden patterns in data?
a)
ETL Tools
b)
Reporting and Query Tools
c)
Data Warehousing
d)
Data Mining Tools
25.
A company wants to find out which products customers buy together. Which BI component would help them do this?
a)
Data Warehousing
b)
ETL Tools
c)
Data Mining Tools
d)
Reporting and Query Tools
26.
Which BI component helps make data look good with charts and graphs?
a)
ETL Tools
b)
Reporting and Query Tools
c)
Data Mining Tools
d)
Dashboard and Data Visualization Tools
27.
What is a dashboard in business intelligence?
a)
A visual display of important data
b)
A long written report about data
c)
A place to store old company files
d)
A tool for sending team messages
28.
A company wants to list exact sales numbers for each day. Which visualization is best?
a)
Pie chart
b)
Bar graph
c)
Line chart
d)
Table
29.
A company wants to compare sales of different products. Which visualization is best?
a)
Table
b)
Line chart
c)
Bar graph
d)
Pie chart
30.
A company wants to see how much money they made last year. Which KPI is best for this?
a)
Total sales revenue
b)
Customer satisfaction score
c)
Average deal size
d)
New customer acquisition rate
31.
A company wants to know how happy its customers are. Which KPI is best for this?
a)
Average deal size
b)
New customer acquisition rate
c)
Customer satisfaction score
d)
Total sales revenue
32.
Which dashboard component helps you see more details about a specific data point?
a)
Key Performance Indicators
b)
Data visualizations
c)
Drill-down features
d)
Filters
33.
A dashboard shows that customer satisfaction is low. What is the most important next step?
a)
Change the dashboard's background color
b)
Find out why customers are not happy
c)
Add more charts to the dashboard
d)
Hide the low satisfaction score from managers
34.
A business dashboard shows sales growth is slow. What is the most likely next step to improve this?
a)
Tell all customers about the slow growth
b)
Stop using the dashboard for a while
c)
Change the colors on the dashboard
d)
Look for new ways to sell products
35.
What is the main goal of the data analytics life cycle?
a)
To store data safely
b)
To make data look nice
c)
To collect all data possible
d)
To get insights from data
36.
What does 'systematic process' mean for data analytics?
a)
It is very fast
b)
It has clear steps
c)
It is done by one person
d)
It uses many computers
37.
What is the first step in the data analytics life cycle?
a)
Data collection
b)
Problem definition
c)
Data exploration
d)
Data cleaning
38.
What does 'qualitative data' mean in data collection?
a)
Data with numbers
b)
Data from social media
c)
Data with descriptions
d)
Data from company databases
39.
Which step ensures data is accurate and complete before analysis?
a)
Data cleaning
b)
Interpretation of results
c)
Problem definition
d)
Data collection
40.
What is the purpose of 'Exploratory Data Analysis'?
a)
To define the problem
b)
To gather data from sources
c)
To find patterns and trends
d)
To put insights into action
41.
A company launches a new product based on data. Which step is this?
a)
Implementation
b)
Problem definition
c)
Data exploration
d)
Data cleaning
42.
What is the main goal of data cleansing in data analysis?
a)
To make data look more colorful
b)
To fix errors in the data
c)
To find new data for analysis
d)
To make data easier to share
43.
A dataset has a product ID listed twice with the same price. What is the first step to fix this?
a)
Change the product price
b)
Mark both entries as missing
c)
Add a new product ID
d)
Remove one of the entries
44.
A dataset has a customer ID listed twice with the same purchase. What is the first step to fix this?
a)
Mark both entries as missing
b)
Remove one of the entries
c)
Change the purchase amount
d)
Add a new customer ID
45.
A dataset has 'New York', 'NY', and 'new york' for the same state. What cleansing technique fixes this?
a)
Detecting outliers
b)
Handling missing values
c)
Standardizing data
d)
Removing duplicates
46.
A dataset has 'Yes', 'Y', and 'yes' for a survey answer. Which cleansing technique makes them consistent?
a)
Standardizing data
b)
Handling missing values
c)
Removing duplicates
d)
Detecting outliers
47.
A dataset has a person's age as 200. Which cleansing technique helps find this error?
a)
Data transformation
b)
Correcting errors
c)
Handling missing values
d)
Removing duplicates
48.
A dataset has a student's grade as 1000. What is this grade likely to be?
a)
A missing value
b)
A duplicate
c)
An outlier
d)
A standardized entry
49.
A dataset has a person's income as 1 million dollars. What is this income likely to be?
a)
A missing value
b)
A duplicate
c)
An outlier
d)
A standardized entry
50.
A data point is very different from most other data. What is this data point called?
a)
A duplicate
b)
A standardized entry
c)
An outlier
d)
A missing value
51.
OLTP stands for ___________.
a)
Online Transaction Processing
b)
Outcome Transaction Processing
c)
Online Transaction Payment
d)
Online Tax Payment
52.
OLTP is a procedure responsible for ______________ which are used for BI
a)
constantly updating software
b)
constantly updating databases
c)
calculation on databases
d)
deleting databases
53.
To make good use of BI and be successful a company must always align its BI to __________ .
a)
business strategy
b)
corporate tax
c)
political situations
d)
economic situations
54.
Descriptive analytics focuses on __________ historical data to gain insights into past performance and understand trends and patterns
a)
deleting
b)
copying
c)
calculating
d)
summarizing
55.
____________ is used to identify a factor that causes a business problem.
a)
Descriptive analytics
b)
Diagnostic analysis
c)
Predictive analytics
d)
Data mining
56.
Predictive Analytics uses statistical algorithms and machine learning techniques to identify trends and patterns in data and make predictions about future outcomes.
a)
True
b)
False
57.
What is a key issue in BI governance for making sure data is correct?
a)
Data security and privacy
b)
Integration of data sources
c)
Data quality management
d)
Compliance and regulations
58.
A company uses old sales figures to plan for next year. The figures are wrong. What is the most likely result?
a)
The company will get new customers
b)
The company will make good plans
c)
The company will save money
d)
The company will waste resources
59.
A company wants to protect customer data from being stolen. Which BI governance issue should they focus on?
a)
Role clarity and accountability
b)
Integration of data sources
c)
Data security and privacy
d)
Data quality management
60.
What is a key issue in BI governance for following data laws?
a)
Data quality management
b)
Data security and privacy
c)
Compliance and regulations
d)
Integration of data sources
61.
What is the goal of integrating diverse data sources?
a)
To reduce data storage costs
b)
To get a full business view
c)
To make data harder to find
d)
To create more data silos
62.
A company has sales data from its website and store. They want to see all sales together. Which BI governance issue is this?
a)
Data quality management
b)
Data security and privacy
c)
Compliance and regulations
d)
Integration of data sources
63.
A company wants employees to use data for decisions. Which BI governance task helps most with this goal?
a)
Developing data quality standards
b)
Implementing security protocols
c)
Creating a data stewardship program
d)
Fostering a data-driven culture
64.
A company wants employees to use BI tools. What is a good way to help them start?
a)
Hide the tools from them
b)
Make the tools very complex
c)
Provide training on the tools
d)
Tell them to figure it out
65.
Which system is designed to handle many short online transactions?
a)
Enterprise Resource Planning (ERP)
b)
Customer Relationship Management (CRM)
c)
Online Transaction Processing (OLTP)
d)
Online Analytical Processing (OLAP)
66.
OLTP systems are optimized for what kind of data changes?
a)
Moving data between different systems
b)
Deleting old data in big batches
c)
Updating small amounts of data quickly
d)
Adding large amounts of data slowly
67.
What kind of data do OLTP systems provide for OLAP systems?
a)
Predicted future data
b)
Accurate and timely data
c)
Data from other companies
d)
Old, summarized data
68.
A company uses OLTP data to guess what customers will buy next year. What is this called?
a)
Operational reporting
b)
Real-time analytics
c)
Predictive analytics
d)
Enhanced customer experience
69.
What is the main difference between OLAP systems and traditional database systems?
a)
OLAP is for daily operations, traditional for long-term analysis
b)
OLAP handles simple queries, traditional handles complex
c)
OLAP analyzes multidimensional data, traditional simple queries
d)
OLAP stores less data than traditional systems
70.
A company wants to identify seasonal patterns in sales. Which OLAP function is most useful for this?
a)
Ad-hoc Reporting
b)
Trend Analysis
c)
Slicing and Dicing
d)
Aggregation
71.
A company wants to identify which products are most popular over time. Which OLAP function is most useful for this?
a)
Ad-hoc Reporting
b)
Trend Analysis
c)
Slicing and Dicing
d)
Aggregation
72.
A company wants to allocate resources efficiently for next year. Which OLAP function is most helpful for this strategic planning?
a)
Data Retrieval
b)
Ad-hoc Reporting
c)
Trend Analysis
d)
Multidimensional Modeling
73.
A company wants to find out which products customers often buy together. Which BI technique should they use?
a)
Data mining
b)
Data warehousing
c)
Predictive analytics
d)
Reporting and querying
74.
A company wants to know what customers will buy next year. Which BI technique helps predict future trends?
a)
Predictive analytics
b)
Reporting and querying
c)
Online Analytical Processing
d)
Data warehousing
75.
Which BI tool is made by Microsoft and works well with other Microsoft products?
a)
Power BI
b)
SAP BusinessObjects
c)
Tableau
d)
QlikView
76.
Which BI tool is a full suite of solutions for large companies, including reporting and analysis?
a)
QlikView
b)
Tableau
c)
SAP BusinessObjects
d)
Power BI
77.
Which type of analytics helps a retail store plan inventory based on past sales?
a)
Descriptive analytics
b)
Prescriptive analytics
c)
Diagnostic analytics
d)
Predictive analytics
78.
Which type of analytics helps a company find out why a marketing campaign failed?
a)
Prescriptive analytics
b)
Diagnostic analytics
c)
Predictive analytics
d)
Descriptive analytics
79.
A company wants to know why a product failed. Which type of analytics helps find the reasons?
a)
Descriptive analytics
b)
Prescriptive analytics
c)
Diagnostic analytics
d)
Predictive analytics
80.
Which type of analytics helps a company find out why customers stopped buying a product?
a)
Descriptive analytics
b)
Predictive analytics
c)
Prescriptive analytics
d)
Diagnostic analytics
81.
Which type of analytics helps a company understand what customers say in emails?
a)
Social media analytics
b)
Predictive analytics
c)
Text analytics
d)
Descriptive analytics
82.
Which type of analytics helps a company understand its online presence and brand reputation?
a)
Social media analytics
b)
Predictive analytics
c)
Text analytics
d)
Descriptive analytics
83.
Which type of analytics helps a brand understand why a campaign was successful?
a)
Predictive analytics
b)
Descriptive analytics
c)
Text analytics
d)
Social media analytics
84.
What is the main purpose of a data warehouse?
a)
To store data for a single department
b)
To manage customer service calls
c)
To support business intelligence activities
d)
To quickly process daily transactions
85.
A data warehouse keeps data from the past. What is this type of data called?
a)
Historical data
b)
Future data
c)
Temporary data
d)
Current data
86.
A data mart is a 'subset' of a data warehouse. What does 'subset' mean?
a)
A different kind of group
b)
A group that is much bigger
c)
A part of a larger group
d)
A group that is not related
87.
A data warehouse helps with 'analytics'. What does 'analytics' mean?
a)
Making data look nice
b)
Studying data to find patterns
c)
Deleting old and bad data
d)
Collecting new data
88.
A data mart offers 'targeted insights'. What does 'targeted' mean for insights?
a)
Insights for a specific group
b)
Insights that are very general
c)
Insights that are hard to find
d)
Insights that are not useful
89.
A company wants to give its marketing team quick access to sales data. Which component would be most helpful?
a)
Data Source
b)
Data Mart
c)
Data Lake
d)
Data Stream
90.
A company uses a three-tier data warehouse. If the 'Transform' step of ETL is skipped, what is the most likely problem?
a)
Users will not be able to see any data
b)
Data will be messy and hard to use
c)
Data will be stored in the wrong place
d)
Data will not be collected from sources
91.
A company's data is messy and not ready for analysis. Which ETL step fixes this problem?
a)
Load
b)
Transform
c)
Present
d)
Extract
92.
A two-tier system has a direct connection. A three-tier system has a middle layer. What is the main difference in communication?
a)
Two-tier is direct, three-tier is indirect.
b)
Two-tier is indirect, three-tier is direct.
c)
Two-tier is complex, three-tier is simple.
d)
Two-tier is slower, three-tier is faster.
93.
A two-tier system has a client and a server. A three-tier system adds a middle layer. What is the middle layer's role?
a)
To connect to the internet.
b)
To process data requests.
c)
To manage user interfaces.
d)
To store all the data.
94.
Which type of database system is typically used in a two-tier architecture?
a)
Object-oriented database systems.
b)
Relational database systems.
c)
NoSQL database systems.
d)
Distributed database systems.
95.
What is one key benefit of a two-tier architecture regarding performance?
a)
Data access is often slower.
b)
Data storage is less efficient.
c)
Data access is often faster.
d)
Data processing is more complex.
96.
A company wants to save money on hardware and software. Which architecture would be a good start?
a)
A three-tier system.
b)
A two-tier system.
c)
A four-tier system.
d)
A multi-tier system.
97.
A company needs a system that can handle huge growth in users and data. Is a two-tier architecture a good choice?
a)
Yes, because it is very simple to manage.
b)
Yes, because it is very cost-effective.
c)
No, because it has scalability issues.
d)
No, because it lacks user control.
98.
A company wants a data system that can handle many users without slowing down. Is a two-tier architecture a good choice?
a)
No, because it lacks user control.
b)
Yes, because it is very simple to manage.
c)
No, because it has scalability issues.
d)
Yes, because it is very cost-effective.
99.
A company needs to combine sales data from 10 different stores. Which architecture is better for a single view?
a)
Centralized
b)
Hybrid
c)
Distributed
d)
Federated
100.
A company wants to keep its data systems separate. Which architecture is better for data independence?
a)
Centralized
b)
Distributed
c)
Federated
d)
Hybrid
Reset
