Deck 9: Business Intelligence and Big Data

Question 1

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

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

Answer 1

A

Question 2

A _____ is a database that stores large amounts of historical data in a form that readily supports analysis and management decision making in an organization.

A)data structure
B)data warehouse
C)data profile
D)data guard

Answer 2

B

Question 3

Which of the following steps in an extract-transform-load (ETL)process creates an updated version of a data warehouse?

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

Answer 3

D

Question 4

Zomi,a fashion outlet,wishes to delete the details of orders that cost less than $30.Which of the following steps in the extract-transform-load (ETL)process is used to accomplish this task?

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

Question 5

Which of the following best describes the relational database model?

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 6

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

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

Question 7

Which of the following is true of a data mart?

A)It is an extended version of a data warehouse.
B)It is an extended version of big data.
C)It is a smaller version of a data warehouse.
D)It is a smaller version of a hadoop.

Question 8

Which of the following best describes an extract-transform-load (ETL)process?

A)It is a smaller version of a data warehouse-scaled down to meet the specific needs of a business unit.
B)It contains data collections that are enormous and complex.
C)It is a simple but highly useful way to organize structured data into collections of two-dimensional tables.
D)It is used to pull data from disparate data sources to populate and maintain the data warehouse.

Question 9

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?

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

Question 10

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

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

Question 11

PHQ,a graphics firm,decides to filter its employees according to their dates of joining.Which of the following steps in the extract-transform-load (ETL)process should be taken by the firm to accomplish the task?

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

Question 12

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?

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

Question 13

Which of the following represents the attribute of an entity in a relational database model?

A)A column
B)A row
C)A Cardinality
D)A tuple

Question 14

Which of the following represents an entity in a relational database model?

A)A column
B)A row
C)An attribute
D)A degree

Question 15

Which of the following steps in an extract-transform-load (ETL)process draws desired data from various data sources to update a data warehouse?

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

Question 16

Which of the following is a special-purpose programming language used for accessing and manipulating data stored in a relational database?

A)SQL
B)FORTRAN
C)JAVA
D)COBOL

Question 17

_____ tools frequently operate on data stored in a data warehouse or data mart.

A)Business intelligence
B)Hadoop
C)Prescriptive analytic
D)Ransomware

Question 18

Which of the following is a term used to describe data collections that are so enormous and complex that traditional data management software and analysis processes are incapable of dealing with them?

A)Big data
B)Data mart
C)Data warehouse
D)Big cell

Question 19

The ACID (atomicity,consistency,isolation,and durability)properties of SQL databases ensure _____.

A)data severance
B)data integrity
C)data security
D)data cogency

Question 20

In an extract-transform-load (ETL)process,the mined data used to update a data warehouse is converted to a different format in the _____ step.

A)extract
B)autorun
C)load
D)transform

Question 21

A(n)_____ is a database management system that stores an entire database in random access memory (RAM).

A)Hadoop Distributed File System layer (HDFS)
B)in-memory database (IMDB)
C)iSQL database
D)Hadoop memory system (HMS)

Question 22

The Hadoop Distributed File System layer (HDFS)stores data in blocks of _____ or more.

A)128 MB
B)64 MB
C)16 MB
D)32 MB

Question 23

_____ enables the analysis of big data and other challenging data-processing applications.

A)In-memory database (IMDB)
B)Hadoop Distributed File System layer (HDFS)
C)Hadoop memory system (HMS)
D)iSQL

Question 24

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?

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

Question 25

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

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 26

Data that does not fit nicely into relational databases is known as _____.

A)ultra-structured data
B)unstructured data
C)highlighter data
D)structured data

Question 27

Which of the following is true of Hadoop?

A)It is designed to store and retrieve data in a manner that does not rigidly enforce the atomicity,consistency,isolation,and durability (ACID)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 28

Identify the feature of a NoSQL database that allows a large database to be distributed across thousands of servers running the same NoSQL database management system.

A)Deduplication
B)Scalability
C)Integrity
D)Authenticity

Question 29

Identify the system feature that is improved due to the highly scalable nature of NoSQL databases.

A)System memory
B)System security
C)System uptime
D)System boot-time

Question 30

Identify a drawback of a NoSQL database.

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.

Question 31

Which of the following databases is designed to store and retrieve data without rigidly implementing the ACID (atomicity,consistency,isolation,and durability)conditions associated with the relational database model?

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

Question 32

Which of the following is true of a NoSQL database?

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.

Question 33

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

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

Question 34

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

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

Question 35

Which of the following is the storage medium of an in-memory database (IMDB)?

A)Read-only memory (ROM)
B)Virtual drive
C)Magnetic tape
D)Random access memory (RAM)

Question 36

A NoSQL database stores data as highly optimized key-value pairs with the data stored in a _____ table.

A)simple two-column
B)contemporary four-column
C)simple three-column
D)contemporary nine-column

Question 37

Which of the following is true of unstructured data?

A)It fits nicely into traditional databases.
B)It ensures that any updates to a database generated by a transaction are completed in their entirety.
C)It relies upon concurrency control by locking database records to ensure that other transactions do not modify a database until the first transaction succeeds or fails.
D)It can add a depth to data analysis,with the right tools,that could not be achieved otherwise.

Question 38

Which of the following layers of Hadoop handles job failures and interruptions?

A)The application layer
B)The Hadoop memory layer (HML)
C)The workload management layer
D)The Hadoop Distributed File System layer (HDFS)

Question 39

Which layer of Hadoop is responsible for data storage?

A)The application layer
B)The Hadoop Distributed File system layer (HDFS)
C)The workload management layer
D)The Hadoop resource layer (HRL)

Question 40

Identify the technique through which an SQL database ensures that other transactions do not modify a database until the first transaction succeeds or fails.

A)Redundancy control
B)Access control
C)Concurrency control
D)Integrity control

Question 41

Identify the spreadsheet tool that is used to determine the optimal solution to a problem with multiple constraints.

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

Question 42

PindCart,a garment retailer,is not sure of the demand for its products during the festive seasons and ends up with very little profit.Which of the following business intelligence tools can help PindCart to predict the demand and maximize its sales?

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

Question 43

Which of the following is the reason behind the quick responsiveness of online analytical processing (OLAP)?

A)Matching a user's query to many sources of information
B)The pre-aggregation of detailed data into useful data summaries
C)Performing operations on data based on user defined formulas
D)An Interactive examination of high-level summary data

Question 44

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

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

Question 45

_____ enables users to identify issues and opportunities as well as perform trend analysis by analyzing multidimensional data from many different perspectives.

A)Online analytical processing (OLAP)
B)Drill-down analysis
C)Excel scenario manager
D)Excel Solver

Question 46

Which of the following business intelligence tools performs operations on data based on formulas created by the end user?

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

Question 47

Which of the following data mining techniques uses a specialized set of algorithms that sorts through data and forms statistical rules about relationships among the items?

A)Neural computing
B)Association analysis
C)Case-based reasoning
D)Drill-down analysis

Question 48

Which of the following business intelligence tools will help an organization to make business predictions?

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

Question 49

Identify a true statement about drill-down analysis.

A)It involves the interactive examination of high-level summary data in increasing detail to gain insight into certain elements.
B)It involves pre-aggregation of detailed data into useful data summaries in anticipation of questions that might be raised.
C)It performs operation on data based on user-defined formulas.
D)It is used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Question 50

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

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

Question 51

Databases built to support online analytical processing (OLAP)consist of _____.

A)data cubes
B)data hubs
C)data cards
D)data marts

Question 52

In-memory databases (IMDBs)have become feasible because of the decrease in _____ capacities.

A)random access memory (RAM)
B)read-only memory (ROM)
C)random access memory (RAM)
D)read-only memory (ROM)

Question 53

Which of the following is true of the neural computing technique in data mining?

A)Historical data is examined for patterns that are then used to make predictions.
B)A set of algorithms sorts through data and forms statistical rules about relationships among the items.
C)Historical if-then-else cases are used to recognize patterns.
D)Operations are performed on given data based on formulas created by the end user.

Question 54

Which of the following best describes reporting and querying tools?

A)They perform operations on the data based on formulas created by the end user.
B)They consist of data cubes that contain numeric facts called measures,which are categorized by dimensions such as time and geography.
C)They match a user's query to many sources of information in an attempt to identify the most important content and the most reliable and relevant source.
D)They present data in a simplified form of graphs and charts,making it easier to understand.

Question 55

_____ can be used to create useful reports and graphs based on given data.

A)Spreadsheets
B)Hadoop
C)Business rule management system
D)Enterprise search software

Question 56

Metrics that consist of a direction,measure,target,and time frame are known as _____.

A)online analytical processors
B)key association indicators
C)drill-down analysis indicators
D)key performance indicators

Question 57

_____ is a powerful tool that enables decision makers to gain insight into the details of business data to better understand why something happened.

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

Question 58

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?

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

Question 59

Which of the following enables end users to make their own data requests and format the results without the need for additional help from the information technology organization?

A)Online analytical processing (OLAP)
B)Reporting and querying tools
C)Spreadsheets
D)Drill-down analysis

Question 60

Which of the following is a method to analyze multidimensional data from different perspectives?

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

Question 61

An SQL database stops abruptly when it encounters an error in the update process.

Question 62

Explain the objective of data governance.

Question 63

_____ are designed to draw data in real time from various sources,including corporate databases and spreadsheets,so decision makers can make use of up-to-the-minute data.

A)Tactical dashboards
B)Operational dashboards
C)Strategic dashboards
D)Analytical dashboards

Question 64

Brief on the relational database model.

Question 65

Identify the industry that implements data governance.

A)Insurance industry
B)Agricultural industry
C)Construction industry
D)Automobile industry

Question 66

Which of the following is true of dashboards?

A)They provide rapid access to information in an easy-to-interpret manner.
B)They provide rapid access to information in a verbose manner.
C)They match a user's query to many sources of information in an attempt to identify the most important content and the most reliable and relevant source.
D)They index documents from a variety of sources such as corporate databases,departmental files,email,corporate wikis,and document repositories.

Question 67

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

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

Question 68

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

Question 69

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

Question 70

What is data mining?

Question 71

An in-memory database (IMDB)is a database management system that stores an entire database in read-only memory (ROM).

Question 72

How is data stored in a NoSQL database?

Question 73

Unstructured data comes from a single source.

Question 74

Organizations employ data warehouses to store junk data.

Question 75

Online analytical processing (OLAP)involves the interactive examination of high-level summary data in increasing detail.

Question 76

Hadoop is designed for processing large volumes of data by dividing the work into a set of independent tasks that are executed in parallel on a large number of servers.

Question 77

Case-based reasoning technique of data mining contains a specialized set of algorithms that sorts through data and forms statistical rules about relationships among the items.

Question 78

The goal of a NoSQL database is to provide very fast performance even as the amount of data that must be processed continues to grow.

Question 79

_____ present a set of key performance indicators about the state of a process at a specific point in time.

A)Spreadsheets
B)Dashboards
C)Timesheets
D)Worksheets

Question 80

Elaborate the process of data mining.