CDMP Mock-Up Exam 2

Which of these are increasingly driving legislation for information security and data privacy?

• An objective of making life more challenging for information management professionals
• A recognition of Ethical issues in information management
• GDPR
• A resistance to open data and transparency
• A desire for economic protectionism

Definition of Data Security Policies should be:

• A collaborative effort between Business and IT
• Reviewed by external Regulators
• Determined by external Regulators
• Based on defined standards and templates
• Conducted by external consultants

Apart from security requirements internal to the organisation, what other strategic goals should a Data Security Management system address?

• Compliance with ISO29100 and PCI-DSS
• None of these
• Ensuring the organisation doesn't engage in SPAM marketing
• Compliance with ISO27001 and HIPPA
• Regulatory requirements for privacy and confidentiality AND Privacy and Confidentiality needs of all stakeholders

A CRUD matrix helps organisations map responsibilities for data changes in the business process work flow. CRUD stands for

• Create, Review, Use, Destroy
• Cost, Revenue, Uplift, Depreciate
• Create, Read, Update, Delete
• Confidential, Restricted, Unclassified, Destroy
• Create, React, Utilise, Delegate

A RACI matrix is a useful tool to support the ______ in an outsourced arrangement.

• Service level Agreement
• Attributing Costs
• Alignment of Business goals
• Segregation of duties
• Transfer of access controls

Which of the following is not a good example of BI?

• Statutory reporting to a Regulatory Body
• Decision Support Systems
• Strategic Analytics for Business Decisions
• Supporting Risk Management Decision Reporting

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:

• On Line Transactional Processing System
• On Line Analytical Processing Cube
• Active Data Warehousing
• Behavioural Decision Support Systems
• Operational Data Store

Slice, Dice, Roll-up and Pivot are terms used in what kind of data processing?

• ODS
• OLAP
• EIEIO
• EDI
• OLTP

When performing an evaluation of analytic applications, which of the following questions is least relevant to identify the level of effort needed?

• How much do the canned processes in the tool match our business
• Annual costs such as license, maintenance, etc.
• How much of the tool infrastructure meets our organisational infrastructure
• The Standard source systems for which ETL is supplied
• Number of source systems we need to integrate into the tool

One of the key differences between operational systems and data warehouses is:

• Operational systems focus on data quality; data warehouses focus on data security
• Operational systems are available 24x7; data warehouses are available during business hours
• Operational systems focus on business processes; data warehouses focus on business strategies
• Operational systems focus on historical data; data warehouses contain current data
• Operational systems focus on current data; data warehouses contain historical data