Reference no: EM133049058

Q1. Operational data and decision support data serve the same purpose. True False 

Q2. _____ tools focus on the strategic and tactical use of information. 

1. Networking
2. Relational database management 
3. Business
4. Business intelligence 

Q3. Controlled redundancy is allowed in creating Fact tables in data warehouse 

True

False

Q4. _____ provide a unified, single point of entry for information distribution. 

1. Dashboards
2. Decision support systems 
3. Data warehouses 
4. Portals

Q5. From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____. 

a. usability

b. transaction processing 

c. dimensionality

d. sparsity

Q6. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom. 

True

False 

Q7. One of the main sources of creating info cubes in an organization's data warehouse is the operational database of the same organization. 

True

False

Q8. Business intelligence (BI) architecture is composed of data, people, processes, and technology working together to facilitate and enhance a business's management and governance. 

True

False 

Q9. In the star schema, dimensions are allowed to have hierarchical structures 

True

False

Q10. Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS. 

True

False