FC0-U71 Practice Exam 55 — 20 Questions

Question 1

Which SQL command is used to add a new row to a table?

Accepted Answer

INSERT INTO. INSERT INTO is the SQL command for adding new rows.

Answer

ADD

Answer

CREATE

Answer

UPDATE

Question 2

Refer to the exhibit. A user is unable to access the internet but can ping the default gateway. Based on the exhibit, what is the most likely cause?

Accepted Answer

Incorrect DNS server. The user can ping the default gateway, which confirms that Layer 3 connectivity to the local network is working and that the firewall is not blocking ICMP traffic. However, the inability to access the internet (by name or IP) while local connectivity works points to a failure in name resolution. An incorrect DNS server address prevents the client from resolving domain names to IP addresses, which is the most likely cause given the symptoms.

Answer

Firewall blocking traffic

Answer

Duplicate IP address

Answer

Incorrect subnet mask

Question 3

A small business owner wants to protect sensitive customer data stored on a laptop that is frequently used on public Wi-Fi networks. The owner is considering implementing a security control that ensures data remains confidential even if the laptop is stolen. Which of the following is the BEST control for this scenario?

Accepted Answer

Implement full-disk encryption. Full-disk encryption (FDE) protects data at rest by encrypting the entire storage volume, typically using AES-128 or AES-256. Even if the laptop is stolen, the encrypted data remains unreadable without the decryption key, ensuring confidentiality. This directly addresses the requirement for data protection after physical theft.

Answer

Use a VPN when connected to public Wi-Fi

Answer

Install antivirus software

Answer

Require a strong password for user login

Question 4

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

Accepted Answer

Python. Python (C) is a high-level programming language because it provides human-readable syntax, automatic memory management, and abstracts away hardware details like registers and memory addresses, allowing developers to write portable code. Java (D) is also high-level: it compiles to bytecode that runs on the JVM, offers garbage collection, and hides low-level machine specifics behind object-oriented constructs. By contrast, machine code (A) consists of raw binary instructions executed directly by the CPU, and binary (E) is simply the base-2 representation underlying machine code, so neither is high-level. Assembly (B) is a low-level language that uses mnemonics mapping closely to a specific processor's instruction set, requiring direct management of registers and memory, so it is not high-level either.

Answer

Machine code

Answer

Assembly

Answer

Binary

Question 5

A user wants to retrieve all records from a table named 'Products' where the price is greater than 100. Which TWO SQL statements will work?

Accepted Answer

SELECT * FROM Products WHERE Price > 100;. It uses the standard SQL SELECT statement with a WHERE clause to filter records where the Price column is greater than 100, retrieving all columns with the asterisk (*). This is the fundamental and correct syntax for filtering rows in SQL.

Answer

SELECT * FROM Products WHERE Price > 100 GROUP BY Category;

Answer

SELECT ALL FROM Products WHERE Price > 100;

Answer

SELECT * FROM Products HAVING Price > 100;

Question 6

Which TWO of the following are effective methods to help secure a wireless network from unauthorized access?

Accepted Answer

Enabling WPA2 encryption. WPA2 (Wi-Fi Protected Access 2) uses AES-based encryption with a pre-shared key (PSK) or 802.1X authentication, providing strong confidentiality and integrity for wireless traffic. It is the minimum recommended standard for securing modern Wi-Fi networks against eavesdropping and unauthorized access.

Answer

Enabling WEP encryption

Answer

Disabling the firewall

Answer

Broadcasting the SSID

Question 7

A user wants to protect their laptop in case it is stolen. Which TWO of the following measures would help protect the confidentiality of the data?

Accepted Answer

Full disk encryption. Full disk encryption (B) is correct because it encrypts the entire drive, so if the laptop is stolen the data remains unreadable without the decryption key, directly preserving confidentiality. A strong user account password (D) is correct because it prevents a thief from logging into the OS and accessing files under that account, adding an authentication barrier to the data. A BIOS password (A) only restricts firmware/startup access and can often be bypassed or reset, so it does not protect data confidentiality by itself. A VPN (C) protects data in transit on untrusted networks and does nothing for a stolen device. Screen lock with a password (E) only secures the current session and is trivially bypassed by removing the drive or booting another OS.

Answer

A strong password set in the BIOS

Answer

Using a VPN when connected to public Wi-Fi

Answer

Enabling the screen lock with a password

Question 8

A program crashes with a 'division by zero' error. Which of the following is the most likely cause?

Accepted Answer

An unvalidated user input that results in a zero divisor. A 'division by zero' error occurs when a program attempts to divide a number by zero, which is mathematically undefined and typically raises a runtime exception. The most likely cause is unvalidated user input that supplies a zero as the divisor, because the program does not check or sanitize the input before performing the arithmetic operation.

Answer

A misspelled variable name

Answer

An infinite loop

Answer

An array index out of bounds

Question 9

A student is comparing storage technologies for a project. The student needs a system that stores data as key-value pairs and is designed to scale horizontally across many servers for very high read and write throughput. Which category of database best fits this requirement?

Accepted Answer

A key-value NoSQL database.. Key-value NoSQL databases store data as simple key-to-value pairs and are purpose-built to scale horizontally across many servers, delivering the high read and write throughput the student needs. Relational databases, flat files, and analytical warehouses each optimize for different workloads that do not match this requirement.

Answer

A data warehouse optimized for complex analytical reporting queries.

Answer

A flat file such as a spreadsheet stored on a shared drive.

Answer

A relational database using tables with fixed schemas and joins.

Question 10

Refer to the exhibit. A user reports that a recent Windows update failed to install. Which action should the technician take FIRST?

Accepted Answer

Run the Windows Update Troubleshooter. The Windows Update Troubleshooter is the correct first step because it is a built-in diagnostic tool that automatically detects and resolves common issues preventing updates from installing, such as corrupted update files, misconfigured Windows Update services, or incorrect proxy settings. Running this troubleshooter is a non-invasive, low-risk action that often resolves the problem without requiring manual intervention or system changes.

Answer

Disable the antivirus permanently

Answer

Manually download the update from Microsoft Update Catalog

Answer

Reinstall the operating system

Question 11

A user reports that their computer is unable to access the internet, but can access local network resources. Which of the following is the most likely cause?

Accepted Answer

Incorrect default gateway. The default gateway is the router that connects a local subnet to other networks, including the internet. If the default gateway is incorrect, the computer can communicate within its own subnet (local resources) but cannot route packets to external networks, causing internet access to fail while local access remains functional.

Answer

Windows Firewall blocking outbound traffic

Answer

DNS server not responding

Answer

Faulty Ethernet cable

Question 12

A junior administrator is learning about database fundamentals and needs to identify characteristics that apply to a relational database management system (RDBMS). (Choose two.)

Accepted Answer

Data is organized into tables with rows and columns.. Relational databases are built on the tabular model, where data resides in tables of rows and columns, and relationships are defined through primary and foreign keys. These two characteristics are fundamental to how an RDBMS organizes, connects, and enforces integrity across data, distinguishing it from document, graph, and other non-relational systems.

Answer

Queries are written in a graph traversal language instead of SQL.

Answer

The system guarantees eventual consistency rather than strong consistency.

Answer

Data is stored as flexible JSON documents without a fixed schema.

Question 13

A junior developer needs to create a simple program that adds two numbers and displays the result. Which programming paradigm is most suitable for this task?

Accepted Answer

Procedural programming. Procedural programming is the most suitable paradigm for a simple program that adds two numbers and displays the result because it follows a linear, step-by-step sequence of instructions. The developer writes a series of statements (e.g., `result = a + b; print(result)`) that execute in order, directly mapping the task's logic without unnecessary abstraction. This paradigm is ideal for small, straightforward tasks where clarity and direct control over execution flow are paramount.

Answer

Functional programming

Answer

Declarative programming

Answer

Object-oriented programming

Question 14

A user wants to create a presentation with slides, animations, and speaker notes. Which application type should they use?

Accepted Answer

Presentation software.. Presentation software, such as Microsoft PowerPoint or Google Slides, is specifically designed to create slide-based presentations with multimedia elements like animations, transitions, and speaker notes. The speaker notes feature allows the presenter to see private notes below each slide while the audience views only the slides, which is a core function of this application type.

Answer

Word processing software.

Answer

Database software.

Answer

Spreadsheet software.

Question 15

A developer writes a Python script that processes user input. During execution, the script prompts for an age and stores it in a variable. Which data type is most appropriate for the variable that stores the age?

Accepted Answer

Integer. An age is a whole number of years, so the Integer type is the natural fit. Python's int type stores whole numbers without a fractional component and supports arithmetic operations directly. Using Integer avoids unnecessary type conversions and preserves numeric semantics for comparisons and calculations.

Answer

Float

Answer

Boolean

Answer

String

Question 16

Which TWO of the following are valid SQL functions used to aggregate data?

Accepted Answer

COUNT. COUNT (option A) is a valid SQL aggregate function that returns the number of rows or non-NULL values in a column, commonly used with GROUP BY to summarize data. SUM (option C) is also a valid SQL aggregate function that returns the total sum of a numeric column, making it a standard tool for data aggregation. The other options are not aggregate functions: SORT (option B) is not a SQL function (ordering is done with ORDER BY), LENGTH (option D) is a scalar string function that returns the character length of a value, and APPEND (option E) is not a standard SQL function at all.

Answer

SORT

Answer

LENGTH

Answer

APPEND

Question 17

A technician is upgrading a desktop computer's memory. Which component would the technician most likely replace to improve system performance using dual-channel architecture?

Accepted Answer

RAM. RAM is correct because dual-channel architecture requires installing memory modules in matched pairs in specific slots on the motherboard, which doubles the memory bandwidth. Upgrading RAM by adding a second matching module enables dual-channel operation, improving system performance for memory-intensive tasks. The question asks which component to replace to improve performance using dual-channel architecture, and RAM is the only component that directly relates to dual-channel memory.

Answer

GPU

Answer

Storage drive

Answer

CPU

Question 18

A developer is creating a program that must respond to user actions such as button clicks and mouse movements. Which programming paradigm is most suitable?

Accepted Answer

Event-driven programming. Event-driven programming is the most suitable paradigm because it is designed to handle asynchronous user actions like button clicks and mouse movements. In this paradigm, the program's flow is determined by events (e.g., user inputs), and callback functions or event handlers are triggered in response. This aligns directly with the requirement to respond to unpredictable, external stimuli.

Answer

Object-oriented programming

Answer

Functional programming

Answer

Procedural programming

Question 19

Which of the following correctly declares a variable to store a person's age in Python?

Accepted Answer

age = 25. In Python, variables are created by assignment with the `=` operator, and no explicit type declaration is needed. Option D correctly assigns the integer value 25 to the variable `age` using `age = 25`, which is the proper syntax for declaring and initializing a variable in Python.

Answer

var age = 25

Answer

int age = 25

Answer

age == 25

Question 20

A user wants to synchronize contacts, calendars, and photos between their Android smartphone and tablet. Which of the following methods would best accomplish this?

Accepted Answer

Configure Google account sync. Configuring a Google account sync on both Android devices automatically synchronizes contacts, calendars, and photos via the cloud. This is the most efficient method for keeping data consistent across multiple devices. Thus, A is correct.

Answer

Pair via Bluetooth

Answer

Use a USB cable to transfer files

Answer

Use an SD card