FC0-U71 Practice Exam 54 — 20 Questions

Question 1

Which TWO of the following are advantages of using a relational database management system (RDBMS) over a file-based system?

Accepted Answer

Enforcement of data integrity. A relational database management system (RDBMS) enforces data integrity through constraints such as primary keys, foreign keys, unique constraints, and check constraints. These rules ensure that data entered into the database adheres to defined business rules and referential integrity, preventing orphaned records and invalid data entries. In contrast, a file-based system relies on application code to enforce such rules, which is error-prone and inconsistent.

Answer

Faster data access for all queries

Answer

No need for a database administrator

Answer

Simpler setup and maintenance

Question 2

Which TWO of the following are benefits of using virtual machines? (Choose two.)

Accepted Answer

They can be easily migrated between host systems. Virtual machines are encapsulated into files (such as .vmdk or .vhdx), which include the entire guest OS, applications, and configuration. This encapsulation allows them to be easily migrated between host systems using technologies like vMotion or live migration, enabling load balancing, hardware maintenance, and disaster recovery without downtime.

Answer

They require less software to operate

Answer

They provide inherent security from all threats

Answer

Virtual machines always run faster than physical machines

Question 3

Refer to the exhibit. A technician is troubleshooting connectivity from a PC connected to the 192.168.1.0/24 network. The PC cannot reach the 10.0.0.0/24 network. What is the most likely cause?

Accepted Answer

GigabitEthernet0/0 is disabled. The PC on 192.168.1.0/24 cannot reach 10.0.0.0/24 because GigabitEthernet0/0 is disabled, which is the interface that provides the default gateway or the path to the router. Without an active interface on the local subnet, the PC cannot send any frames to the router, and no traffic can leave the local network. Even if routes exist, a disabled interface prevents all Layer 1 and Layer 2 communication, making connectivity impossible.

Answer

Incorrect subnet mask on the PC

Answer

Missing route to 10.0.0.0/24

Answer

Faulty cable on GigabitEthernet0/1

Question 4

A user is looking for a cloud-based suite of applications that includes word processing, spreadsheets, and email, and allows real-time collaboration with colleagues. Which of the following best meets these requirements?

Accepted Answer

Google Workspace. Google Workspace (formerly G Suite) is a cloud-based productivity suite that includes Docs, Sheets, Gmail, and real-time collaboration features. Microsoft 365 is also cloud-based but includes locally installed applications; however, the question emphasizes cloud-based and real-time collaboration, both of which Google Workspace is known for. Microsoft 365 also offers these features, but Google Workspace is often more strongly associated with real-time collaboration.

Answer

Slack

Answer

Microsoft 365

Answer

Zoom

Question 5

A user is trying to print but receives the error shown in the exhibit. Which of the following is the MOST likely cause?

Accepted Answer

Printer is powered off or disconnected from the network. The error shown in the exhibit (e.g., 'Printer not responding' or 'Offline') typically indicates the printer is powered off or disconnected from the network. When a printer is unreachable on the TCP/IP network, the print spooler cannot establish a connection to the printer's IP address or hostname, resulting in this error. This is the most common cause before investigating software or consumable issues.

Answer

Corrupt printer driver

Answer

Paper jam in the printer

Answer

Low toner level

Question 6

A technician is troubleshooting a workstation that cannot connect to a server at 192.168.1.100. The workstation's IP configuration shows: IP: 192.168.2.50, Subnet: 255.255.255.0, Gateway: 192.168.2.1. Which of the following is the MOST likely cause of the connectivity issue?

Accepted Answer

Workstation and server are on different subnets with no routing. The workstation's IP address (192.168.2.50) and the server's IP address (192.168.1.100) belong to different subnets (192.168.2.0/24 and 192.168.1.0/24, respectively). Without a router configured to forward traffic between these subnets, the workstation cannot reach the server, even though the default gateway (192.168.2.1) is correct for its own subnet.

Answer

Incorrect default gateway

Answer

Incorrect subnet mask

Answer

Duplicate IP address on the network

Question 7

A company is deploying a custom application to 500 employees. The IT department needs to ensure the software is properly installed and updated on all machines. Which deployment method is most efficient?

Accepted Answer

Network-based automated deployment. Network-based automated deployment, is the most efficient method for deploying a custom application to 500 employees. This method allows IT to centrally distribute the software via tools like Group Policy or SCCM, ensuring consistent installation and easy updates across all machines. Manual installation (B) is time-consuming, email attachment (C) is insecure and unreliable for large numbers, and user download (D) lacks control and scalability. Network-based deployment is the standard for enterprise environments.

Answer

Manual installation via USB

Answer

Email attachment of installer

Answer

Allow users to download from website

Question 8

A database administrator is troubleshooting a slow query on a large table. Which index type would improve performance for an exact match search on a single column?

Accepted Answer

B-tree index. A B-tree index is the correct choice for an exact match search on a single column because it organizes data in a balanced tree structure that allows O(log n) lookups, making it highly efficient for equality searches. In a large table, the B-tree index reduces the number of disk I/O operations by quickly navigating to the leaf node containing the exact key value.

Answer

Clustered index

Answer

Bitmap index

Answer

Hash index

Question 9

A help desk technician receives a call from a user who cannot connect to a network share. The user's computer shows a network icon with a red X. The technician asks the user to check the network cable connection. The user reports that the cable is securely connected. The technician then pings the default gateway from their own computer and the ping is successful. Which of the following is the NEXT step the technician should take?

Accepted Answer

Check the IP configuration on the user's computer. The user's computer shows a network icon with a red X, indicating a physical or data-link layer issue, but the cable is reported as securely connected. The technician successfully pings the default gateway from their own computer, proving the network infrastructure (router, switch, cabling) is functional. The next logical step is to check the IP configuration on the user's computer, as a missing or misconfigured IP address (e.g., APIPA 169.254.x.x due to DHCP failure) could prevent connectivity even with a good cable. This isolates the problem to the user's device rather than the network.

Answer

Replace the network cable

Answer

Restart the network share server

Answer

Disable the firewall on the user's computer

Question 10

Which THREE of the following are best practices for password security?

Accepted Answer

Enabling two-factor authentication where possible. Strong passwords are long, complex, unique, and not shared.

Answer

Sharing passwords with trusted coworkers when necessary

Answer

Reusing the same password across multiple sites

Question 11

Based on the exhibit, what will be the last value output?

Accepted Answer

5. The loop runs while count <= 5. It outputs 1,2,3,4,5. The last output is 5. Then count becomes 6 and loop exits. 1 is first, 6 is not output because loop ends.

Answer

6

Answer

10

Answer

1

Question 12

A user reports that their computer is running slowly. Which of the following is the FIRST troubleshooting step the technician should perform?

Accepted Answer

Restart the computer. The first troubleshooting step for a slow computer is to restart it. Restarting clears temporary memory issues, stops unnecessary processes, and can resolve many software-related slowdowns without further intervention. Option A (Update device drivers) is not typically a first step as drivers usually don't cause gradual slowdowns. Option B (Reinstall the operating system) is a drastic step saved for last. Option D (Run a virus scan) is important but should follow a restart to ensure a clean state. Therefore, restarting is the correct initial step.

Answer

Update device drivers

Answer

Reinstall the operating system

Answer

Run a virus scan

Question 13

A network technician is explaining to a client why a file transfer over the network is slower than expected. Which factor MOST likely affects transfer speed?

Accepted Answer

Bandwidth. Bandwidth is the maximum rate at which data can be transferred over a network path, typically measured in bits per second (bps). A lower bandwidth directly limits the throughput of a file transfer, causing it to take longer regardless of other factors. This is the most fundamental constraint on transfer speed, as it defines the pipe size through which all data must flow.

Answer

File compression

Answer

File format

Answer

Encryption

Question 14

A small business wants to secure its wireless network. Which configuration provides the strongest encryption?

Accepted Answer

WPA3. WPA3 (Wi-Fi Protected Access 3) is the latest wireless security standard, introduced in 2018, which provides the strongest encryption through mandatory use of 192-bit AES encryption in WPA3-Enterprise and 128-bit AES in WPA3-Personal, along with Simultaneous Authentication of Equals (SAE) to replace the vulnerable Pre-Shared Key (PSK) exchange used in WPA2. This makes it resistant to offline dictionary attacks and provides forward secrecy, ensuring that even if a password is compromised, past sessions remain secure.

Answer

WPA

Answer

WEP

Answer

WPA2

Question 15

A company wants to deploy a custom application to 500 employees. The IT team needs to ensure each workstation has the same version and configuration. Which deployment method should be used?

Accepted Answer

Use Group Policy to publish the application to all workstations.. Group Policy (GPO) allows centralized deployment of software via Active Directory, ensuring all workstations receive the same version and configuration automatically during startup or user logon. This method uses the Windows Installer service (MSI) and can assign or publish applications, enforcing consistency without user intervention. It is the only option that guarantees uniform deployment across 500 machines with minimal administrative overhead.

Answer

Place the installer on a network share and instruct users to run it.

Answer

Distribute USB drives with the installer to each employee.

Answer

Email the installer to all employees.

Question 16

Match each storage type to its description.

Accepted Answer

HDD: Uses magnetic platters for long-term storage.. Storage types have different technologies: HDD uses magnetic disks, SSD uses flash memory, RAM is volatile. Common mistakes include swapping magnetic and flash, or confusing volatile vs non-volatile.

Answer

HDD: Uses flash memory for storage.

Answer

SSD: Uses magnetic platters for storage.

Answer

RAM: Provides permanent storage for files.

Question 17

Which programming concept allows a program to make decisions based on conditions, such as checking if a user is logged in?

Accepted Answer

Conditional logic. Conditional logic (e.g., if/else) enables a program to execute different code based on conditions.

Answer

Loops

Answer

Functions

Answer

Variables

Question 18

Which type of software provides an interface for users to interact with the computer's hardware?

Accepted Answer

Operating system. The operating system (OS) is the core software that manages hardware resources and provides a user interface (such as a GUI or CLI) for users to interact with the computer's hardware. It abstracts the underlying hardware details, allowing applications to communicate with devices through standardized system calls and drivers. Without an OS, users would have to write low-level machine code to perform basic tasks like reading from a disk or displaying output.

Answer

Firmware

Answer

Application software

Answer

Utility software

Question 19

A small business needs to allow multiple employees to use the same application on their individual computers while ensuring each user has their own settings. Which type of software license is best?

Accepted Answer

Per-seat license. A per-seat license (Option D) is the best choice because it allows the application to be installed on multiple computers while tracking individual users and their settings. Each user has a unique license, ensuring personal settings are preserved. Open source (Option A) may not provide per-user settings management. Freeware (Option B) is typically free but often lacks multi-user support and per-user configuration. A site license (Option C) covers all users at a site but usually does not track individual settings.

Answer

Open source

Answer

Freeware

Answer

Site license

Question 20

A technician needs to identify a network interface on a device. Which notational system is most commonly associated with MAC addresses?

Accepted Answer

Hexadecimal. MAC addresses are typically written in hexadecimal (base 16) notation, using digits 0-9 and letters A-F.

Answer

Binary

Answer

Octal

Answer

Decimal