Demo WGU Data-Management-Foundations Exam Questions

A Database Administrator (DBA) is responsible for the management, security, and performance of a
database system. This includes controlling access to data, ensuring database integrity, optimizing  performance, managing backups, and protecting the system from unauthorized access.
Option A (Incorrect): A DBA is not just a consumer of data but is primarily responsible for the
database’s management.
Option B (Correct): Security is one of the key responsibilities of a DBA, including enforcing user
access controls and implementing encryption and authentication mechanisms.
Option C (Incorrect): While DBAs work with data structures, it is typically the role of a data architect
or database designer to define data formats and schema structures.
Option D (Incorrect): Developing application programs that interact with the database is typically the
role of software developers or database programmers, not DBAs.
Reference: Database Administration best practices from SE 3050 zyBooks.

A data type defines the kind of data a column can store in a database. It ensures data consistency and
efficient storage.
Option A (Correct): A data type is a named set of values, such as INTEGER, VARCHAR, DATE, etc.
Option B (Incorrect): A tuple refers to a row in a relational database, not a data type.
Option C (Incorrect): Data types define column values, but they do not correspond directly to
columns.
Option D (Incorrect): Data types do not have a varying set of rows; they define attributes for columns.
Reference: Data types in relational databases.

An aggregate function performs a calculation over multiple rows and returns a single value.
Examples include SUM(), AVG(), MAX(), MIN(), and COUNT() in SQL.
Option A (Correct): Aggregate functions compute values over a set of rows, like summing total sales
or averaging grades. Option B (Incorrect): Selecting rows that appear in one table but not another is done using set

operations (EXCEPT or MINUS in SQL).

Option C (Incorrect): Eliminating columns is done using the PROJECT operation or SELECT with

specific columns.

Option D (Incorrect): Combining rows from two tables refers to a JOIN operation, not aggregation.

Reference: Aggregate functions in relational algebra.