Data Storage and Operations Quiz Set

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

Metadata Management
Data Security
Data Storage and Operations
Data Management and process
Master Data Management

A Database Administrator plays many roles in data storage and operations. Which of these tasks does NOT relate to their role?

Supporting the database from implementation of the environment to monitoring and tuning it to ensure good performance
Assist in data security measures
Defining technical requirements to meet the needs of the organisation
Matching, merging and standardising data
Backing up and purging data

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

Identify and act on automation opportunities
Understand and appropriately apply best practices
Connect database standards to support requirements
Build with reuse in mind
Set expectations for the DBA role in project work

Which of these terms defines a subset of database objects used to organise the objects into more manageable parts?

Table
Column
Node
Instance
Schema

A production DBA is responsible for:

Establishing backup and recovery mechanisms so that data can be recovered should it be lost
Executing other database maintenance activities, such as implementing mechanisms for archiving data
Implementing mechanisms for clustering and failover of the database, if continual data availability data is a requirement
Ensuring the performance and reliability of the database, through performance tuning, monitoring and error reporting
All of the above

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

Procedural and Development DBAs
Application DBA
Production DBA
Systems DBA
All types of DBA

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
Non distributed database
Centralised database
Cloud platforms
Blockchain database

Which of these database processing types is best used in relational database storage?

BASE
OLAP
ACID
DBMS
ASCII

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

BASE
OLAP
ACID
DBMS
ASCII

Which of the following is a valid use case for a test environment?

Performance testing
Integration testing
QA
UAT
All of the above

When performing a proof of concept with a new potential software, which environment is the most suitable?

Sandbox
Development
Production
Support
Testing

Non relational databases are used to store:

Data involving time
Data that allows searching using several data element filters simultaneously
Data that constantly changes
Data as simple strings or complete files
Data in a tree-like structure

What are the differences between a column oriented database and a row oriented database?

Row oriented storage is best suited for OLTP while column oriented storage is best suited for OLAP
Row-oriented organisation is more efficient when writing a new row if all of the row data is supplied at the same time
Column-oriented organisation is more efficient when new values of a column are supplied for all rows at once
Column-oriented organisation is more efficient when an aggregate needs to be computed over many rows
All of the above

What is the process called that involves moving data that is no longer active out of production systems into long-term storage systems?

Change Data Capture
Archiving
Replication
Retention
Sharding

What is NOT a technology factor to consider when selecting a DBMS software?

Volume and velocity limits, including streaming rate
Scalability
Resiliency
Hardware platform and operating system support
The relative score given by various technology analysts

What should a DBA do when defining storage requirements?

Plan for adding additional space beyond what is needed and account for growth outside of the data itself
Account for regulation related to data retention
Discuss data retention needs with the data owners at design time and reach agreement on how to treat data through its lifecycle
Work with application developers and other operations staff, including server and storage administrators, to implement the approved data retention plan
All of the above

What is NOT one of the Software Configuration Management procedures?

Configuration identification
Configuration management
Configuration change control
Configuration audits
Configuration status accounting

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
An SLA will identify the minimum execution time for application transactions
An SLA can be reflected to help transfer all responsibility from DBAs to development teams to ensure DBAs aren't involved
If process execution times violate the SLA, the DBA can escalate to a data owner to investigate causes of the problem
All of the above

Database availability is an important factor to manage. Which issues that prevent databases from being available should a DBA focus on?

Operating system failure
Human error
Data replication failure
Security or authorisation issues
All of the above

One cause of poor database performance is when users submit queries that scan through a large set of data that is shared across systems. This is commonly known as?

Insufficient indexing
Poor coding
Runaway queries
Application activity
Overloaded servers

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

EIEIO
CDC
ESB
ETL
ELT

Data Storage and Operations Quiz Set

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

Get CDMP certified, FAST. Click here for guaranteed results.

Would you like to get

FREE LESSONS?