DSST DSST Management Information Systems Flashcards

Requirements Analysis – the phase where stakeholders’ needs are captured, documented, and validated.

Recognizing the correct phase is critical for correctly mapping project activities to SDLC stages in exam questions.

Waterfall is linear and sequential; Agile is iterative, incremental, and embraces change through frequent feedback.

Exam questions often ask you to contrast models; knowing key differences saves time in multiple‑choice items.

Agile is preferable because it supports incremental delivery, continuous feedback, and rapid adaptation to evolving needs.

Understanding when to pick Agile helps answer scenario‑based questions about project fit.

It validates the system against requirements, identifies defects, and ensures they are resolved before release.

Accurate role knowledge prevents misidentifying phases in diagram or multiple‑choice questions.

Normalization is the process of organizing data to minimize data redundancy and dependency.

Normalization is crucial for efficient database design, and understanding its concept is essential for the exam. It helps to eliminate data anomalies and improve data integrity.

Data inconsistencies and anomalies increase.

This question assesses the ability to apply the concept of data redundancy to a scenario, which is vital for understanding database design principles. High data redundancy can lead to data inconsistencies and anomalies.

False. Denormalization can improve performance in certain cases.

This question addresses a common misconception about denormalization. Denormalization can be beneficial in specific situations, such as improving query performance, despite its potential drawbacks.

A Relational Database supports transactional operations, while a Data Warehouse supports analytical operations.

Understanding the distinction between Relational Databases and Data Warehouses is critical for the exam. This question evaluates the ability to identify the primary difference between these two concepts.

To retrieve specific data from a database.

This question tests the understanding of a fundamental SQL concept, which is essential for working with databases. The SELECT statement is used to retrieve specific data from a database, making it a crucial aspect of database management.

The query retrieves specific data that meets the condition.

Understanding SQL basics, such as the SELECT statement and WHERE clause, is vital for working with databases. This concept is frequently tested on the exam.

False. A Data Warehouse is a central repository for data from various sources.

This misconception can lead to confusion about data storage and analysis. The exam requires distinguishing between different types of databases and data management systems.

Uniquely identifies each record in a table.

The PRIMARY KEY concept is often misunderstood, but it's essential for maintaining data integrity and supporting relationships between tables. The exam requires recalling this fundamental concept.