FC0-U61 Hard Questions — 25 Difficult Questions

Question 1

Refer to the exhibit. A technician runs ipconfig /all on a user's computer. The user can access the internet but cannot browse to any websites by domain name. What is the most likely cause?

Accepted Answer

The DNS server address is incorrect or not functioning for external lookups.. The user can access the internet (IP connectivity works) but cannot browse by domain name, which indicates that DNS resolution is failing. The `ipconfig /all` output would show a DNS server address; if that address is incorrect or the DNS server cannot perform external lookups, the computer cannot translate domain names to IP addresses, even though other network functions (like DHCP and IP routing) are working correctly.

Answer

DHCP is disabled on the computer.

Answer

The IP address is a private address and cannot access the internet.

Answer

The subnet mask should be 255.255.0.0.

Question 2

Refer to the exhibit. A database administrator runs the following query:

SELECT c.Name, SUM(o.Quantity) AS TotalItems
FROM Customers c
LEFT JOIN Orders o ON c.ID = o.CustomerID
GROUP BY c.Name;

What is the result for 'Alice'?

Accepted Answer

7. The LEFT JOIN ensures that Alice's record from the Customers table is retained even if there are no matching rows in Orders. The SUM(o.Quantity) aggregates the Quantity values from the joined Orders rows for Alice. Since Alice has two orders with quantities 2 and 5, the sum is 7, making option D correct.

Answer

2

Answer

NULL

Answer

5

Question 3

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 4

Which TWO of the following are common causes of errors when executing a SELECT query? (Choose two.)

Accepted Answer

Incorrect column name. Option B is correct because a SELECT query references specific columns in the WHERE clause or SELECT list; if the column name is misspelled or does not exist in the table schema, the database returns an error (e.g., 'Unknown column' in MySQL or 'Invalid column name' in SQL Server). This is a fundamental syntax error that prevents query execution.

Answer

Table is too large

Answer

Index is missing

Answer

Network is slow

Question 5

A developer runs a SQL query against a database and receives the error shown. Which of the following actions should the developer take first to resolve the issue?

Accepted Answer

Check the table definition to confirm column names.. The error indicates that the column 'user_id' does not exist in the 'users' table. The most logical first step is to check the table definition to confirm the actual column names, as the developer may have misspelled the column name or used the wrong case. This avoids unnecessary destructive actions like dropping the table or making incorrect assumptions about case sensitivity.

Answer

Drop and recreate the 'users' table with the correct column.

Answer

Change 'user_id' to 'UserID' to match case-sensitive settings.

Answer

Add quotes around the table name.

Question 6

Which THREE of the following are characteristics of a relational database? (Choose THREE.)

Accepted Answer

Queries are written using SQL.. Option B is correct because SQL (Structured Query Language) is the standard language used to query and manipulate data in relational databases. It allows users to perform operations such as SELECT, INSERT, UPDATE, and DELETE on structured data stored in tables.

Answer

The database uses a hierarchical model.

Answer

The database is schema-less and flexible.

Answer

Data is stored as JSON documents.

Question 7

A security analyst is reviewing user permissions and discovers that several users have been granted more privileges than necessary to perform their job functions. The analyst wants to apply the principle of least privilege. Which TWO actions should the analyst take? (Choose TWO.)

Accepted Answer

Audit current permissions to identify unnecessary privileges. Auditing current permissions (Option B) is the first step in applying least privilege because it identifies exactly which users have excessive rights. Creating RBAC groups (Option C) then allows the analyst to assign permissions based on job functions, ensuring users only have the access necessary to perform their roles. Together, these actions systematically reduce privilege levels without disrupting operations.

Answer

Grant full administrative access to a single IT administrator

Answer

Allow users to request temporary elevation of privileges for specific tasks

Answer

Remove all permissions from users and add them back only when requested

Question 8

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.. Option B is correct because 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 9

Refer to the exhibit. A security analyst reviews the NTFS permissions on the C:\Shared folder. Which user or group has the ability to delete files created by other users?

Accepted Answer

Users. The 'Users' group in Windows NTFS has the 'Modify' permission on the C:\Shared folder by default, which includes the 'Delete Subfolders and Files' advanced permission. This allows members of the Users group to delete files created by other users, even if they are not the owner of those files. The 'Delete' permission alone only allows deletion of one's own files, but 'Delete Subfolders and Files' overrides that restriction for the container.

Answer

No user or group

Answer

Admin

Answer

Everyone

Question 10

A company is designing a disaster recovery plan. They need to restore operations within 4 hours and can tolerate up to 1 hour of data loss. Which combination of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) should they set?

Accepted Answer

RTO = 4 hours, RPO = 1 hour. The Recovery Time Objective (RTO) defines the maximum acceptable downtime to restore operations, which is 4 hours. The Recovery Point Objective (RPO) defines the maximum acceptable data loss measured in time, which is 1 hour. Option A correctly matches these requirements: RTO = 4 hours and RPO = 1 hour.

Answer

RTO = 2 hours, RPO = 1 hour

Answer

RTO = 4 hours, RPO = 4 hours

Answer

RTO = 1 hour, RPO = 4 hours

Question 11

A user reports being unable to access the internet, but can reach other devices on the local network. Based on the exhibit, what is the most likely cause?

Accepted Answer

The DNS server is not reachable.. Since the user can reach other devices on the local network but cannot access the internet, the issue is likely with the default gateway or DNS resolution. Option D is correct because if the DNS server is unreachable, the user can still communicate with local devices via IP addresses but cannot resolve domain names to access internet resources. The exhibit likely shows a valid IP address and subnet mask, but the DNS server address is missing or incorrect, preventing name resolution.

Answer

The default gateway is missing.

Answer

The IP address is in the wrong subnet.

Answer

The subnet mask is incorrect.

Question 12

Which THREE of the following are characteristics of a relational database?

Accepted Answer

Data is stored in tables with rows and columns. A relational database organizes data into tables, where each table consists of rows (records) and columns (attributes). This tabular structure enforces a fixed schema and allows relationships between tables to be defined and queried efficiently. Option B correctly identifies this fundamental characteristic.

Answer

Schema-less design allows flexible data structures

Answer

Uses a document-based model like JSON

Question 13

A software developer is writing a script that needs to run a set of instructions repeatedly until a condition is met. Which programming construct should be used?

Accepted Answer

While loop. A while loop is the correct construct because it repeatedly executes a block of code as long as a specified condition remains true. This is ideal for scenarios where the number of iterations is not known in advance and depends on a dynamic condition, such as waiting for a file to appear or a network response.

Answer

For loop

Answer

If-else statement

Answer

Function definition

Question 14

A system administrator is reviewing a security policy that specifies that users must be uniquely identified and access must be audited. Which principle of the CIA triad is being addressed?

Accepted Answer

Accountability. The scenario describes a security policy requiring unique identification and auditing of access. These are the core components of accountability, which ensures that actions can be traced back to a specific user. While accountability is not one of the three classic CIA triad principles (Confidentiality, Integrity, Availability), it is often considered an extension or supporting principle that relies on identification, authentication, and audit logs to enforce non-repudiation.

Answer

Availability

Answer

Integrity

Answer

Confidentiality

Question 15

Refer to the exhibit. A technician sees an established connection to an external IP on port 443 from PID 3400. What is the most likely purpose of this connection?

Accepted Answer

Secure web browsing (HTTPS). Port 443 is the default port for HTTPS (HTTP over TLS/SSL), which is used for secure web browsing. PID 3400 indicates a specific process, likely a web browser or an application making an encrypted HTTPS connection to an external IP. This matches the purpose of secure web browsing.

Answer

File sharing over SMB

Answer

Remote Desktop Protocol (RDP) session

Answer

Email submission (SMTP)

Question 16

A company has a server that hosts a critical database. The server uses RAID 5 with three disks. One disk fails. What is the immediate impact on data availability?

Accepted Answer

Data is still available, but performance may degrade. RAID 5 uses block-level striping with distributed parity. With three disks, the array can tolerate a single disk failure without data loss because the parity information on the remaining two disks can reconstruct the missing data on the fly. Therefore, data remains fully available immediately after one disk fails, though read and write performance may degrade due to the overhead of parity calculation and reconstruction.

Answer

Data is available only after replacing the disk

Answer

The server will shut down

Answer

All data on the array is lost

Question 17

A company's server room is experiencing intermittent overheating. The administrator notices that the perforated floor tiles are blocked by equipment. What is the most likely consequence of this obstruction?

Accepted Answer

Reduced cooling efficiency and hot spots. Blocking perforated floor tiles restricts the flow of cold air from the raised-floor plenum into the server room. This reduces the overall cooling efficiency of the HVAC system and creates localized hot spots around the obstructed tiles, which can lead to equipment overheating and failure.

Answer

Increased electrical load on the UPS

Answer

Increased humidity levels

Answer

Reduced battery backup time

Question 18

A technician is setting up a new computer on a network. The computer receives an IP address of 169.254.1.5. Which of the following is the most likely issue?

Accepted Answer

The DHCP server is unavailable. The IP address 169.254.1.5 falls within the Automatic Private IP Addressing (APIPA) range (169.254.0.0/16), which Windows automatically assigns when a DHCP client fails to receive an IP lease from a DHCP server. This indicates that the DHCP server is either unreachable or not responding, making D the correct answer.

Answer

The network cable is faulty

Answer

The DNS server is unreachable

Answer

The gateway is misconfigured

Question 19

A small business has 20 employees using a mix of wired and wireless devices. The network uses a single router with built-in 4-port switch and Wi-Fi. Recently, employees have reported intermittent connectivity drops, especially during peak hours. The technician notices that the router's CPU usage is consistently at 90% or higher. The business cannot afford to replace the router immediately. Which of the following actions would BEST improve the situation without purchasing new hardware?

Accepted Answer

Configure VLANs to separate wired and wireless traffic. Configuring VLANs separates wired and wireless traffic into distinct broadcast domains, reducing the amount of broadcast traffic and collisions that the router's CPU must process. This lowers CPU overhead, which directly addresses the 90% CPU usage causing intermittent drops, without requiring new hardware.

Answer

Disable Quality of Service (QoS) settings

Answer

Disable the Wi-Fi network and require all devices to connect via Ethernet

Answer

Assign static IP addresses to all devices

Question 20

A company wants to deploy a custom application to 500 employees. The IT team needs to ensure each workstation has the same version and configuration. Which deployment method should be used?

Accepted Answer

Use Group Policy to publish the application to all workstations.. Group Policy (GPO) allows centralized deployment of software via Active Directory, ensuring all workstations receive the same version and configuration automatically during startup or user logon. This method uses the Windows Installer service (MSI) and can assign or publish applications, enforcing consistency without user intervention. It is the only option that guarantees uniform deployment across 500 machines with minimal administrative overhead.

Answer

Place the installer on a network share and instruct users to run it.

Answer

Distribute USB drives with the installer to each employee.

Answer

Email the installer to all employees.

FC0-U61 Hard Questions — 25 Difficult Questions

Exhibit

FC0-U61 Hard Questions — 25 Difficult Questions

Exhibit