Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CDMP > Data storage & operations > Flashcards

Data storage & operations Flashcards

1
Q

DBA types

A

Production, development

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

CIA

A

Confidentiality Integrity Availability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Lack of integrity (data storage and operations)

A

Loosing data because (a) you were hacked (b) physical failures e.g., hardware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Main data storage and operations activities

A

Database support (ensuring performance & reliability, backups & recovery, archiving, clustering and failover)

Data technology management (follow same standards for any technology, e.g., inc. licensing)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is clustering and failover?

A

independent servers which can maintain 24/7 availability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Causes of poor database performacne

A
  • 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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What to consider when looking at technology architechture componets

A
  • 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)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is performed by data operations staff?

A

Implement and control database environments
plan for data retention
keep track of database licenses
monitor and tune database performance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a goal of data operations?

A

Assuring the availability of the data throughout its Lifecyle
protection and integrity assurance of structured data assets
performance optimisation of database transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The data operations team ensures data is recoverable by…

A

Defining an executing the data recovery plan

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Which of these guiding principles for DBAs involves collaboration with data modelling and data architecture teams?

A

Identify and act on automation opportunities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is DBA

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Three types of database architechtures

A

centralised
Distributed
federated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Advantages of a centralised system

A

easy to manage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Advantages of a distributed system

A

faster access and improved reliability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Advantages of a federated system

A

flexibility

17
Q

ACID Databases

A

prioritise accuracy and reliability, ensuring that transactions are completed and the database is up to date,

18
Q

BASE databases

A

Focus on data availability

19
Q

CAP theorem

A

helps organisations choose the right balance between ACID and BASE

20
Q

Software Configuration management procedures

A

Configuration identification
Configuration change control
Configuration audits
Configuration status accounting

21
Q

Readiness assessments for a governance program

A

Data management maturity
Capacity to change
Collaborative readiness
Business alignment

22
Q

Which database processing type permits some level of data availability (even with stale data), with data in a state of flux?

A

BASE

23
Q

Which of the guiding principles for DBAs involves collaboration with data modelling and data architecture teams?

A

Identify and act on automation opportunities

24
Q

Which type of DBA is responsible for one or more databases in all environments?

A

Application DBA

25
Q

How does an SLA govern system performance, data availability and recovery expectations?

A

An SLA will identify the timeframes during which the database is expected to be available for use

26
Q

A Data Integration approach that updates a Data Warehouse with small changes from Operational systems is called

A

CDC

27
Q

The design, implementation, and support of stored data, to maximize its value across its lifecycle is known as

A

data storage and operations

28
Q

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?

A

Federated Database

29
Q

ACID is best used in a

A

relational database

CDMP (14 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions