Question 1

The part of the BI software application that parses the questions entered by employees is known as the____________ .
A)semantic layer
B)data link layer
C)network layer
D)session layer

Accepted Answer

The semantic layer is responsible for parsing and interpreting the questions entered by employees in BI software applications. The data link layer, network layer, and session layer are all part of the OSI model, which is not directly related to BI software applications.

Question 2

Some companies require workers to create reports of their finding to transfer knowledge into manageable____________ .
A)folders
B)dictionaries
C)online resources
D)indexes

Accepted Answer

Online resources allow for easy access and sharing of information, making it an efficient way to transfer knowledge into manageable formats. Folders and indexes can be limiting, as they may only be accessible to a select few, and dictionaries may not be the most practical choice for organizing reports.

Question 3

The popular name of an interface for business intelligence tools is____________ .
A)whiteboard
B)command line interface
C)dashboard
D)graphic user interface

Accepted Answer

A dashboard is a popular interface for business intelligence tools, which presents key performance indicators and other relevant data in a visual, easy-to-understand format. A whiteboard is a physical board used for brainstorming or presentation purposes, while a command line interface (CLI) is a text-based interface used for system administration tasks. A graphic user interface (GUI) is a visual interface used for interacting with computer systems, including operating systems and applications. While GUIs are commonly used for business intelligence tools as well, the more specific and popular term for this interface is dashboard.

Question 4

OLAP might process data from a ____________.
A)non-relational database
B)cloud database
C)navigational database
D)transactional database

Accepted Answer

OLAP is designed to process data from transactional databases, which are relational databases that store transactional data such as sales, orders, and inventory. OLAP is used to analyze these transactional data and create reports that give different perspectives on the data. Non-relational databases, cloud databases, and navigational databases typically store different types of data and are not well-suited for OLAP processing.

Question 5

BI software has become so popular in large companies that Microsoft decided to integrate such software into its popular database management system,____________ .
A)SQL Server
B)MySQL
C)DB2
D)DBMS

Accepted Answer

Microsoft has integrated BI software into its SQL Server, making it a popular choice for large companies. MySQL and DB2 are also database management systems but are not mentioned in the context of BI software integration. DBMS is a generic term for any software used to manage databases, and it does not refer to a specific product.

Question 6

OLAP applications are usually installed on a special server that communicates with both the user's computer and the server or servers that contain a data warehouse or .
A)house databases
B)information silos
C)relational applications
D)dimensional databases

Accepted Answer

OLAP applications are specifically designed to work with dimensional databases, which are optimized for data analysis and have a pre-aggregated structure that facilitates faster data retrieval and analysis. This makes D) dimensional databases the most suitable option for OLAP applications. Options A, B, and C are not specifically designed for OLAP applications and may not provide the same level of performance or functionality.

Question 7

____________enables managers to see summaries and ratios of the intersection of any two dimensions in a database.
A)CRM
B)SCM
C)OLAP
D)CAD

Accepted Answer

OLAP (Online Analytical Processing) is a database technology that enables managers to see summaries and ratios of the intersection of any two dimensions in a database. This allows for analysis and decision-making based on specific criteria and metrics. CRM (Customer Relationship Management) is a software system designed to manage interactions with customers and prospects, while SCM (Supply Chain Management) focuses on optimizing the management of goods and services throughout the supply chain. CAD (Computer-Aided Design) is a software tool used for designing and drafting.

Question 8

______is the attempt by organizations to put procedures and technologies in place to transfer individual knowledge into databases.
A)Data mining
B)Knowledge management
C)Knowledge extraction
D)Data warehousing

Accepted Answer

Knowledge management is the process of creating, sharing, using, and managing the knowledge and information of an organization. This includes capturing individual knowledge and storing it in databases or other knowledge management systems. Data mining, knowledge extraction, and data warehousing are related concepts, but not specifically focused on transferring individual knowledge into databases.

Question 9

Some companies use____________ techniques to try to predict what customers are likely to purchase in the future.
A)data-mining
B)web scraping
C)knowledge extraction
D)information integration

Accepted Answer

Data-mining involves analyzing large amounts of data to find patterns and relationships. This technique can be used to understand customer behavior and predict future purchases. Web scraping involves extracting data from websites, whereas knowledge extraction involves identifying and transferring information from various sources. Information integration involves combining data from multiple sources to provide a unified view of the data. While all of these techniques can be used to understand customer behavior, data-mining is specifically focused on identifying patterns that can be used to make predictions.

Question 10

OLAP applications can process ____________records per second.
A)10,000
B)20,000
C)30,000
D)40,000

Accepted Answer

The answer of OLAP applications can process ____________records per second.
A)10,000
B)20,000
C)30,000
D)40,000...

Question 11

Both data-mining and OLAP software are often integrated into____________ for the purpose of collecting business intelligence about customers.
A)SCM systems
B)ERP systems
C)CRM systems
D)HRM systems

Accepted Answer

Both data-mining and OLAP software are often used in CRM (Customer Relationship Management) systems to gather business intelligence about customers. SCM (Supply Chain Management) and ERP (Enterprise Resource Planning) systems may also collect data, but they are more focused on operational processes and supply chain management rather than customer data analysis. HRM (Human Resource Management) systems may collect employee data, but not customer data.

Question 12

The meaningful information gleaned from data warehouses using software tools is referred to as ____________.
A)raw data
B)business intelligence
C)unstructured data
D)performance indicators

Accepted Answer

The term used to describe meaningful information gleaned from data warehouses using software tools is business intelligence. Business intelligence tools help to extract useful insights from large volumes of raw data stored in a data warehouse, which can help organizations make better decisions and gain a competitive advantage in their respective markets.

Question 13

Companies such as Razorfish,DoubleClick,and Engage Software use ____________to collect consumer data.
A)riskware
B)malware
C)middleware
D)spyware

Accepted Answer

These companies use spyware to track and collect consumer data without their knowledge or consent. This information is used for targeted advertising and marketing purposes.

Question 14

______are often designed to quickly present predefined business metrics,such as occupancy ratios in hotels and hospitals,or inventory turns in retail.
A)Performance indicators
B)Dashboards
C)Toolboxes
D)Shared whiteboards

Accepted Answer

Dashboards are specifically designed to showcase predefined business metrics in a quick and easy-to-understand way. Performance indicators can be a part of a dashboard, but are not as comprehensive. Toolboxes and shared whiteboards are not related to presenting business metrics.

Question 15

To group knowledge into manageable data,companies____________ use software.
A)clickstream
B)autocategorization
C)data mining
D)OLAP

Accepted Answer

Autocategorization software is designed to automatically group information into categories based on predefined rules and criteria. This allows companies to more efficiently manage and analyze large amounts of data, making it easier to extract meaningful insights and make informed decisions. Clickstream, data mining, and OLAP are also useful tools for managing and analyzing data, but are not specifically designed for grouping knowledge into manageable data like autocategorization software.

Question 16

Since OLAP applications are designed to process large amounts of records and produce summaries,they are usually significantly faster than relational applications such as those using____________ .
A)XML
B)FTP protocols
C)SQL queries
D)SGML

Accepted Answer

OLAP applications use multidimensional data structures to process data and produce summaries, while relational applications using SQL queries process data in tables with multiple joins, which can be slower in performance compared to OLAP. Therefore, the correct answer is option C - SQL queries.

Question 17

To make the use of BI tools convenient for executives,companies that develop BI tools create ____________that help the executives to quickly grasp business situations.
A)data marts
B)clickstream software
C)programming languages
D)interfaces

Accepted Answer

Interfaces are the graphical user interfaces (GUIs) that BI tool developers create to make it easier for executives to access and analyze data. These interfaces can include dashboards, scorecards, and other interactive displays that provide executives with a bird's-eye view of key performance metrics and trends. By presenting data in an easily digestible format, these interfaces help busy executives quickly make informed decisions that drive business success.

Question 18

A major effort of most businesses,especially retail businesses,in using customer relationship management (CRM) systems is to collect ____________about customers.
A)artificial intelligence
B)business intelligence
C)personal information
D)knowledge management parameters

Accepted Answer

The answer of A major effort of most businesses,especially retail...

Question 19

The purpose of ____________is mainly to learn where to find information about a given subject.
A)knowledge management
B)data mining
C)business analytics
D)business intelligence

Accepted Answer

Knowledge management involves identifying, creating, sharing, and utilizing knowledge and information within an organization to improve decision-making, performance, and innovation. This includes knowing where to find information about a given subject, which is critical to effective knowledge management. Data mining, business analytics, and business intelligence also involve data and information, but they are more focused on analyzing and generating insights from that data rather than managing it.

Question 20

Information that can be gleaned from stored data is ____________.
A)knowledge
B)experience
C)intelligence
D)wisdom

Accepted Answer

Stored data can provide information that can be used to gain knowledge and insights. It is up to the individual or organization to analyze and interpret the data to gain this knowledge. Experience, intelligence, and wisdom are traits or qualities typically associated with individuals rather than data.

Quiz 11: Business Intelligence and Knowledge Management

The part of the BI software application that parses the questions entered by employees is known as the____________ .

Some companies require workers to create reports of their finding to transfer knowledge into manageable____________ .

The popular name of an interface for business intelligence tools is____________ .

OLAP might process data from a ____________.

BI software has become so popular in large companies that Microsoft decided to integrate such software into its popular database management system,____________ .

OLAP applications are usually installed on a special server that communicates with both the user's computer and the server or servers that contain a data warehouse or .

____________enables managers to see summaries and ratios of the intersection of any two dimensions in a database.

______is the attempt by organizations to put procedures and technologies in place to transfer individual knowledge into databases.

Some companies use____________ techniques to try to predict what customers are likely to purchase in the future.

OLAP applications can process ____________records per second.

Both data-mining and OLAP software are often integrated into____________ for the purpose of collecting business intelligence about customers.

The meaningful information gleaned from data warehouses using software tools is referred to as ____________.

Companies such as Razorfish,DoubleClick,and Engage Software use ____________to collect consumer data.

______are often designed to quickly present predefined business metrics,such as occupancy ratios in hotels and hospitals,or inventory turns in retail.

To group knowledge into manageable data,companies____________ use software.

Since OLAP applications are designed to process large amounts of records and produce summaries,they are usually significantly faster than relational applications such as those using____________ .

To make the use of BI tools convenient for executives,companies that develop BI tools create ____________that help the executives to quickly grasp business situations.

A major effort of most businesses,especially retail businesses,in using customer relationship management (CRM) systems is to collect ____________about customers.

The purpose of ____________is mainly to learn where to find information about a given subject.

Information that can be gleaned from stored data is ____________.