FC0-U71 Practice Test 2 — 30 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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.

Question 16

A user connects to a website using its domain name. Which server translates that domain name into an IP address?

Accepted Answer

DNS server. DNS (Domain Name System) servers resolve domain names to IP addresses, enabling browsers to locate web servers.

Answer

Proxy server

Answer

Web server

Answer

DHCP server

Question 17

A user is troubleshooting a slow internet connection and has verified that the modem is working. The user suspects that the router is causing the issue. Which TWO of the following functions are typically performed by a home router? (Select TWO.)

Accepted Answer

Assigns IP addresses via DHCP. A home router typically performs NAT (Network Address Translation) to allow multiple devices to share a single public IP, and also provides DHCP to assign IP addresses to devices on the local network.

Answer

Translates domain names to IP addresses

Answer

Amplifies wireless signal

Answer

Converts ISP signal to digital

Question 18

Which THREE of the following are common types of network topologies? (Choose three.)

Accepted Answer

Star. Star, bus, and ring are three of the most common physical network topologies defined in networking standards. In a star topology, all devices connect to a central switch or hub, which manages traffic and isolates failures to individual links. Bus topology uses a single backbone cable with terminators at both ends, while ring topology passes data sequentially from one node to the next using a token-passing mechanism (e.g., Token Ring per IEEE 802.5).

Answer

Circle

Answer

Square

Question 19

A user downloads a free application from the internet that offers full functionality for a 30-day period. After 30 days, the user must pay to continue using it. Which license type does this describe?

Accepted Answer

Trial. Trial software (often called trialware) provides full functionality for a limited time, then requires payment. Shareware may have limited functionality or be fully functional for a trial period. Freeware is free forever, and open source is free and modifiable.

Answer

Open source

Answer

Freeware

Answer

Shareware

Question 20

Which TWO of the following are advantages of server virtualization? (Select TWO.)

Accepted Answer

Easier backup and recovery using snapshots. Server virtualization allows administrators to take snapshots of virtual machines (VMs) at a specific point in time. These snapshots capture the entire VM state, including disk, memory, and power state, enabling quick and consistent backup and recovery without the complexity of traditional physical server backups.

Answer

Increased security by isolating VMs

Answer

Eliminates the need for operating system licenses

Answer

Improved performance over physical servers