FC0-U71 Practice Test 44 — 15 Questions

Question 1

A database contains two tables: 'Authors' (AuthorID, Name) and 'Books' (BookID, Title, AuthorID). A query needs to return all authors and any books they have written, including authors with no books. Which type of JOIN should be used?

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

Accepted Answer

LEFT JOIN. A LEFT JOIN returns all rows from the left table (Authors) and matching rows from the right table (Books), filling NULLs where no match exists. Since the requirement is to include authors with no books, the Authors table must be the left (preserved) side. This is the textbook use case for LEFT JOIN.

Answer

CROSS JOIN

Answer

RIGHT JOIN

Answer

INNER JOIN

Question 2

A technician is troubleshooting a network where users in one department cannot reach a web server in another subnet. The technician confirms the server is running and the switch ports are up. Which of the following should be checked NEXT?

Accepted Answer

Router configuration. Since the server is running and switch ports are up, the issue is likely at Layer 3 (network layer). The router is responsible for forwarding traffic between subnets, so a misconfigured router (e.g., missing static route, incorrect ACL, or routing protocol issue) would prevent inter-subnet communication. Checking the router configuration is the logical next step to verify that routing is properly set up for the destination subnet.

Answer

DHCP server scope

Answer

Firewall rules on the server

Answer

DNS server settings

Question 3

Which TWO are characteristics of object-oriented programming? (Choose two.)

Accepted Answer

Inheritance. Inheritance (A) is a defining characteristic of object-oriented programming because it lets a class derive from a parent class, reusing and extending its attributes and methods to model an "is-a" relationship. Encapsulation (E) is also core to OOP: it bundles data (fields) and the methods that operate on that data inside a class, and restricts direct external access via access modifiers such as private, protected, and public. By contrast, loops (B) are general control-flow constructs found in procedural and other paradigms, not unique to OOP. Functions (C) are reusable code blocks present in procedural and functional programming as well, and variables (D) are simply named storage locations for data, so neither is a distinguishing OOP characteristic.

Answer

Loops

Answer

Functions

Answer

Variables

Question 4

A user wants to ensure that a document cannot be edited by others. Which file property should be set?

Accepted Answer

Read-only. The read-only property prevents users from modifying or deleting the file's contents, as it restricts write access to the file. When set, any attempt to edit and save the document will result in an error unless the file is saved with a new name or the property is cleared. This is the standard file attribute used in Windows and other operating systems to enforce write protection at the file system level.

Answer

Archive

Answer

Hidden

Answer

System

Question 5

A small business owner wants to protect customer data stored on laptops in case the devices are stolen. Which encryption method provides the best protection for the entire hard drive?

Accepted Answer

Full disk encryption. Full disk encryption (FDE) encrypts the entire storage volume — OS, applications, temp files, and user data — using a key protected by a TPM or pre-boot authentication, so a stolen laptop's drive is unreadable without the credential. Because it covers everything on the disk, it protects customer data regardless of which files or folders it lives in. This is the standard control for lost/stolen device scenarios.

Answer

HTTPS encryption for web traffic

Answer

File-level encryption on individual documents

Answer

A VPN when connecting to the internet

Question 6

A company wants to ensure that sensitive documents are not readable if a laptop is stolen. Which of the following provides the best protection?

Accepted Answer

Full disk encryption. Full disk encryption (FDE) encrypts the entire storage drive, so if a laptop is stolen, the data remains unreadable without the decryption key. It protects data at rest even if the attacker removes the drive or boots from external media. This directly addresses the risk of physical theft.

Answer

Antivirus software

Answer

Firewall

Answer

Strong password on user account

Question 7

A company is designing a disaster recovery plan. They need to restore operations within 4 hours and can tolerate up to 1 hour of data loss. Which combination of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) should they set?

Accepted Answer

RTO = 4 hours, RPO = 1 hour. The Recovery Time Objective (RTO) defines the maximum acceptable downtime to restore operations, which is 4 hours. The Recovery Point Objective (RPO) defines the maximum acceptable data loss measured in time, which is 1 hour. Option A correctly matches these requirements: RTO = 4 hours and RPO = 1 hour.

Answer

RTO = 2 hours, RPO = 1 hour

Answer

RTO = 4 hours, RPO = 4 hours

Answer

RTO = 1 hour, RPO = 4 hours

Question 8

A database designer wants to reduce data redundancy and avoid update anomalies. Which process should be applied?

Accepted Answer

Normalization. Normalization is the process of organizing database tables to minimize redundancy and eliminate update, insert, and delete anomalies by decomposing tables according to normal forms (1NF, 2NF, 3NF, BCNF). It systematically removes partial and transitive dependencies so that each fact is stored in exactly one place. This directly addresses the designer's goal of reducing redundancy and avoiding update anomalies.

Answer

Denormalization

Answer

Encryption

Answer

Indexing

Question 9

A user downloads a free game from an untrusted website. After installation, the user's computer begins displaying pop-up advertisements frequently. Which type of malware is most likely installed?

Accepted Answer

Adware. Adware is malware that automatically displays or downloads unwanted advertisements, often bundled with free software from untrusted sources. The symptom described—frequent pop-up ads after installing a free game—matches adware's defining behavior. Unlike spyware, adware's primary goal is forced advertising rather than covert data collection.

Answer

Ransomware

Answer

Rootkit

Answer

Spyware

Question 10

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 three total copies of data (the original plus two backups), stored on two different media types, with at least one copy kept offsite. Option A matches this definition exactly.

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 11

A user wants to purchase a new monitor for gaming. Which THREE specifications are most important for a smooth gaming experience?

Accepted Answer

Response time (e.g., 1ms, 5ms). Option B, response time (e.g., 1ms, 5ms), is critical because it measures how quickly a pixel can change color, and lower values like 1ms reduce motion blur and ghosting during fast-paced gameplay. Option D, resolution (e.g., 1080p, 4K), matters because it determines the sharpness and detail of the image, directly affecting visual clarity and how many pixels the GPU must drive. Option E, refresh rate (e.g., 60Hz, 144Hz), is essential since a higher refresh rate allows the monitor to display more frames per second, producing smoother motion when paired with sufficient GPU output. Options A and C do not belong: built-in speakers are a convenience audio feature unrelated to visual gaming performance, and USB ports are merely connectivity extras that do not affect smoothness or image quality.

Answer

Built-in speakers

Answer

Number of USB ports

Question 12

Which THREE of the following are characteristics of a strong password? (Select THREE)

Accepted Answer

At least 12 characters in length. Option A is correct because a minimum length of at least 12 characters increases the search space an attacker must cover in a brute-force or dictionary attack, making the password substantially harder to crack. Option B is correct because mixing uppercase letters, lowercase letters, numbers, and symbols expands the character set and defeats simple dictionary and pattern-based guessing techniques. Option D is correct because using a unique password that is not reused on other accounts prevents credential-stuffing attacks, where a breach of one service would otherwise compromise multiple accounts. Option C is incorrect because including a user's birth date creates a predictable, easily guessable value often obtainable from social media or public records. Option E is incorrect because reusing a password across multiple accounts is a dangerous practice that amplifies the impact of any single credential leak.

Answer

Includes the user's birth date

Answer

Is reused across multiple accounts

Question 13

A small business wants to store customer contact information and order history. The data is structured and relationships between customers and orders must be enforced. Which type of database is most appropriate?

Accepted Answer

Relational database. A relational database enforces structured schemas and relationships (via primary and foreign keys), which is exactly what is needed to link customers to their orders and maintain referential integrity. It supports SQL queries and transactions, making it ideal for structured business data with enforced relationships. This matches the requirement for structured data with enforced relationships.

Answer

Flat-file database

Answer

NoSQL database

Answer

Hierarchical database

Question 14

A graphic designer needs to create vector logos that can be scaled without losing quality. Which software category is most appropriate?

Accepted Answer

Vector graphics editor. Vector graphics editors, such as Adobe Illustrator or Inkscape, use mathematical equations (paths) to define shapes, lines, and curves. This allows the image to be scaled to any size without pixelation or loss of quality, which is essential for professional logo design. Raster-based tools cannot achieve this because they rely on a fixed grid of pixels.

Answer

Desktop publishing software

Answer

Raster graphics editor

Answer

Photo editing software

Question 15

A medium-sized business has a policy that requires all employees to use two-factor authentication (2FA) when accessing the corporate email system. The authentication method uses a time-based one-time password (TOTP) app on employees' smartphones. Several employees have reported that they cannot log in because they recently changed phones and did not transfer the TOTP seed. The help desk has been resetting 2FA for these users, but management is concerned about the security of the reset process. Which of the following procedures should the help desk follow to securely reset 2FA for a user?

Accepted Answer

Verify the user's identity through a separate out-of-band channel, then reset.. Verifying the user's identity through a separate out-of-band channel (e.g., a phone call to a known number or a text message to a previously registered device) ensures the requester is legitimate and prevents unauthorized resets. Option A is wrong because disabling 2FA reduces security and violates the company's policy. Option C is wrong because resetting 2FA upon email request alone is insecure—email can be spoofed or compromised. Option D is wrong because while in-person verification with a photo ID is secure, it is not always practical for remote employees; out-of-band verification provides a good balance of security and convenience.

Answer

Disable 2FA for the user and allow password-only access.

Answer

Reset the 2FA immediately upon user request via email.

Answer

Require the user to visit the IT department in person with a photo ID.