FC0-U71 Practice Test 45 — 15 Questions

Question 1

A developer accidentally committed a bug that broke the build. The team wants to undo the commit without losing the commit history. Which Git command should be used?

Accepted Answer

git revert HEAD. `git revert HEAD` creates a new commit that undoes the changes introduced by the most recent commit, preserving the full commit history. This is the only safe way to undo a commit that has already been pushed or shared, as it does not rewrite history.

Answer

git reset HEAD~1

Answer

git checkout HEAD~1

Answer

git branch -d bugfix

Question 2

A security analyst discovers that a file on a server has been modified without authorization. Which element of the CIA triad has been compromised?

Accepted Answer

Integrity. Integrity ensures that data is not altered unexpectedly. Unauthorized modification violates integrity.

Answer

Non-repudiation

Answer

Availability

Answer

Confidentiality

Question 3

A company wants to ensure that its corporate data is secure if a mobile device is lost. The IT department needs to remotely wipe the device and enforce a passcode policy. Which technology should be implemented?

Accepted Answer

MDM. Mobile Device Management (MDM) solutions allow remote wipe and policy enforcement (like passcode requirements) on mobile devices, protecting corporate data.

Answer

Firewall

Answer

Antivirus

Answer

VPN

Question 4

A small office uses a single ISP-provided modem/router combination device. Employees need to connect their desktops and printers to the network. Which of the following devices would allow them to connect multiple wired devices and also extend wireless coverage?

Accepted Answer

Switch. A switch allows multiple wired devices like desktops and printers to connect to the network via Ethernet ports. The existing ISP modem/router combo already provides wireless coverage, so a switch adds wired ports without additional routing functions. While a switch does not extend wireless coverage, the built-in wireless of the ISP device can be used; if further wireless extension is needed, a separate wireless access point would be required. Among the given options, only the switch provides the necessary wired ports for the multiple devices.

Answer

Wireless access point

Answer

Modem

Answer

Hub

Question 5

Which internet connection type provides symmetric upload and download speeds over a fiber-optic cable?

Accepted Answer

Fiber. Fiber-optic internet (often referred to as Fiber-to-the-Home or FTTH) uses light pulses transmitted through glass strands to deliver data. Unlike DSL or cable, fiber connections are inherently symmetric, meaning they provide identical upload and download speeds because the technology does not rely on asymmetric frequency division or shared coaxial infrastructure. This makes fiber the correct answer for symmetric speeds.

Answer

Satellite

Answer

Cable

Answer

DSL

Question 6

Which TWO of the following are appropriate steps when troubleshooting a user's inability to access the internet? (Select TWO.)

Accepted Answer

Check the IP address configuration. Checking the IP address configuration is a fundamental first step in troubleshooting network connectivity. A misconfigured IP address, such as an Automatic Private IP Addressing (APIPA) address in the 169.254.x.x range, indicates that the device failed to obtain a valid IP from a DHCP server, which would prevent internet access. Verifying the IP configuration with commands like `ipconfig` (Windows) or `ifconfig` (Linux/macOS) helps identify if the device has a proper IP, subnet mask, and default gateway.

Answer

Restart the computer

Answer

Replace the network cable

Answer

Power cycle the router

Question 7

Refer to the exhibit. This JSON policy is associated with a user. Which of the following actions is the user permitted to perform?

Accepted Answer

Download files from example-bucket. The JSON policy grants the 'read object' action on the example-bucket storage location, which allows the user to retrieve (download) objects from that bucket. The Effect is set to 'Allow', so the policy explicitly permits this action. No other actions are listed in the Statement, so only downloads are permitted.

Answer

Upload files to example-bucket

Answer

Delete files from example-bucket

Answer

List the contents of example-bucket

Question 8

A developer is testing a piece of code that calculates discounts. The code should give 10% off for orders over $100, and 5% off for orders between $50 and $100. Which test input set would best verify boundary conditions?

Accepted Answer

$49.99, $50.00, $99.99, $100.00, $100.01. It tests the exact boundary values for the discount tiers: $49.99 (just below $50, no discount), $50.00 (5% threshold), $99.99 (still 5%), $100.00 (boundary between 5% and 10%), and $100.01 (10% threshold). This set validates both the lower and upper edges of each range, ensuring the code handles floating-point comparisons correctly.

Answer

$50, $100, $150

Answer

$0, $50, $100, $200

Answer

$50.00, $100.00

Question 9

Which TWO of the following are characteristics of a solid-state drive (SSD) compared to a hard disk drive (HDD)?

Accepted Answer

Silent operation. SSDs have no moving parts; they use NAND flash memory to store data, which eliminates the mechanical noise produced by spinning platters and moving actuator arms in HDDs. This makes SSDs completely silent during operation, a key advantage in noise-sensitive environments like recording studios or quiet office spaces.

Answer

Higher storage capacity

Answer

Lower cost per gigabyte

Answer

Sensitive to magnetic fields

Question 10

Refer to the exhibit. A user runs the query but gets no results, even though there are employees in the Sales department. Which of the following is the most likely cause?

Accepted Answer

The Department values contain trailing spaces.. The query likely uses an exact match (e.g., WHERE Department = 'Sales'), but if the Department column contains trailing spaces (e.g., 'Sales '), the string comparison fails because SQL treats trailing spaces as significant in many databases (or the data was padded with spaces). This is a common data integrity issue where imported or manually entered data includes invisible whitespace, causing legitimate rows to be missed.

Answer

The column name is misspelled.

Answer

The database is offline.

Answer

The table name is incorrect.

Question 11

A user receives an 'Insufficient memory' error when opening a large spreadsheet. Which hardware component is most likely insufficient?

Accepted Answer

RAM. RAM (Random Access Memory) is the primary volatile memory used to hold active data and program instructions for the CPU. When opening a large spreadsheet, the entire file must be loaded into RAM for processing. An 'Insufficient memory' error indicates that the system's RAM is too small to accommodate the spreadsheet's data, causing the operating system to fail the allocation request.

Answer

Hard drive

Answer

CPU

Answer

GPU

Question 12

A user wants to remove a program that is no longer needed from a Windows computer. Which of the following is the correct method?

Accepted Answer

Use the Add or Remove Programs feature from Control Panel.. The correct method to remove a program from a Windows computer is to use the Add or Remove Programs feature (also known as Programs and Features) in Control Panel. This built-in tool runs the program's official uninstaller, which removes all associated files, registry entries, and shortcuts, ensuring a clean removal without leaving orphaned data or breaking system dependencies.

Answer

Drag the program's shortcut to the Recycle Bin.

Answer

Delete the program's folder from Program Files.

Answer

Locate the program in the Start menu and click Uninstall.

Question 13

A report requires data from two tables: Customers and Orders. Which SQL clause is used to combine rows from both tables based on a related column?

Accepted Answer

JOIN. The JOIN clause (specifically an INNER JOIN) is used to combine rows from two or more tables based on a related column between them, such as a foreign key. In this scenario, the Customers and Orders tables would typically be linked by a CustomerID column, and a JOIN allows you to retrieve data like customer names alongside their order details in a single result set.

Answer

UNION

Answer

SUBQUERY

Answer

INTERSECT

Question 14

A user reports that a web application fails to load in a browser. The IT technician suspects a compatibility issue. Which TWO actions should the technician take to diagnose the problem?

Accepted Answer

Check the browser console for error messages.. The browser console displays JavaScript errors, network request failures, and other runtime issues that can prevent a web application from loading. Checking the console is a direct diagnostic step to identify compatibility problems, such as unsupported APIs or deprecated features. Option C is correct because testing the application in a different browser isolates whether the issue is browser-specific, which is a common compatibility troubleshooting technique.

Answer

Reinstall the web browser application.

Answer

Clear the browser cache and cookies.

Answer

Update the operating system to the latest version.

Question 15

Which THREE of the following are best practices for database security?

Accepted Answer

Use strong, complex passwords. Using strong, complex passwords is a fundamental security practice that reduces the risk of brute-force or dictionary attacks against database authentication. Passwords should meet length and complexity requirements (e.g., at least 12 characters with mixed case, numbers, and special characters) and be stored using salted, cryptographically strong hashes like bcrypt or PBKDF2. This prevents unauthorized access even if the password hash is compromised.

Answer

Grant all database privileges to all users

Answer

Disable audit logs to save storage