Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. WGU
  5. Cybersecurity-Architecture-and-Engineering

WGU Cybersecurity-Architecture-and-Engineering Exam Questions
WGU Cybersecurity Architecture and Engineering (KFO1/D488) (Page 6 )

Updated On: 27-Feb-2026
Page 6 of 48
PDF with 232 Questions

What is the typical organizing principle of a database?

  1. Selective
  2. Projection
  3. Relational
  4. Modular

Answer(s): C

Explanation:

The relational model is the most common organizing principle of databases. In a relational database, data is organized into tables (or relations), where each table consists of rows and columns. Each row represents a record with a unique identifier, and each column represents a data field. This model allows for easy data retrieval and management through the use of structured query language (SQL).



Which database has multiple tables with interrelated fields?

  1. Interrelated
  2. Hierarchical
  3. Flat file
  4. Relational

Answer(s): D

Explanation:

Arelational databaseis structured to recognize relations among stored items of information.

Multiple tablesin a relational database can have interrelated fields.

These relationships are often managed throughforeign keys, which reference the primary keys of other tables.

This relational model allows for complex queries and data integrity across the database.

Example:Tables such asCustomers,Orders, andProductsin a sales database, whereOrderstable may reference bothCustomersandProductstables to establish relationships.


Reference:

"Database System Concepts" by Silberschatz, Korth, and Sudarshan.

"SQL and Relational Theory" by C.J. Date.



Which task is the responsibility of a database administrator?

  1. Installing and configuring databases
  2. Compiling code into an executable file
  3. Deciding on database applications for the company
  4. Troubleshooting network security issues

Answer(s): A

Explanation:

ADatabase Administrator (DBA)is responsible for managing the database infrastructure.

Primary responsibilitiesinclude:

Installing and configuringnew databases and database servers.

Ensuring databases run efficiently and are properly maintained.

Performingbackup and recoveryoperations to prevent data loss.

Monitoring performanceand tuning databases for optimal performance.

Implementingsecurity measuresto protect the database against unauthorized access.


Reference:

"Database Administration: The Complete Guide to DBA Practices and Procedures" by Craig S. Mullins.

Oracle and Microsoft SQL Server official documentation.



Which two options allow an application to access a database?

Choose 2 answers

  1. Structured Query Language (SQL)
  2. Java Database Connectivity (JDBC)
  3. Database management system (DBMS)
  4. Open Database Connectivity (ODBC) application
  5. Graphical user interface (GUI)

Answer(s): A,B

Explanation:

SQLis a standard language used to communicate with and manage databases. It allows applications to perform operations such as querying, updating, and managing data.

JDBCis an API in Java that enables Java applications to interact with databases. It provides methods for querying and updating data in a database using SQL.

DBMS (Database Management System)is the system software for creating and managing databases but not directly used by applications for database access.

ODBC (Open Database Connectivity)is another standard API but specific to applications in a broader range of languages and platforms.

GUI (Graphical User Interface)is a user interface and not a method for applications to access databases.


Reference:

"SQL: The Complete Reference" by James R. Groff and Paul N. Weinberg.

"Java Database Connectivity: JDBC and Java" by Daniel K. Akers.



What does the following SQL statement produce when executed?

SELECT ` FROM Customers

WHERE State = 'Arizona';

  1. All of the records from the Customers table
  2. All of the records from the Customers database
  3. All of the records from the Customers database that are located in Arizona
  4. 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.






Post your Comments and Discuss WGU Cybersecurity-Architecture-and-Engineering exam dumps with other Community members:

Join the Cybersecurity-Architecture-and-Engineering Discussion