Question 1

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 
A) data integrity 
B) data deduplication 
C) data authenticity 
D) data consistency D

Question 2

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. 
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 3

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) 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 4

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 
A) visual basic 
B) extract-transform-load 
C) chamfering 
D) actuating

Question 5

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 
A) Excel Solver 
B) Excel filter manager 
C) Excel chart 
D) Excel scenario manager

Question 6

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 
A) Data cart 
B) Data mart 
C) Data wallet 
D) Data set

Question 7

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. 
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 8

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. 
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 9

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

Accepted Answer

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

Question 10

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 
A) Drill-down analysis 
B) Online analytical processing 
C) Spreadsheets 
D) Data mining

Question 11

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 
A) Hadoop 
B) SQL 
C) COBOL 
D) NoSQL

Question 12

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 13

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 
A) extract-transform-load (ETL)process 
B) hadoop process 
C) online analytical process 
D) drill-down process

Question 14

_____ 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 
A) Data endorsement 
B) Data authorization 
C) Data authentication 
D) Data governance

Question 15

Explain the objective of data governance.

Accepted Answer

Data governance involves the overall man

Question 16

_____ 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 
A) Business intelligence 
B) Artificial intelligence 
C) Prescriptive analytics 
D) Artificial analytics

Question 17

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 
A) Transform 
B) Compress 
C) Load 
D) Extract

Question 18

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. 
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 19

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

Accepted Answer

A) True 
 B)False

Question 20

_____ 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 
A) Online analytical processing (OLAP) 
B) Data governance 
C) Data mining 
D) Drill-down analysis

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 _____.

Which of the following is true of a NoSQL database?

Identify a drawback of a NoSQL database.

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

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

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?

Which of the following best describes the relational database model?

Which of the following is true of Hadoop?

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

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?

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

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

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

Explain the objective of data governance.

_____ 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.

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?

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

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

_____ 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.

Managers: Key to Information Technology Results

Strategic Planning

Project Management

Business Process and It Outsourcing

Corporate and It Governance

Collaboration Tools

E-Commerce

Enterprise Systems

Knowledge Management

Cybercrime and It Security

Ethical, legal, and Social Issues of Information Technology

Filters

Exam 9: Business Intelligence and Big Data

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 _____.

Which of the following is true of a NoSQL database?

Identify a drawback of a NoSQL database.

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

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

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?

Which of the following best describes the relational database model?

Which of the following is true of Hadoop?

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

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?

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

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

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

Explain the objective of data governance.

_____ 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.

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?

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

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

_____ 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.

Managers: Key to Information Technology Results

Strategic Planning

Project Management

Business Process and It Outsourcing

Corporate and It Governance

Collaboration Tools

E-Commerce

Enterprise Systems

Knowledge Management

Cybercrime and It Security

Ethical, legal, and Social Issues of Information Technology

Filters