Other Flashcards
(18 cards)
Which approach is considered most effective when supporting multi-dimensional business report requests?
OLAP
One of the difficulties when integrating multiple source systems is:
determining valid links or equivalences between data elements.
A Data Integration approach that updates a Data Warehouse with small changes from Operational systems is called
CDC
When outsourcing information management functions, organisations can ..
Transfer control but not accountability
Which of these statements has the most meaningful relationship label?
An order is composed of order lines.
A comparatively new architectural approach is where volatile data is provisioned in a data warehouse structure to provide transactional systems with a combination of historical and near real time data to meet customer needs. This is a definition of:
Active Data Warehousing
Which of the following is not a good example of BI?
Statutory reporting to a Regulatory Body
Critical to the incremental development of the data warehouse is
a strong release management process.
Slice, Dice, Roll-up and Pivot are terms used in what kind of data processing?
OLAP
In its broadest context, the data warehouse includes:
any data stores or extracts used to support the delivery for BI purposes.
All of the following are TRUE statements on relationship types except:
A one-to-many relationship says that a child entity may have one or more parent entities.
A CRUD matrix helps organisations map responsibilities for data changes in the business process work flow. CRUD stands for
Create, Read, Update, Delete
Identify who has primary responsibility for data capture and usage design within programs
Software Architects, Developers
One of the key differences between operational systems and data warehouses is:
operational systems focus on current data; data warehouses contain historical data.
The best way to validate that a database backup is working, is to:
Periodically recover from the backup file
When reviewing data access plans, sequential searching is slowing the database.
One way to fix this is:
Creating new indexes
‘Planning, implementation and control activities for lifecycle management of data and information, found in any form or medium’, pertains to which knowledge area?
Document and Content Management
Which framework forms the basis of the CDMP Certification exams, outlining standards and practices for data management?
Data Management Body of Knowledge (DMBOK)
