WGU D330 DATA SYSTEMS FINAL EXAM 2024
WGU D330 DATA SYSTEMS FINAL EXAM 2024
PRACTICE QUESTIONS AND ANSWERS
VERIFIED AND GRADED A+ (ALL AREAS
COVERED) LATEST
1. What is the primary purpose of a database management system
(DBMS)?
a) Store data in the cloud
b) Secure data from unauthorized access
c) Provide tools for data storage, retrieval, and management
d) Generate automated reports
Answer: c) Provide tools for data storage, retrieval, and management
2. Which of the following is an example of a relational database?
a) MongoDB
b) MySQL
c) Neo4j
d) DynamoDB
Answer: b) MySQL
,WGU D330 DATA SYSTEMS FINAL EXAM 2024
3. What does the acronym ACID stand for in database transactions?
a) Accuracy, Clarity, Integrity, Durability
b) Atomicity, Consistency, Isolation, Durability
c) Access, Control, Information, Data
d) Analysis, Computation, Iteration, Definition
Answer: b) Atomicity, Consistency, Isolation, Durability
4. What is a primary key in a relational database?
a) A field that identifies a record uniquely
b) A field that allows duplicate values
c) A field used for indexing
d) A field containing metadata
Answer: a) A field that identifies a record uniquely
5. Which SQL command is used to retrieve data from a database?
a) INSERT
b) UPDATE
c) DELETE
d) SELECT
Answer: d) SELECT
, WGU D330 DATA SYSTEMS FINAL EXAM 2024
True/False Questions
6. A foreign key must always reference the primary key of another
table.
Answer: True
7. Indexes improve data retrieval speed but increase storage
requirements.
Answer: True
8. Normalization reduces redundancy in database design.
Answer: True
9. In a star schema, fact tables are surrounded by dimension tables.
Answer: True
10.ETL stands for Extract, Transfer, and Load.
Answer: False (Correct: Extract, Transform, and Load)
Short Answer Questions
11.Explain the difference between OLAP and OLTP.
Answer: OLAP (Online Analytical Processing) is used for analyzing
large volumes of data for decision-making, while OLTP (Online
WGU D330 DATA SYSTEMS FINAL EXAM 2024
PRACTICE QUESTIONS AND ANSWERS
VERIFIED AND GRADED A+ (ALL AREAS
COVERED) LATEST
1. What is the primary purpose of a database management system
(DBMS)?
a) Store data in the cloud
b) Secure data from unauthorized access
c) Provide tools for data storage, retrieval, and management
d) Generate automated reports
Answer: c) Provide tools for data storage, retrieval, and management
2. Which of the following is an example of a relational database?
a) MongoDB
b) MySQL
c) Neo4j
d) DynamoDB
Answer: b) MySQL
,WGU D330 DATA SYSTEMS FINAL EXAM 2024
3. What does the acronym ACID stand for in database transactions?
a) Accuracy, Clarity, Integrity, Durability
b) Atomicity, Consistency, Isolation, Durability
c) Access, Control, Information, Data
d) Analysis, Computation, Iteration, Definition
Answer: b) Atomicity, Consistency, Isolation, Durability
4. What is a primary key in a relational database?
a) A field that identifies a record uniquely
b) A field that allows duplicate values
c) A field used for indexing
d) A field containing metadata
Answer: a) A field that identifies a record uniquely
5. Which SQL command is used to retrieve data from a database?
a) INSERT
b) UPDATE
c) DELETE
d) SELECT
Answer: d) SELECT
, WGU D330 DATA SYSTEMS FINAL EXAM 2024
True/False Questions
6. A foreign key must always reference the primary key of another
table.
Answer: True
7. Indexes improve data retrieval speed but increase storage
requirements.
Answer: True
8. Normalization reduces redundancy in database design.
Answer: True
9. In a star schema, fact tables are surrounded by dimension tables.
Answer: True
10.ETL stands for Extract, Transfer, and Load.
Answer: False (Correct: Extract, Transform, and Load)
Short Answer Questions
11.Explain the difference between OLAP and OLTP.
Answer: OLAP (Online Analytical Processing) is used for analyzing
large volumes of data for decision-making, while OLTP (Online
