Data storage & operations Flashcards
DBA types
Production, development
CIA
Confidentiality Integrity Availability
Lack of integrity (data storage and operations)
Loosing data because (a) you were hacked (b) physical failures e.g., hardware
Main data storage and operations activities
Database support (ensuring performance & reliability, backups & recovery, archiving, clustering and failover)
Data technology management (follow same standards for any technology, e.g., inc. licensing)
What is clustering and failover?
independent servers which can maintain 24/7 availability
Causes of poor database performacne
- memory allocation
- inappropriate indexing (too many/ too few/ wrong)
- locking and blocking
- failure to update database stats
- poor SQL coding
- poor design of views
- application activity
- increase in the number/ size/ use of databases
- database volatility (spikes in updating)
What to consider when looking at technology architechture componets
- current (already supported and used)
- deployment period (when they can be deployed)
- strategic period (when will things be available for use)
- retirement (what is going to be retired)
- preferred
- containment (limited to use by certain applications)
- emerging (those being researched and piloted)
What is performed by data operations staff?
Implement and control database environments
plan for data retention
keep track of database licenses
monitor and tune database performance
What is a goal of data operations?
Assuring the availability of the data throughout its Lifecyle
protection and integrity assurance of structured data assets
performance optimisation of database transactions
The data operations team ensures data is recoverable by…
Defining an executing the data recovery plan
Which of these guiding principles for DBAs involves collaboration with data modelling and data architecture teams?
Identify and act on automation opportunities
What is DBA
Essential for ensuring data is properly stored managed and protected, manage and optimise the database overtime, safeguard data and manage its use, keep database software up to date.
Three types of database architechtures
centralised
Distributed
federated
Advantages of a centralised system
easy to manage
Advantages of a distributed system
faster access and improved reliability
Advantages of a federated system
flexibility
ACID Databases
prioritise accuracy and reliability, ensuring that transactions are completed and the database is up to date,
BASE databases
Focus on data availability
CAP theorem
helps organisations choose the right balance between ACID and BASE
Software Configuration management procedures
Configuration identification
Configuration change control
Configuration audits
Configuration status accounting
Readiness assessments for a governance program
Data management maturity
Capacity to change
Collaborative readiness
Business alignment
Which database processing type permits some level of data availability (even with stale data), with data in a state of flux?
BASE
Which of the guiding principles for DBAs involves collaboration with data modelling and data architecture teams?
Identify and act on automation opportunities
Which type of DBA is responsible for one or more databases in all environments?
Application DBA
How does an SLA govern system performance, data availability and recovery expectations?
An SLA will identify the timeframes during which the database is expected to be available for use
A Data Integration approach that updates a Data Warehouse with small changes from Operational systems is called
CDC
The design, implementation, and support of stored data, to maximize its value across its lifecycle is known as
data storage and operations
If you need to select a database architecture type for projects such as Master Data Management or enterprise information integration, which would be the best choice?
Federated Database
ACID is best used in a
relational database
