Question 1
The best way to validate that a database backup is working, is to:
- Periodically recover from the backup file
- Check the backup logs every day
- Appoint a special DBA in charge of backups
- Check the size of the backup file
- Check for the automatic email notification of backup success
Question 2
When reviewing data access plans, sequential searching is slowing the database. One way to fix this is:
- Reducing the number of database users
- Creating new indexes
- Converting it to an in-memory database
- Moving the database to the cloud
- Adding more memory
Question 3
What area do you not consider when developing a 'data governance operating model'?
- The availability of industry data models
- The business model – decentralized versus centralized
- The value of data to the organisation
- Cultural factors - such as acceptance of discipline and adaptability to change
- Impact of regulation
Question 4
The purpose of data governance is to ensure that:
- Data can be reported on by the business line
- Data is backed up every night
- Data will be understood by all stakeholders
- Data is available for other systems to use
- Data is managed properly, according to policies and best practices
Question 5
A common driver for data governance is:
- Irreconcilable figures in reports
- Regulatory compliance
- The appointment of a CDO
- Internal audits
- Outsourcing