Assignment: Business Intelligence

Question 1
Identify a drawback of a NoSQL database.
1) It lacks strong data consistency.
2) It deteriorates the system uptime.
3) It is less scalable.
4) It is not efficient in dealing with extremely large databases.

Question 2
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?
1) Neural computing
2) Association analysis
3) Case-based reasoning
4) Drill-down analysis

Question 3
Which of the following represents an entity in a relational database model?
1) A column
2) A row
3) An attribute
4) A degree

Question 4
Which of the following best describes the relational database model?
1) It helps organize unstructured data into collections of three-dimensional tables.
2) It helps organize unstructured data into collections of two-dimensional tables.
3) It helps organize structured data into collections of three-dimensional tables.
4) It helps organize structured data into collections of two-dimensional tables.

Question 5
Which of the following is a method to analyze multidimensional data from different perspectives?
1) Spreadsheet reporting
2) Data mining
3) Online analytical processing (OLAP)
4) Drill-down analysis

Question 6
The columns in a relational database model such as customer name and address represent _____.
1) attributes
2) entities
3) keys
4) tuples

Question 7
_____ 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.
1) Business intelligence
2) Artificial intelligence
3) Prescriptive analytics
4) Artificial analytics

Question 8
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?
1) Data cart
2) Data mart
3) Data wallet
4) Data set

Question 9
Metrics that consist of a direction, measure, target, and time frame are known as _____.
1) online analytical processors
2) key association indicators
3) drill-down analysis indicators
4) key performance indicators

Question 10
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?
1) Big data
2) Data mart
3) Data warehouse
4) Big cell

Question 11
Identify the industry that implements data governance.
1) Insurance industry
2) Agricultural industry
3) Construction industry
4) Automobile industry

Question 12
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?
1) Hadoop
2) SQL
3) COBOL
4) NoSQL

Question 13
In-memory databases (IMDBs) have become feasible because of the decrease in _____ capacities.
1) random access memory (RAM)
2) read-only memory (ROM)
3) random access memory (RAM)
4) read-only memory (ROM)

Question 14
Which of the following is true of dashboards?
1) They provide rapid access to information in an easy-to-interpret manner.
2) They provide rapid access to information in a verbose manner.
3) 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.
4) They index documents from a variety of sources such as corporate databases, departmental files, email, corporate wikis, and document repositories.

Question 15
Identify a true statement about drill-down analysis.
1) It involves the interactive examination of high-level summary data in increasing detail to gain insight into certain elements.
2) It involves pre-aggregation of detailed data into useful data summaries in anticipation of questions that might be raised.
3) It performs operation on data based on user-defined formulas.
4) It is used to explore large amounts of data for hidden patterns to predict future trends and behaviors for use in decision making.

Question 16
Which of the following represents the attribute of an entity in a relational database model?
1) A column
2) A row
3) A Cardinality
4) A tuple

Question 17
Which layer of Hadoop is responsible for data storage?
1) The application layer
2) The Hadoop Distributed File system layer (HDFS)
3) The workload management layer
4) The Hadoop resource layer (HRL)

Question 18
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?
1) Drill-down analysis
2) Online analytical processing
3) Spreadsheets
4) Dashboards

Question 19
Which of the following is true of the neural computing technique in data mining?
1) Historical data is examined for patterns that are then used to make predictions.
2) A set of algorithms sorts through data and forms statistical rules about relationships among the items.
3) Historical if-then-else cases are used to recognize patterns.
4) Operations are performed on given data based on formulas created by the end user.

Question 20
A NoSQL database stores data as highly optimized key-value pairs with the data stored in a _____ table.
1) simple two-column
2) contemporary four-column
3) simple three-column
4) contemporary nine-column.