Lesson 1. Database Concepts

What is a database?

• A collection of related files

• A collection of tables with data

• A collection of folders and documents

• A collection of hardware components

What does DBMS stand for?

• Database Modeling System

• Data Backup and Management System

• Database Management System

• Data Buffering and Monitoring System

A classification of DBMS which involves enterprises, positions, skills, etc.

• System resources

• Business resources

• Data resources

• Organization resources

Which of the following is not part of data to information process?

• Acquisition

• Storage

• Relation

• Retrieval

You are tasked with collecting customer feedback for a new product. Which data acquisition method is most suitable for gathering qualitative data about user experiences?

• Surveys

• Sensor data

• Web scraping

• Social media monitoring

Your organization needs a data storage solution for archiving large volumes of data that are rarely accessed. Which storage type is the most cost-effective and suitable for this purpose?

• Solid State Drives (SSD)

• Hard Disk Drives (HDD)

• Network Attached Storage (NAS)

• Cloud Object Storage

Which of the following is NOT a process in Data Transformation?

• Data distribution

• Data retrieval

• Gather

• Allocate

Scenario: A multinational corporation with offices in multiple countries is considering its database management options. They want a solution that provides centralized control and consistency of data across all offices. Which database architecture is most suitable for this scenario?

• Centralized Database

• Decentralized Database

• Distributed Database

• NoSQL Database

Scenario: A small startup with a remote team spread across different regions needs to ensure that each team member can access and update data independently while minimizing the need for constant synchronization. Which database architecture is most appropriate for this situation?

• Centralized Database

• Decentralized Database

• Distributed Database

• Graph Database

Scenario: A government agency responsible for managing public health records requires a system where different hospitals and clinics maintain their own patient data but also need to securely share information when required. What database architecture should be considered?

• Centralized Database

• Decentralized Database

• Distributed Database

• Relational Database