FC0-U71 Practice Questions

Question 1

A user wants to access a website but types the wrong URL. Which technology resolves domain names to IP addresses?

Accepted Answer

DNS. DNS (Domain Name System) is the technology that translates human-readable domain names (like www.example.com) into machine-readable IP addresses (like 192.0.2.1). When a user types a wrong URL, the browser still sends a DNS query to resolve the domain portion of the URL; if the domain is valid but the path is wrong, DNS resolves correctly, but if the domain itself is mistyped, DNS may fail or redirect to a different IP. This resolution is essential for locating the web server on the internet.

Answer

HTTP

Answer

NAT

Answer

DHCP

Question 2

Based on the exhibit, which of the following is the most likely cause of the error?

Accepted Answer

Application crash due to system library issue. The error message indicates a missing system library (DLL) dependency, which prevents the application from launching. This is a classic symptom of an application crash due to a corrupted or missing shared library, not a hardware or network issue.

Answer

Hard drive failure

Answer

Incorrect user permissions

Answer

Network connectivity loss

Question 3

A user runs a query on a database table and notices that the results contain duplicate rows. Which SQL keyword would eliminate these duplicates?

Accepted Answer

DISTINCT. The DISTINCT keyword in SQL is used within a SELECT statement to remove duplicate rows from the result set. When a query returns multiple identical rows, DISTINCT filters them out so that only unique combinations of column values are displayed. This directly addresses the user's requirement to eliminate duplicate rows.

Answer

GROUP BY

Answer

WHERE

Answer

ORDER BY

Question 4

A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?

Accepted Answer

It returns all columns for employees in Sales. The SELECT * clause retrieves all columns from the specified table, and the WHERE Department = 'Sales' filter restricts the result set to only those rows where the Department column has the value 'Sales'. Therefore, the query returns every column for employees in the Sales department, making option B correct.

Answer

It sorts results by Department

Answer

It returns only the Department column

Answer

It returns all rows from the Employees table

Question 5

A data center administrator is considering virtualization to consolidate multiple physical servers. Which of the following is the PRIMARY benefit of using virtual machines in this environment?

Accepted Answer

Better utilization of physical hardware resources. The primary benefit of virtualization in a data center is better utilization of physical hardware resources. By running multiple virtual machines on a single physical host, the hypervisor allows the underlying CPU, memory, and storage to be shared efficiently, reducing idle capacity and maximizing the return on hardware investment.

Answer

Reduction in the total amount of physical hardware needed

Answer

Increased performance for each application

Answer

Improved security by isolating applications

Question 6

A user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)

Accepted Answer

.pkg. On macOS, common installer files are .dmg (disk image) and .pkg (package installer). .msi and .deb are for Windows and Linux respectively. .exe is for Windows.

Answer

.exe

Answer

.msi

Answer

.deb

Question 7

An application is displaying an error message: "Cannot write to file. The file may be read-only or in use by another application." Which of the following is the LEAST likely cause?

Accepted Answer

The file has been deleted.. If the file has been deleted, the error message would typically be 'File not found' or 'The system cannot find the file specified,' not a write failure related to read-only status or another application's lock. The error specifically indicates a write conflict or permission issue, not a missing file. Therefore, a deleted file is the least likely cause among the options.

Answer

The file system is full.

Answer

The file is open in another program.

Answer

The user does not have write permissions.

Question 8

An organization implements a security policy where users must provide a password and a one-time code generated by a mobile app to log in. Which type of authentication is being used?

Accepted Answer

Two-factor authentication. Multi-factor authentication requires two or more factors from different categories: something you know (password), something you have (smartphone app generating a code), and something you are (biometric).

Answer

Biometric authentication

Answer

Token-based authentication

Answer

Single-factor authentication

Question 9

Which TWO of the following are examples of system software?

Accepted Answer

Device driver. Device drivers are system software because they provide a low-level interface between the operating system and hardware components, translating generic OS commands into device-specific instructions. The operating system itself is the core system software that manages hardware resources, runs applications, and provides essential services. Both are fundamental to the computer's operation, not end-user productivity tasks.

Answer

Word processor

Answer

Web browser

Answer

Photo editor

Question 10

A company's customer database contains a table named 'Orders' with columns: OrderID, CustomerID, ProductID, Quantity, OrderDate. The company wants to enforce that every CustomerID in 'Orders' must exist in the 'Customers' table. Which database constraint should be added to the 'Orders' table?

Accepted Answer

Foreign key on CustomerID referencing Customers. A foreign key constraint on the CustomerID column in the Orders table ensures referential integrity by requiring that every value entered in that column must match a CustomerID value in the Customers table. This prevents orphan records and maintains consistency between the two tables, which is the standard relational database approach for enforcing such a relationship.

Answer

Check constraint on CustomerID

Answer

Primary key on CustomerID

Answer

Unique constraint on CustomerID

Question 11

Refer to the exhibit. A technician is troubleshooting a connectivity issue. The user can access local resources but cannot reach the internet. Based on the output, what is the most likely cause?

Accepted Answer

Missing DNS server configuration. The user can access local resources but cannot reach the internet, which indicates that local network communication (e.g., ARP, broadcast) is functioning, but name resolution is failing. The output likely shows that the DNS server configuration is missing or incorrect, preventing the resolution of internet domain names to IP addresses. Without a valid DNS server, the user cannot translate URLs like www.example.com into routable IP addresses, even if the default gateway and IP configuration are correct.

Answer

No default gateway

Answer

IP address conflict

Answer

Incorrect subnet mask

Question 12

Drag and drop the steps to connect a Bluetooth device to a Windows 10 computer into the correct order.

Accepted Answer

Step 1: Turn on Bluetooth on the computer. Step 2: Put the Bluetooth device in pairing mode (make it discoverable). Step 3: Open Settings > Bluetooth & other devices > Add Bluetooth or other device. Step 4: Select the device from the list and confirm pairing.. Pairing a Bluetooth device requires making it discoverable and adding it via Settings.

Answer

Step 1: Put the Bluetooth device in pairing mode. Step 2: Turn on Bluetooth on the computer. Step 3: Open Settings > Bluetooth & other devices > Add Bluetooth or other device. Step 4: Select the device and confirm pairing.

Answer

Step 1: Open Settings > Bluetooth & other devices > Add Bluetooth or other device. Step 2: Turn on Bluetooth on the computer. Step 3: Put the Bluetooth device in pairing mode. Step 4: Select the device and confirm pairing.

Answer

Step 1: Turn on Bluetooth on the computer. Step 2: Open Settings > Bluetooth & other devices > Add Bluetooth or other device. Step 3: Put the Bluetooth device in pairing mode. Step 4: Select the device and confirm pairing.

Question 13

Drag and drop the steps to uninstall a program in Windows 10 into the correct order.

Accepted Answer

1. Open the Settings app.
2. Click on "Apps".
3. Click on "Apps & features".
4. Select the program and click "Uninstall".. The correct sequence to uninstall a program in Windows 10 via Settings is: Open Settings, click Apps, click Apps & features, select the program, and click Uninstall. This ensures you access the proper list of installed programs. Other orders either mis-navigate within Settings or use the older Control Panel method, which is not the expected modern approach.

Answer

1. Open the Settings app.
2. Click on "Apps & features".
3. Click on "Apps".
4. Select the program and click "Uninstall".

Answer

1. Open the Control Panel.
2. Click on "Uninstall a program".
3. Select the program.
4. Click "Uninstall".

Answer

1. Open the Settings app.
2. Click on "Apps".
3. Select the program.
4. Click "Uninstall".

Question 14

A technician is recommending a device to protect a server from data loss during a power outage. Which device should the technician recommend?

Accepted Answer

Uninterruptible Power Supply (UPS). An Uninterruptible Power Supply (UPS) provides battery backup power to the server during a power outage, allowing for a safe shutdown or continued operation until power is restored. This directly prevents data loss by ensuring the server does not abruptly lose power while writing data to disk. Unlike other devices, a UPS combines surge protection with battery backup, making it the correct choice for this scenario.

Answer

Generator

Answer

Power strip

Answer

Surge protector

Question 15

Refer to the exhibit. What is the most likely cause of the application crash?

Accepted Answer

A necessary system runtime library (msvcrt.dll) is corrupted or missing.. The error message indicates that the application cannot find the entry point for a function in msvcrt.dll, which is a critical system runtime library for C/C++ applications. This typically occurs when the DLL is corrupted, missing, or of an incorrect version, preventing the application from loading necessary functions. Since the error specifically references msvcrt.dll, the most likely cause is that this runtime library is corrupted or missing.

Answer

The computer does not have enough RAM to run the application.

Answer

The antivirus software is blocking the application from executing.

Answer

The application inventory.exe is incompatible with the operating system.

CompTIA Tech+ (FC0-U71) FC0-U71 practice test

Three ways to study

Study FC0-U71 by domain

Study FC0-U71 by topic

Tech Concepts and Terminology practice questions

Infrastructure practice questions

Applications and Software practice questions

Software Development Concepts practice questions

Data and Database Fundamentals practice questions

Security practice questions

FC0-U71 fundamentals practice questions

FC0-U71 scenario practice questions

FC0-U71 troubleshooting practice questions

Top FC0-U71 questions

CompTIA Tech+ (FC0-U71) practice questions

How to use these FC0-U71 questions

Quick answer