A support technician needs to view a list of all customer names and their associated account numbers from a database table named Customers. Which SQL statement correctly retrieves only those two columns from the table?

RETRIEVE CustomerName, AccountNumber FROM Customers;

SELECT Customers FROM CustomerName, AccountNumber;

SELECT CustomerName, AccountNumber FROM Customers;

A company's database contains personally identifiable information (PII). To comply with data protection regulations, they must ensure that only authorized personnel can view the data and that any access is logged. Which combination of measures should be implemented?

Use a firewall to block all external access to the database.

Implement strong authentication, role-based access control, and enable audit logging.

Encrypt the database and store the encryption key on the same server.

Perform regular database backups and store them offsite.

Which of the following is a common method used to protect database data?

Increasing the database cache size

User authentication and access control

What is the purpose of a database backup?

To improve the performance of database queries

To compress the database to save storage space

To encrypt the data in the database

To create a copy of the data that can be used to restore the database in case of loss or corruption

CompTIATech+

Domain 5Objective 3

Database Use FC0-U71 Practice Questions (Page 2)

Part of the Data and database fundamentals domain, which accounts for 13% of the FC0-U71 exam. CompTIA does not publish an official question count, but from its 60-minute exam (~25–40 total, ~3–5 in this domain), expect 1–1 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

10concepts

13%of the exam

Questions 6–10

6foundation · medium
A support technician needs to view a list of all customer names and their associated account numbers from a database table named Customers. Which SQL statement correctly retrieves only those two columns from the table?
Select an answer first
7expert · hard
A company's database contains personally identifiable information (PII). To comply with data protection regulations, they must ensure that only authorized personnel can view the data and that any access is logged. Which combination of measures should be implemented?
Select an answer first
8foundation · easy
Which of the following is a common method used to protect database data?
Select an answer first
9foundation · easy
Which SQL statement is used to remove records from a table?
Select an answer first
10foundation · easy
What is the purpose of a database backup?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to FC0-U71

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. “FC0-U71” is a trademark of its owner, used for identification only.