FC0-U71 Practice Test 12 — 15 Questions

Question 1

Which THREE of the following are common features of word processing applications?

Accepted Answer

Spell check. Spell check is a standard feature in word processing applications like Microsoft Word or Google Docs. It automatically scans text for spelling errors against a built-in dictionary and often provides suggestions for corrections, helping users produce error-free documents.

Answer

Creating slide shows

Answer

Tracking financial transactions

Question 2

A web application constructs SQL queries by concatenating user input directly. What is the primary security risk?

Accepted Answer

SQL injection. When a web application constructs SQL queries by concatenating user input directly, an attacker can inject malicious SQL code into the query. This allows the attacker to manipulate the database, such as by bypassing authentication, retrieving unauthorized data, or executing arbitrary commands. This is the classic definition of SQL injection, which exploits the lack of input sanitization or parameterized queries.

Answer

Denial of service

Answer

Cross-site scripting

Answer

Buffer overflow

Question 3

Drag and drop the steps to check for Windows Updates in Windows 10 into the correct order.

Accepted Answer

Step 1: Open the Start menu. Step 2: Select Settings (gear icon). Step 3: Select Update & Security. Step 4: Select Check for updates.. The correct sequence for checking Windows Updates in Windows 10 is: Open the Start menu, then select Settings (gear icon), then select Update & Security, and finally click Check for updates. This ensures you navigate through the proper system settings to initiate a manual update check, keeping your system secure and up to date.

Answer

Step 1: Open the Start menu. Step 2: Select Check for updates. Step 3: Select Settings (gear icon). Step 4: Select Update & Security.

Answer

Step 1: Select Settings (gear icon). Step 2: Open the Start menu. Step 3: Select Update & Security. Step 4: Select Check for updates.

Answer

Step 1: Open the Start menu. Step 2: Select Update & Security. Step 3: Select Settings (gear icon). Step 4: Select Check for updates.

Question 4

A database designer wants to ensure that no two employees have the same email address. Which constraint should be applied to the Email column?

Accepted Answer

UNIQUE. The UNIQUE constraint ensures that all values in the Email column are distinct, preventing any two employees from having the same email address. Unlike PRIMARY KEY, UNIQUE allows NULL values (though typically email columns are set to NOT NULL), and it can be applied to non-key columns. This directly enforces the business rule of unique email addresses without requiring the column to be the table's primary identifier.

Answer

PRIMARY KEY

Answer

CHECK

Answer

FOREIGN KEY

Question 5

Which TWO of the following are examples of open-source software licenses?

Accepted Answer

GNU GPL. The GNU General Public License (GPL) is a widely used open-source license that grants users the freedom to run, study, share, and modify the software. It requires that any distributed derivative work be licensed under the same GPL terms, ensuring the software remains free and open.

Answer

Apple App Store License

Answer

Microsoft EULA

Answer

Adobe EULA

Question 6

A technician installs a new network printer. It can communicate with other computers on the same network but no one outside the network can access it. What is the MOST likely cause?

Accepted Answer

Firewall blocking external traffic. A firewall is designed to control incoming and outgoing network traffic based on predetermined security rules. If the printer can communicate locally but not with external networks, the most likely cause is that the firewall is blocking inbound traffic from outside the local subnet, preventing external devices from reaching the printer's IP address or port.

Answer

Incorrect printer driver

Answer

No IP address configured

Answer

Faulty Ethernet cable

Question 7

A small office has 15 computers that need to be connected to share files and a printer. Which type of network is most appropriate for this local setup?

Accepted Answer

LAN. A LAN connects devices within a limited area like an office.

Answer

WAN

Answer

PAN

Answer

MAN

Question 8

A company wants to deploy a new wireless network in its office. The network must support high device density and minimize interference from neighboring networks. Which Wi-Fi standard and frequency band combination is most suitable?

Accepted Answer

802.11ax on 5GHz. 802.11ax (Wi-Fi 6) on 5GHz provides faster speeds, better efficiency in dense environments, and less interference than 2.4GHz.

Answer

802.11n on 5GHz

Answer

802.11ax on 2.4GHz

Answer

802.11ac on 2.4GHz

Question 9

Which principle ensures that data is not modified by unauthorized users?

Accepted Answer

Integrity. Integrity ensures that data has not been altered or tampered with by unauthorized users. This is typically enforced through mechanisms like hashing (e.g., SHA-256) or digital signatures, which detect any modification to the original data. Without integrity controls, an attacker could change financial records or system files without detection.

Answer

Authentication

Answer

Confidentiality

Answer

Availability

Question 10

A user wants to connect a laptop to a corporate wireless network. What internal component must be present in the laptop?

Accepted Answer

Wireless NIC. A Wireless NIC (Network Interface Card) is the internal component required for a laptop to connect to a corporate wireless network. It contains a radio transceiver that communicates with wireless access points using IEEE 802.11 standards (e.g., 802.11ax), handling frame encapsulation, authentication, and encryption such as WPA3. Without a wireless NIC, the laptop has no physical layer capability to transmit or receive Wi-Fi signals.

Answer

Cellular modem

Answer

Infrared port

Answer

Bluetooth adapter

Question 11

Which of the following character encodings can represent characters from virtually all written languages?

Accepted Answer

Unicode/UTF-8. Unicode (UTF-8) is variable-width and supports all languages.

Answer

EBCDIC

Answer

Extended ASCII

Answer

ASCII

Question 12

An employee receives an email from 'IT Support' asking for his password due to 'system maintenance'. This is an example of:

Accepted Answer

Phishing. Phishing is a social engineering attack where an attacker masquerades as a trusted entity (here, 'IT Support') to trick the victim into revealing sensitive information, such as a password. The email requesting credentials under the pretext of 'system maintenance' is a classic phishing technique, often executed via email (spear phishing if targeted). This directly matches the definition of phishing as an attempt to acquire sensitive data through deceptive electronic communication.

Answer

Baiting

Answer

Tailgating

Answer

Pretexting

Question 13

A support technician is explaining binary operations to a junior technician. Which TWO of the following are valid binary arithmetic operations? (Select TWO.)

Accepted Answer

AND. AND and XOR are standard binary operations; NOT is unary; OR is included but only TWO must be selected. The correct ones are AND and XOR.

Answer

NOT

Answer

SUBTRACT

Answer

DIVIDE

Question 14

Which of the following file extensions is associated with a compressed archive file?

Accepted Answer

.zip. .zip is a common compressed archive format.

Answer

.exe

Answer

.jpg

Answer

.docx

Question 15

Which of the following best describes the function of an operating system?

Accepted Answer

It manages hardware resources and provides a platform for applications.. The OS manages hardware resources and provides services for application software.

Answer

It converts source code into machine code.

Answer

It performs calculations for scientific simulations.

Answer

It protects the computer from viruses.