FC0-U71 Practice Exam 56 — 20 Questions

Question 1

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 2

Which of the following is a characteristic of a NoSQL database compared to a relational database?

Accepted Answer

Supports flexible schema. NoSQL databases are characterized by a flexible schema, meaning they do not require a fixed table structure and can handle unstructured or semi-structured data. This allows for easy evolution of data models and rapid development. In contrast, relational databases enforce a strict schema and normalization.

Answer

Requires normalized data

Answer

Enforces strict schema definition

Answer

Uses SQL for queries

Question 3

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 4

An IT administrator needs to deploy a new application to 50 company-owned smartphones. The devices are managed by a central console that can enforce policies, install apps, and wipe data remotely. Which technology is being used?

Accepted Answer

Mobile Device Management (MDM). Mobile Device Management (MDM) is the technology that allows an IT administrator to centrally manage and secure mobile devices like smartphones and tablets. MDM solutions provide features such as policy enforcement, remote app installation, and remote wipe, which match the scenario exactly. The central console described is typical of MDM software (e.g., Microsoft Intune, VMware Workspace ONE). Thus, MDM is the correct answer.

Answer

Google Account Sync

Answer

Synchronisation

Answer

iCloud

Question 5

A small business with 50 employees currently hosts its email and file-sharing server on-premises on a single physical server. The server is experiencing frequent hardware failures, causing downtime and data loss. The owner wants a solution that improves reliability, scalability, and reduces the need for in-house maintenance. The company has a limited IT budget and wants to avoid large upfront hardware costs. The owner is concerned about data security and compliance but is open to cloud solutions. As an IT consultant, which of the following would be the best recommendation?

Accepted Answer

Migrate to a public cloud IaaS solution. Migrating to a public cloud IaaS solution addresses every stated requirement: it eliminates single points of hardware failure through the provider's resilient infrastructure, scales on demand, removes the need for in-house server maintenance, and converts capital expenditure into predictable operational costs. IaaS also supports the security and compliance controls the owner requires through provider certifications and customer-managed configurations.

Answer

Implement a regular backup strategy

Answer

Purchase a more powerful on-premises server

Answer

Move to a peer-to-peer network

Question 6

An organization uses an open-source application. They modify the source code and distribute the modified version. According to the GNU General Public License (GPL), what must they do?

Accepted Answer

Release the modified source code under the same license. The GNU General Public License (GPL) is a copyleft license that requires any modified version of the software to be distributed under the same GPL terms. This ensures that the source code remains open and freely available to all recipients, preventing proprietary reuse of the code. Option D is correct because it states this requirement. Options A, B, and C are incorrect: renaming is not required, no fee is mandated, and modifications must be disclosed.

Answer

Rename the application

Answer

Pay a fee to the original developers

Answer

Keep the modifications private

Question 7

A company decides to deploy a new accounting application. The vendor offers a subscription model where users pay monthly. This is an example of:

Accepted Answer

Software as a Service (SaaS). SaaS is a cloud delivery model where the vendor hosts the application and users subscribe to it, typically on a monthly or annual per-user basis, accessing it over the internet. A monthly subscription to a vendor-hosted accounting application matches this model exactly, since the customer pays for ongoing access rather than purchasing a perpetual license. This is the defining characteristic of Software as a Service under the NIST cloud service models.

Answer

Shareware

Answer

Freeware

Answer

Open source

Question 8

A user's laptop has a SATA SSD, and they want to upgrade to a faster storage solution. Which interface technology would provide the most significant performance improvement?

Accepted Answer

NVMe M.2. NVMe M.2 provides the most significant performance improvement because it communicates over PCIe lanes rather than the SATA bus, bypassing the AHCI controller and its ~600 MB/s ceiling. NVMe drives routinely exceed 3,000 MB/s and support deep parallel command queues (up to 64K queues with 64K commands each), dramatically reducing latency.

Answer

Hybrid drive (SSHD)

Answer

External USB 3.0 SSD

Answer

SATA M.2

Question 9

A project has frequent requirement changes and the team needs to deliver working software in short cycles. Which software development methodology is most appropriate?

Accepted Answer

Agile. Agile methodology is the most appropriate because it explicitly supports iterative development, frequent requirement changes, and short delivery cycles through practices like sprints and continuous feedback. Unlike rigid sequential models, Agile embraces change even late in development, making it ideal for projects where requirements evolve rapidly.

Answer

Waterfall

Answer

DevOps

Answer

Spiral

Question 10

A company uses a relational database with a 'Customers' table and an 'Orders' table. Each order must be linked to exactly one customer. Which type of relationship exists between Customers and Orders?

Accepted Answer

One-to-many. In a relational database, if each order must be linked to exactly one customer, but a customer can have multiple orders, the relationship is one-to-many. The 'one' side is Customers (each customer is unique) and the 'many' side is Orders (multiple orders per customer). This is implemented via a foreign key in the Orders table referencing the primary key in Customers.

Answer

No relationship

Answer

Many-to-many

Answer

One-to-one

Question 11

A database must be restored to the exact state at 11:00 AM. The last full backup was at 10:00 PM previous day, and transaction log backups were taken every hour. What is the minimum to restore?

Accepted Answer

Full backup plus all transaction log backups from after full backup. To restore a database to a specific point in time (11:00 AM) when only full and transaction log backups exist, you must restore the most recent full backup (from 10:00 PM previous day) and then apply all subsequent transaction log backups in sequence. Transaction log backups contain all committed transactions up to the time of the backup, so applying them in order after the full backup brings the database to the exact state at the time of the last log backup (which would be 11:00 AM if the hourly log backup was taken at that time). Option A is correct because it includes the full backup and all transaction log backups taken after it, which is the minimum required for point-in-time recovery.

Answer

Transaction log backup only

Answer

Full backup only

Answer

Full backup plus differential backup

Question 12

A database designer is creating a table to store employee information. To ensure that each employee can be uniquely identified, which constraint should be applied?

Accepted Answer

PRIMARY KEY. A PRIMARY KEY constraint uniquely identifies each record in a database table. It enforces both uniqueness and non-nullability, ensuring that no two employees can have the same primary key value and that the value is never NULL. This makes it the correct choice for guaranteeing each employee can be uniquely identified.

Answer

UNIQUE

Answer

FOREIGN KEY

Answer

NOT NULL

Question 13

Consider the following algorithm:
SET x = 5
SET y = 2
SET result = x ^ y
OUTPUT result
Assuming '^' is the exponentiation operator, what is the output?

Accepted Answer

25. The algorithm sets x = 5 and y = 2, then computes result = x ^ y, where '^' is the exponentiation operator. 5 raised to the power of 2 equals 25. Therefore, the output is 25, making option D correct.

Answer

32

Answer

7

Answer

10

Question 14

A user wants to synchronize files across multiple devices, including an iPhone, a Windows laptop, and an Android tablet. Which TWO cloud services would be most effective for this cross-platform syncing?

Accepted Answer

OneDrive. OneDrive (B) is correct because Microsoft's OneDrive client is available for iOS, Android, Windows, and the web, allowing the same files to be synced and accessed across an iPhone, Windows laptop, and Android tablet. Google Drive (C) is also correct because Google provides Drive apps for iOS, Android, Windows, and the web, enabling cross-platform file synchronization among those exact devices. Bluetooth file transfer (A) is not a cloud service and only supports short-range, manual device-to-device transfers, so it does not synchronize files across multiple devices. iTunes sync (D) is designed primarily for Apple device management and local syncing with a computer, not cloud-based cross-platform synchronization. iCloud (E) is not the best fit here because, while it has some Windows and web support, it is optimized for Apple's ecosystem and does not natively sync files on Android devices.

Answer

Bluetooth file transfer

Answer

iTunes sync

Answer

iCloud

Question 15

A user inserts a software CD into their computer to install a new application. Which of the following is the most likely next step after the CD is inserted?

Accepted Answer

The operating system automatically runs the installer or prompts the user.. When a software CD is inserted, modern operating systems like Windows use the AutoPlay feature to detect the disc's content. If the disc contains an autorun.inf file with a valid 'open=' directive, the OS automatically launches the installer or prompts the user with available actions, making B the correct answer.

Answer

The user must open a web browser and download additional drivers.

Answer

The user must open File Explorer and double-click the setup.exe file.

Answer

The setup files are automatically copied to the desktop.

Question 16

A software development team is adopting an Agile methodology. Which of the following are characteristics of Agile? (Choose three.)

Accepted Answer

Customer collaboration. Option B (Customer collaboration) is correct because the Agile Manifesto explicitly values customer collaboration over contract negotiation, ensuring the customer stays engaged throughout development. Option C (Responding to change over following a plan) is correct because Agile prioritizes adaptability to changing requirements over rigid adherence to an initial plan. Option E (Iterative development) is correct because Agile delivers software in short, repeated cycles (iterations/sprints) to incorporate feedback continuously. Option A is incorrect because strict adherence to a fixed plan contradicts Agile's flexibility. Option D is incorrect because Agile values working software over comprehensive documentation.

Answer

Strict adherence to a fixed plan

Answer

Emphasis on documentation over working software

Question 17

A database administrator needs to ensure that a transaction either completes fully or not at all. Which property of database transactions is this?

Accepted Answer

Atomicity. Atomicity ensures that a transaction is treated as a single, indivisible unit of work: either all of its operations are committed successfully, or none are applied. This is the 'all-or-nothing' property described in the ACID model. If any part of the transaction fails, the database management system (DBMS) rolls back the entire transaction, leaving the database unchanged.

Answer

Isolation

Answer

Consistency

Answer

Durability

Question 18

An employee calls the help desk claiming to be a manager from another department and requests a password reset. This is an example of which social engineering technique?

Accepted Answer

Pretexting. Pretexting is a social engineering technique where an attacker invents a fabricated scenario (a pretext) — such as impersonating a manager from another department — to manipulate a victim into divulging information or performing an action like a password reset. The key element is the false identity and fabricated context used to gain trust. Because the caller claims to be a manager requesting a password reset, this is a textbook pretexting attack.

Answer

Baiting

Answer

Tailgating

Answer

Phishing

Question 19

Which TWO of the following are types of malware?

Accepted Answer

Virus. A virus (C) is a type of malware: it is a self-replicating program that attaches itself to a host file or boot sector and spreads when the infected file is executed, often requiring user action. A worm (D) is also malware: it is a standalone, self-replicating program that spreads across networks by exploiting vulnerabilities or using file-sharing/email mechanisms without needing a host file or user interaction. The other options are not malware: a patch (A) is a legitimate software update that fixes bugs or closes vulnerabilities, encryption (B) is a security technique that encodes data to protect confidentiality, and a firewall (E) is a network security device or software that filters traffic based on rules.

Answer

Patch

Answer

Encryption

Answer

Firewall

Question 20

A technician is configuring a wireless access point for a small office. The office has several older laptops that only support the 2.4 GHz frequency band, as well as newer devices that support both 2.4 GHz and 5 GHz. The technician wants to ensure all devices can connect while minimizing interference. Which of the following should the technician do?

Accepted Answer

Enable both 2.4 GHz and 5 GHz bands with separate SSIDs.. To support both older and newer devices while minimizing interference, the technician should enable both bands with separate SSIDs. This allows older devices to use 2.4 GHz and newer devices to use 5 GHz, reducing congestion and improving performance. Other options either exclude some devices or fail to optimize band usage.

Answer

Enable both bands with the same SSID.

Answer

Enable only the 5 GHz band.

Answer

Enable only the 2.4 GHz band.