Question 1

SoulTree,a software giant,has adopted a business strategy,already employed by its competitor,to market its products.Unfortunately,the adopted strategy does not work for SoulTree although it has been successful for its competitor.Which of the following business intelligence tools can help SoulTree to understand why the adopted strategy failed?

Accepted Answer

A)  Drill-down analysis
B)  Online analytical processing
C)  Spreadsheets
D)  Data mining

Question 2

_____ includes a wide range of applications,practices,and technologies for the extraction,transformation,integration,analysis,interpretation,and presentation of data to support improved decision making.

Accepted Answer

A)  Business intelligence
B)  Artificial intelligence
C)  Prescriptive analytics
D)  Artificial analytics

Question 3

The effectiveness of a(n) _____ process is essential to ensure the success of a data warehouse.

Accepted Answer

A)  visual basic
B)  extract-transform-load
C)  chamfering
D)  actuating

Question 4

The columns in a relational database model such as customer name and address represent _____.

Accepted Answer

A)  attributes
B)  entities
C)  keys
D)  tuples

Question 5

Which of the following databases should be used by a company that has over 50,000 employees in several locations to efficiently manage its database even when a couple of servers are down?

Accepted Answer

A)  Hadoop
B)  SQL
C)  COBOL
D)  NoSQL

Question 6

Which of the following tools in a spreadsheet performs "what if" analysis?

Accepted Answer

A)  Excel Solver
B)  Excel filter manager
C)  Excel chart
D)  Excel scenario manager

Question 7

_____ involves the overall management of the availability,usability,integrity,and security of the data used in an organization.

Accepted Answer

A)  Data endorsement
B)  Data authorization
C)  Data authentication
D)  Data governance

Question 8

Explain the objective of data governance.

Accepted Answer

Data governance involves the overall man...

Question 9

Which of the following is true of Hadoop?

Accepted Answer

A)  It is designed to store and retrieve data in a manner that does not rigidly enforce the atomicity,consistency,isolation,and durability (ACI
D)  conditions associated with the relational database model.
B)  It is an open-source software framework designed for processing large volumes of data by dividing the work into a set of independent tasks.
C)  It is a simple but highly useful way to organize structured data into collections of two-dimensional tables called relations.
D)  It is a method to analyze multidimensional data from many different perspectives.

Question 10

Which of the following is a minor version of a data warehouse that is scaled down to meet the specific needs of a business unit?

Accepted Answer

A)  Data cart
B)  Data mart
C)  Data wallet
D)  Data set

Question 11

Online analytical processing (OLAP)enables users to identify issues and opportunities as well as perform trend analysis.

Accepted Answer

A) True 
 B)False

Question 12

Identify a drawback of a NoSQL database.

Accepted Answer

A)  It lacks strong data consistency.
B)  It deteriorates the system uptime.
C)  It is less scalable.
D)  It is not efficient in dealing with extremely large databases. A

Question 13

Which of the following best describes the relational database model?

Accepted Answer

A)  It helps organize unstructured data into collections of three-dimensional tables.
B)  It helps organize unstructured data into collections of two-dimensional tables.
C)  It helps organize structured data into collections of three-dimensional tables.
D)  It helps organize structured data into collections of two-dimensional tables.

Question 14

Which of the following best describes the application layer of Hadoop?

Accepted Answer

A)  It enables applications such as internally developed programming languages or purchased third-party business intelligence tools to interact with Hadoop.
B)  It handles the scheduling and initiation of jobs and balances the required work among the various resources available.
C)  It handles inevitable job failures and interruptions.
D)  It is responsible for the storage of big data.

Question 15

Which of the following is true of a NoSQL database?

Accepted Answer

A)  It possesses high data consistency.
B)  It stores data in a contemporary five-column table.
C)  It stores data in a simple three-column table.
D)  It is highly scalable. D

Question 16

In spreadsheets programs,Excel Solver can be used by the end users to perform "what if" analysis for the evaluation of various alternatives.

Accepted Answer

A) True 
 B)False

Question 17

_____ is a business intelligence (BI) tool used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Accepted Answer

A)  Online analytical processing (OLAP) 
B)  Data governance
C)  Data mining
D)  Drill-down analysis

Question 18

A(n) _____ is used to pull data from disparate data sources to populate and maintain a data warehouse.

Accepted Answer

A)  extract-transform-load (ETL) process
B)  hadoop process
C)  online analytical process
D)  drill-down process

Question 19

Which of the following steps in an extract-transform-load (ETL) process updates an existing data warehouse with the data obtained from the extract and transform steps?

Accepted Answer

A)  Transform
B)  Compress
C)  Load
D)  Extract

Question 20

The ability to ensure that an update to data in one part of a database is immediately propagated to all other parts of the database is known as _____.

Accepted Answer

A)  data integrity
B)  data deduplication
C)  data authenticity
D)  data consistency D

Exam 9: Business Intelligence and Big Data

Correct Answer
verified

_____ includes a wide range of applications,practices,and technologies for the extraction,transformation,integration,analysis,interpretation,and presentation of data to support improved decision making.

Correct Answer
verified

The effectiveness of a(n) _____ process is essential to ensure the success of a data warehouse.

Correct Answer
verified

The columns in a relational database model such as customer name and address represent _____.

Correct Answer
verified

Which of the following databases should be used by a company that has over 50,000 employees in several locations to efficiently manage its database even when a couple of servers are down?

Correct Answer
verified

Which of the following tools in a spreadsheet performs "what if" analysis?

Correct Answer
verified

_____ involves the overall management of the availability,usability,integrity,and security of the data used in an organization.

Correct Answer
verified

Explain the objective of data governance.

Correct Answer
verified
Data governance involves the overall man...
View Answer

Which of the following is true of Hadoop?

Correct Answer
verified

Which of the following is a minor version of a data warehouse that is scaled down to meet the specific needs of a business unit?

Correct Answer
verified

Online analytical processing (OLAP)enables users to identify issues and opportunities as well as perform trend analysis.

Correct Answer
verified

Identify a drawback of a NoSQL database.

Correct Answer
verified
A

Which of the following best describes the relational database model?

Correct Answer
verified

Which of the following best describes the application layer of Hadoop?

Correct Answer
verified

Which of the following is true of a NoSQL database?

Correct Answer
verified
D

In spreadsheets programs,Excel Solver can be used by the end users to perform "what if" analysis for the evaluation of various alternatives.

Correct Answer
verified

_____ is a business intelligence (BI) tool used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Correct Answer
verified

A(n) _____ is used to pull data from disparate data sources to populate and maintain a data warehouse.

Correct Answer
verified

Which of the following steps in an extract-transform-load (ETL) process updates an existing data warehouse with the data obtained from the extract and transform steps?

Correct Answer
verified

The ability to ensure that an update to data in one part of a database is immediately propagated to all other parts of the database is known as _____.

Correct Answer
verified
D

Exam 9: Business Intelligence and Big Data

Correct AnswerverifiedShow Answer

_____ includes a wide range of applications,practices,and technologies for the extraction,transformation,integration,analysis,interpretation,and presentation of data to support improved decision making.

Correct AnswerverifiedShow Answer

The effectiveness of a(n) _____ process is essential to ensure the success of a data warehouse.

Correct AnswerverifiedShow Answer

The columns in a relational database model such as customer name and address represent _____.

Correct AnswerverifiedShow Answer

Which of the following databases should be used by a company that has over 50,000 employees in several locations to efficiently manage its database even when a couple of servers are down?

Correct AnswerverifiedShow Answer

Which of the following tools in a spreadsheet performs "what if" analysis?

Correct AnswerverifiedShow Answer

_____ involves the overall management of the availability,usability,integrity,and security of the data used in an organization.

Correct AnswerverifiedShow Answer

Explain the objective of data governance.

Correct AnswerverifiedData governance involves the overall man...View AnswerShow Answer

Which of the following is true of Hadoop?

Correct AnswerverifiedShow Answer

Which of the following is a minor version of a data warehouse that is scaled down to meet the specific needs of a business unit?

Correct AnswerverifiedShow Answer

Online analytical processing (OLAP)enables users to identify issues and opportunities as well as perform trend analysis.

Correct AnswerverifiedShow Answer

Identify a drawback of a NoSQL database.

Correct AnswerverifiedA

Which of the following best describes the relational database model?

Correct AnswerverifiedShow Answer

Which of the following best describes the application layer of Hadoop?

Correct AnswerverifiedShow Answer

Which of the following is true of a NoSQL database?

Correct AnswerverifiedD

In spreadsheets programs,Excel Solver can be used by the end users to perform "what if" analysis for the evaluation of various alternatives.

Correct AnswerverifiedShow Answer

_____ is a business intelligence (BI) tool used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Correct AnswerverifiedShow Answer

A(n) _____ is used to pull data from disparate data sources to populate and maintain a data warehouse.

Correct AnswerverifiedShow Answer

Which of the following steps in an extract-transform-load (ETL) process updates an existing data warehouse with the data obtained from the extract and transform steps?

Correct AnswerverifiedShow Answer

The ability to ensure that an update to data in one part of a database is immediately propagated to all other parts of the database is known as _____.

Correct AnswerverifiedD

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Data governance involves the overall man...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D