FC0-U71 Practice Test 13 — 15 Questions

Question 1

Which of the following is a primary advantage of using a database over a flat file system for storing customer records?

Accepted Answer

Supports simultaneous multi-user access. A database management system supports concurrent multi-user access through locking, transactions, and isolation levels, allowing many users to read and write customer records simultaneously without corrupting data. A flat file system offers no such concurrency control, so simultaneous writes can overwrite each other.

Answer

Simpler to set up and manage

Answer

Stores data in a non-structured format

Answer

No need for a query language

Question 2

A user reports that their computer has been displaying unwanted pop-up advertisements frequently. Which type of malware is most likely responsible?

Accepted Answer

Adware. Adware displays unwanted advertisements, often in pop-ups or banners.

Answer

Ransomware

Answer

Spyware

Answer

Rootkit

Question 3

Which component of a computer stores data permanently even when the power is turned off?

Accepted Answer

SSD. An SSD (Solid State Drive) is non-volatile storage, meaning it retains data even when power is removed. It uses NAND flash memory to store data persistently, making it the correct answer for permanent storage. In contrast, CPU cache, GPU memory, and RAM are all volatile and lose their contents when power is cut.

Answer

CPU cache

Answer

GPU

Answer

RAM

Question 4

A network technician observes that a DHCP server is not issuing IP addresses to clients. The DHCP server is running on a Windows Server with a static IP of 192.168.1.10. Clients are on the same subnet. Which of the following should the technician check FIRST?

Accepted Answer

Whether the DHCP Server service is running. The most fundamental check when a DHCP server fails to issue IP addresses is whether the DHCP Server service itself is running. If the service is stopped, the server cannot respond to any DHCP Discover messages, regardless of scope configuration or network topology. Since the clients are on the same subnet, no router forwarding is required, making service status the logical first step.

Answer

Whether the DHCP scope is full

Answer

Whether a router is forwarding DHCP broadcasts

Answer

Whether the clients have a wireless connection

Question 5

A user saves a document as 'report.docx'. Based on the file extension, what type of file is it?

Accepted Answer

Word processing document. The .docx extension is the standard file format for Microsoft Word documents, which are word processing files. It indicates a document created in a word processor, containing formatted text, images, and other elements. Therefore, 'report.docx' is a word processing document.

Answer

PDF file

Answer

Presentation

Answer

Spreadsheet

Question 6

A developer is trying to find why a program is producing incorrect output. The developer runs the program with a debugging tool, sets a breakpoint at a specific line, and examines the values of variables at that point. Which debugging technique is being used?

Accepted Answer

Breakpoint inspection. The developer is using breakpoint inspection, a debugging technique where execution is paused at a specific line of code (the breakpoint) to examine variable values at that exact moment. This allows the developer to inspect the program's state without stepping through each subsequent line, directly identifying why incorrect output occurs.

Answer

Code review

Answer

Step-through execution

Answer

Logging

Question 7

A user wants to permanently delete files from a USB flash drive without any possibility of recovery. Which of the following techniques should be used?

Accepted Answer

Overwrite the drive with random data. Overwriting the drive with random data (a multi-pass overwrite) destroys the original file contents at the physical level, making recovery with forensic tools effectively impossible. This is the standard secure-erase technique for USB flash drives and other storage media. Simple deletion or formatting only removes file system references, leaving data recoverable.

Answer

Quick format

Answer

Change the file extension

Answer

Delete and empty Recycle Bin

Question 8

A developer accidentally committed a bug that broke the build. The team wants to undo the commit without losing the commit history. Which Git command should be used?

Accepted Answer

git revert HEAD. `git revert HEAD` creates a new commit that undoes the changes introduced by the most recent commit, preserving the full commit history. This is the only safe way to undo a commit that has already been pushed or shared, as it does not rewrite history.

Answer

git reset HEAD~1

Answer

git checkout HEAD~1

Answer

git branch -d bugfix

Question 9

Which of the following best describes the function of a hypervisor?

Accepted Answer

It allows multiple operating systems to run on a single physical machine. A hypervisor, also known as a virtual machine monitor (VMM), is software that creates and runs virtual machines by abstracting the underlying physical hardware. It allows multiple guest operating systems to run concurrently on a single physical host, each isolated from the others. This is the core function of virtualization, enabling efficient use of hardware resources and flexibility in IT environments.

Answer

It is a type of operating system designed for servers

Answer

It manages cloud resource allocation across multiple data centers

Answer

It provides antivirus protection for virtual machines

Question 10

A database table contains repeating groups of fields for multiple phone numbers per customer. Which normal form is being violated?

Accepted Answer

First Normal Form. First Normal Form (1NF) requires that each column in a table contains atomic (indivisible) values and that there are no repeating groups of columns. Storing multiple phone numbers per customer in a single row, such as Phone1, Phone2, Phone3, violates 1NF because it creates a repeating group of fields. To comply with 1NF, the phone numbers should be stored in a separate child table with one row per phone number per customer.

Answer

Second Normal Form

Answer

Third Normal Form

Answer

No violation

Question 11

A developer wants to represent the logic of a program before writing code. The diagram should show decisions with diamond shapes and processes with rectangles. Which representation is the developer creating?

Accepted Answer

Flowchart. A flowchart is the only representation that uses standardized geometric symbols to depict program logic visually: diamonds represent decisions (conditional branches), rectangles represent processes or actions, parallelograms represent input/output, and arrows show control flow. The question explicitly describes these shapes, which are the defining visual vocabulary of a flowchart. Algorithms, data structures, and pseudocode do not use diamond/rectangle diagrams.

Answer

Algorithm

Answer

Data structure

Answer

Pseudocode

Question 12

Refer to the exhibit. A user cannot access the internet. What is the most likely issue based on the configuration shown?

Accepted Answer

The default gateway is missing. The exhibit shows an IP address of 192.168.1.10 with a subnet mask of 255.255.255.0, but no default gateway is configured. Without a default gateway, the device can communicate within its local subnet (192.168.1.0/24) but cannot route traffic to any external network, including the internet. The default gateway is the router's IP address that provides the next-hop path for all off-subnet traffic.

Answer

The DNS server is not configured

Answer

The IP address is invalid

Answer

The subnet mask is incorrect

Question 13

A technician needs to convert a decimal IP address octet value of 192 to binary. Which of the following is the correct binary representation?

Accepted Answer

11000000. To convert decimal 192 to binary, decompose it into powers of two: 128 + 64 = 192, so bits 7 and 6 (values 128 and 64) are set to 1 and the remaining six bits are 0. That yields 11000000. This is a standard octet value recognizable as the first octet of a Class C private range (192.168.x.x).

Answer

10101010

Answer

11110000

Answer

10000001

Question 14

Which TWO of the following are advantages of using a virtual private network (VPN) for remote employees?

Accepted Answer

Provides encrypted communication. Option B is correct because a VPN creates an encrypted tunnel (typically using protocols such as IPsec, TLS, or WireGuard) between the remote employee's device and the corporate network, protecting data in transit from eavesdropping on untrusted networks like public Wi-Fi. Option C is correct because a VPN extends the corporate network to the remote user, allowing them to reach internal resources such as file servers, intranet sites, and internal applications as if they were on-site. Option A is incorrect because a VPN secures transmission but does not detect or remove malware, so endpoint antivirus is still required. Option D is incorrect because VPNs are a software/connectivity solution and do not inherently reduce hardware costs. Option E is incorrect because encryption and tunneling overhead typically reduce, not increase, effective bandwidth.

Answer

Eliminates need for antivirus software

Answer

Reduces hardware costs

Answer

Increases network bandwidth

Question 15

A database administrator needs to ensure that only authorized users can access sensitive data. Which of the following concepts describes this requirement?

Accepted Answer

Confidentiality. Confidentiality ensures that sensitive data is accessible only to authorized users, typically enforced through access controls, encryption, and authentication mechanisms. In database administration, this is implemented via permissions, roles, and encryption at rest (e.g., AES-256) to prevent unauthorized disclosure.

Answer

Availability

Answer

Non-repudiation

Answer

Integrity