FC0-U71 Practice Test 16 — 15 Questions

Question 1

A company wants to use a cloud service where they can deploy their own applications on virtual machines without managing the underlying hardware. Which cloud service model best fits this requirement?

Accepted Answer

Infrastructure as a Service (IaaS). IaaS provides virtualized compute, storage, and networking resources where the customer manages the OS, middleware, and applications while the provider manages the physical hardware and hypervisor. Deploying your own applications on VMs without managing hardware is the textbook definition of IaaS (e.g., Amazon EC2).

Answer

Software as a Service (SaaS)

Answer

Function as a Service (FaaS)

Answer

Platform as a Service (PaaS)

Question 2

A SELECT statement combines rows from two tables based on a related column. Which SQL clause is used to accomplish this?

Accepted Answer

JOIN. The JOIN clause combines rows from two or more tables based on a related column, such as a primary key to foreign key relationship. INNER JOIN returns matching rows, while LEFT/RIGHT/FULL OUTER JOINs include unmatched rows. This is the standard SQL mechanism for relational row combination.

Answer

GROUP BY

Answer

ORDER BY

Answer

WHERE

Question 3

A developer is writing a program in C++. The source code needs to be translated into machine code before execution. Which process is required?

Accepted Answer

Compilation. Compilation is the process required to translate C++ source code into machine code before execution. The compiler converts the high-level code into an executable format.

Answer

Interpretation

Answer

Linking

Answer

Debugging

Question 4

Which of the following best describes a web application?

Accepted Answer

An application that runs within a web browser and processes data on a server. A web application is defined as an application that runs within a web browser and processes data on a server. This matches option C. The client-side runs in the browser, and server-side logic handles data processing.

Answer

An application that runs only on mobile devices

Answer

An application installed locally that has direct hardware access

Answer

An application that connects services using APIs

Question 5

A user wants to install software on a Linux system. Which file types are most commonly used for installing applications?

Accepted Answer

.deb and .rpm. On Linux, the two dominant package formats are .deb (used by Debian, Ubuntu, and derivatives via dpkg/apt) and .rpm (used by Red Hat, Fedora, CentOS, and SUSE via rpm/dnf/yum). These are the standard installer file types for Linux distributions.

Answer

.dmg and .pkg

Answer

.app and .apk

Answer

.exe and .msi

Question 6

A user wants to connect a modern monitor to their laptop using a single cable that can carry both video and audio signals. Which port on the laptop should they use?

Accepted Answer

HDMI. HDMI (High-Definition Multimedia Interface) carries both digital video and audio over a single cable, making it the correct choice for connecting a modern monitor with integrated speakers or a TV. It supports high resolutions and is ubiquitous on laptops and monitors. This satisfies the requirement of a single cable for both signals.

Answer

USB-A

Answer

VGA

Answer

DVI

Question 7

Which of the following character encoding standards supports characters from most of the world's languages and uses a variable number of bytes per character?

Accepted Answer

Unicode/UTF-8. Unicode/UTF-8 is a variable-length encoding that can represent characters from virtually all of the world's writing systems, using 1 to 4 bytes per character. UTF-8 is backward-compatible with ASCII for the first 128 code points.

Answer

Base64

Answer

EBCDIC

Answer

ASCII

Question 8

What is the primary purpose of a password manager?

Accepted Answer

To generate and store strong, unique passwords. A password manager's core function is to create high-entropy, unique passwords for every account and store them in an encrypted vault, eliminating password reuse and weak credentials. It uses a master password and strong encryption (e.g., AES-256) to protect the vault, and can auto-fill credentials, reducing human error. While some managers offer cloud sync or sharing, those are secondary features, not the primary purpose.

Answer

To store passwords in the cloud for easy access

Answer

To encrypt all network traffic

Answer

To share passwords securely with team members

Question 9

A database designer wants to enforce that a 'CustomerID' value in an 'Orders' table must exist in the 'Customers' table. Which TWO methods can achieve this?

Accepted Answer

Use a trigger to check existence. Option E is correct because a FOREIGN KEY constraint from Orders.CustomerID referencing Customers.CustomerID is the declarative, purpose-built mechanism for enforcing referential integrity, ensuring every Orders.CustomerID value matches an existing Customers.CustomerID value (or is NULL if allowed). Option C is correct because a trigger (e.g., a BEFORE INSERT/UPDATE trigger that queries Customers for the given CustomerID and raises an error if absent) can also enforce this existence check, which is useful when the referenced column lacks a unique/primary key constraint or when custom logic is needed. Option A is wrong because a UNIQUE constraint on Orders.CustomerID only prevents duplicate values in Orders; it does not verify that the value exists in Customers. Option B is wrong because an index merely speeds up lookups and enforces no referential rule. Option D is wrong because a PRIMARY KEY on Customers.CustomerID guarantees uniqueness in Customers but does not, by itself, constrain or validate the values stored in Orders.CustomerID.

Answer

Create a unique constraint on Orders.CustomerID

Answer

Create an index on Orders.CustomerID

Answer

Create a primary key on Customers.CustomerID

Question 10

Which of the following best describes the principle of confidentiality in the CIA triad?

Accepted Answer

Preventing unauthorized access to information. Confidentiality in the CIA triad means ensuring information is not disclosed to unauthorized individuals, entities, or processes — i.e., preventing unauthorized access to information. It is enforced through encryption, access controls, and authentication. The scenario's phrasing 'preventing unauthorized access to information' is the textbook definition of confidentiality.

Answer

Data is not altered unexpectedly

Answer

Systems are accessible when needed

Answer

Ensuring data is backed up regularly

Question 11

Which TWO of the following are types of cloud computing service models?

Accepted Answer

SaaS. SaaS (Software as a Service) is a cloud computing service model where users access software applications over the internet on a subscription basis, with the provider managing the underlying infrastructure, platform, and application. This model eliminates the need for local installation and maintenance, as seen in services like Google Workspace or Microsoft 365.

Answer

DHCP

Answer

LAN

Answer

VPN

Question 12

A database administrator needs to retrieve all customer names from a table named 'Customers' where the city is 'New York'. Which SQL statement should be used?

Accepted Answer

SELECT Name FROM Customers WHERE City = 'New York'. The SELECT statement is the only SQL command that retrieves data without modifying it. The syntax SELECT Name FROM Customers WHERE City = 'New York' correctly specifies the column to return (Name), the table to query (Customers), and the filter condition (City = 'New York'). This returns exactly the customer names in New York as required.

Answer

UPDATE Customers SET Name = 'New York' WHERE City = 'New York'

Answer

INSERT INTO Customers (Name) VALUES ('New York')

Answer

DELETE FROM Customers WHERE City = 'New York'

Question 13

A small e-commerce website uses a relational database to manage its products and orders. The most common query is retrieving a product by its unique product ID. This query is executed thousands of times per minute. The database currently has no indexes, and the query is slow, causing user-facing delays. The database administrator wants to improve performance with minimal downtime and cost. Which action should be taken first?

Accepted Answer

Add an index on the product ID column. Adding an index on the product ID column creates a B-tree data structure that allows the database to locate rows using a logarithmic search instead of a full table scan. Since the query is executed thousands of times per minute and the table has no indexes, this single-column index directly addresses the bottleneck with minimal downtime and cost, as it requires only a CREATE INDEX statement.

Answer

Partition the table by product category

Answer

Increase the server's memory to allow more caching

Answer

Change the database to a NoSQL system for faster key-value access

Question 14

A programmer needs to store a customer's name in a variable. Which data type is most appropriate?

Accepted Answer

String. A customer's name is a sequence of characters (letters, spaces, possibly punctuation), which is best represented as a String data type. In most programming languages, strings are used to store text and are enclosed in quotes (e.g., "John Doe"). This aligns with the fundamental concept that names are not numeric or logical values.

Answer

Float

Answer

Integer

Answer

Boolean

Question 15

Which of the following RAM types is the fastest and most recent?

Accepted Answer

DDR5. DDR5 is the fastest and most recent RAM type listed, offering higher data rates (starting at 4800 MT/s and scaling beyond 6400 MT/s), lower operating voltage (1.1V vs DDR4's 1.2V), and greater capacity per module. It was introduced for consumer platforms starting with Intel's 12th Gen (Alder Lake) and AMD's Ryzen 7000 series. DDR4, DDR3, and DDR2 are all older generations with progressively lower speeds and higher voltages.

Answer

DDR4

Answer

DDR2

Answer

DDR3