FC0-U71 Practice Test 45 — 15 Questions

Question 1

Which of the following Wi-Fi standards operates on the 5 GHz band and provides the fastest theoretical speeds?

Accepted Answer

802.11ax. IEEE 802.11ax (marketed as Wi-Fi 6 and Wi-Fi 6E) is the newest standard listed and delivers the fastest theoretical throughput, up to roughly 9.6 Gbps, while operating on both 2.4 GHz and 5 GHz bands (and 6 GHz for Wi-Fi 6E). It introduces OFDMA, MU-MIMO, and 1024-QAM to boost efficiency and speed in dense environments. This makes it the correct answer for 'fastest theoretical speeds on the 5 GHz band.'

Answer

802.11g

Answer

802.11ac

Answer

802.11n

Question 2

A programmer writes a loop that performs a bitwise AND operation between the byte 0b11001100 and the mask 0b00001111. What is the result in decimal?

Accepted Answer

12. Bitwise AND compares each bit position: 1 AND 1 = 1, otherwise 0. For 0b11001100 AND 0b00001111, only the lower nibble survives: 1100 in binary = 12 in decimal. The upper nibble (1100) is masked out by the zeros in the mask.

Answer

204

Answer

0

Answer

15

Question 3

An organization needs to run multiple operating systems on a single physical server to isolate development environments. Which virtualization technology should they use?

Accepted Answer

Type 1 hypervisor. A Type 1 hypervisor (bare-metal) runs directly on the physical server hardware and is designed for enterprise virtualization, allowing multiple isolated VMs to run concurrently on one host. This matches the requirement to isolate development environments on a single physical server. Type 1 hypervisors like VMware ESXi, Microsoft Hyper-V, and KVM provide strong isolation and efficient resource allocation.

Answer

Containerization

Answer

Dual boot

Answer

Type 2 hypervisor

Question 4

Which component on the motherboard is responsible for temporarily storing frequently accessed data to speed up processing?

Accepted Answer

Cache. Cache is a small, high-speed memory component located on the CPU or motherboard that stores frequently accessed data and instructions. By keeping this data close to the processor, cache reduces the average time to access memory, thereby speeding up processing. Unlike RAM, which is larger but slower, cache operates at speeds close to the CPU, making it essential for performance optimization.

Answer

GPU

Answer

SSD

Answer

RAM

Question 5

Which of the following is the binary result of the AND operation on 1010 and 1110?

Accepted Answer

1010. The AND operation compares each bit of two binary numbers and returns 1 only if both bits are 1. For 1010 and 1110: 1 AND 1 = 1, 0 AND 1 = 0, 1 AND 1 = 1, 0 AND 0 = 0, resulting in 1010. Thus, option B is correct.

Answer

1011

Answer

0010

Answer

1110

Question 6

A database manager is designing a new table to store customer information for a retail company. The table needs to store a unique identifier for each customer, the customer's first and last name, email address, phone number, and date of birth. The manager also wants to ensure that the email address is always provided and that no two customers have the same email. Which of the following SQL constraints should be applied to the email column?

Accepted Answer

UNIQUE and NOT NULL. The email column must be both unique (to prevent duplicate email addresses) and NOT NULL (to ensure an email is always provided). The UNIQUE constraint enforces that no two rows have the same value, and NOT NULL guarantees that the column cannot be left empty. Together, they satisfy the requirement that every customer has a distinct, mandatory email address.

Answer

INDEX

Answer

FOREIGN KEY

Answer

PRIMARY KEY

Question 7

A technician is explaining data storage to a customer. Which of the following best describes the difference between a bit and a byte?

Accepted Answer

A bit is a single binary digit; a byte is 8 bits.. A bit (short for binary digit) is the smallest unit of digital information, representing a single logical state of either 0 or 1. A byte is a standard grouping of 8 bits, which is the fundamental addressable unit of memory in most computer architectures. This 8-bit byte definition is codified in ISO/IEC 2382 and is the basis for storage measurements like kilobytes (1024 bytes) and megabytes.

Answer

A bit is 8 bits; a byte is 16 bits.

Answer

A bit is 4 bits; a byte is 8 bits.

Answer

A bit is 16 bits; a byte is 32 bits.

Question 8

A user is concerned about losing edits to a document if the power fails. Which type of memory is the document most likely stored in while being edited?

Accepted Answer

RAM. While a document is being actively edited, it resides in RAM because RAM is the volatile working memory the CPU reads and writes during application use. If power fails, RAM contents are lost, which is exactly the user's concern. The document is only persisted to the HDD when saved.

Answer

Cache

Answer

HDD

Answer

ROM

Question 9

Which backup strategy involves keeping three copies of data on two different media types with one copy offsite?

Accepted Answer

3-2-1 backup rule. The 3-2-1 backup rule is a widely recommended strategy that specifies: at least 3 copies of data, on 2 different media types, with 1 copy stored offsite. This ensures redundancy and protection against various failure scenarios, including local disasters. The other options are specific backup types, not strategies for copy distribution.

Answer

Full backup

Answer

Differential backup

Answer

Incremental backup

Question 10

Which TWO of the following are advantages of using a relational database over a NoSQL database? (Choose two.)

Accepted Answer

ACID compliance. Relational databases are designed around ACID transactions—atomicity, consistency, isolation, and durability—which guarantee reliable, predictable behavior for multi-row operations, something most NoSQL databases only partially support. Option D (Standard query language (SQL)) is correct because relational databases use SQL, a standardized, widely known language that provides portable, declarative querying and broad tool/ecosystem support across vendors. Option A (Schema flexibility) is not an advantage of relational databases; it is a hallmark of NoSQL systems like document or key-value stores, since relational databases enforce a predefined schema. Option B (Low latency for large volumes) is not a general relational advantage; NoSQL databases are often chosen specifically for high-throughput, low-latency access to massive datasets. Option E (Horizontal scalability) is also typically a NoSQL strength, since relational databases traditionally scale vertically and require sharding or clustering add-ons to scale horizontally.

Answer

Schema flexibility

Answer

Low latency for large volumes

Answer

Horizontal scalability

Question 11

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 12

In a database, which SQL statement is used to add new records to a table?

Accepted Answer

INSERT INTO. The SQL INSERT INTO statement is used to add new records (rows) to a table. It specifies the target table and the values to insert, optionally listing columns. This is the standard DML statement for creating new rows in a relational database.

Answer

DELETE

Answer

UPDATE

Answer

SELECT

Question 13

A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?

Accepted Answer

.exe. The .exe file extension is the standard executable format for Windows applications, including installers. When a user downloads or runs an installer for a graphics editing application on Windows, it is most likely a .exe file that contains the setup program.

Answer

.deb

Answer

.pkg

Answer

.dmg

Question 14

A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described as:

Accepted Answer

Freemium. Freemium is the model where the base product is free but monetized through ads and/or paid premium upgrades. The scenario explicitly mentions both ads and paid upgrade options, which is the textbook definition of freemium. Freeware is free with no monetization path, and shareware is trial-limited software requiring payment to continue using.

Answer

Shareware

Answer

Freeware

Answer

Commercial

Question 15

A user wants to install software on a Windows computer using the application's official installer. Which of the following file extensions is most likely associated with a Windows executable installer?

Accepted Answer

.exe. Exe (executable) is the standard Windows file extension for application installers and executables. Running an .exe file launches the installer or the application on Windows systems.

Answer

.pkg

Answer

.dmg

Answer

.deb