FC0-U71 Practice Exam 52 — 20 Questions

Question 1

A network administrator is setting up a small office network for a new startup. The office has five computers, two printers, and one server. The administrator wants to ensure that all devices can communicate with each other and access the internet. The administrator has decided to use a switch and a router. Which of the following configurations is the MOST appropriate?

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

Accepted Answer

Connect all devices to the switch, then connect the switch to the router. A switch creates a local area network (LAN) by forwarding frames based on MAC addresses, allowing all five computers, two printers, and one server to communicate directly. The router provides network address translation (NAT) and a default gateway for internet access, so connecting the switch to the router enables all devices on the switch to reach the internet. This is the standard small office topology because the switch handles internal traffic efficiently at Layer 2, while the router handles Layer 3 routing and internet connectivity.

Answer

Connect the server and printers to the switch, computers to the router

Answer

Use a hub instead of a switch

Answer

Connect all devices directly to the router

Question 2

A user is selecting a storage device for a new computer and wants fast boot times and durability. Which TWO storage technologies should the user consider? (Select TWO.)

Accepted Answer

NVMe SSD. NVMe SSDs and SATA SSDs both use flash memory, delivering fast boot times and no moving parts for durability. NVMe drives connect via PCIe and offer significantly higher throughput and lower latency than SATA SSDs, while standard SSDs remain a cost-effective, durable option. Together they satisfy the 'fast boot times and durability' requirement.

Answer

Optical drive

Answer

HDD (Hard Disk Drive)

Answer

Magnetic tape

Question 3

A help desk technician needs to retrieve the names and email addresses of all customers who live in 'Chicago'. Which SQL statement should the technician use?

Accepted Answer

SELECT name, email FROM customers WHERE city = 'Chicago'. The SELECT statement is used to query data from a database. Option B correctly uses SELECT to retrieve the 'name' and 'email' columns from the 'customers' table, filtered by the WHERE clause to only include rows where the 'city' column equals 'Chicago'. This matches the technician's requirement to retrieve specific data without modifying or deleting it.

Answer

UPDATE customers SET city = 'Chicago'

Answer

DELETE FROM customers WHERE city = 'Chicago'

Answer

INSERT INTO customers (name, email) VALUES (...)

Question 4

A user wants to edit a document collaboratively with multiple team members in real-time. Which type of application should they use?

Accepted Answer

Cloud-based office suite. A cloud-based office suite (e.g., Google Workspace, Microsoft 365) stores documents on remote servers and uses synchronization protocols (like WebDAV or proprietary APIs) to allow multiple users to edit the same file simultaneously, with changes reflected in real-time via operational transformation or conflict-free replicated data types (CRDTs). This enables collaborative editing without file locking or version conflicts.

Answer

Email client

Answer

Desktop word processor

Answer

Standalone spreadsheet

Question 5

A user needs to edit a video file for a presentation. Which type of application is most suitable?

Accepted Answer

Video editing software. Video editing software is specifically designed to manipulate video files, offering features like trimming, transitions, effects, and timeline-based editing. For editing a video file for a presentation, this type of application provides the necessary tools to adjust the video content, add text overlays, and synchronize audio, making it the most suitable choice.

Answer

Spreadsheet software

Answer

Database software

Answer

Audio editing software

Question 6

A company's IT policy requires that all corporate smartphones be remotely wiped if lost. Which technology enables this capability?

Accepted Answer

MDM. Mobile Device Management (MDM) is a class of software that enables centralized administration of mobile devices, including the ability to remotely wipe corporate data or the entire device if it is lost or stolen. MDM solutions enforce policies, distribute configurations, and perform remote actions such as lock, wipe, and password reset. This directly satisfies the requirement to remotely wipe corporate smartphones.

Answer

Bluetooth

Answer

NFC

Answer

GPS

Question 7

During a Scrum sprint review, stakeholders request a new feature that was not in the product backlog. The product owner wants to add it to the next sprint. What is the correct action according to Scrum?

Accepted Answer

Add the feature to the product backlog for future prioritization. In Scrum, the product backlog is the single source of requirements and is owned by the Product Owner. Any new feature request, regardless of when it arises, must first be added to the product backlog. The Product Owner then prioritizes it against other items, and it can be considered for a future sprint during Sprint Planning. This maintains the integrity of the current sprint and ensures transparency and empirical process control.

Answer

Ask the development team to work overtime to include it

Answer

Reject the request because the sprint is complete

Answer

Add the feature to the current sprint immediately

Question 8

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 9

A developer needs to repeat a set of instructions exactly 10 times. Which programming construct should be used?

Accepted Answer

For loop. A for loop is the correct construct because it is specifically designed to execute a block of code a predetermined number of times, such as exactly 10 iterations. The loop's initialization, condition, and increment/decrement components allow precise control over the repetition count, making it ideal for this requirement.

Answer

Variable

Answer

Function

Answer

If-else statement

Question 10

A database analyst is designing a schema for a library system. Each book can have multiple authors, and each author can write multiple books. Which relationship type should be used?

Accepted Answer

Many-to-many. The correct relationship is many-to-many because a book can have multiple authors and an author can write multiple books. In database schema design, this requires a junction table (also known as a linking or associative table) to resolve the many-to-many relationship into two one-to-many relationships, ensuring referential integrity and avoiding data redundancy.

Answer

Many-to-one

Answer

One-to-many

Answer

One-to-one

Question 11

A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?

Accepted Answer

It returns all columns for employees in Sales. The SELECT * clause retrieves all columns from the specified table, and the WHERE Department = 'Sales' filter restricts the result set to only those rows where the Department column has the value 'Sales'. Therefore, the query returns every column for employees in the Sales department, making option B correct.

Answer

It sorts results by Department

Answer

It returns only the Department column

Answer

It returns all rows from the Employees table

Question 12

A developer runs a SQL query against a database and receives the error shown. Which of the following actions should the developer take first to resolve the issue?

Accepted Answer

Check the table definition to confirm column names.. The error indicates that the column 'user_id' does not exist in the 'users' table. The most logical first step is to check the table definition to confirm the actual column names, as the developer may have misspelled the column name or used the wrong case. This avoids unnecessary destructive actions like dropping the table or making incorrect assumptions about case sensitivity.

Answer

Drop and recreate the 'users' table with the correct column.

Answer

Change 'user_id' to 'UserID' to match case-sensitive settings.

Answer

Add quotes around the table name.

Question 13

A technician runs the ipconfig command and observes the following output:

IPv4 Address. . . . . . . . . . . : 192.168.1.10
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.1.1

Based on the output, which of the following can the technician conclude?

Accepted Answer

The computer can communicate on the local network. The output from commands such as ipconfig or ifconfig typically shows the computer's IP address and subnet mask. A valid IP address on a local subnet (e.g., 192.168.x.x with a 255.255.255.0 mask) indicates the computer can communicate with other devices on the same local network, as no gateway or internet access is required for local communication. The presence of a default gateway does not confirm internet access or DNS reachability without further testing.

Answer

The computer has internet access

Answer

The DNS server is reachable

Answer

The default gateway is not configured

Question 14

An employee allows a delivery person to enter a secure office building by holding the door open. The delivery person does not have an access badge. Which social engineering attack is this?

Accepted Answer

Tailgating. Tailgating (or piggybacking) occurs when an unauthorized person follows an authorized person into a restricted area without proper authentication.

Answer

Phishing

Answer

Baiting

Answer

Pretexting

Question 15

Which of the following is the primary purpose of hashing a password before storing it in a database?

Accepted Answer

To verify the password without storing it in plaintext. Hashing is a one-way function that converts a password into a fixed-length string. It is used to securely store passwords so that even if the database is breached, the actual passwords are not easily recoverable.

Answer

To make the password longer and more secure

Answer

To compress the password to save storage space

Answer

To encrypt the password so it can be decrypted later

Question 16

Which of the following best describes the 'Confidentiality' component of the CIA triad?

Accepted Answer

Data is accessible only to authorized users. Confidentiality ensures that data is not accessed by unauthorized individuals. Integrity protects data from unauthorized modification, and availability ensures data is accessible when needed.

Answer

Systems are operational when needed

Answer

Data is encrypted at rest

Answer

Data is not modified without authorization

Question 17

A user is concerned about connecting to a public Wi-Fi network at a coffee shop. Which security measure can best protect their data?

Accepted Answer

Use a VPN. A VPN encrypts traffic between the user's device and the VPN server, protecting data on public networks.

Answer

Use HTTPS websites only

Answer

Use a firewall

Answer

Disable antivirus

Question 18

Refer to the exhibit. A technician runs ipconfig /all on a user's computer. The user can access the internet but cannot browse to any websites by domain name. What is the most likely cause?

Accepted Answer

The DNS server address is incorrect or not functioning for external lookups.. The user can access the internet (IP connectivity works) but cannot browse by domain name, which indicates that DNS resolution is failing. The `ipconfig /all` output would show a DNS server address; if that address is incorrect or the DNS server cannot perform external lookups, the computer cannot translate domain names to IP addresses, even though other network functions (like DHCP and IP routing) are working correctly.

Answer

DHCP is disabled on the computer.

Answer

The IP address is a private address and cannot access the internet.

Answer

The subnet mask should be 255.255.0.0.

Question 19

Refer to the exhibit. What is the most likely cause of the application crash?

Accepted Answer

A necessary system runtime library (msvcrt.dll) is corrupted or missing.. The error message indicates that the application cannot find the entry point for a function in msvcrt.dll, which is a critical system runtime library for C/C++ applications. This typically occurs when the DLL is corrupted, missing, or of an incorrect version, preventing the application from loading necessary functions. Since the error specifically references msvcrt.dll, the most likely cause is that this runtime library is corrupted or missing.

Answer

The computer does not have enough RAM to run the application.

Answer

The antivirus software is blocking the application from executing.

Answer

The application inventory.exe is incompatible with the operating system.

Question 20

Which TWO of the following are open-source licenses? (Select 2)

Accepted Answer

MIT License. The MIT License (B) is a permissive open-source license that allows users to freely use, modify, and redistribute software with minimal restrictions, requiring only preservation of the copyright notice and license text. The GNU General Public License (D) is a copyleft open-source license that guarantees end users the freedom to run, study, share, and modify the software, requiring derivative works to be distributed under the same terms. Both are recognized by the Open Source Initiative (OSI) as approved open-source licenses. In contrast, a shareware license (A) permits limited trial use with a required payment for continued use and is not open source, a EULA (C) is a proprietary contract restricting usage rights rather than granting open-source freedoms, and a commercial license (E) is a proprietary licensing model sold for profit, not an open-source license.

Answer

Shareware license

Answer

End-User License Agreement (EULA)

Answer

Commercial license