FC0-U71 Practice Test 2 — 25 Questions

Question 1

A company wants to secure its wireless network. Which of the following is the BEST practice?

Accepted Answer

Change the default administrator password. Changing the default administrator password is the best practice because default credentials are widely known and easily exploited, providing an attacker with full administrative access to the wireless access point or router. This action directly mitigates unauthorized configuration changes, which is a fundamental security measure. In contrast, the other options either weaken security or have no significant protective effect.

Answer

Broadcast the SSID

Answer

Disable MAC filtering

Answer

Use WEP encryption

Question 2

A company is deploying new laptops for employees. The IT department requires that the laptops have fast storage, support for external 4K monitors, and the ability to connect to a wireless network. Which THREE of the following should be included?

Accepted Answer

Wi-Fi 6 (802.11ax). NVMe SSD provides fast storage; HDMI/DisplayPort supports 4K; Wi-Fi 6 provides modern wireless.

Answer

SATA HDD

Answer

Bluetooth 4.0

Question 3

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

Accepted Answer

ACID compliance. Relational databases offer ACID compliance and a standard query language (SQL), which are key advantages.

Answer

Schema flexibility

Answer

Low latency for large volumes

Answer

Horizontal scalability

Question 4

Refer to the exhibit. A user attempts to insert a row into Orders with a CustomerID that does not exist in the Customers table. What is the expected outcome?

Accepted Answer

The INSERT statement fails with a constraint violation. The INSERT statement fails with a constraint violation because the CustomerID column in the Orders table is defined as a foreign key referencing the CustomerID primary key in the Customers table. When a user attempts to insert a row with a CustomerID that does not exist in the Customers table, the relational database management system (RDBMS) enforces referential integrity and rejects the operation, raising a foreign key constraint violation error.

Answer

The row is inserted but with a warning

Answer

The row is inserted successfully

Answer

The Customers table automatically creates a new customer

Question 5

Which of the following is a benefit of using a database instead of a flat file?

Accepted Answer

Support for concurrent multi-user access. Databases provide concurrent access control, allowing multiple users to read/write data simultaneously without corruption.

Answer

Simpler setup and configuration

Answer

Faster file transfer speeds

Answer

Lower storage requirements

Question 6

In a relational database, a foreign key in the 'Enrollments' table references the primary key of the 'Students' table. What does this relationship primarily enforce?

Accepted Answer

Referential integrity. Foreign keys enforce referential integrity, ensuring that values in the foreign key column match a primary key value in the referenced table.

Answer

Entity integrity

Answer

Normalization

Answer

Domain integrity

Question 7

Which of the following are advantages of using a cloud database service (DBaaS) compared to an on-premises database? (Select TWO.)

Accepted Answer

Managed maintenance and updates. DBaaS provides managed maintenance and automatic scalability without hardware management. High availability is inherent, and initial cost is lower (pay-as-you-go).

Answer

Full control over underlying hardware

Answer

Requires dedicated IT staff for database administration

Answer

Higher initial capital expenditure

Question 8

Which SQL command is used to add a new row to a table?

Accepted Answer

INSERT INTO. INSERT INTO is the SQL command for adding new rows.

Answer

ADD

Answer

CREATE

Answer

UPDATE

Question 9

A database designer is normalizing a table that contains repeating groups (multiple values in one column). Which of the following are goals of normalization? (Select THREE.)

Accepted Answer

Eliminate update anomalies. Normalization aims to reduce redundancy, enforce data integrity, and eliminate update anomalies. It rarely improves query performance (often may reduce it due to more joins).

Answer

Simplify the database schema

Answer

Improve query performance

Question 10

A university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?

Accepted Answer

The primary key of Professors is ProfessorID.. ProfessorID in Courses is a foreign key; many courses can have the same professor (one-to-many); the primary key of Professors is ProfessorID.

Answer

The primary key of Professors is CourseID.

Answer

The relationship between Professors and Courses is many-to-many.

Question 11

A technician needs to set up a small office network with 15 computers. The computers should be able to communicate with each other and share a single internet connection. Which device is required to enable internet sharing?

Accepted Answer

Router. A router is required to enable internet sharing because it performs Network Address Translation (NAT), which allows multiple devices on a local network to share a single public IP address provided by the ISP. The router also routes traffic between the local subnet and the internet, making it the essential device for both inter-device communication and internet access.

Answer

Modem

Answer

Hub

Answer

Switch

Question 12

An employee needs to create a chart showing quarterly sales data for a presentation. Which of the following types of applications should the employee use?

Accepted Answer

Spreadsheet. (Spreadsheet) is correct because spreadsheet applications like Microsoft Excel have built-in charting features to create charts from data. Option A (Presentation) is wrong because presentation software is for displaying slides, not for creating charts from data. Option B (Database) is wrong because databases are for storing and managing data but lack direct charting capabilities. Option C (Word processor) is wrong because word processors are for text documents, not for creating charts.

Answer

Presentation

Answer

Database

Answer

Word processor

Question 13

Which type of malware replicates itself across a network without user interaction?

Accepted Answer

Worm. A worm is a standalone malware program that replicates itself across a network by exploiting vulnerabilities or using network protocols (e.g., SMB, HTTP) without requiring any user action, such as opening a file or executing a payload. Unlike a virus, which attaches to a host file and needs user interaction to spread, a worm self-propagates automatically, making it the correct answer for malware that spreads without user interaction.

Answer

Virus

Answer

Ransomware

Answer

Trojan

Question 14

A user is trying to connect a laptop to a high-definition monitor that supports 4K resolution at 60Hz. Which of the following ports on the laptop will support this video output?

Accepted Answer

HDMI. DisplayPort and HDMI 2.0+ support 4K@60Hz. USB-A and Thunderbolt 3/4 can also carry video, but USB-A alone does not. Among the options, HDMI is the most common and correct.

Answer

Ethernet RJ45

Answer

3.5mm audio jack

Answer

USB-A 3.0

Question 15

A user reports that their laptop cannot connect to the corporate Wi-Fi network. Other users in the same area are connected without issues. The laptop shows it is connected to the Wi-Fi but has no internet access. Which of the following is the MOST likely cause?

Accepted Answer

Incorrect IP configuration. The laptop shows it is connected to Wi-Fi but has no internet access, which indicates that the Layer 3 (network layer) configuration is faulty. An incorrect IP configuration, such as a static IP in the wrong subnet or a failed DHCP lease, prevents the laptop from obtaining a valid default gateway and DNS server, breaking internet connectivity while the Wi-Fi association (Layer 2) remains intact.

Answer

Weak Wi-Fi signal

Answer

SSID broadcast disabled

Answer

MAC address filter enabled

Question 16

Which TWO of the following are examples of volatile memory?

Accepted Answer

RAM. RAM (Random Access Memory) is volatile because it requires constant electrical power to retain data; once the system is powered off, all stored information is lost. This characteristic makes RAM ideal for temporary storage of actively used data and program instructions during operation.

Answer

Hard Drive

Answer

SSD

Answer

ROM

Question 17

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. Databases support concurrent multi-user access with locking mechanisms, while flat files cannot handle simultaneous writes safely.

Answer

Simpler to set up and manage

Answer

Stores data in a non-structured format

Answer

No need for a query language

Question 18

A user reports that their laptop cannot connect to the corporate Wi-Fi. Other devices in the same area work fine. The network technician checks the laptop and sees that the wireless adapter is enabled and shows available networks, but the connection attempt to the corporate SSID fails with an authentication error. Which of the following is the MOST likely cause?

Accepted Answer

The pre-shared key is incorrect. The authentication error specifically indicates that the laptop failed to verify its credentials with the access point. Since the wireless adapter is enabled and the SSID is visible, the most common cause is an incorrect pre-shared key (PSK), which prevents the 4-way handshake in WPA2/WPA3 from completing successfully.

Answer

The MAC address is filtered on the access point

Answer

The DHCP lease has expired

Answer

The wireless adapter is disabled in Device Manager

Question 19

A user reports that the company's customer relationship management (CRM) application is slow after a recent network upgrade. What could be the cause?

Accepted Answer

The network firewall is blocking certain CRM traffic.. A network firewall can introduce latency or block traffic if its rules are misconfigured after an upgrade. If the CRM application relies on specific ports or protocols (e.g., HTTPS on TCP 443, or a proprietary port like TCP 8080), the firewall might be inspecting, throttling, or dropping packets, causing perceived slowness. This is a common post-upgrade issue when ACLs or stateful inspection rules change.

Answer

The application has too many users.

Answer

The user's password has expired.

Answer

The user is entering data too quickly.

Question 20

A small business owner wants to create a simple website to display business hours and contact information. The owner has no programming experience and needs to quickly update the content without learning code. A family member suggests using a content management system (CMS) like WordPress. Another suggests using a plain HTML file and editing it manually. The owner is concerned about both ease of use and security. Which solution best addresses the owner's needs while minimizing technical complexity?

Accepted Answer

Use a CMS because it provides a graphical interface for content updates.. A CMS provides a graphical interface for easy updates without coding, and with proper maintenance it can be secure. Plain HTML requires manual editing each time, which is not user-friendly. A static site generator still requires technical skills. Hiring a developer is expensive and adds complexity.

Answer

Hire a developer to create a custom application.

Answer

Use a plain HTML file because it does not require a database.

Answer

Use a static site generator but requires command line knowledge.