Business Intelligence MCQ Questions And Answers
This section focuses on "Business Intelligence" in Data Science. These Data Science Multiple Choice Questions (MCQ) should be practiced to improve the skills required for various interviews (campus interview, walk-in interview, company interview), placements, entrance exams and other competitive examinations.
1. How many types of BI users are there?
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : C
Explanation: Four types of BI users : The Professional Data Analyst, The IT users, The head of the company, The Business Users.
2. Which of the following statement is true about Business Intelligence?
A. BI convert raw data into meaningful information
B. BI has a direct impact on organization's strategic, tactical and operational business decisions.
C. BI tools perform data analysis and create reports, summaries, dashboards, maps, graphs, and charts
D. All of the above
View Answer
Ans : D
Explanation: All of the above statement are true.
3. KPI stands for?
A. Key Performance Indicators
B. Key Performance Identifer
C. Key Processes Identifer
D. Key Processes Indicators
View Answer
Ans : A
Explanation: BI : creating KPI (Key Performance Indicators) based on historic data
4. Which of the following does not form part of BI Stack in SQL Server?
A. SSRS
B. SSIS
C. SSAS
D. OBIEE
View Answer
Ans : D
Explanation: Oracle Business Intelligence Enterprise Edition Plus, also termed OBI EE Plus, is Oracle Corporation’s set of business intelligence tools.
5. _________ is a category of applications and technologies for presenting and analyzing corporate and external data.
A. MIS
B. DIS
C. EIS
D. CIS
View Answer
Ans : C
Explanation: EIS stands for Enterprise Information System.
6. Which of the following areas are affected by BI?
A. Revenue
B. CRM
C. Sales
D. CPM
View Answer
Ans : B
Explanation: Customer relationship management (CRM) is a system for managing a company’s interactions with current and future customers. It often involves using technology to organize, automate and synchronize sales, marketing, customer service, and technical support.
7. Business intelligence (BI) is a broad category of application programs which includes _____________
A. Decision support
B. Data Mining
C. OLAP
D. All of the above
View Answer
Ans : D
Explanation: Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources.
8. __________ is a system where operations like data extraction, transformation and loading operations are executed.
A. Data staging
B. Data integration
C. ETL
D. None of the above
View Answer
Ans : A
Explanation: A staging area, or landing zone, is an intermediate storage area used for data processing during the extract, transform and load process. The data staging area sits between the data source and the data target, which are often data warehouses, data marts, or other data repositories.
9. Business intelligence equips enterprises to gain business advantage from data
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: Once an organization is powered with BI it can anticipate enhanced turnaround time on data collection, come up with fresh ideas for novel business initiatives.
10. BI is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : B
Explanation: Online Analytical Processing is a category of database software that provides an interface to help users quickly and interactively scrutinize the results in a variety of dimensions of the data.
Discussion
somu
Correct 8 Answer option