D651|WGU D651 |Data Management and Analytics | Objective Assessment|1005 Verified Questions & Answers| Latest Updated

WGU D651 – Data Management and Analytics |
Objective Assessment


1. Which of the following best defines
structured data?
A. Data stored in text documents with no fixed
format
B. Data that is organized in rows and columns in
a database (Correct Answer)
C. Data in video and audio
formats
D. Data that cannot be analyzed
Rationale: Structured data resides in organized
formats like relational databases, making it
easily searchable and analyzable.

2. What is the main purpose of a primary key
in a relational database?

,A. To encrypt data
B. To uniquely identify each record in a table
(Correct Answer)
C. To link to an external file
D. To store numeric data
Rationale: A primary key ensures each record is
unique and facilitates data integrity.

3. In SQL, which command is used to retrieve
data from a table?
A. INSERT
B. UPDATE
C. SELECT (Correct Answer)
D. DELETE
Rationale: SELECT is the SQL command used to
query and retrieve data from tables.

, 4. Which of the following is an example of a
NoSQL database?
A. MySQL
B. MongoDB (Correct Answer)
C. Oracle
D. SQL Server
Rationale: NoSQL databases like MongoDB are
designed for unstructured or semi-structured
data and use document or key-value stores.

5. What does ETL stand for in data
management?
A. Extract, Transform, Load (Correct Answer)
B. Evaluate, Test, Link
C. Enter, Transfer, List
D. Extract, Translate, Log
Rationale: ETL is the process used to move data
from source systems into data warehouses.