Exam 6: Data: Business Intelligence

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

What are the two different categories for information type?

What is a real-time system?

What does extraction,transformation,and loading mean?

What is data redundancy?

The five common characteristics of high-quality include accurate,complete,__________,timely and unique.

Within the data warehouse model,the external databases could include competitor information,industry information and stock market analysis.

What displays information graphically so it can be easily understood?

What describes technologies that allow users to "see" or visualize data to transform information into a business perspective?

_________ information includes data that change based on user actions.

Data mining occurs on structured data that are already in a database or a spreadsheet.

What are the three common forms for mining structured and unstructured data?

What type of keys do you need to use to create a relational database model?

Data visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

Within the beginning stage of the data warehouse models process,which of the following are included in the internal databases?

What is a foreign key?

What are the two main objectives associated with data mining?

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

Which of the following represents the different information granularities?

___________ displays information graphically so it can be easily understood.