FC0-U71 Practice Test 1 — 10 Questions

Question 1

A user wants to access a website but types the wrong URL. Which technology resolves domain names to IP addresses?

Accepted Answer

DNS. DNS (Domain Name System) is the technology that translates human-readable domain names (like www.example.com) into machine-readable IP addresses (like 192.0.2.1). When a user types a wrong URL, the browser still sends a DNS query to resolve the domain portion of the URL; if the domain is valid but the path is wrong, DNS resolves correctly, but if the domain itself is mistyped, DNS may fail or redirect to a different IP. This resolution is essential for locating the web server on the internet.

Answer

HTTP

Answer

NAT

Answer

DHCP

Question 2

Based on the exhibit, which of the following is the most likely cause of the error?

Accepted Answer

Application crash due to system library issue. The error message indicates a missing system library (DLL) dependency, which prevents the application from launching. This is a classic symptom of an application crash due to a corrupted or missing shared library, not a hardware or network issue.

Answer

Hard drive failure

Answer

Incorrect user permissions

Answer

Network connectivity loss

Question 3

A user runs a query on a database table and notices that the results contain duplicate rows. Which SQL keyword would eliminate these duplicates?

Accepted Answer

DISTINCT. The DISTINCT keyword in SQL is used within a SELECT statement to remove duplicate rows from the result set. When a query returns multiple identical rows, DISTINCT filters them out so that only unique combinations of column values are displayed. This directly addresses the user's requirement to eliminate duplicate rows.

Answer

GROUP BY

Answer

WHERE

Answer

ORDER BY

Question 4

A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?

Accepted Answer

It returns all columns for employees in Sales. The SELECT * clause retrieves all columns from the specified table, and the WHERE Department = 'Sales' filter restricts the result set to only those rows where the Department column has the value 'Sales'. Therefore, the query returns every column for employees in the Sales department, making option B correct.

Answer

It sorts results by Department

Answer

It returns only the Department column

Answer

It returns all rows from the Employees table

Question 5

A data center administrator is considering virtualization to consolidate multiple physical servers. Which of the following is the PRIMARY benefit of using virtual machines in this environment?

Accepted Answer

Better utilization of physical hardware resources. The primary benefit of virtualization in a data center is better utilization of physical hardware resources. By running multiple virtual machines on a single physical host, the hypervisor allows the underlying CPU, memory, and storage to be shared efficiently, reducing idle capacity and maximizing the return on hardware investment.

Answer

Reduction in the total amount of physical hardware needed

Answer

Increased performance for each application

Answer

Improved security by isolating applications

Question 6

A user wants to install software on a macOS computer. Which TWO file types are commonly used as installer packages on macOS? (Select TWO.)

Accepted Answer

.pkg. On macOS, common installer files are .dmg (disk image) and .pkg (package installer). .msi and .deb are for Windows and Linux respectively. .exe is for Windows.

Answer

.exe

Answer

.msi

Answer

.deb

Question 7

An application is displaying an error message: "Cannot write to file. The file may be read-only or in use by another application." Which of the following is the LEAST likely cause?

Accepted Answer

The file has been deleted.. If the file has been deleted, the error message would typically be 'File not found' or 'The system cannot find the file specified,' not a write failure related to read-only status or another application's lock. The error specifically indicates a write conflict or permission issue, not a missing file. Therefore, a deleted file is the least likely cause among the options.

Answer

The file system is full.

Answer

The file is open in another program.

Answer

The user does not have write permissions.

Question 8

An organization implements a security policy where users must provide a password and a one-time code generated by a mobile app to log in. Which type of authentication is being used?

Accepted Answer

Two-factor authentication. Multi-factor authentication requires two or more factors from different categories: something you know (password), something you have (smartphone app generating a code), and something you are (biometric).

Answer

Biometric authentication

Answer

Token-based authentication

Answer

Single-factor authentication

Question 9

Which TWO of the following are examples of system software?

Accepted Answer

Device driver. Device drivers are system software because they provide a low-level interface between the operating system and hardware components, translating generic OS commands into device-specific instructions. The operating system itself is the core system software that manages hardware resources, runs applications, and provides essential services. Both are fundamental to the computer's operation, not end-user productivity tasks.

Answer

Word processor

Answer

Web browser

Answer

Photo editor

Question 10

A company's customer database contains a table named 'Orders' with columns: OrderID, CustomerID, ProductID, Quantity, OrderDate. The company wants to enforce that every CustomerID in 'Orders' must exist in the 'Customers' table. Which database constraint should be added to the 'Orders' table?

Accepted Answer

Foreign key on CustomerID referencing Customers. A foreign key constraint on the CustomerID column in the Orders table ensures referential integrity by requiring that every value entered in that column must match a CustomerID value in the Customers table. This prevents orphan records and maintains consistency between the two tables, which is the standard relational database approach for enforcing such a relationship.

Answer

Check constraint on CustomerID

Answer

Primary key on CustomerID

Answer

Unique constraint on CustomerID