Exam 3: Databases and Data Warehouses: Building Business

Your student ID is an example of a(n)_____.

Which of the following systems contain information from multiple databases?

Data marts focus on the entire organization,while data warehouses focus on specific needs.

A(n)_____ is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

If you were viewing information from different perspectives,you would be _____.

_____ are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

_____ help users apply various mathematical models to information stored in a data warehouse to discover new information.

If you were comparing information from various divisions of an organization for instance,sales,marketing,and production,what type of information repository would you most likely work with?

If you needed to store facts about information that you were collecting,you would store these facts in the _____.

The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

What is the purpose of a data warehouse?

If you were able to quickly pull information from student records with course records to build students' schedules,you would be using a _____ tool.

The primary key of the Customer file is the Customer ID field and the primary key of the Order file is the Order ID field.Therefore,the _____ field would be used to create a logical relationship between the Customer and Order files.

A physical view represents how the users view the data.

Which type of application requires that you know the physical location of information before you are able to access it?

In a data warehouse,which artificial intelligence tools allows you to discover information and build intelligence?

What application enables your organization to analyze competitor,customer,environmental,and internal data?

In an organization,_____ plans for,oversees the development of,and monitors the information resource.

A database management system contains five important software components.Which of the following components accepts and processes requests from other the other four database components?