FC0-U71 Practice Test 44 — 15 Questions

Question 1

Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?

Accepted Answer

55000. The AVG function calculates the arithmetic mean of the Salary column across all rows in the Employees table. Given the salaries 50000, 60000, and 55000, the average is (50000 + 60000 + 55000) / 3 = 55000. Therefore, option A is correct.

Answer

50000

Answer

165000

Answer

60000

Question 2

A database administrator is setting up user permissions. Which THREE actions follow the principle of least privilege?

Accepted Answer

Granting SELECT only on specific tables to a read-only user. Granting SELECT only on specific tables to a read-only user adheres to the principle of least privilege by limiting data access to exactly what the user needs to perform their job. This prevents unnecessary exposure of sensitive data and reduces the risk of accidental or malicious modification. In SQL databases, this is implemented via GRANT SELECT ON specific_table TO user, rather than granting broader permissions like SELECT on all tables or higher-level privileges.

Answer

Allowing remote access from any IP address for flexibility

Answer

Granting DBA privileges to all developers for convenience

Question 3

A technician is troubleshooting a computer that cannot connect to the network. Which THREE steps should the technician perform first in the troubleshooting process?

Accepted Answer

Check if the network cable is securely connected. Checking the physical connection is the first step in the CompTIA A+ troubleshooting methodology. A loose or damaged network cable is a common cause of connectivity failure, and verifying it eliminates the simplest issue before moving to software or configuration checks.

Answer

Reinstall the operating system

Answer

Replace the network interface card

Question 4

Which TWO of the following are examples of output devices?

Accepted Answer

Monitor. A monitor is an output device because it receives processed data from the computer's graphics card and displays it visually to the user. Output devices convert electronic signals into human-readable form, such as text, images, or video, which is exactly what a monitor does.

Answer

Scanner

Answer

Keyboard

Answer

Mouse

Question 5

A user wants to share a large video file with colleagues. Which THREE methods are appropriate? (Choose THREE.)

Accepted Answer

Upload to a cloud storage service and share a link.. Uploading a large video file to a cloud storage service (e.g., Google Drive, OneDrive, Dropbox) and sharing a link is appropriate because cloud storage is designed to handle large files without size limits imposed by email servers. The recipient can download the file at their convenience, and the link can be set with permissions to control access. This method avoids bandwidth and attachment size restrictions common in email systems.

Answer

Copy the file to a USB drive and mail it.

Answer

Attach the file to an email.

Question 6

A technician is selecting a storage solution for a home server that requires fast access speeds and redundancy against a single drive failure. Which TWO technologies should be considered?

Accepted Answer

SSD. SSD (Solid State Drive) provides fast access speeds due to its use of NAND flash memory, which eliminates mechanical seek times and rotational latency found in HDDs. This makes it ideal for a home server requiring rapid data retrieval. RAID 1 (mirroring) writes identical data to two drives, offering redundancy against a single drive failure by allowing the system to continue operating if one drive fails.

Answer

Cloud storage

Answer

HDD

Answer

RAID 0

Question 7

A company wants to implement a solution that allows employees to access internal applications from home without installing software on their personal devices. Which technology should be used?

Accepted Answer

Virtual Desktop Infrastructure (VDI). VDI provides hosted virtual desktops that users can access from any device, including personal ones, without installing software locally. The applications run on the server, and only screen updates are sent to the client, meeting the requirement of no software installation on personal devices.

Answer

Remote Desktop Services (RDS)

Answer

Thin client

Answer

Virtual Private Network (VPN)

Question 8

A company uses a legacy application that only runs on Windows 7. The IT department plans to upgrade to Windows 10. What is the best approach to ensure compatibility?

Accepted Answer

Use Windows 10 compatibility mode for the application.. Windows 10 compatibility mode allows the legacy application to run by emulating the environment of Windows 7, including specific service packs and settings. This is the best approach because it requires no additional hardware or software costs and preserves the existing application functionality without modification. Compatibility mode works by intercepting API calls and presenting the expected Windows 7 behavior to the application.

Answer

Replace the legacy application with a modern equivalent.

Answer

Run the application in a virtual machine with Windows 7.

Answer

Install the application directly on Windows 10 without changes.

Question 9

A company has two office buildings 1.5 km apart and needs to connect their networks with a high-speed, reliable link. Which cabling type is most appropriate?

Accepted Answer

Fiber optic. Fiber optic cabling is the most appropriate choice for connecting two office buildings 1.5 km apart because it supports high-speed data transmission over long distances (up to several kilometers) with minimal signal loss and immunity to electromagnetic interference (EMI). Unlike copper-based cables, fiber optic uses light pulses to transmit data, making it ideal for reliable, high-bandwidth links between separate buildings.

Answer

Cat6a

Answer

Coaxial

Answer

Cat5e

Question 10

A software developer writes code that interacts with the operating system to access hardware. Which layer of software is being used?

Accepted Answer

System software. System software, specifically the operating system kernel, provides the interface between application software and hardware. When a software developer writes code that interacts with the OS to access hardware, they are using system calls (e.g., Windows API, POSIX syscalls) that are part of the system software layer. This layer manages hardware resources and abstracts them for higher-level programs.

Answer

Application software

Answer

Firmware

Answer

Utility software

Question 11

A company is deciding between using open-source software and proprietary software for a new project. Which of the following is a primary advantage of open-source software?

Accepted Answer

The ability to modify the source code to fit specific needs.. Open-source software provides access to its source code under a license (e.g., GPL, Apache 2.0) that permits users to study, modify, and redistribute it. This ability to customize the code to meet specific business or technical requirements is a primary advantage, as proprietary software typically restricts such modifications through end-user license agreements (EULAs).

Answer

No cost for any type of use or distribution.

Answer

Guaranteed professional technical support.

Answer

Vendor lock-in with regular updates.

Question 12

A developer is trying to find why a program is producing incorrect output. The developer runs the program with a debugging tool, sets a breakpoint at a specific line, and examines the values of variables at that point. Which debugging technique is being used?

Accepted Answer

Breakpoint inspection. The developer is using breakpoint inspection, a debugging technique where execution is paused at a specific line of code (the breakpoint) to examine variable values at that exact moment. This allows the developer to inspect the program's state without stepping through each subsequent line, directly identifying why incorrect output occurs.

Answer

Code review

Answer

Step-through execution

Answer

Logging

Question 13

A graphic designer needs to choose a software for vector illustration. Which of the following is best suited?

Accepted Answer

Adobe Illustrator. Adobe Illustrator is the industry-standard vector graphics editor, designed specifically for creating and editing scalable vector illustrations. GIMP and Adobe Photoshop are primarily raster (pixel-based) editors, while Microsoft Word offers only basic shape tools and is not intended for professional vector illustration. Therefore, Adobe Illustrator is the best suited choice.

Answer

GIMP

Answer

Adobe Photoshop

Answer

Microsoft Word

Question 14

A small office has five desktop computers that need to be connected to share files and a printer. Which network device should be used to create a local area network?

Accepted Answer

Switch. A switch is the correct device because it operates at Layer 2 of the OSI model, using MAC addresses to forward frames only to the specific port where the destination device is connected. This creates a dedicated, collision-free path between any two communicating devices, which is essential for a small office LAN where five computers need to share files and a printer efficiently.

Answer

Hub

Answer

Modem

Answer

Router

Question 15

A user wants to permanently delete files from a USB flash drive without any possibility of recovery. Which of the following techniques should be used?

Accepted Answer

Overwrite the drive with random data. Overwriting the data with random patterns ensures the original data cannot be recovered. Quick format only removes the file system index, and deletion marks space as available.

Answer

Quick format

Answer

Change the file extension

Answer

Delete and empty Recycle Bin