Chapter6- Data storage and Operations

Play an AI-generated podcast conversation about this lesson

Which type of database system maps multiple autonomous database systems into a single federated database?

Blockchain database

Distributed database

Federated database (correct)

Non-federated database

What is the purpose of using MapReduce in distributed databases?

To provide high aggregate bandwidth

To improve performance (correct)

To detect and handle failures

To replicate data amongst the servers

What is the main advantage of using a tightly coupled federated database system?

Data replication

Autonomous component systems

Independent processes

Location transparency (correct)

Which type of database is used to securely manage financial transactions and create chains of time-bound groups of transactions?

Blockchain database Signup and view all the answers

Which of the following activities is NOT included in Data Storage and Operations?

Data security Signup and view all the answers

What is the role of a Database Administrator (DBA) in Data Storage and Operations?

Managing database operations Signup and view all the answers

Which aspect of data management practices is considered the most mature?

Database administration Signup and view all the answers

What is the main goal of Database Technology Support in Data Storage and Operations?

Installing and administering technology Signup and view all the answers

Which role is the most established and widely adopted in the field of data management?

Database administrator Signup and view all the answers

What is the purpose of a schema in a database?

To organize objects into more manageable parts Signup and view all the answers

What is the advantage of using database abstraction?

Portability Signup and view all the answers

What is included in data lifecycle management?

Acquisition, migration, retention, expiration, and disposition of data Signup and view all the answers

Which role is responsible for ensuring the performance and reliability of the database, implementing backup and recovery mechanisms, and executing other database maintenance activities?

Production DBA Signup and view all the answers

What is one of the deliverables created by Production DBAs as part of managing data operations?

A production database environment Signup and view all the answers

Which role is responsible for one or more databases in all environments and collaborates closely with data analysts, modelers, and architects?

Application DBA Signup and view all the answers

Which type of database manages all the data in one system in one place, with all users accessing the data through that system?

Centralized database Signup and view all the answers

Which of the following is NOT a goal of data storage and operations?

Minimizing the risk of disruption Signup and view all the answers

What is the primary driver of data storage and operations activities?

Data availability Signup and view all the answers

Which of the following is NOT a guiding principle for data storage and operations?

Understand and appropriately apply best practices Signup and view all the answers

What is the main purpose of virtualizing data in data storage and operations?

To prevent applications from being tightly coupled to database schemas Signup and view all the answers

Which of the following methods for implementing databases on the cloud involves application owners not having to install and maintain the database on their own?

Database-as-a-service (DaaS) Signup and view all the answers

Which of the following is a characteristic of ACID database processing?

All operations are performed, or none of them is Signup and view all the answers

Which of the following is a characteristic of BASE database processing?

The data is in a constant state of flux Signup and view all the answers

Which of the following is NOT a method for implementing databases on the cloud?

Data encryption procedures Signup and view all the answers

According to the text, which of the following is true about eventual consistency?

The data will eventually be consistent through all nodes and in all databases. Signup and view all the answers

According to the text, which of the following is true about BASE implementations?

They are common in Big Data environments. Signup and view all the answers

According to the text, which of the following is true about the CAP Theorem?

A distributed system must trade-off between consistency, availability, and partition tolerance. Signup and view all the answers

According to the text, which of the following is a property of the CAP Theorem?

All three properties can exist in any shared-data system. Signup and view all the answers

According to the text, which of the following is true about ACID and BASE?

ACID systems prioritize immediate accuracy of all data elements at all times. Signup and view all the answers

According to the text, who coined the term ACID?

Haerder and Rueter Signup and view all the answers