FC0-U71 Practice Test 15 — 15 Questions

Question 1

A small business uses a MySQL database to manage inventory and sales. The database has two tables: Products (ProductID, ProductName, QuantityInStock) and Sales (SaleID, ProductID, QuantitySold, SaleDate). The business runs a nightly script that updates QuantityInStock by subtracting QuantitySold from the Products table based on the day's sales. Recently, the inventory levels have become inaccurate. For example, a product shows negative stock even though no sales occurred that day. The database administrator suspects the issue is related to how transactions are handled. The nightly script runs multiple UPDATE statements in a loop. If the script fails partway through, some products' stock is updated while others are not, leaving inconsistent data. The administrator wants to ensure that either all updates succeed or none do, and that the script does not interfere with daytime operations. Which action should the administrator take?

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

Accepted Answer

Wrap all UPDATE statements in a single transaction with READ COMMITTED isolation level and add error handling to roll back on failure. Wrapping all UPDATE statements in a single transaction with READ COMMITTED isolation level ensures atomicity: either all updates commit or none do, preventing partial updates. Adding error handling with a rollback on failure guarantees that if the script fails partway through, the entire transaction is undone, leaving the database consistent. READ COMMITTED isolation prevents dirty reads and minimizes locking, reducing interference with daytime operations.

Answer

Use a stored procedure that updates all products in one statement without error handling

Answer

Increase the frequency of the script to run every hour with smaller batches

Answer

Remove the transaction and use individual UPDATE statements with error logging

Question 2

A small business uses a legacy inventory management application that runs on a Windows 10 workstation. The application stores data in a local Microsoft Access database. Recently, the application has started crashing intermittently when users attempt to generate reports. The error message indicates a 'database connection lost' error. The IT technician has verified that the network is stable and the workstation has sufficient disk space. The technician suspects the issue is related to software compatibility. Which of the following is the BEST course of action to resolve the issue while minimizing disruption to daily operations?

Accepted Answer

Configure the application to run in compatibility mode for Windows 7.. Running the application in compatibility mode for an earlier Windows version often resolves crashes in legacy software that expects older system behaviors. Upgrading to a subscription-based cloud application would be costly and disruptive. Repairing the database might help if the database were corrupt, but the error is about connection loss, not data integrity. Disabling the antivirus is a security risk and unlikely to fix a database connection issue.

Answer

Upgrade the application to a cloud-based subscription version.

Answer

Repair the Microsoft Access database using the built-in repair tool.

Answer

Disable the antivirus software temporarily to test if it is interfering.

Question 3

A company has a server room with two UPS units, each connected to a separate power circuit. The server room contains 10 servers, each with dual power supplies. One UPS fails and stops providing power. The administrator notices that half of the servers shut down, while the other half remain on. The servers that shut down were all connected to the failed UPS. However, the servers that remained on were also connected to the same UPS via their second power supply. Why did those servers not fail?

Accepted Answer

The servers that remained on had both power supplies connected to different UPS units. The servers that remained on had each of their dual power supplies connected to different UPS units (one to the failed UPS and one to the working UPS). When one UPS failed, the working UPS continued to supply power through the second power supply, allowing those servers to stay operational. The servers that shut down were only connected to the failed UPS via both power supplies or had their second power supply connected to the same failed UPS, providing no redundancy.

Answer

The servers that shut down were not connected to the working UPS

Answer

The failed UPS was overloaded and only some servers lost power

Answer

The servers that remained on had only one power supply connected

Question 4

Which cloud service model provides users with access to software applications over the internet without managing the underlying infrastructure?

Accepted Answer

SaaS. SaaS (Software as a Service) delivers applications via the cloud.

Answer

PaaS

Answer

IaaS

Answer

DaaS

Question 5

An attacker gains physical access to a building by following an employee through a secured door without using a badge. This is an example of which social engineering technique?

Accepted Answer

Tailgating. Tailgating (also called piggybacking) is when an unauthorized person follows an authorized person into a restricted area.

Answer

Phishing

Answer

Baiting

Answer

Pretexting

Question 6

Which TWO of the following are effective measures to protect against ransomware attacks? (Select two.)

Accepted Answer

Installing the latest software updates and patches. Regular backups allow restoration without paying ransom; keeping systems patched closes vulnerabilities that ransomware exploits.

Answer

Using the same password for all accounts

Answer

Disabling the firewall

Answer

Opening email attachments from unknown senders

Question 7

An organization adopts the 3-2-1 backup rule. Which of the following practices aligns with this rule?

Accepted Answer

Three copies of data on two different media types, with one offsite. The 3-2-1 rule means having three copies of data on two different media types with one copy offsite. Storing backups on external drives and cloud meets this requirement.

Answer

Four backups all stored on tape

Answer

One backup stored in the same location as the original

Answer

Two copies of data on the same hard drive

Question 8

A security administrator wants to protect data at rest on a laptop that may be lost or stolen. Which of the following is the BEST solution?

Accepted Answer

Enable full disk encryption. Full disk encryption (e.g., BitLocker or FileVault) encrypts the entire drive, making data inaccessible without the decryption key, protecting data at rest.

Answer

Use a VPN when connecting to the internet

Answer

Install a host-based firewall

Answer

Implement strong password policies

Question 9

An employee is tailgated into a secure office building by someone without a badge. Which type of security threat does this represent?

Accepted Answer

Tailgating. Tailgating (or piggybacking) is a physical social engineering attack where an unauthorized person follows an authorized person into a restricted area.

Answer

Phishing

Answer

Baiting

Answer

Pretexting

Question 10

A user reports that a previously working word-processing application now crashes immediately after launch. The user has not installed any new software recently. Which of the following should the user try first?

Accepted Answer

Run a system file checker (SFC) scan.. A system file checker (SFC) scan is the correct first step because it verifies and repairs protected system files, including those that the word-processing application may depend on. Since the application previously worked and no new software was installed, the most likely cause is a corrupted or missing system file, which SFC can detect and restore from the Windows Component Store.

Answer

Disable the antivirus software.

Answer

Run the application as an administrator.

Answer

Reinstall the operating system.

Question 11

Which of the following is an example of an input device?

Accepted Answer

Keyboard. A keyboard is an input device because it allows users to send data and commands to a computer by pressing keys, which are converted into electrical signals that the system processes. Input devices are defined as hardware components that provide data and control signals to a computer, and the keyboard is a classic example of this category.

Answer

Printer

Answer

Monitor

Answer

Speaker

Question 12

Which TWO data types are considered unstructured? (Select exactly two.)

Accepted Answer

Email messages. Email messages are considered unstructured data because they contain free-form text, attachments, and metadata that do not conform to a predefined data model or schema. Unlike structured data stored in rows and columns, email content lacks a fixed format, making it difficult to query directly using traditional database tools.

Answer

Spreadsheet cells

Answer

Database records

Answer

Relational data

Question 13

Refer to the exhibit. A technician runs two ping commands. Based on the output, which of the following is the MOST likely cause?

Accepted Answer

The network connection is down. The ping to the loopback address (127.0.0.1) succeeds, confirming that the TCP/IP stack is functioning correctly on the local host. However, the ping to the remote host (e.g., 8.8.8.8) fails, indicating that the issue lies beyond the local machine. Since the loopback test passes, the most likely cause is that the network connection (e.g., cable, NIC, switch port) is down, preventing any Layer 2 or Layer 3 communication with the external network.

Answer

The default gateway is unreachable

Answer

DNS server is misconfigured

Answer

A firewall is blocking ICMP traffic

Question 14

A small business wants to set up a wireless network. Which of the following is the BEST security method to use?

Accepted Answer

WPA2. WPA2 (Wi-Fi Protected Access 2) is the best security method among the options because it uses AES (Advanced Encryption Standard) with CCMP (Counter Mode CBC-MAC Protocol), providing strong encryption and integrity protection. WEP is outdated and easily cracked, while MAC filtering and disabling SSID broadcast are not encryption methods and offer minimal security against determined attackers.

Answer

WEP

Answer

MAC address filtering

Answer

Disable SSID broadcast

Question 15

Drag and drop the steps to connect a laptop to a Wi-Fi network in Windows 10 into the correct order.

Accepted Answer

Click the network icon, then select the desired Wi-Fi network, then click Connect, then enter the password.. Connecting to Wi-Fi involves selecting the network, entering the password, and optionally saving it.

Answer

Select the desired Wi-Fi network, then click the network icon, then click Connect, then enter the password.

Answer

Click Connect, then select the desired Wi-Fi network, then click the network icon, then enter the password.

Answer

Enter the password, then click the network icon, then select the desired Wi-Fi network, then click Connect.