FC0-U71 Practice Test 4 — 10 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