FC0-U61 Practice Test 20 — 15 Questions

Question 1

Refer to the exhibit. A technician is troubleshooting connectivity from a PC connected to the 192.168.1.0/24 network. The PC cannot reach the 10.0.0.0/24 network. What is the most likely cause?

Accepted Answer

GigabitEthernet0/0 is disabled. The PC on 192.168.1.0/24 cannot reach 10.0.0.0/24 because GigabitEthernet0/0 is disabled, which is the interface that provides the default gateway or the path to the router. Without an active interface on the local subnet, the PC cannot send any frames to the router, and no traffic can leave the local network. Even if routes exist, a disabled interface prevents all Layer 1 and Layer 2 communication, making connectivity impossible.

Answer

Incorrect subnet mask on the PC

Answer

Missing route to 10.0.0.0/24

Answer

Faulty cable on GigabitEthernet0/1

Question 2

Which of the following best describes the function of a DNS server?

Accepted Answer

Resolves domain names to IP addresses. A DNS (Domain Name System) server translates human-readable domain names (e.g., www.example.com) into machine-readable IP addresses (e.g., 192.0.2.1). This resolution process is fundamental to network communication, as applications rely on IP addresses to locate and connect to servers. Without DNS, users would need to memorize numeric IP addresses for every website or service.

Answer

Hosts web pages

Answer

Forwards traffic between networks

Answer

Assigns IP addresses to devices

Question 3

Which TWO of the following are characteristics of a client-server network?

Accepted Answer

Resources are shared from servers. In a client-server network, resources such as files, printers, and applications are hosted on dedicated servers and shared with client devices. This centralized resource sharing is a defining characteristic, as servers are designed to provide services to multiple clients, unlike peer-to-peer networks where each device shares its own resources directly.

Answer

No dedicated server required

Answer

All devices are equal

Answer

Typically used in small offices with few computers

Question 4

Which THREE of the following are types of network topologies?

Accepted Answer

Mesh. A mesh topology connects each device to every other device, providing high redundancy and fault tolerance. It is a valid network topology type commonly used in WANs and wireless networks.

Answer

Triangle

Answer

Circle

Question 5

Refer to the exhibit. A user sees this error when using an application. What is the most likely cause?

Accepted Answer

The application does not have permission to write to the folder.. The error message indicates the application cannot write to the specified folder. This is most commonly caused by insufficient file system permissions, such as the user account lacking Write or Modify access to the directory. Without the correct NTFS or share permissions, the application cannot create or modify files, resulting in a write failure.

Answer

Antivirus software is blocking the application.

Answer

The data file is corrupted.

Answer

The hard drive is full.

Question 6

A developer needs to repeat a set of instructions exactly 10 times. Which programming construct should be used?

Accepted Answer

For loop. A for loop is the correct construct because it is specifically designed to execute a block of code a predetermined number of times, such as exactly 10 iterations. The loop's initialization, condition, and increment/decrement components allow precise control over the repetition count, making it ideal for this requirement.

Answer

Variable

Answer

Function

Answer

If-else statement

Question 7

Which TWO of the following are examples of high-level programming languages? (Select TWO).

Accepted Answer

Python. Python and Java are both high-level programming languages because they provide strong abstraction from the computer's hardware, using human-readable syntax and automatic memory management. Python is interpreted and dynamically typed, while Java is compiled to bytecode and statically typed, but both allow developers to write code without managing registers or memory addresses directly.

Answer

Machine code

Answer

Assembly

Answer

Binary

Question 8

A help desk technician receives an alert from the security monitoring system showing multiple events like the one in the exhibit. The technician is investigating a possible brute-force attack. Based on the exhibit, which of the following is the primary attack vector being used?

Accepted Answer

RDP brute-force attack. The exhibit shows repeated failed authentication attempts targeting TCP port 3389, which is the default port for Remote Desktop Protocol (RDP). A brute-force attack on RDP involves systematically trying many username/password combinations to gain unauthorized remote access to a Windows system. This matches the definition of an RDP brute-force attack.

Answer

VPN brute-force attack

Answer

SSH brute-force attack

Answer

Web application attack

Question 9

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 10

A developer writes an UPDATE statement to change the price of a product but accidentally omits the WHERE clause. What is the most likely outcome?

Accepted Answer

All rows in the table are updated.. In SQL, an UPDATE statement without a WHERE clause applies the change to every row in the specified table. The database engine processes the statement as a set operation, iterating over all rows and setting the specified column(s) to the new value. This is not an error; it is a valid SQL command that results in a mass update.

Answer

Only the first row is updated.

Answer

The database returns a syntax error.

Answer

No rows are updated because the statement is invalid.

Question 11

A database transaction that updates two accounts fails halfway due to a power outage. Which ACID property ensures that partial changes are undone?

Accepted Answer

Atomicity. Atomicity ensures that a transaction is treated as a single, indivisible unit of work. If a power outage interrupts the transaction after updating one account but before updating the second, the database management system (DBMS) must roll back any partial changes to restore the original state. This 'all-or-nothing' property prevents incomplete transactions from leaving the database in an inconsistent state.

Answer

Durability

Answer

Isolation

Answer

Consistency

Question 12

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

Question 13

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 14

Refer to the exhibit. The query returns two rows. If the database had an index on the Department column only, how would the query execution be affected?

Accepted Answer

The query would run faster because the index reduces the number of rows to scan for Department.. Option A is correct because an index on the Department column allows the database engine to quickly locate rows matching the Department condition without scanning the entire table. This reduces the number of rows that need to be evaluated for the Salary condition, speeding up the query. The index does not affect the result set—it only improves access path efficiency.

Answer

The query would return fewer rows because the index excludes the Salary condition.

Answer

The query would return more rows because the index includes both columns.

Answer

The query would fail because the index conflicts with the SELECT *.

Question 15

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.

FC0-U61 Practice Test 20 — 15 Questions

Exhibit

FC0-U61 Practice Test 20 — 15 Questions

Exhibit