FC0-U71 Practice Test 49 — 15 Questions

Question 1

A user receives a notification that their software subscription will expire in seven days. The user wants to continue using the software without interruption. Which of the following should the user do to ensure continued access?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Renew the software subscription online.. The software subscription is tied to a licensing server that validates the user's right to use the software. Renewing the subscription online updates the license key or extends the activation period on the server, ensuring the software remains functional beyond the expiration date without interruption.

Answer

Uninstall the software and reinstall it.

Answer

Disable automatic updates to save bandwidth.

Answer

Delete temporary files to free up space.

Question 2

A table has columns: EmployeeID (PK), DepartmentID, DepartmentName, Salary. Which normal form violation exists?

Accepted Answer

Third Normal Form. The table violates Third Normal Form (3NF) because DepartmentName depends on DepartmentID, which is not a candidate key. In 3NF, every non-key column must depend solely on the primary key (EmployeeID), not on another non-key column. This transitive dependency (EmployeeID → DepartmentID → DepartmentName) requires splitting the table into Employees and Departments to achieve 3NF.

Answer

No violation

Answer

Second Normal Form

Answer

First Normal Form

Question 3

A database has a 'Students' table with columns: StudentID (primary key), Name, Major. Another table 'Enrollments' has columns: EnrollmentID (primary key), StudentID (foreign key), CourseID. Which SQL query correctly lists each student's name and their enrolled courses by joining the tables?

Accepted Answer

SELECT Name, CourseID FROM Students INNER JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;. INNER JOIN returns only rows where the join condition (Students.StudentID = Enrollments.StudentID) is satisfied, which lists each student's name only if they have at least one enrollment. Option A (RIGHT JOIN) would include all enrollments, even if a StudentID does not match a student, resulting in NULL names for orphaned enrollments. Option C uses an implicit cross join (comma) with a WHERE clause; though it produces the same result set, it is not considered a proper JOIN statement and is less clear, so it does not meet the requirement of 'joining tables'. Option D (LEFT JOIN) would include students with no enrollments, showing NULL for CourseID, which does not match the requirement of listing only enrolled courses.

Answer

SELECT Name, CourseID FROM Students RIGHT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;

Answer

SELECT Name, CourseID FROM Students, Enrollments WHERE Students.StudentID = Enrollments.StudentID;

Answer

SELECT Name, CourseID FROM Students LEFT JOIN Enrollments ON Students.StudentID = Enrollments.StudentID;

Question 4

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 5

A company's database administrator notices that queries against a large customer table are running slowly. The table has millions of rows and is frequently filtered by the 'last_name' column. Which of the following is the BEST way to improve query performance without changing the application code?

Accepted Answer

Create an index on the 'last_name' column.. Creating an index on the 'last_name' column allows the database to locate rows matching filter conditions without scanning the entire table. This dramatically reduces I/O and CPU overhead for queries that filter by last_name, directly addressing the performance bottleneck without requiring any changes to application code.

Answer

Partition the table by row count.

Answer

Increase the database server's RAM.

Answer

Denormalize the table to reduce joins.

Question 6

A technician is asked to install a software package on a company laptop. The licensing type requires the software to be installed on a single device and cannot be transferred. Which licensing model is being described?

Accepted Answer

OEM license.. An OEM (Original Equipment Manufacturer) license is tied to the specific device it was originally installed on and cannot be transferred to another computer. This matches the scenario where the software must be installed on a single device and cannot be moved, as OEM licenses are permanently bound to that hardware.

Answer

Volume license.

Answer

Subscription license.

Answer

Perpetual license.

Question 7

You are a system administrator for a small marketing firm. The firm uses a web-based project management application (Trello) for task tracking. One morning, users report that they cannot access Trello from any workstation. However, other websites (e.g., Google, YouTube) are accessible. The network uses a single router with default settings. No changes were made to the network or firewall overnight. You check the DNS settings on a workstation and it points to the ISP's DNS server. What is the most likely cause and the best course of action?

Accepted Answer

Contact the ISP to unblock Trello.. Since only Trello is inaccessible while other websites (including Google and YouTube) work, the issue is likely specific to Trello, not a general network or DNS problem. The workstations already use the ISP's DNS servers (8.8.8.8 and 8.8.4.4) as indicated, so changing the router's DNS to the same would not resolve the issue. The most plausible cause is that the ISP is blocking access to Trello, possibly due to a security policy or a temporary restriction. Therefore, the best course of action is to contact the ISP and ask them to unblock Trello.

Answer

Change the DNS server settings on the router to use the ISP's DNS servers.

Answer

Reset the router to factory defaults.

Answer

Clear the browser cache on all workstations.

Question 8

A database administrator notices that queries on a large table are taking too long to execute. Which action would most likely improve performance?

Accepted Answer

Create an index on frequently queried columns.. Creating an index on frequently queried columns allows the database to locate rows using a B-tree or hash structure, reducing the need for full table scans. This directly addresses slow query performance on large tables by minimizing disk I/O and CPU overhead during SELECT operations.

Answer

Add more columns to the table.

Answer

Denormalize the table.

Answer

Perform further normalization.

Question 9

A small business wants to connect its computers to share files and printers. Which of the following network devices would BEST facilitate this?

Accepted Answer

Switch. A switch operates at Layer 2 of the OSI model and uses MAC addresses to forward frames only to the specific port where the destination device is connected. This creates a dedicated, collision-free path between the computers, making it the ideal device for connecting multiple computers within a local area network (LAN) to share files and printers efficiently.

Answer

Router

Answer

Hub

Answer

Modem

Question 10

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

Accepted Answer

Faster access times. SSDs use NAND flash memory with no moving parts, allowing near-instantaneous data access (typically 0.1 ms or less) compared to HDDs that require mechanical arm movement and platter rotation (5–15 ms). This eliminates rotational latency and seek time, making access times significantly faster.

Answer

Higher storage capacity typically

Answer

More noise

Question 11

A sales database has a Customers table with CustomerID as the primary key and an Orders table that includes CustomerID. Which type of relationship is typically established between Customers and Orders?

Accepted Answer

One-to-many. A customer can have multiple orders, but each order belongs to one customer, so it's a one-to-many relationship.

Answer

One-to-one

Answer

Many-to-many

Answer

Unrelated

Question 12

A technician is configuring a new workstation. The user requires access to a legacy application that only runs on Windows 7. However, the company standard is Windows 10. Which of the following is the BEST solution?

Accepted Answer

Use a virtual machine with Windows 7.. A virtual machine (VM) running Windows 7 allows the legacy application to operate in its native environment while the host system runs the company-standard Windows 10. This isolates the legacy software from the modern OS, avoiding compatibility issues and maintaining security compliance. Virtualization is the preferred solution when an application has strict OS dependencies that cannot be resolved through compatibility features.

Answer

Upgrade the legacy application to a Windows 10 version.

Answer

Install Windows 7 on a separate partition.

Answer

Use Windows 10 compatibility mode.

Question 13

Which of the following is an example of a strong password?

Accepted Answer

Cr@zy8#s. (Cr@zy8#s) is correct because it meets all strong password criteria: it is at least 8 characters long, includes uppercase and lowercase letters, a digit, and special characters (@ and #). This complexity makes it resistant to brute-force attacks and dictionary attacks, as it increases the entropy and does not contain common words or sequential patterns.

Answer

123456

Answer

abc123

Answer

password

Question 14

A developer is planning a new project that has very clear and fixed requirements. The project must be completed in a linear fashion with each phase finished before moving to the next. Which development methodology should be used?

Accepted Answer

Waterfall. The Waterfall methodology is correct because it follows a linear, sequential approach where each phase (e.g., requirements, design, implementation, testing) must be completed before the next begins. This aligns perfectly with the project's very clear and fixed requirements, as Waterfall assumes that all requirements are known upfront and changes are minimized.

Answer

Spiral

Answer

Scrum

Answer

Agile

Question 15

A technician is setting up a small office network with five workstations and a file server. Which TWO of the following are essential hardware components for this network to function? (Select TWO).

Accepted Answer

Switch. A router connects the local network to the internet and manages traffic between devices; a switch allows the workstations and server to communicate within the LAN. A hub is outdated and less efficient, a modem is needed for internet but not strictly for local communication, and a firewall can be software or integrated into the router.

Answer

Hub

Answer

Firewall

Answer

Modem