- | Page
WGU C175 DATA MANAGEMENT –
FOUNDATIONS EXAM| QUIZ BANK (LATEST)
300+ QUESTIONS AND VERIFIED CORRECT
ANSWERS- 100% CORRECT
When you move data from an unstructured form to a structured form, what benefit do you gain?
a) The ability to use data programmatically
b) The ability to easily locate data
c) The ability to easily sort data
- all of the above
CORRECT ANSWER: All of the above
CORRECT ANSWER: Structuring data enables programmatic
use, easy location, and sorting.
When you store data in a database, what is one advantage you get over a plain spreadsheet?
a) Rows of data can be associated with each other across tables
b) You can keep information stored in a regular, organized way
- | Page
c) You can insert and delete data
d) Data can be sorted by column
CORRECT ANSWER: a - The ability to create relationships
between tables is a core function of relational databases.
CORRECT ANSWER: Relationships across tables enhance data
integrity and querying, unlike spreadsheets.
What is one advantage of using a spreadsheet to store data?
a) It protects data from becoming inconsistent
b) It ensures that the data is correct
c) It protects data from unauthorized changes
d) It can help you see gaps in the data
CORRECT ANSWER: d - when pieces of information are
arranged in a consistent way, it becomes easier to see what information you have.
- | Page
CORRECT ANSWER: Spreadsheets visually highlight missing
data through consistent layout.
The definition of how data in a database will be organized is called the ________?
- setting
- schema
- tables
- layout
CORRECT ANSWER: b - The database’s schema includes the
information about the layout of tables and other information about the database itself.
CORRECT ANSWER: The schema defines structure,
relationships, and constraints.
What are four benefits to utilizing databases?
- | Page
CORRECT ANSWER: - They divide structure to the data
CORRECT ANSWER: - They allow enforcement rules to be
applied to the data
CORRECT ANSWER: - They protect the data from unauthorized
access or changes
CORRECT ANSWER: - They make sure changes only get made
if other associated changes are made successfully
CORRECT ANSWER: These benefits improve organization,
integrity, security, and consistency.
What is a DBMS?