The advantage of creating indexes is to provide quick and efficient access to data. An index is a data structure that stores the values of one or more columns of a table in a sorted order, along with pointers to the corresponding rows in the table. An index helps to speed up queries that search, filter, sort, or join data based on the indexed columns, as it reduces the number of disk accesses or scans required to locate the desired data. An index also helps to enforce uniqueness or referential integrity constraints on the indexed columns. The other options are either not true or not relevant for this purpose. For example, an index does not help with space allocation, as it consumes additional space in the database; an index does not reduce memory, as it may use memory for caching or buffering purposes; an index does not update the query plan, as it is an input or a factor for the query optimizer to generate the query plan.

The best suited database engine for this task is MongoDB. MongoDB is a type of non-relational database that stores data as documents in JSON-like format. MongoDB allows administrators to perform quick and simple queries on unstructured data, such as text, images, videos, or social media posts, without requiring a predefined schema or complex joins. MongoDB also supports cloud-based deployment, scalability, and high availability. The other options are either relational databases that require a fixed schema and structure for data, or specialized databases that are designed for specific purposes, such as graph databases for storing and analyzing network data. Reference: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.1 Given a scenario, identify and apply database structure types.

The correct answer is D. Password hash salting. According to CompTIA DataSys+ objectives, rainbow table attacks specifically target hashed passwords by using precomputed hash values to quickly reverse weak or unsalted hashes back into their original plaintext passwords. If an attacker successfully used a rainbow table, it strongly indicates that the database stored password hashes without proper salting or used weak hashing algorithms.
Password salting is a defensive technique where a unique random value (the salt) is added to each password before hashing. This ensures that even if two users have the same password, their resulting hashes are different. More importantly, salting renders rainbow tables ineffective because the attacker would need to generate a separate rainbow table for every possible salt value, which is computationally impractical.
DataSys+ highlights salting as a critical immediate control to protect stored credentials once a password compromise is identified.
Option C, strong passwords, is a preventative control but not the best immediate response. Even strong passwords can be compromised if hashes are unsalted and exposed. Option A, security and awareness training, addresses user behavior but does not mitigate the technical weakness exploited in this attack. Option B, implementing security policies and procedures, is important for long-term governance but does not directly stop rainbow table attacks against existing password hashes.
CompTIA DataSys+ emphasizes that when credential storage mechanisms are compromised, administrators must prioritize cryptographic protections at the database level. This includes salting, using strong hashing algorithms, and forcing credential resets. Among the options provided, password hash salting is the most direct and effective response to prevent the same attack vector from succeeding again.
Therefore, the best immediate response is D. Password hash salting, making it the verified and correct answer aligned with CompTIA DataSys+ guidance.

The factor that must be considered to ensure data integrity during transmission is encryption. Encryption is a process that transforms data into an unreadable or scrambled form using an algorithm and a key. Encryption helps protect data integrity during transmission by preventing unauthorized access or modification of data by third parties, such as hackers, eavesdroppers, or interceptors. Encryption also helps verify the identity and authenticity of the source and destination of the data using digital signatures or certificates. The other options are either not related or not sufficient for this purpose. For example, bandwidth is the amount of data that can be transmitted over a network in a given time; redundancy is the duplication of data or components to provide backup or alternative sources in case of failure; masking is a technique that replaces sensitive data with fictitious but realistic data to protect its confidentiality or compliance. References: CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.2 Given a scenario, implement security controls for databases.