Business Intelligence Exam 1 UPDATED
ACTUAL Exam Questions and CORECT
Answers
Which of the following statements about Big Data is true? - CORRECT 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? - CORRECT ANSWER Transformation
All of the following statements about data mining are true EXCEPT: - CORRECT
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) - CORRECT
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. - CORRECT ANSWER online transaction
processing systems
Which kind of data warehouse is created separately from the enterprise data warehouse by a
department and not reliant on it for updates? - CORRECT ANSWER Independent Data Mart
Operational or transaction databases are product oriented, handling transactions that update the
database. In contrast, data warehouses are - CORRECT ANSWER subject-oriented and
nonvolatile.
The data field "salary" can be best described as - CORRECT ANSWER ratio data.
, What application is MOST dependent on text analysis of transcribed sales call center notes and
voice conversations with customers? - CORRECT ANSWER CRM
When querying a dimensional database, a user went from summarized data to its underlying
details. The function that served this purpose is - CORRECT ANSWER Drill down
In data mining, finding an affinity of two products to be commonly together in a shopping cart is
known as - CORRECT 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 -
CORRECT ANSWER Speed of data transfer
Which broad area of data mining applications analyzes data, forming rules to distinguish
between defined classes? - CORRECT ANSWER classification
Which of the following online analytical processing (OLAP) technologies does NOT require the
precomputation and storage of information? - CORRECT ANSWER ROLAP
The data field "ethnic group" can be best described as - CORRECT ANSWER nominal data
Sentiment classification usually covers all the following issues EXCEPT: - CORRECT
ANSWER biometric identification of the consumer expressing the sentiment
What data discovery process, whereby objects are categorized into predetermined groups, is used
in text mining? - CORRECT ANSWER classification
Data warehouses provide direct and indirect benefits to using organizations. Which of the
following is an indirect benefit of data warehouses? - CORRECT ANSWER Improved
customer service
ACTUAL Exam Questions and CORECT
Answers
Which of the following statements about Big Data is true? - CORRECT 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? - CORRECT ANSWER Transformation
All of the following statements about data mining are true EXCEPT: - CORRECT
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) - CORRECT
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. - CORRECT ANSWER online transaction
processing systems
Which kind of data warehouse is created separately from the enterprise data warehouse by a
department and not reliant on it for updates? - CORRECT ANSWER Independent Data Mart
Operational or transaction databases are product oriented, handling transactions that update the
database. In contrast, data warehouses are - CORRECT ANSWER subject-oriented and
nonvolatile.
The data field "salary" can be best described as - CORRECT ANSWER ratio data.
, What application is MOST dependent on text analysis of transcribed sales call center notes and
voice conversations with customers? - CORRECT ANSWER CRM
When querying a dimensional database, a user went from summarized data to its underlying
details. The function that served this purpose is - CORRECT ANSWER Drill down
In data mining, finding an affinity of two products to be commonly together in a shopping cart is
known as - CORRECT 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 -
CORRECT ANSWER Speed of data transfer
Which broad area of data mining applications analyzes data, forming rules to distinguish
between defined classes? - CORRECT ANSWER classification
Which of the following online analytical processing (OLAP) technologies does NOT require the
precomputation and storage of information? - CORRECT ANSWER ROLAP
The data field "ethnic group" can be best described as - CORRECT ANSWER nominal data
Sentiment classification usually covers all the following issues EXCEPT: - CORRECT
ANSWER biometric identification of the consumer expressing the sentiment
What data discovery process, whereby objects are categorized into predetermined groups, is used
in text mining? - CORRECT ANSWER classification
Data warehouses provide direct and indirect benefits to using organizations. Which of the
following is an indirect benefit of data warehouses? - CORRECT ANSWER Improved
customer service
