FC0-U71 Practice Test 33 — 15 Questions

Question 1

You are a support technician for a small company. An employee reports that their desktop computer will not turn on. You have verified that the power cable is securely connected to both the computer and the wall outlet. When you press the power button, you hear a faint clicking sound but the computer does not start. The power supply fan does not spin, and there are no lights on the motherboard. You have tested the wall outlet with a known working device and it provides power. What is the most likely cause of the issue?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The power supply is faulty.. The symptoms—faint clicking sound, no fan spin, no motherboard lights, and confirmed wall outlet power—strongly indicate a power supply failure. The clicking sound often comes from a relay or overload protection circuit inside the PSU attempting to start but failing due to internal component damage or short circuit. A faulty power supply cannot deliver the necessary voltages (e.g., +3.3V, +5V, +12V) to power the system, explaining the complete lack of activity.

Answer

The CPU is overheated.

Answer

The power button is not connected properly.

Answer

The motherboard has failed.

Question 2

A small office needs a network that is easy to set up and allows devices to connect without wires. The office has a single internet connection and about 15 devices. Which of the following is the BEST choice?

Accepted Answer

Wireless router with integrated switch. A wireless router with an integrated switch combines a router, a wireless access point, and a multi-port Ethernet switch into a single device. This allows the office to connect all 15 devices wirelessly while sharing the single internet connection, and the integrated switch provides wired ports for devices that may need a stable connection. It is the simplest and most cost-effective solution for a small office requiring easy setup and wireless connectivity.

Answer

Network hub

Answer

PoE switch

Answer

Cable modem

Question 3

A small e-commerce website uses a relational database to manage its products and orders. The most common query is retrieving a product by its unique product ID. This query is executed thousands of times per minute. The database currently has no indexes, and the query is slow, causing user-facing delays. The database administrator wants to improve performance with minimal downtime and cost. Which action should be taken first?

Accepted Answer

Add an index on the product ID column. Adding an index on the product ID column creates a B-tree data structure that allows the database to locate rows using a logarithmic search instead of a full table scan. Since the query is executed thousands of times per minute and the table has no indexes, this single-column index directly addresses the bottleneck with minimal downtime and cost, as it requires only a CREATE INDEX statement.

Answer

Partition the table by product category

Answer

Increase the server's memory to allow more caching

Answer

Change the database to a NoSQL system for faster key-value access

Question 4

Match each troubleshooting step to its order in the CompTIA A+ methodology.

Accepted Answer

Identify the problem: Step 1. The CompTIA A+ troubleshooting methodology has 7 steps: 1. Identify the problem, 2. Establish a theory of probable cause, 3. Test the theory, 4. Establish a plan of action, 5. Implement the solution, 6. Verify full system functionality, 7. Document findings. Common mistakes include swapping the order of the first three steps.

Answer

Identify the problem: Step 3

Answer

Test the theory to determine cause: Step 1

Question 5

You are a desktop support technician for a small accounting firm. The firm uses a legacy accounting application that only runs on Windows 7. The application stores data in a local SQL Server Express database. A user reports that since the IT department applied a mandatory security update last night, the accounting application fails to start and displays an error: 'Cannot connect to database server. Check that the SQL Server (MSSQLSERVER) service is running.' You verify that the SQL Server service is set to Automatic but is not running. When you attempt to start it manually, it fails with error 1069: 'The service did not start due to a logon failure.' Which of the following is the MOST likely cause and solution?

Accepted Answer

The password for the service account has expired or was changed. Update the service logon credentials.. Error 1069 specifically indicates a logon failure for the service account. When a mandatory security update is applied, it may enforce password expiration policies or reset the service account password, causing the SQL Server service to fail to start. Updating the service logon credentials in the Services console resolves the issue.

Answer

The security update changed the service startup type to Disabled. Set it back to Automatic.

Answer

The security update deleted the database file. Reinstall the application.

Answer

The security update corrupted the database files. Restore the database from backup.

Question 6

A programmer needs to store a customer's name in a variable. Which data type is most appropriate?

Accepted Answer

String. A customer's name is a sequence of characters (letters, spaces, possibly punctuation), which is best represented as a String data type. In most programming languages, strings are used to store text and are enclosed in quotes (e.g., "John Doe"). This aligns with the fundamental concept that names are not numeric or logical values.

Answer

Float

Answer

Integer

Answer

Boolean

Question 7

A system administrator configures a server to run multiple virtual machines for testing. Which type of software enables this?

Accepted Answer

Virtualization software. Virtualization software, such as VMware vSphere, Microsoft Hyper-V, or Oracle VirtualBox, creates a hypervisor layer that abstracts physical hardware resources (CPU, memory, storage) and allocates them to multiple isolated virtual machines. This allows a single physical server to run several operating systems concurrently for testing or production workloads, which is exactly what the system administrator needs.

Answer

Backup software

Answer

Remote desktop software

Answer

Antivirus software

Question 8

Which THREE operations can be performed using Data Manipulation Language (DML) statements?

Accepted Answer

UPDATE. UPDATE is a Data Manipulation Language (DML) statement because it modifies existing data within a table without altering the table's structure. DML focuses on managing data stored in database objects, and UPDATE directly changes row values.

Answer

CREATE

Answer

DROP

Question 9

Which software license allows a user to install the software on multiple computers for personal use?

Accepted Answer

Personal license. A personal license grants a single user the right to install the software on multiple devices they own or control, typically for non-commercial use. This is distinct from a per-seat license, which limits installation to one computer per license key. The key differentiator is that the license is tied to the user, not the machine count.

Answer

Trial version

Answer

Enterprise license

Answer

Open source license

Question 10

A database designer is creating a table to store employee information. To ensure that each employee can be uniquely identified, which constraint should be applied?

Accepted Answer

PRIMARY KEY. A PRIMARY KEY constraint uniquely identifies each record in a database table. It enforces both uniqueness and non-nullability, ensuring that no two employees can have the same primary key value and that the value is never NULL. This makes it the correct choice for guaranteeing each employee can be uniquely identified.

Answer

UNIQUE

Answer

FOREIGN KEY

Answer

NOT NULL

Question 11

Consider the following algorithm:
SET x = 5
SET y = 2
SET result = x ^ y
OUTPUT result
Assuming '^' is the exponentiation operator, what is the output?

Accepted Answer

25. The algorithm sets x = 5 and y = 2, then computes result = x ^ y, where '^' is the exponentiation operator. 5 raised to the power of 2 equals 25. Therefore, the output is 25, making option D correct.

Answer

32

Answer

7

Answer

10

Question 12

Refer to the exhibit. A security analyst reviews the NTFS permissions on the C:\Shared folder. Which user or group has the ability to delete files created by other users?

Accepted Answer

Users. The 'Users' group in Windows NTFS has the 'Modify' permission on the C:\Shared folder by default, which includes the 'Delete Subfolders and Files' advanced permission. This allows members of the Users group to delete files created by other users, even if they are not the owner of those files. The 'Delete' permission alone only allows deletion of one's own files, but 'Delete Subfolders and Files' overrides that restriction for the container.

Answer

No user or group

Answer

Admin

Answer

Everyone

Question 13

Which security threat is indicated in the exhibit?

Accepted Answer

Brute force attack. The exhibit shows repeated failed login attempts from a single IP address, which is characteristic of a brute force attack. This attack systematically tries many username/password combinations to gain unauthorized access, often targeting services like SSH, RDP, or web login portals.

Answer

DDoS

Answer

Phishing

Answer

Malware infection

Question 14

Refer to the exhibit. Which type of license does Acme Corp hold?

Accepted Answer

Volume license. The exhibit shows a license key format that includes 'VOL' (volume) and a large number of users (e.g., 1000), which is characteristic of a volume license. Volume licenses are sold in bulk to organizations, allowing deployment on multiple devices under a single agreement, often with a single product key. This contrasts with per-user or concurrent licenses, which track individual or simultaneous usage.

Answer

Site license

Answer

Per-user license

Answer

Concurrent license

Question 15

A company's IT department is developing a new internal tool to track employee leave requests. The development team is using a waterfall model. After the requirements phase, they create a detailed design document. During implementation, a key stakeholder requests a new feature that requires a change to the database schema. The team is reluctant to accommodate the change because they have already started coding. Which approach should the team take to best handle this situation while adhering to the waterfall model?

Accepted Answer

Complete the current phase, then formally review and update the design document before moving to testing.. In waterfall, changes are typically handled at phase boundaries. Completing the current implementation phase, then formally updating the design before testing allows structured change control. Ignoring the request or stopping immediately disrupts the process. Switching to agile mid-project is not practical.

Answer

Switch to an agile methodology to handle the change.

Answer

Immediately stop coding and incorporate the change into the design document.

Answer

Ignore the request because it wasn't in the original requirements.