Business Intelligence Exam 1 2025
Questions and Answers
Which of the following statements about Big Data is true? - --Answer --Pure
Big Data systems do not involve fault tolerance
In which stage of extraction, transformation, and load (ETL) into a data warehouse
are data aggregated? - --Answer --Transformation
All of the following statements about data mining are true EXCEPT: - --
Answer --the process aspect means that data mining should be a one-step
process to results
For the majority of organizations, a daily accounts receivable transaction is a(n) - --
Answer --Structured decision
The ________ handle a company s routine ongoing business and give
management the ability to scour data from the data warehouse for information
about the business and use the analysis to provide tactical or operational decision
support. - --Answer --online transaction processing systems
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, Which kind of data warehouse is created separately from the enterprise data
warehouse by a department and not reliant on it for updates? - --Answer --
Independent Data Mart
Operational or transaction databases are product oriented, handling transactions
that update the database. In contrast, data warehouses are - --Answer --
subject-oriented and nonvolatile.
The data field "salary" can be best described as - --Answer --ratio data.
What application is MOST dependent on text analysis of transcribed sales call
center notes and voice conversations with customers? - --Answer --CRM
When querying a dimensional database, a user went from summarized data to its
underlying details. The function that served this purpose is - --Answer --
Drill down
In data mining, finding an affinity of two products to be commonly together in a
shopping cart is known as - --Answer --association rule mining
Active data warehousing can be used to support the highest level of decision
making sophistication and power. The major feature that enables this in relation to
handling the data is - --Answer --Speed of data transfer
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
Questions and Answers
Which of the following statements about Big Data is true? - --Answer --Pure
Big Data systems do not involve fault tolerance
In which stage of extraction, transformation, and load (ETL) into a data warehouse
are data aggregated? - --Answer --Transformation
All of the following statements about data mining are true EXCEPT: - --
Answer --the process aspect means that data mining should be a one-step
process to results
For the majority of organizations, a daily accounts receivable transaction is a(n) - --
Answer --Structured decision
The ________ handle a company s routine ongoing business and give
management the ability to scour data from the data warehouse for information
about the business and use the analysis to provide tactical or operational decision
support. - --Answer --online transaction processing systems
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 1
, Which kind of data warehouse is created separately from the enterprise data
warehouse by a department and not reliant on it for updates? - --Answer --
Independent Data Mart
Operational or transaction databases are product oriented, handling transactions
that update the database. In contrast, data warehouses are - --Answer --
subject-oriented and nonvolatile.
The data field "salary" can be best described as - --Answer --ratio data.
What application is MOST dependent on text analysis of transcribed sales call
center notes and voice conversations with customers? - --Answer --CRM
When querying a dimensional database, a user went from summarized data to its
underlying details. The function that served this purpose is - --Answer --
Drill down
In data mining, finding an affinity of two products to be commonly together in a
shopping cart is known as - --Answer --association rule mining
Active data warehousing can be used to support the highest level of decision
making sophistication and power. The major feature that enables this in relation to
handling the data is - --Answer --Speed of data transfer
....COPYRIGHT ©️ 2025 ALL RIGHTS RESERVED...TRUSTED & VERIFIED 2
