FC0-U71 Practice Test 37 — 15 Questions

Question 1

A user downloads a software installer from the internet. On Windows, which file extension is most likely to be used for the installer?

Accepted Answer

.exe. .exe and .msi are common Windows installer file extensions.

Answer

.pkg

Answer

.deb

Answer

.dmg

Question 2

A user needs to install a new graphics editing application on a Windows computer. Which file extension is most likely associated with the installer?

Accepted Answer

.exe. Windows executable installers typically use the .exe extension. .msi is also common for Windows Installer packages, but .exe is the most common for applications. .dmg is for macOS, .deb for Debian-based Linux.

Answer

.deb

Answer

.pkg

Answer

.dmg

Question 3

A user downloads a freeware application that displays occasional ads and offers paid upgrade options. This distribution model is best described as:

Accepted Answer

Freemium. Freemium offers basic features free and charges for premium features. Freeware is completely free with no payment required. Shareware is trial-based. Commercial is paid upfront.

Answer

Shareware

Answer

Freeware

Answer

Commercial

Question 4

A system administrator is evaluating antivirus software for company computers. Which TWO features are most important for protecting against malware? (Select TWO.)

Accepted Answer

Real-time scanning. Real-time scanning checks files as they are accessed, preventing malware execution. Automatic updates ensure the antivirus can recognize new threats. Email filtering helps but is not as core. Firewall is network security, VPN is for privacy.

Answer

Virtual private network (VPN) support

Answer

Email spam filtering

Answer

Built-in firewall

Question 5

A user is trying to install software from an .msi file on a Windows computer. What is the most likely purpose of an .msi file?

Accepted Answer

It is a Microsoft Installer package that automates software installation.. An .msi file is a Windows Installer package used for the installation, maintenance, and removal of software. It contains installation instructions and files.

Answer

It is a compressed archive like a .zip file.

Answer

It is a script that downloads software from the internet.

Answer

It is a configuration file for Windows settings.

Question 6

Refer to the exhibit. A database administrator runs the command shown, but user1 still cannot select data from the Customers table. What is the most likely reason?

Accepted Answer

The user does not have permission to access the database.. The GRANT command shown grants SELECT on the Customers table to user1, but if user1 does not have the CONNECT privilege or has not been granted access to the database itself, the SELECT will still fail. In most SQL databases (e.g., MySQL, PostgreSQL, SQL Server), a user must first have the ability to connect to the database (e.g., CONNECT privilege in PostgreSQL or a login in SQL Server) before any object-level permissions take effect. Without that foundational access, the GRANT SELECT is effectively useless.

Answer

The GRANT command requires a COMMIT.

Answer

The user also needs UPDATE privilege.

Answer

The table name is misspelled in the GRANT command.

Question 7

A software engineer is working on a collaborative project and needs to track changes to the source code. Which of the following tools is specifically designed for version control?

Accepted Answer

Git. Git is a version control system that tracks changes to files, allowing collaboration and rollback.

Answer

Compiler

Answer

Debugger

Answer

IDE

Question 8

A user wants to connect a high-resolution 4K monitor to their desktop computer for gaming at 144Hz. Which port should they use to ensure the best performance?

Accepted Answer

DisplayPort. DisplayPort supports high resolutions and refresh rates, including 4K at 144Hz, while HDMI 1.4 is limited to 4K at 30Hz.

Answer

DVI

Answer

VGA

Answer

HDMI 1.4

Question 9

Refer to the exhibit. A database contains tables Customers and Orders. Based on the query, what is the purpose of the INNER JOIN clause?

Accepted Answer

To return only customers who have at least one order in New York. INNER JOIN returns only rows where the CustomerID value matches in both tables. Combined with the WHERE clause filtering orders in New York, the query returns only customers who have placed at least one order in New York. Option B describes a CROSS JOIN. Option C describes a FULL OUTER JOIN. Option D describes a LEFT JOIN.

Answer

To create a Cartesian product of customers and orders

Answer

To combine all rows from both tables regardless of match

Answer

To include all customers even if they have no orders

Question 10

Which TWO of the following are characteristics of the Agile software development methodology?

Accepted Answer

Customer collaboration. Agile emphasizes iterative development and customer collaboration, not upfront planning or heavy documentation.

Answer

Emphasis on detailed upfront planning

Answer

Heavy documentation

Answer

Rigid change control

Question 11

What is the output of the pseudocode in the exhibit?

Accepted Answer

5. The loop increments num from 1 until num is no longer less than 5, so it stops when num is 5, which is printed.

Answer

4

Answer

6

Answer

1

Question 12

A company wants to run multiple operating systems on a single physical server to maximize resource utilization. Which technology should they use?

Accepted Answer

Virtual machines. Virtualization, via a hypervisor, allows multiple VMs (each with its own OS) to run on one physical host.

Answer

Dual booting

Answer

Cloud computing

Answer

Containerization

Question 13

Which device is used to connect multiple devices within the same network segment and forward data based on MAC addresses?

Accepted Answer

Switch. A switch operates at Layer 2 (Data Link Layer) of the OSI model and uses MAC addresses to make forwarding decisions. It maintains a MAC address table (CAM table) to learn which port each device is connected to, allowing it to forward frames only to the intended destination port, reducing collisions and improving network efficiency.

Answer

Hub

Answer

Modem

Answer

Router

Question 14

A company requires all employees to use strong passwords. Which of the following password policies best aligns with security best practices?

Accepted Answer

Passwords must be at least 8 characters and include uppercase, lowercase, numbers, and symbols.. It enforces complexity requirements (uppercase, lowercase, numbers, symbols) and a minimum length of 8 characters, which aligns with NIST SP 800-63B guidelines and modern security best practices. Complex passwords resist brute-force and dictionary attacks by increasing the keyspace exponentially. Simple passwords, even if changed frequently, remain vulnerable to guessing and credential stuffing.

Answer

Passwords must be changed every 30 days but can be simple.

Answer

Passwords must be the same across all corporate accounts for consistency.

Answer

Passwords must be a minimum of 6 characters and contain only letters.

Question 15

Refer to the exhibit. A developer wrote this BASIC program. What will happen if the user presses Enter without typing a name?

Accepted Answer

The program will print "Hello, " with no name.. The program shown in the exhibit likely uses a simple INPUT statement to read a name, followed by a PRINT statement that outputs 'Hello, ' and the entered value. If the user presses Enter without typing anything, the INPUT statement reads an empty string into the name variable. Consequently, the program prints 'Hello, ' with nothing after it. There is no validation to re‑prompt or check for an empty input, so no error occurs and the program does not loop.

Answer

The program will display an error message.

Answer

The program will prompt for input again.

Answer

The program will end with no output.