Cybersecurity-Architecture-and-Engineering Exam dumps PDF (Page: 4)

QUESTION: 25

What does the following SQL statement produce when executed?

SELECT ` FROM Customers

WHERE State = 'Arizona';

All of the records from the Customers table
All of the records from the Customers database
All of the records from the Customers database that are located in Arizona
All of the records from the Customers table that are located in Arizona

Answer(s): D

Explanation:

The SQL statementSELECT * FROM Customers WHERE State = 'Arizona';is used to select records from theCustomerstable.

TheSELECT *clause indicates that all columns from theCustomerstable should be returned.

TheWHEREclause filters the rows to only include those where theStatecolumn value is'Arizona'.

The result is a subset of theCustomerstable with all rows that match the condition.

Reference:

"SQL For Dummies" by Allen G. Taylor.

"SQL Pocket Guide" by Jonathan Gennick.

Reveal Solution Next Question

QUESTION: 26

What is true about an operating system?

It is a firmware burned onto the computer mother board.
It is a software program that directly supports the computer itself.
It is a hardware component of the computer system.
It is an application program similar to word processors.

Answer(s): B

Explanation:

Anoperating system (OS)is a system software that manages computer hardware and software resources and provides common services for computer programs.

It serves as an intermediary between users and the computer hardware.

Key functionsof an OS include:

Managinghardware resourceslike the CPU, memory, and I/O devices.

Providing auser interface(UI) for interaction with the system.

File managementand handling file operations.

Process managementand multitasking.

Securityand access control.

Examples include Windows, Linux, and macOS.

Reference:

"Operating System Concepts" by Abraham Silberschatz, Greg Gagne, and Peter B. Galvin.

"Modern Operating Systems" by Andrew S. Tanenbaum.

Reveal Solution Next Question

QUESTION: 27

What does the following SQL statement produce when executed?

SELECT ` FROM Customers

WHERE State = 'Arizona';

All of the records from the Customers table
All of the records from the Customers database
All of the records from the Customers database that are located in Arizona
All of the records from the Customers table that are located in Arizona

Answer(s): D

Explanation:

The SQL statement provided is:

SELECT*FROMCustomersWHEREState ='Arizona';

SELECT *indicates that all columns from the table should be selected.

FROM Customersspecifies the table from which to retrieve the data.

WHERE State = 'Arizona'filters the results to include only those records where the State column has the value 'Arizona'.

Therefore, the statement returns all records from the Customers table that are located in Arizona.

Reference:

SQL SELECT statement documentation: SQL SELECT

SQL WHERE clause documentation: SQL WHERE

Reveal Solution Next Question

QUESTION: 28

How does application software differ from operating systems?

Choose 2 answers

Application software includes system utilities that run on demand of the user.
Application software consists of programs that end users run to accomplish business or personal tasks, such as e-mail.
Application software includes word processors and spreadsheet software that are useful to end users.
Application software supports the computer hardware system directly.

Answer(s): B,C

Explanation:

Application Software:

Application software refers to programs that help end users perform specific tasks. Examples include email clients, word processors, and spreadsheet programs.

These are designed to be used by people to perform tasks such as writing documents, managing data, or communicating.

Operating Systems:

Operating systems (OS) manage the hardware and software resources of a computer system. They provide a platform for application software to run.

Examples include Microsoft Windows, macOS, and Linux. The OS handles system-level tasks like memory management, process scheduling, and hardware interaction.

Key Differences:

Application software (B, C) is user-oriented, aimed at helping users complete tasks.

Operating systems (A, D) manage the computer's hardware and system resources.

Reference:

Application software: Application Software

Operating system functions: Operating System Functions

Reveal Solution Next Question

QUESTION: 29

What are three operating systems that are commonly used today?

Choose 3 answers

Microsoft Outlook
Mac OS
Linux
MySQL
Microsoft Windows
Mozilla Firefox

Answer(s): B,C,E

Explanation:

Operating Systems:

Operating systems are software that manage computer hardware and software resources, providing common services for computer programs.

Commonly Used Operating Systems:

Mac OS: Developed by Apple Inc., used on Apple computers.

Linux: An open-source operating system used on a wide variety of devices from servers to personal computers.

Microsoft Windows: Developed by Microsoft, it is one of the most widely used operating systems for personal and business computers.

Not Operating Systems:

Microsoft Outlook: An email client, part of the Microsoft Office suite.

MySQL: A relational database management system.

Mozilla Firefox: A web browser.

Reference:

Types of operating systems: Types of Operating Systems

Mac OS:macOS

Linux:Linux

Microsoft Windows:Windows

Reveal Solution Next Question

QUESTION: 30

What is a function of a proxy server?

It stores files that any user of the network may wish to access.
It acts as a giant cache of web pages that anyone in the organization has recently retrieved.
It responds to user queries to create, manipulate, and retrieve records from a database.
It responds to HTTP requests and can execute scripts to generate dynamic pages.

Answer(s): B

Explanation:

Proxy Server Functions:

Caching: Proxy servers can store copies of web pages and other web resources. This helps to improve load times for frequently accessed resources and reduce bandwidth usage.

Security: They can provide additional security by anonymizing the user's IP address and filtering unwanted content.

Correct Function:

Acting as a cache (B) is one of the primary functions, where it stores web pages that users in the organization have recently accessed.

Incorrect Functions:

A: Describes a file server.

C: Describes a database server.

D: Describes a web server.

Reference:

Proxy servers: Proxy Server

Caching in proxy servers:Caching Proxy

Reveal Solution Next Question

QUESTION: 31

Which characteristic identifies intranet application software?

Hosted by an outsourced provider
Hosted in the internal business network
Hosted by a third-party web portal
Hosted on an individual computer

Answer(s): B

Explanation:

Intranet Application Software:

Intranet applications are designed to be used within an organization's internal network. They are not accessible from outside the organization unless through a secure connection like a VPN.

Characteristics:

Internal Hosting: These applications are hosted on servers within the business network, ensuring that only authorized internal users can access them.

Security: Since they are hosted internally, they can be secured with internal security measures like firewalls and access controls.

Incorrect Options:

A: Describes applications hosted by external providers.

C: Describes applications hosted by third-party web portals.

D: Describes standalone applications on individual computers.

Reference:

Intranet applications: Intranet Applications

Reveal Solution Next Question

QUESTION: 32

What type of software utilizes a commercial software license?

Public Domain
Proprietary
Open Source
Shareware

Answer(s): B

Explanation:

Proprietary softwareis a type of software that is owned by an individual or a company.

It is usually sold commercially and comes with acommercial software license.

This type of license typically restricts the ways in which the software can be used, modified, and distributed.

Users must agree to the terms of the license, which often include restrictions on copying, sharing, and modifying the software.

Example:Microsoft Windows and Adobe Photoshop are proprietary software products.

Reference:

"The Cathedral and the Bazaar" by Eric S. Raymond.

"Understanding Open Source and Free Software Licensing" by Andrew M. St. Laurent.

Reveal Solution Next Question

WGU Cybersecurity-Architecture-and-Engineering Exam (page: 4) WGU Cybersecurity Architecture and Engineering (KFO1/D488) Updated on: 24-Mar-2026

QUESTION: 25

Explanation:

Reference:

QUESTION: 26

Explanation:

Reference:

QUESTION: 27

Explanation:

Reference:

QUESTION: 28

Explanation:

Reference:

QUESTION: 29

Explanation:

Reference:

QUESTION: 30

Explanation:

Reference:

QUESTION: 31

Explanation:

Reference:

QUESTION: 32

Explanation:

Reference:

WGU Cybersecurity-Architecture-and-Engineering Exam (page: 4)
WGU Cybersecurity Architecture and Engineering (KFO1/D488)
Updated on: 24-Mar-2026