Exam 7: Enterprise Architecture and Security

Transactional data encompasses all of the data contained within a single business process or unit of work,and its primary purpose is to support the performing of daily operational tasks.

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

______________________ is the time it takes a human to comprehend the analytic result and determine an appropriate action.

The primary purpose of a data warehouse is to perform transactional processes.

Which company uses statistical analysis toally detect potential issues,provide quick and easy access to reports,and perform multidimensional analysis on all warranty information?

Which of the following represents the different information levels?

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

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.

Which of the following is a valid type of integrity constraint?

The ________ view of information focuses on how users logically access information to meet their particular business needs.

A data warehouse is a ___________ collection of information-gathered from many different operational databases that supports business analysis activities and decision-making tasks.

Assess the impact of low quality information on an organization and the benefits of high quality information on an organization.

Explain why an organization cannot achieve 100 percent accurate and complete information.

Explain the primary difference between a database and a data warehouse.

______________ is the duplication of information,or storing the same information in multiple places.

All of the following are relational integrity constraints,except

Ideally,an organization only wants to build forward integrations.

Evaluate the advantages of the relational database model.

When does information cleansing occur in the data warehouse?

What refers to how well a system can adapt to increased demands?