(New users at a company are reporting that the system is not accepting new credentials when the users are asked to change the credentials for the first time. Which of the following is the reason the credentials are being rejected?)
Correct Answer: D
The correct answer is D. Password policies. CompTIA DataSys+ emphasizes that password policies are a core component of authentication and security controls within database systems and enterprise environments. When new users are required to change their credentials for the first time, the system typically enforces predefined password rules. If the new credentials do not meet these rules, the system will reject them automatically. Password policies define specific requirements such as minimum password length, complexity (use of uppercase letters, lowercase letters, numbers, and special characters), password history, expiration intervals, and restrictions against using previously compromised or common passwords. In many environments, first- time password changes are subject to the strictest enforcement of these rules to ensure strong baseline security from the start of a user's lifecycle. Option A, identity management, focuses on the creation, provisioning, and lifecycle management of user identities across systems. While identity management systems initiate the credential change process, they do not usually enforce the detailed rules that cause a password to be rejected. Option B, access controls, govern what resources a user can access after authentication, not whether a password itself is valid. Option C, service accounts, are non-interactive accounts used by applications or services and are unrelated to new end-user credential changes. DataSys+ documentation highlights that authentication failures during credential updates are most commonly tied to policy enforcement, not permissions or account type. This includes scenarios where users unknowingly violate complexity rules or reuse default or temporary passwords that are explicitly disallowed. Therefore, the rejection of new credentials during a first-time password change is best explained by password policies, making option D the most accurate and verified answer according to CompTIA DataSys+ principles.
Question 12
(Which of the following best describe a tablespace? Select two.)
Correct Answer: D,F
The correct answers are D. It can contain more than one data file and F. It can be used to organize data in a database. CompTIA DataSys+ describes a tablespace as a logical storage container used by a database to organize how data is physically stored on disk. Tablespaces provide an abstraction layer between the logical database objects and the physical storage files. A tablespace can include multiple data files, which allows database administrators to distribute data across different disks or storage systems. This capability supports scalability, performance optimization, and high availability. By adding or resizing data files within a tablespace, administrators can expand storage capacity without restructuring the database schema. DataSys+ highlights this as a key advantage for capacity planning and storage management. Tablespaces are also used to organize data within a database. Different tablespaces can be created for different purposes, such as separating user data, indexes, temporary data, and system metadata. This organization improves performance tuning, simplifies backup and recovery operations, and enhances manageability. For example, placing indexes in a separate tablespace from table data can reduce I/O contention. Option A is incorrect because a tablespace belongs to a single database and cannot span multiple databases. Option B is misleading; while tablespaces map to data files, blocks are allocated within files, not mixed arbitrarily across files. Option C is incorrect because segments are allocated in extents, and their sizing behavior is controlled by storage parameters, not defined as a primary purpose of tablespaces. Option E is incorrect because tablespaces represent disk-based storage, not memory-resident structures. CompTIA DataSys+ emphasizes understanding logical versus physical storage concepts. Tablespaces play a central role in bridging these concepts by organizing data logically while enabling flexible physical storage management. Therefore, the best descriptions of a tablespace are D and F, making them the correct and verified answers.
Question 13
Several users received a message from the Chief Executive Officer asking them for their bank account details. Which of the following types of attacks is taking place?
Correct Answer: A
Question 14
Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principles addresses this issue?
Correct Answer: D
The principle that addresses this issue is least privilege. Least privilege is a security principle that states that users should only have the minimum level of access or permissions required to perform their tasks or roles. By applying this principle, the administrator can ensure that users cannot change data unless they have been authorized by the management team through a request approval process. This prevents unauthorized or accidental modifications of data that may compromise its integrity or security. The other options are either opposite or unrelated to this principle. For example, open access means that users have unrestricted access to data; least resistance means that users have the easiest or most convenient access to data; elevated privilege means that users have higher or more permissions than they need.
Question 15
An IT department needs to validate who signs in and has permissions to use the company's cloud resources. Which of the following can be used to accomplish this task?
Correct Answer: A
Identity and Access Management (IAM) systems authenticate users and authorize permissions, ensuring that only validated individuals can access cloud resources.
