A database monitoring tool shows a sudden, sustained increase in network traffic to the database port, along with a sharp rise in failed connection attempts. Which symptom is most consistent with a denial of service attack?

A flood of incomplete or malformed connection requests

A user receiving an email asking for their password

A single user repeatedly entering incorrect passwords

A database table being dropped unexpectedly

Which measure is most effective in preventing phishing attacks that target database users?

Disabling the database's audit logging

Providing regular security awareness training to users

Increasing the database's connection timeout

Which log pattern is most indicative of a brute-force attack on a database?

An increase in database read operations

A single successful login from a new IP address

A large number of failed authentication attempts from the same IP address

A database table being truncated

A database administrator is concerned about brute-force attacks on the 'sa' account. The administrator wants to implement a control that will prevent automated attacks while minimizing disruption to legitimate users. Which control is MOST appropriate?

Implement a password policy that requires a 20-character password

Account lockout policy that locks the account after 5 failed attempts for 15 minutes

CompTIADataSys+

Domain 4Objective 5

Threat Mitigation DS0-001 Practice Questions (Page 2)

Part of the Data and database security domain, which accounts for 23% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 2–3 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)

32questions here

7free pages

10concepts

23%of the exam

Questions 6–10

6foundation · easy
A database monitoring tool shows a sudden, sustained increase in network traffic to the database port, along with a sharp rise in failed connection attempts. Which symptom is most consistent with a denial of service attack?
Select an answer first
7foundation · easy
Which measure is most effective in preventing phishing attacks that target database users?
Select an answer first
8foundation · easy
A database user receives an email that appears to be from the IT department, asking them to click a link and enter their database password to 'verify their account'. Which type of attack is this?
Select an answer first
9foundation · easy
Which log pattern is most indicative of a brute-force attack on a database?
Select an answer first
10expert · hard
A database administrator is concerned about brute-force attacks on the 'sa' account. The administrator wants to implement a control that will prevent automated attacks while minimizing disruption to legitimate users. Which control is MOST appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.