CompTIA Tech+ Certification Exam FC0-U71 Exam Questions
A database administrator creates a new database and assigns the primary key. Which of the following database types has the administrator created?
Correct Answer: C
A relational database uses tables consisting of rows and columns where a primary key uniquely identifies each row (record). As stated in the CompTIA ITF+ FC0-U71 Official Study Guide:
" Relational databases store data in tables consisting of rows and columns. Each table has a primary key, which uniquely identifies each record. "
" Document and key/value databases are types of NoSQL databases and do not use primary keys in the same structured tabular format. "
Non-structured databases (like object storage or big data repositories) do not enforce primary keys.
A database administrator creates an outline for a database structure. Which of the following did the administrator create?
Correct Answer: D
According to the CompTIA Tech+ Study Guide (Exam FC0-U71, 3rd Edition, 2025):
“The rules and structure of the database are called its schema. It defines the tables, forms, reports, queries, data types allowed, and pretty much everything else about the database.”
It also clarifies:
“The logical schema outlines the structure of the database, such as the tables and their fields (columns), and relationships between tables.”
Thus, an outline of a database’s structure is called a schema.
Verified Reference:
Chapter 7: Database Fundamentals — “Schema” (pp. 392–393).
A user is configuring a server OS. Which of the following should the user do after setting up the system?
Correct Answer: A
According to the CompTIA Tech+ Study Guide:
“Changing Default Usernames and Passwords — The first thing a potential hacker will try to use is the default username or password for a device. Always change them.”
It also emphasizes:
“Enabling passwords and changing default usernames and passwords are essential password management best practices.”
Therefore, the correct action after server setup is to change the default usernames and passwords to secure the system.
Verified Reference:
Chapter 11: Security Best Practices — “Managing Passwords” (pp. 594–595).
Which of the following describes a use case for a flash drive?
Correct Answer: A
The correct answer is A. A flash drive is a small, portable local storage device, so it is useful when a user needs to copy or back up a local file and carry it to another location, such as home. Option B describes cloud storage. Option C describes network file sharing. Option D describes long-term archiving, which is not the best use case for a flash drive because flash drives are small, easy to misplace, and not ideal as long-term archive media.
Exact Extract/Reference: The CompTIA Tech+ Study Guide defines an external flash drive as “a small, portable SSD that connects through a USB port” and says its “primary benefit is portability.” The guide also lists flash drives as a locally attached backup storage option.
Which of the following best describes the primary connection between a wireless access point and a tablet?
Correct Answer: A
Tablets typically connect to wireless networks using Wi-Fi, which adheres to the IEEE 802.11 standard (often seen as 802.11a/b/g/n/ac/ax). The correct protocol family for this type of connection is 802.11X (referring to Wi-Fi technologies broadly).
“Wireless devices such as tablets use the 802.11 standards to connect to Wi-Fi access points for network connectivity.” — CompTIA ITF+
Other options:
B. Thunderbolt and D. USB-C – Wired connection standards
C. Bluetooth – Short-range peripheral communication, not Wi-Fi
Correct answer: A