HNS Exam: Database Functionality and Scalability

1. What are the three main ways to create backup copies of data in a database, according to the document?

A. Full Backup, Partial Backup, Incremental Backup B. Transaction Log, Differential Backup, System Restore C. Full Backup, Transaction Log, Differential Backup D. Full Backup, Archival Backup, Real-time Backup

2. What does data integrity ensure in a DBMS?

A. That the data is kept away from unauthorized users B. That the data is complete and consistent C. That the data is backed up regularly D. That the data can be recovered after a system failure

3. Which function of a DBMS allows users to create, modify, and remove objects like tables and indexes?

A. Data Manipulation Function B. Data Definition Function C. Data Security and Integrity Function D. Data Concurrency Control Function

4. What is the purpose of Data Concurrency Control functions?

A. To ensure data is backed up in case of system failure B. To ensure that two simultaneously running processes are executed without conflict C. To define and manage the database structure D. To convert and integrate data from multiple sources

5. Which of the following is a key component of understanding business requirements for a database, as described in Unit Two?

A. Developing a comprehensive marketing plan B. Defining business goals and engaging with stakeholders C. Creating the final database schema D. Choosing the specific DBMS software to be used

6. In a DBMS, what is the process of reversing the effects of an unsuccessful transaction due to system failure called?

A. Rollback or Undo Recovery B. Commit or Redo Recovery C. Full Backup D. Transaction Log

7. A data dictionary is also known as a(n):

A. Database schema B. Data catalog or metadata repository C. Data integrity constraint D. Indexing table

8. What is a key strategy employed by a DBMS to improve performance by reducing the response time of read-intensive operations?

A. Normalization B. Data Archiving C. Caching D. Data Purging

9. What is the process of freeing up space by deleting obsolete or redundant data called?

A. Data Archiving B. Data Purging C. Data Replication D. Data Integration

10. What is a key aspect of "future proofing" a database design?

A. Keeping the design simple to avoid complexity B. Designing with scalability in mind to accommodate future growth C. Limiting the number of users to maintain performance D. Using only a single, proprietary database system

11. Which function of a DBMS enables the system to present data in a raw format even if it's stored in separate tables (e.g., combining date, month, and year into a single date)?

A. Data Transformation and Presentation B. Data Manipulation C. Data Definition D. Data Retrieval and Reporting

12. According to the document, which of the following is NOT one of the techniques for converting and integrating data from multiple sources?

A. Data Extraction B. Data Mapping C. Data Transformation D. Data Archiving

13. To ensure compliance with regulations like GDPR, what role might be appointed, as mentioned in the document?

A. Data Analyst B. Data Protection Officer (DPO) C. Database Administrator D. IT Manager

14. What two key strategies are mentioned for improving database performance and efficiency under the "Data Performance Optimization Function"?

A. Indexing and Query Optimization B. Data Archiving and Purging C. Data Replication and Synchronization D. Data Transformation and Integration

15. What does the acronym ETL stand for in the context of data migration?

A. Encode, Transfer, Link B. Execute, Test, Load C. Extract, Transform, Load D. Export, Transcribe, Log

16. What is the main purpose of data archiving, as described in the document?

A. To permanently delete irrelevant data B. To convert data formats for migration C. To replicate data across multiple servers D. To save memory by moving old or infrequently accessed data

17. Which type of data replication applies changes to all replica databases synchronously before confirming the transaction's completion?

A. Asynchronous Replication B. Synchronous Replication C. Master-slave Replication D. Peer-to-peer Replication

18. According to the document, which of the following is a real-world application of a DBMS?

A. Social media websites like Facebook and Instagram B. Word processing software C. Graphic design programs D. Spreadsheet applications for personal use

19. Which two components of "key data needs" are crucial for designing scalable and responsive data systems?

A. Data quality and security B. Data types and formats C. Data volume and velocity D. Data governance and compliance

20. What is a foundational step in understanding business requirements, which involves aligning them with the organization's overarching purpose?

A. Alignment with Mission and Vision B. Defining financial goals C. Implementing new technologies D. Launching a new product

21. In database design, what is the purpose of normalizing data?

A. To encrypt sensitive information B. To speed up data retrieval with caching C. To move data from one database to another D. To eliminate redundancy and dependency issues

22. What visual aid is used to create a conceptual data model, as mentioned in the document?

A. Data Flow Diagrams B. Entity-Relationship Diagrams (ERD) C. Performance Metrics Charts D. Organizational Charts

23. Which theory ensures that transactions are executed without concurrency conflicts?

A. ACID (Atomicity, Consistency, Isolation, and Durability) B. ETL (Extract, Transform, Load) C. GDPR (General Data Protection Regulation) D. SQL (Structured Query Language)

24. What process involves defining the stages of data, such as creation, usage, archival, and deletion?

A. Data Security and Privacy B. Data Transformation and Integration C. Data Concurrency Control D. Data Lifecycle Management

25. Which function of a DBMS includes operations for Inserting, Updating, and Deleting data?

A. Data Definition Function B. Data Retrieval and Reporting Function C. Data Manipulation Function D. Data Archiving and Purging Function

HNS Exam: Database Functionality and Scalability

Exam Results