FC0-U71 Practice Exam 53 — 20 Questions

Question 1

A company uses a cloud database service where the provider automatically handles backups, patching, and scaling. This deployment model is known as:

Accepted Answer

Database as a Service (DBaaS). Database-as-a-Service (DBaaS) is a cloud service where the provider manages the database infrastructure.

Answer

Platform as a Service (PaaS)

Answer

Software as a Service (SaaS)

Answer

Infrastructure as a Service (IaaS)

Question 2

Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?

Accepted Answer

SELECT * FROM Customers WHERE city = 'London';. The SELECT statement retrieves data. The correct syntax is: SELECT * FROM Customers WHERE city = 'London';

Answer

RETRIEVE * FROM Customers WHERE city = 'London';

Answer

SELECT * FROM Customers HAVING city = 'London';

Answer

GET * FROM Customers WHERE city = 'London';

Question 3

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

Accepted Answer

SELECT * FROM Employees. The SELECT * statement retrieves all columns from the specified table.

Answer

RETRIEVE Employees

Answer

SHOW * FROM Employees

Answer

GET * FROM Employees

Question 4

Which THREE of the following are types of data integrity enforced in relational databases?

Accepted Answer

Referential integrity. Entity integrity (via primary keys), referential integrity (via foreign keys), and domain integrity (via data types and constraints) are the three main types.

Answer

Network integrity

Answer

File integrity

Question 5

A company stores product data in a MongoDB database. Each product document contains fields like 'name', 'price', and 'tags' (an array). What type of NoSQL database is MongoDB?

Accepted Answer

Document store. MongoDB is a document-oriented NoSQL database that stores data in JSON-like documents.

Answer

Wide-column store

Answer

Graph database

Answer

Key-value store

Question 6

Which of the following is a characteristic of a NoSQL database compared to a relational database?

Accepted Answer

Supports flexible schema. NoSQL databases often have a flexible schema, allowing different structures in the same collection.

Answer

Requires normalized data

Answer

Enforces strict schema definition

Answer

Uses SQL for queries

Question 7

An IT administrator needs to deploy a virtual machine (VM) on a server that will host multiple operating systems. The administrator wants the VM to have dedicated resources and minimal overhead. Which type of hypervisor should be installed on the server?

Accepted Answer

Type 1 hypervisor. Type 1 hypervisor runs directly on hardware, providing better performance and resource allocation.

Answer

Container engine

Answer

Hosted hypervisor

Answer

Type 2 hypervisor

Question 8

Which of the following is a best practice for creating a strong password?

Accepted Answer

Using a long passphrase that includes symbols and numbers. Strong passwords should be at least 12 characters, include a mix of uppercase, lowercase, numbers, and symbols, and should not be reused across accounts.

Answer

Using a password with 8 characters including letters and numbers

Answer

Reusing the same password across multiple sites

Answer

Using your pet's name as a password

Question 9

An organization uses a security model where users are granted the minimum permissions necessary to perform their job functions. This model is known as:

Accepted Answer

Principle of least privilege. The principle of least privilege ensures users have only the access they need, reducing risk of misuse.

Answer

Role-based access control

Answer

Mandatory access control

Answer

Discretionary access control

Question 10

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

Accepted Answer

Preventing unauthorized access to information. Confidentiality ensures that information is not disclosed to unauthorized individuals, systems, or processes.

Answer

Data is not altered unexpectedly

Answer

Systems are accessible when needed

Answer

Ensuring data is backed up regularly

Question 11

Which of the following best describes the principle of least privilege?

Accepted Answer

Users should have the minimum permissions needed to do their job. The principle of least privilege states that users should be granted only the minimum permissions necessary to perform their job functions, reducing potential damage from accidents or attacks.

Answer

Users should have all permissions by default

Answer

Users should use multi-factor authentication

Answer

Users should change passwords every 30 days

Question 12

Which TWO of the following are recommended practices for physical security in an office environment? (Select two.)

Accepted Answer

Locking computer screens when leaving the desk. Locking screens when away prevents unauthorized access; shredding documents ensures sensitive information is not readable.

Answer

Writing passwords on sticky notes and attaching them to monitors

Answer

Sharing access badges with colleagues

Answer

Leaving doors propped open for convenience

Question 13

Which of the following is a key difference between a vulnerability and a threat in cybersecurity?

Accepted Answer

A vulnerability is a weakness, while a threat is a potential danger. A vulnerability is a weakness that could be exploited, while a threat is a potential danger (e.g., a hacker or malware) that could exploit that vulnerability.

Answer

A vulnerability is a potential harm, while a threat is a weakness

Answer

A vulnerability is always present, while a threat is actively exploited

Answer

A vulnerability can be patched, but a threat cannot be mitigated

Question 14

Which of the following is the best practice for creating strong passwords?

Accepted Answer

Use a random combination of uppercase, lowercase, numbers, and symbols of at least 12 characters. A strong password should be at least 12 characters long and include a mix of character types.

Answer

Use your birthday and pet's name

Answer

Use a common phrase with numbers replacing letters

Answer

Use the same password for all accounts but change it monthly

Question 15

What is the primary purpose of a password manager?

Accepted Answer

To generate and store strong, unique passwords. Password managers generate and store complex, unique passwords for each account, reducing password reuse and improving security.

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 16

A small business with 50 employees currently hosts its email and file-sharing server on-premises on a single physical server. The server is experiencing frequent hardware failures, causing downtime and data loss. The owner wants a solution that improves reliability, scalability, and reduces the need for in-house maintenance. The company has a limited IT budget and wants to avoid large upfront hardware costs. The owner is concerned about data security and compliance but is open to cloud solutions. As an IT consultant, which of the following would be the best recommendation?

Accepted Answer

Migrate to a public cloud IaaS solution. (Migrate to a public cloud IaaS solution) is correct because it provides scalability, high availability, and reduces maintenance overhead without large upfront costs. Cloud providers offer robust security and compliance features, addressing the owner's concerns. Option A (regular backup) is incorrect because backup alone does not prevent downtime; it only enables recovery after a failure. Option C (more powerful server) is incorrect because it still relies on a single physical server and does not eliminate hardware failure risk. Option D (peer-to-peer network) is incorrect because it lacks centralized management and reliability, making it unsuitable for a 50-user business.

Answer

Implement a regular backup strategy

Answer

Purchase a more powerful on-premises server

Answer

Move to a peer-to-peer network

Question 17

A developer needs to track changes to source code over time, collaborate with other developers, and maintain a history of all modifications. Which tool is specifically designed for these tasks?

Accepted Answer

Git. Git is a version control system that tracks changes, enables collaboration, and maintains a history. An IDE is for writing code, a debugger finds errors, and a text editor edits text files but lacks version control features.

Answer

Text editor

Answer

Integrated Development Environment (IDE)

Answer

Debugger

Question 18

A company is deploying a new customer relationship management (CRM) software. The software requires each user to have a unique login. Which of the following best describes this type of licensing?

Accepted Answer

Subscription license.. A subscription license grants the right to use software for a specific period, typically requiring recurring payments. In this scenario, each user needs a unique login, which aligns with a per-user subscription model where access is tied to individual accounts and renewed periodically. This is distinct from other licensing types that do not enforce per-user uniqueness or time-limited access.

Answer

Site license.

Answer

Volume license.

Answer

Perpetual license.

Question 19

Refer to the exhibit. A technician is investigating a computer that randomly restarts. Based on the log, what should the technician check?

Accepted Answer

Power supply and connections. The log shows a 'Kernel-Power' event (ID 41) with no clear error before the restart, which typically indicates an unexpected loss of power. This points directly to a failing power supply or loose connections, as the system cannot maintain stable voltage under load. Checking the power supply and its connections is the first step in diagnosing random restarts caused by power instability.

Answer

CPU cooling fan for proper operation

Answer

Recently installed device drivers

Answer

Memory modules for errors

Question 20

A user cannot connect to the internet. The network uses DHCP. Based on the exhibit, what is the most likely cause?

Accepted Answer

DHCP server is not responding. The exhibit shows an APIPA address (169.254.x.x), which indicates that the client failed to obtain a DHCP lease. Since the network uses DHCP, the most likely cause is that the DHCP server is not responding, preventing the client from receiving a valid IP configuration.

Answer

IP address conflict

Answer

Incorrect subnet mask

Answer

No default gateway configured