FC0-U71 Practice Exam 57 — 20 Questions

Question 1

A developer notices that an application runs slowly when processing large files. Which optimization technique is most likely to improve performance?

Accepted Answer

Implement buffered reading and process in chunks. Processing large files often causes performance bottlenecks due to excessive I/O operations. Buffered reading reads data into memory in larger blocks, reducing the number of system calls, while processing in chunks prevents memory overload and allows the application to handle data incrementally. This directly addresses the slow performance by minimizing disk access overhead.

Answer

Increase the scope of variables to avoid passing arguments

Answer

Add more comments to the code

Answer

Use recursion instead of loops

Question 2

What is the primary purpose of a password manager?

Accepted Answer

To store passwords in an encrypted vault and generate complex passwords. A password manager securely stores and generates strong, unique passwords for each account, reducing password reuse and improving security.

Answer

To share passwords with other users securely

Answer

To automatically log in to websites without typing a password

Answer

To recover forgotten passwords quickly

Question 3

A database administrator needs to remove all rows from the 'Log' table but keep the table structure for future use. The administrator also wants the operation to be irreversible (cannot be rolled back). Which SQL statement should be used?

Accepted Answer

TRUNCATE TABLE Log;. TRUNCATE TABLE Log; is correct because it removes all rows from the table while preserving the table structure (columns, constraints, indexes) for future use. Unlike DELETE, TRUNCATE is a DDL operation that does not generate individual row deletion logs, making it irreversible and cannot be rolled back in most database systems.

Answer

DELETE FROM Log;

Answer

ALTER TABLE Log REMOVE ROWS;

Answer

DROP TABLE Log;

Question 4

Refer to the exhibit. The Products table has been created and two rows have been inserted. What will be the result of the following query?
SELECT ProductName FROM Products WHERE Price > 100;

Accepted Answer

Laptop. The query selects ProductName from the Products table where the Price column is greater than 100. According to the exhibit (not shown but implied), only the row with ProductName 'Laptop' has a Price value exceeding 100, so only 'Laptop' is returned. This demonstrates the basic SQL WHERE clause filtering on a numeric column.

Answer

Mouse

Answer

Laptop, Mouse

Answer

An empty result set

Question 5

Which of the following is an example of a NoSQL database?

Accepted Answer

MongoDB. MongoDB is a popular document-oriented NoSQL database.

Answer

Oracle Database

Answer

MySQL

Answer

PostgreSQL

Question 6

A database designer is modeling a system where each book can have multiple authors and each author can write multiple books. Which type of relationship should be used between the Book and Author entities?

Accepted Answer

Many-to-many. The scenario describes a many-to-many relationship because each book can have multiple authors and each author can write multiple books. In relational database design, this is modeled using a junction (or associative) table that contains foreign keys referencing both the Book and Author primary keys, enabling the bidirectional association without data redundancy.

Answer

One-to-one

Answer

Hierarchical

Answer

One-to-many

Question 7

A technician is troubleshooting a network issue and needs to identify the IP address of a device. Which of the following are private IPv4 addresses? (Select TWO).

Accepted Answer

192.168.1.10. Private IPv4 addresses belong to reserved ranges for internal networks (RFC 1918). The options that fall within private ranges are 192.168.1.10 (192.168.0.0/16) and 172.16.0.1 (172.16.0.0/12). The other options are not private: 8.8.8.8 is a public DNS server, 203.0.113.5 is a public test address (from RFC 5737), and 169.254.1.1 falls in the APIPA link-local range (169.254.0.0/16), which is not routable but also not considered private per RFC 1918.

Answer

8.8.8.8

Answer

203.0.113.5

Answer

169.254.1.1

Question 8

A user wants to ensure data is not lost in the event of a drive failure. Which storage configuration provides redundancy?

Accepted Answer

RAID 1. RAID 1 (mirroring) writes identical data to two or more drives simultaneously, so if one drive fails, the data remains accessible from the other drive(s). This provides fault tolerance and ensures no data loss during a single drive failure, meeting the user's requirement for redundancy.

Answer

JBOD

Answer

RAID 0

Answer

Single drive

Question 9

Based on the exhibit, which commit introduced the password validation fix?

Accepted Answer

d4f5e6g. Commit d4f5e6g is correct because it is the commit that implements the password validation fix. The other commits either predate the fix or address unrelated features such as UI updates or logging enhancements.

Answer

e3a1b2c

Answer

l0m1n2o

Answer

h7i8j9k

Question 10

A user reports that a SELECT query on a large table with millions of records is very slow. The table has no indexes. Which index type would most likely improve the performance of equality searches (e.g., WHERE id = 100)?

Accepted Answer

Clustered index on the column. A clustered index on the column used in equality searches (e.g., WHERE id = 100) is the most effective because it physically reorders the table data in the same order as the index key. This allows the database engine to perform a single seek operation directly to the exact row, rather than scanning millions of records. For a large table with no indexes, a clustered index provides the fastest possible access for equality lookups on the indexed column.

Answer

Full-text index on the column

Answer

Nonclustered index on the column

Answer

Unique index on the column

Question 11

Which of the following best describes the difference between a compiler and an interpreter?

Accepted Answer

A compiler translates the entire source code into machine code before execution; an interpreter executes code line by line.. A compiler translates the entire source code into machine code before execution, producing a separate executable. An interpreter translates and executes source code line by line at runtime. Compiled programs generally run faster at execution because translation is done ahead of time. Therefore, option C is correct. Option A confuses development speed (no separate compile step) with execution speed. Option B reverses the two definitions, and option D incorrectly describes when syntax checking occurs.

Answer

Compiled programs run slower than interpreted programs.

Answer

A compiler executes code line by line; an interpreter translates the entire program at once.

Answer

A compiler checks for syntax errors at runtime; an interpreter checks at compile time.

Question 12

A programmer is using a version control system. Which THREE are core Git concepts?

Accepted Answer

Repository. Git concepts include repository, commit, branch, merge, etc.

Answer

Variable

Answer

Compilation

Question 13

Match each software license type to its description.

Accepted Answer

Open Source License: Software with source code available for modification and redistribution.. Common software licenses include open source (source code available), freeware (free to use, no source), shareware (trial-based), and commercial (paid). Public domain (no copyright) and GPL (copyleft) are often confused with open source or freeware.

Answer

Public Domain: Software that is free to use and modify, but still under copyright.

Answer

GNU General Public License: A license that allows free use but prohibits redistribution.

Question 14

Match each database concept to its description.

Accepted Answer

Table: A collection of related data organized into rows and columns. The correct matches are: Table (rows/columns), Primary Key (unique identifier), Foreign Key (link to another table), Query (data request). Common confusions include mixing up primary and foreign keys.

Answer

Primary Key: A field that links to another table

Answer

Foreign Key: A unique identifier for each record

Question 15

Which component of the CIA triad ensures that data cannot be modified by unauthorized users?

Accepted Answer

Integrity. Integrity ensures that data is not altered unexpectedly by unauthorized parties. Confidentiality prevents unauthorized access, and availability ensures systems are accessible when needed.

Answer

Authentication

Answer

Availability

Answer

Confidentiality

Question 16

Which of the following license types allows users to view, modify, and distribute the source code, as long as they include the original copyright notice and any modifications are also open source?

Accepted Answer

GNU General Public License (GPL). The GNU General Public License (GPL) is a copyleft open source license that requires derivative works to be distributed under the same license, ensuring source code remains open. MIT and Apache are permissive licenses with fewer restrictions, and shareware is not open source.

Answer

Shareware

Answer

Apache License 2.0

Answer

MIT License

Question 17

You are an IT support specialist for a mid-sized company. A user in the accounting department, Jane, reports that her accounting software (QuickBooks 2021) crashes every time she tries to export a report to PDF. The crash occurs immediately after clicking 'Export to PDF' and displays the error: 'The application has stopped working.' Jane's workstation runs Windows 10 Pro with 8GB RAM and an SSD. She has sufficient disk space. Other users in the same department using the same software version do not experience this issue. Jane recently installed a free PDF printer driver for personal use. What is the most likely cause and the best course of action?

Accepted Answer

Remove the recently installed PDF printer driver and test the export again.. The most likely cause is the recently installed free PDF printer driver, which conflicts with QuickBooks' PDF export functionality. QuickBooks relies on its own PDF generation engine or system PDF printers, and a third-party PDF driver can intercept or corrupt the export process, causing the crash. Removing the driver and testing is the best first step because it isolates the change without affecting other software or system files.

Answer

Reinstall QuickBooks 2021 using the original installation media.

Answer

Reinstall Windows 10 because the operating system is corrupted.

Answer

Update all printer drivers to the latest versions.

Question 18

Which THREE of the following are valid database integrity constraints?

Accepted Answer

UNIQUE. A UNIQUE constraint ensures that all values in a column or a set of columns are distinct from one another, preventing duplicate entries. This is a standard SQL integrity constraint that enforces data uniqueness at the table level, and it is correctly listed as a valid database integrity constraint.

Answer

INDEX

Answer

CONDITION

Question 19

An IT administrator is hardening a server. Which three of the following actions should be taken to improve security? (Select THREE.)

Accepted Answer

Disable unused services and ports. Disabling unnecessary services reduces attack surface; enabling automatic updates ensures patches; implementing least privilege limits access.

Answer

Disable the firewall for better performance

Answer

Grant all users administrative rights

Question 20

You are the IT administrator for a small accounting firm with 25 employees. The firm uses a Windows Server 2019 domain controller, a file server, and an email server running Microsoft Exchange. Each employee has a company-issued laptop running Windows 10. The firm recently experienced a ransomware attack that encrypted all files on the file server. The attacker demanded a ransom in Bitcoin. The firm restored the files from a backup that was taken the previous night. However, the CEO is concerned about future attacks and wants to implement additional security measures. The firm has a limited budget and cannot afford a full security suite. Which of the following is the BEST course of action to reduce the risk of another ransomware infection?

Accepted Answer

Implement application whitelisting on all workstations.. Application whitelisting prevents any unauthorized executable, script, or installer from running, which would block ransomware even if it reaches the system via email or web download. This is the most effective single control on a limited budget because it stops unknown malware at the execution point, regardless of patch status or user behavior.

Answer

Ensure all systems are patched monthly.

Answer

Deploy an email spam filter to block phishing emails.

Answer

Conduct annual security awareness training for all employees.