FC0-U71 Practice Test 15 — 15 Questions

Question 1

Which of the following is an example of a NoSQL database that stores data as JSON-like documents?

Accepted Answer

MongoDB. MongoDB is a document-oriented NoSQL database that stores data in BSON (Binary JSON) documents, making it the canonical example of a JSON-like document store. It allows flexible, schema-less documents and is widely used for content management, catalogs, and real-time analytics.

Answer

MySQL

Answer

PostgreSQL

Answer

SQLite

Question 2

A small independent bookstore has been operating for several years using a single Microsoft Excel spreadsheet to manage its inventory, sales, and customer data. The spreadsheet contains over 10,000 rows and is shared among five employees. Recently, employees have noticed recurring data quality issues: the same book appears multiple times in the inventory list with different prices, some sales records reference book titles that do not exist in the inventory, and customer contact information is duplicated across rows. Because there are no constraints, employees can enter any value into any cell. The owner wants to implement a more robust system to eliminate data redundancy and ensure data integrity. The bookstore has a budget for new software and some technical support. The owner is not very technical but is willing to hire a consultant. Which action should be taken to best address these problems?

Accepted Answer

Migrate to a relational database with normalized tables and foreign key constraints. Migrating to a relational database with normalized tables and foreign key constraints directly addresses the data redundancy and integrity issues. Normalization splits data into separate tables (e.g., Books, Sales, Customers) to eliminate duplicate entries, while foreign key constraints ensure that every sales record references a valid book and that customer data is stored once. This approach enforces referential integrity and prevents the anomalies seen in the flat spreadsheet.

Answer

Use a single flat file for all data to simplify data entry

Answer

Implement a NoSQL database for flexibility

Answer

Continue using the spreadsheet but add data validation rules to restrict input

Question 3

A database administrator adds an index on the 'Email' column of a 'Users' table. What is a likely consequence?

Accepted Answer

Slower update operations on the table. Adding an index on the 'Email' column improves the speed of SELECT queries that filter or sort by that column, but it introduces overhead on write operations. Every time a row is inserted, updated, or deleted, the database must also update the index structure (e.g., a B-tree). This additional work makes UPDATE operations slower, which is why option C is correct.

Answer

Reduced storage space

Answer

Improved query performance for all queries

Answer

Faster inserts on the table

Question 4

Which of the following storage types uses spinning platters to read and write data?

Accepted Answer

HDD. HDDs (Hard Disk Drives) use spinning magnetic platters, while SSDs use flash memory.

Answer

SSD

Answer

RAM

Answer

Cache

Question 5

Which TWO of the following are examples of multi-factor authentication?

Accepted Answer

A smart card and a PIN. It combines two distinct authentication factors: something you have (the smart card) and something you know (the PIN), which is the definition of multi-factor authentication. Option C (a password and a fingerprint scan) is also correct because it pairs something you know (the password) with something you are (the fingerprint biometric), satisfying MFA's requirement for different factor categories. Option B (two different passwords) is not MFA because both are the same factor type—something you know—so it is merely multi-instance, not multi-factor. Option D (a username and a password) is not MFA because a username is an identifier, not an authentication factor, and the password alone represents a single factor. Option E (a password and a security question) is not MFA because both are knowledge-based factors (something you know), so they belong to the same factor category.

Answer

Two different passwords

Answer

A username and a password

Answer

A password and a security question

Question 6

A software developer writes code that stores sensitive user data. To comply with data protection regulations, which application-level security measure should be implemented?

Accepted Answer

Use encryption for data storage and transmission.. Encryption (e.g., AES-256 for data at rest and TLS 1.3 for data in transit) renders sensitive user data unreadable to unauthorized parties, directly addressing data protection regulations such as GDPR or HIPAA that mandate confidentiality. This is an application-level security measure implemented within the software code or database layer, not a network or perimeter control.

Answer

Install a firewall on the server.

Answer

Run regular antivirus scans.

Answer

Require multi-factor authentication for login.

Question 7

Which TWO of the following are examples of open-source software licenses?

Accepted Answer

GNU GPL. The GNU GPL (B) is a canonical open-source license: it grants users the freedom to run, study, share, and modify the software, and its copyleft provision requires derivative works to be distributed under the same license terms. The MIT License (C) is also a permissive open-source license that allows reuse, modification, and redistribution with minimal conditions, typically just preserving the copyright notice and license text. By contrast, the Apple App Store License (A), Microsoft EULA (D), and Adobe EULA (E) are proprietary end-user license agreements that restrict copying, modification, and redistribution, so they are not open-source licenses.

Answer

Apple App Store License

Answer

Microsoft EULA

Answer

Adobe EULA

Question 8

A company wants to deploy a custom application to 500 employees. The IT team needs to ensure each workstation has the same version and configuration. Which deployment method should be used?

Accepted Answer

Use Group Policy to publish the application to all workstations.. Group Policy (GPO) allows centralized deployment of software via Active Directory, ensuring all workstations receive the same version and configuration automatically during startup or user logon. This method uses the Windows Installer service (MSI) and can assign or publish applications, enforcing consistency without user intervention. It is the only option that guarantees uniform deployment across 500 machines with minimal administrative overhead.

Answer

Place the installer on a network share and instruct users to run it.

Answer

Distribute USB drives with the installer to each employee.

Answer

Email the installer to all employees.

Question 9

Two developers have edited the same file and created different versions. To integrate their changes, which Git operation should they perform?

Accepted Answer

git merge. The git merge command is used to integrate changes from one branch into another, combining the histories of both branches. When two developers have edited the same file in different branches, merging brings their changes together into a single branch, resolving any conflicts. This is the standard operation for integrating divergent work.

Answer

git pull

Answer

git rebase

Answer

git commit

Question 10

Based on the exhibit, what will be the last value output?

Accepted Answer

5. The loop runs while count <= 5. It outputs 1,2,3,4,5. The last output is 5. Then count becomes 6 and loop exits. 1 is first, 6 is not output because loop ends.

Answer

6

Answer

10

Answer

1

Question 11

Given the following pseudocode that calculates the average of a list of numbers, which error will occur?

SET total = 0
SET count = 0
FOR EACH number IN list
   total = total + number
   count = count + 1
ENDFOR
SET average = total / count
OUTPUT average

Accepted Answer

Runtime error. The pseudocode computes an average by dividing `total` by `count`. If the list is empty, `count` remains 0, and division by zero is a runtime error. This error occurs during execution, not during compilation or syntax checking, and is not a logic error because the code is logically correct for non-empty lists.

Answer

Compile-time error

Answer

Logic error

Answer

Syntax error

Question 12

A user wants to install a free text editor on their Windows computer. Which file extension is most likely used for the installer?

Accepted Answer

.exe. On Windows, executable installers most commonly use the .exe extension (and .msi for Windows Installer packages). A free text editor for Windows would therefore be distributed as an .exe installer. The other extensions belong to different operating systems.

Answer

.deb

Answer

.dmg

Answer

.pkg

Question 13

Match each network protocol to its well-known port number.

Accepted Answer

HTTP: 80. HTTP uses port 80 (A is correct). HTTPS uses port 443 (B is correct). FTP uses port 21 (C is correct). SSH uses port 22 (D is correct). SMTP uses port 25, not 53, so E is incorrect. DNS uses port 53, not 25, so F is incorrect.

Answer

SMTP: 53

Answer

DNS: 25

Question 14

Which TWO of the following are common causes of errors when executing a SELECT query? (Choose two.)

Accepted Answer

Incorrect column name. Option B (Incorrect column name) is correct because a SELECT statement referencing a column that does not exist in the target table will fail with an error such as 'Unknown column' in MySQL or 'Invalid column name' in SQL Server, since the parser cannot resolve the identifier against the table's schema. Option D (Missing table name) is correct because a SELECT query must specify a FROM clause with a valid table (or equivalent source); omitting it or naming a nonexistent table produces errors like 'No tables used' or 'Table doesn't exist'. Option A (Table is too large) is not a cause of query errors—large tables may affect performance, but the query still executes correctly. Option C (Index is missing) is not an error cause either; a missing index only slows execution, and the query returns correct results via a full scan. Option E (Network is slow) is unrelated to query correctness—it may cause timeouts or latency but does not itself make a SELECT statement erroneous.

Answer

Table is too large

Answer

Index is missing

Answer

Network is slow

Question 15

Which SQL statement is used to retrieve all columns from a table named 'Employees'?

Accepted Answer

SELECT * FROM Employees. SELECT * FROM Employees is the correct SQL statement to retrieve all columns from the Employees table. SELECT * specifies all columns, and FROM identifies the table. No WHERE clause is needed because the question asks for all rows.

Answer

RETRIEVE Employees

Answer

SHOW * FROM Employees

Answer

GET * FROM Employees