FC0-U71 Practice Exam 2 — 20 Questions

Question 1

An employee is working from a coffee shop and needs to access company files. Which of the following is the most secure method?

Accepted Answer

Use a VPN to encrypt all traffic between the laptop and the company. A VPN encrypts traffic between the device and the company network, protecting data on public Wi-Fi. HTTPS alone protects only web traffic, and disabling sharing is not sufficient.

Answer

Connect directly to the company's network over the public Wi-Fi

Answer

Disable file sharing on the laptop

Answer

Use HTTPS websites only

Question 2

A company is choosing between HDD and SSD storage for new laptops. Which THREE of the following are advantages of SSDs over traditional HDDs? (Select THREE.)

Accepted Answer

Lower power consumption. SSDs are faster, more durable (no moving parts), and consume less power.

Answer

Louder operation

Answer

Higher capacity per dollar

Question 3

A programmer declares a variable 'price' and assigns it the value 19.99. In most programming languages, what is the data type of this variable?

Accepted Answer

Float. 19.99 is a number with a decimal point, so it is a floating-point number (float). Integer is a whole number, string is text, and boolean is true/false.

Answer

Boolean

Answer

String

Answer

Integer

Question 4

A company needs to manage and secure a fleet of employee smartphones used for work. Which technology should they implement?

Accepted Answer

MDM. Mobile Device Management (MDM) allows organizations to enforce policies, manage apps, and secure data on mobile devices.

Answer

DNS

Answer

NAC

Answer

VPN

Question 5

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, new work is added to the product backlog and prioritized by the product owner for a future sprint; the current sprint scope is not changed.

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 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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