CIS9440 Chapter 7
21. Which of these attributes of NoSQL is not true? a)it is schema‐free design that provides flexibility to start loading data and then changing it later. b) provides ACID support instead of BASE support c) Supports distributed, scalable and real time data updates d) NoSQL is referred to as "Not Only" SQL database, since SQL is not required but may be used for some of the databases.
Answer: b)provides ACID support instead of BASE support(page 163)
20. Out of all the OLAPs, the OLAP that has the fastest query performance, is limited by physical cube in data volumes and needs to rebuild when data change is: a)HOLAP b)ROLAP c)MOLAP d)TOLAP
Answer: c)MOLAP(page 160)
31.Of the four technology architectures, which is used to store integrated data that would then be consumed by BI and analytics? (a)Data Source (b)Data Warehousing (c)Information access and data integration (d)Business Intelligence and analytics
answer:(b)Data Warehousing (page 147)
41. Which of the following is NOT a category of data based on its form in the primary source: a. Structured b. Multi Structured c. Semi structured d. Unstructured
ANSWER: B, Page 163
40. Which one of the following is NOT part of the four technology layers that form the BI technology architecture: a. Business intelligence and analytics b. Information access and data integration c. Data architecture d. Data warehousing
ANSWER: C, Page 147
6. NoSQL databases fall into several technology architectures categories, except: (A) Key‐Value (B) Column‐Family (C) Support (D) Graph
Answer (C) Support ; Big Data (page 163)
5. About Data Management we cannot affirm that: (A) A cornerstone of using relational databases for BI has been the adoption of dimensional modeling. (B) Many of the data integration design principles rely on dimensional schemas. (C) BI and data integration tools leveraging dimensional modeling and relational databases in a symbiotic relationship, there have been continual improvements in the effectiveness and ROI of BI applications. (D) All option above are wrong.
Answer (D) All option above are wrong; DATA MANAGEMENT (page 146 )
35. OLAP Analysis includes all of the following except: (a) Drill‐up (b) Drill‐down (c) Drill‐across (d) Slice and dice
Answer: (a) Drill‐up (150)
42. __________________ are a combination of products designed to improve performance and increase scalability of BI and analytical applications. a. DW b. Business Process Bundles c. Database analytical tools d. BI Appliances
ANSWER: D, Page 164
19. Which of the four technology layers is considered the tools used to gather, integrate and transform data into information and then make it accessible? a)Business Intelligence and analytics b)Information access and data integration c)Data warehousing d)Data sources
Answer: b) Information access and data integration (page 147)
4. "In the early days of data warehousing, the mainframe was the primary computing platform with minicomputers, PCs, and client/server computing emerging to expand the implementation options available to IT". Which of the following statement has the best complement to the beginning statement (A) Enterprise networking expanded. (B) Supporting client/server computing. (C) Proliferation of servers and PCs. (D) All option above.
Answer (D) All option above; TECHNOLOGY PLATFORMS (page 145)
25. Transactional data from enterprise applications is considered as: (a) structured data (b) unstructured data (c) semi structured (d) None of the above.
Answer (a) structured (page 163)
26. Which NoSQL technology architecture category creates a collection of one or more key‐ value pairs that match a record? (a) Key‐Value (b) Column‐Family (c) Document (d) Graph
Answer (b) Column‐Family (page 164)
27. Which type of OLAP creates physical cubes? (a) Relational OLAP (b) Hybrid OLAP (c) Multidimensional OLAP (d) None of the above.
Answer (c) Multidimensional OLAP (page 159)
2. What is the primary data integration tool used by BI? (A) ETL (B) Enterprise information integration (C) Cloud integration (D) All of the above
Answer: (A) ETL page 154
17. Which is the description of ragged dimension hierarchies? A. The system allows dimension hierarchies of intermediate depth, such as organization charts and parts explosions, where records in the dimension can play the roles of parents as well as children. B. The system implements a surrogate key pipeline process for the cardinality of dimensions. C. The system guarantees that the dimensions and the facts maintain referential integrity. D. All dimension allow comparison calculations that constraints two or more disjoints values of a single attribute from a dimension in computations such as ratios or differences.
Answer: (A) The system allows dimension hierarchies of intermediate depth, such as organization charts and parts explosions, where records in the dimension can play the roles of parents as well as children. (page 229)
1. Is a database that turn the row‐based orientation of relational databases on its side, instead storing data vertically by columns. (A) Relational Database (B) Columnar Database (C) Multi‐Dimensional Database (D) None of the above
Answer: (B) Columnar Database page 160
18. Which is the description of dimensional symmetry? A. The system allows dimension hierarchies of intermediate depth, such as organization charts and parts explosions, where records in the dimension can play the roles of parents as well as children. B. The system implements a surrogate key pipeline process for the cardinality of dimensions. C. All dimension allow comparison calculations that constraints two or more disjoints values of a single attribute from a dimension in computations such as ratios or differences. D. The system guarantees that the dimensions and the facts maintain referential integrity.
Answer: (C) All dimension allow comparison calculations that constraints two or more disjoints values of a single attribute from a dimension in computations such as ratios or differences. (page 228)
16. Which is the description of dimensional integrity? A. The system uses physically stored aggregates as a way to enhance performance of common queries. B. The system delivers upon request all the records from a production source of a dimension that have changed since the last such request. C. The system guarantees that the dimensions and the facts maintain referential integrity. D. All dimension allow comparison calculations that constraints two or more disjoints values of a single attribute from a dimension in computations such as ratios or differences.
Answer: (C) The system guarantees that the dimensions and the facts maintain referential integrity. (page 228)
3. Which of the following is/are part of the common protocols used in information access and data integration? (A) Open Database Connectivity (B) Java Database Connectivity (C) XML for Analysis (D) All of the above
Answer: (D) All of the above page 153
38. Which type of analytics searches for patterns in unstructured data that meet query criteria by the business person? (a) Big Data analytics (b) BI search (c) Data discovery (d) Predictive analytics
Answer: (a) Big Data analytics (page 151)
12. What is an advantage that ELT has against ETL? (a) It does not require a dedicated data integration server (b) It has greater integration capabilities and better performance (c) It runs integration services only on the source database servers (d) It requires specialized database and data integration server expertise
Answer: (a) It does not require a dedicated data integration server (page 157)
14. In terms of API to access and integrates information, it is possible to affirm that (a) JDBC, or JAVA database connectivity, is a standard middleware used by Java Programming languages. (b) XQuery was developed to be database and operating system independent, replacing database‐specific APIs. (c) XML for Analysis (XML/A) is common in OLAP and data mining. It can executes MDX and SQL only. (d) All of them are correct
Answer: (a) JDBC, or JAVA database connectivity, is a standard middleware used by Java Programming languages. (158)
44. What does ETL stand for? (a) exam, total, level (b) extract, transform, load (c) encase, transform, label (d) extract, transgress, load
Answer: (b) (page 155)
10. Among the most common BI styles, the one that presents the data to the users allowing them to create their own custom reports with data and data they select is called: (a) Reporting and alerts (b) Ad hoc analysis (c) Dashboards and scorecards (d) OLAP analysis
Answer: (b) Ad hoc analysis (page 150)
13. About the technology architecture, it is possible to say that: (a) There are 3 technology layers that forms BI: BI and analytics, Data warehousing and Data sources (b) Besides data marts and OLAP cubes, the DW could also implement MDM, ODS, Analytical sandboxes, refined big data or repositories. (c) Information access and data integration do not relates to querying, integrating, cleansing and transforming data into information that is delivered to a person, process or database. (d) None of them are right.
Answer: (b) Besides data marts and OLAP cubes, the DW could also implement MDM, ODS, Analytical sandboxes, refined big data or repositories. (147)
36. BI Venders fall into one of these categories except: (a) Full BI Stack (b) IOT data creation specialists (c) BI and analytic specialists (d) Data integration specialists
Answer: (b) IOT data creation specialists (166)
24. Which of the following is NOT an integrated application of BI architecture. (a) Cloud Integration (b) Java (c) B2B Integration (d) Application services
Answer: (b) Java (page 155)
15. About the OLAP, one of the alternatives to relational databases, we can assure: (a) The fastest query processing and, therefore, best query performance is called ROLAP. (b) The type of OLAP that needs to be rebuilt when data changes is called MOLAP. (c) In ROLAP and HOLAP the administrator does not need to manage both relational DBMS and metadata layer. (d) MOLAP, OLAP and HOLAP are limited by physical cube, in terms of data volumes.
Answer: (b) The type of OLAP that needs to be rebuilt when data changes is called MOLAP. (160)
29. What is function of a relational OLAP(ROLAP)? (a) creates a physical cubes (b) data stored in relational with logical scheme (c) mixture of ROLAP for detailed data and MOLAP for aggregations (d) none of the above
Answer: (b) data stored in relational with logical scheme (pg 159)
23. This method presents data to users and lets them create their own custom report. (a) OLAP analysis (b) Spreadsheet integration (c) Ad hoc analysis (d) Cloud BI
Answer: (c) Ad hoc analysis (page 150)
37. Which technology layer is used to store integrated data that would then be consumed by BI and analytics? (a) Business intelligence and analytics (b) Information access and data integration (c) Data warehousing (d) Data sources
Answer: (c) Data warehousing (page 148)
34. The logical data warehouse may include all of the following except: (a) EDW (b) Data marts (c) Payments Processing (d) OLAP Cubes
Answer: (c) Payments Processing (143)
30. What type of data does text, audio, and video from social media and Web applications count as? (a) structured (b) semi structured (c) unstructured (d) atomic
Answer: (c) unstructured (pg 163)
43. which is not one of the four technology layers? (a) Business intelligence and analytics (b) Data warehousing (c) Data sources (d) Financial reporting
Answer: (d) (page 147)
45.what are examples of unstructured data (a) e‐mails (b) social media (c) patient records (d) all of the above
Answer: (d) (page 158)
8. Which of the below is the delivery option of BI reporting and alerts? (a) Static reports pushed to users via e‐mail (b) Parameter‐driven reports run on‐demand by user (c) Alerts, sent via email or other messaging (d) All of the above
Answer: (d) All of the above (page 150)
9. Which is Data access APIs (application programming interfaces)? (a) XQuery (b) XML for Analysis (XML/A) (c) Open Database Connectivity (ODBC) (d) All of the above
Answer: (d) All of the above (page 153)
11. Oversimplified view of a BI environment leads to misperceptions like the following, EXCEPT: (a) BI and analytics applications merely query data (b) BI tool is always the destination of data in the BI architecture (c) Data integration is always an ETL batch process (d) Business person as well as business processes and applications are important BI targets
Answer: (d) Business person as well as business processes and applications are important BI targets (page 152)
22. Any source that captures data that will be used by an enterprise is a(n): (a) Data architecture (b) Database (c) Server (d) Data source
Answer: (d) Data source page (page147)
39. Which database uses treelike structures that are linked to other nodes through relationships? (a) Key‐Value (b) Column‐Family (c) Document (d) Graph
Answer: (d) Graph (page 164)
7. Which is not the terms to describe the query capabilities? (a) Drill‐down (b) Drill‐across (c) Slice and dice (d) None of the above
Answer: (d) None of the above (page 150)
28. Which is not one of the four technology layers that form the BI technology architecture? (a) business intelligence and analytics (b) data warehousing (c) data sources (d) Multivalued dimensions
Answer: (d) multivalued dimensions (pg 147)
33.For what are NoSQL Databases used? (a)Handling structured data from enterprise applications (b)Handling semi structured machine data from the Internet of Things (c)Handling unstructured data such as social media and web applications (d)Handling all types of data
answer:(c)Handling unstructured data such as social media and web applications (page 163)
32.What is the primary data integration tool used in BI and data warehousing? (a)EAI (Enterprise application integration) (b)EMS (Enterprise message services) (c)EII (Enterprise information integration) (d)ETL (Extract, load, and Transform)
answer:(d)ETL (Extract, load, and Transform) (page 154)
