FC0-U71 Practice Test 25 — 15 Questions

Question 1

Which TWO of the following are key characteristics of a NoSQL database compared to a traditional relational database?

Accepted Answer

Flexible schema design. NoSQL databases often use flexible schemas (allowing varied data structures) and can scale horizontally across many servers.

Answer

Strict schema enforcement

Answer

Uses SQL as the query language

Answer

ACID transactions are always guaranteed

Question 2

An online store uses a relational database with tables: Customers, Orders, and Products. Which of the following are valid ways to query the database structure? (Select THREE.)

Accepted Answer

DESCRIBE Customers. SELECT retrieves data, SHOW TABLES lists tables in MySQL, and DESCRIBE shows column info. INSERT adds data, not structure.

Answer

SELECT * FROM Customers

Answer

INSERT INTO Customers VALUES (...)

Question 3

A user receives an email that appears to be from their bank, asking them to click a link and verify their account details. The email contains urgent language and threats of account closure. What type of attack is this?

Accepted Answer

Phishing. Phishing is a social engineering attack where attackers impersonate a legitimate entity to steal sensitive information.

Answer

Spear phishing

Answer

Smishing

Answer

Vishing

Question 4

Which THREE of the following are effective methods to protect against malware infections? (Select THREE.)

Accepted Answer

Install and maintain antivirus software. Antivirus software detects and removes malware; keeping software updated patches vulnerabilities; using a firewall blocks malicious traffic. Disabling software updates would increase risk, and opening all email attachments is dangerous.

Answer

Open all email attachments regardless of sender

Answer

Disable automatic software updates to avoid changes

Question 5

A database administrator needs to choose a database for an e-commerce application that requires high availability and automatic scaling. Which TWO options are cloud database services?

Accepted Answer

Google Cloud SQL. Amazon RDS and Google Cloud SQL are cloud-based DBaaS offerings.

Answer

SQLite

Answer

Microsoft SQL Server Express

Answer

MySQL Community Edition

Question 6

A company needs to store customer orders and ensure that each order is uniquely identified. Which database concept should be used?

Accepted Answer

Primary key. A primary key uniquely identifies each row in a table, ensuring no duplicates and no null values.

Answer

Constraint

Answer

Index

Answer

Foreign key

Question 7

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) format.

Answer

MySQL

Answer

PostgreSQL

Answer

SQLite

Question 8

Which TWO of the following are characteristics of a relational database? (Select TWO.)

Accepted Answer

Data is stored in tables with rows and columns.. Relational databases store data in tables and enforce relationships through keys.

Answer

It does not support SQL queries.

Answer

It is optimized for storing unstructured data like videos.

Answer

It uses a flexible schema that can change dynamically.

Question 9

In a relational database, which type of relationship is typically implemented by creating a third table (junction table) that contains foreign keys from both related tables?

Accepted Answer

Many-to-many. Many-to-many relationships require a junction table to associate records from both sides.

Answer

Self-referencing

Answer

One-to-one

Answer

One-to-many

Question 10

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

Accepted Answer

JOIN. JOIN clauses, such as INNER JOIN, combine rows from two tables based on a related column.

Answer

GROUP BY

Answer

ORDER BY

Answer

WHERE

Question 11

Which of the following malware types is characterized by self-replication without needing to attach to a host file?

Accepted Answer

Worm. A worm is standalone malware that replicates itself to spread to other computers, often using network connections.

Answer

Virus

Answer

Trojan

Answer

Ransomware

Question 12

A user needs to retrieve all product names and prices from a table named 'Products' where the price is greater than 50. Which SQL statement should be used?

Accepted Answer

SELECT name, price FROM Products WHERE price > 50;. The SELECT statement with a WHERE clause filters rows based on a condition.

Answer

GET name, price FROM Products WHERE price > 50;

Answer

SELECT name, price FROM Products;

Answer

SELECT * FROM Products WHERE price > 50;

Question 13

Which THREE of the following are examples of multi-factor authentication? (Select three.)

Accepted Answer

A smart card and a PIN. MFA requires two or more different factors: something you know, something you have, and something you are. Each correct answer uses at least two distinct factors.

Answer

A retina scan and a fingerprint scan

Answer

A username and password

Question 14

Which TWO of the following are examples of popular relational database management systems (RDBMS)? (Select TWO.)

Accepted Answer

MySQL. MySQL and PostgreSQL are both widely used relational databases.

Answer

Cassandra

Answer

MongoDB

Answer

Redis

Question 15

Which TWO of the following are examples of NoSQL database types?

Accepted Answer

Document store. Document stores (e.g., MongoDB) and key-value stores (e.g., Redis) are NoSQL types.

Answer

Spreadsheet

Answer

Relational database

Answer

Flat file