WGU - D427 - Data Management -
Applications – PreAssessment
Questions and Answers Already Passed
What is the primary purpose of a database management system (DBMS)?
a. To increase data redundancy
b. To provide a framework for data manipulation
✔✔c. To manage and organize data efficiently
d. To eliminate the need for data security
Which of the following is an example of a relational database?
✔✔a. MySQL
b. Google Sheets
c. Microsoft Word
d. Adobe Photoshop
What does SQL stand for in the context of databases?
a. Structured Question Language
✔✔b. Structured Query Language
1
,c. Simple Query Language
d. Standard Query Language
What is a primary key in a database table?
a. A key used for encryption
✔✔b. A unique identifier for a record
c. A key that allows multiple entries
d. A type of data backup
Which of the following best describes normalization in databases?
a. The process of duplicating data
b. The method of securing data
✔✔c. The process of organizing data to reduce redundancy
d. The technique for data visualization
What is the purpose of a foreign key in a relational database?
a. To increase data security
✔✔b. To establish a link between two tables
2
,c. To define the primary key
d. To restrict user access
Which SQL command is used to retrieve data from a database?
✔✔a. SELECT
b. GET
c. FETCH
d. RETRIEVE
What does the term "data integrity" refer to?
a. The size of the data
b. The speed of data processing
✔✔c. The accuracy and consistency of data
d. The amount of data storage
What is an example of unstructured data?
a. A customer database
✔✔b. An email message
3
, c. A sales report
d. A spreadsheet
What is the primary function of data warehousing?
✔✔a. To consolidate and store large amounts of data for analysis
b. To create real-time data reports
c. To secure sensitive information
d. To manage user access to data
Which of the following describes a data lake?
a. A type of database for small datasets
b. A structured storage system
✔✔c. A centralized repository for storing raw data
d. A method for data normalization
What is the purpose of data mining?
✔✔a. To discover patterns and relationships in large datasets
b. To secure sensitive information
4
Applications – PreAssessment
Questions and Answers Already Passed
What is the primary purpose of a database management system (DBMS)?
a. To increase data redundancy
b. To provide a framework for data manipulation
✔✔c. To manage and organize data efficiently
d. To eliminate the need for data security
Which of the following is an example of a relational database?
✔✔a. MySQL
b. Google Sheets
c. Microsoft Word
d. Adobe Photoshop
What does SQL stand for in the context of databases?
a. Structured Question Language
✔✔b. Structured Query Language
1
,c. Simple Query Language
d. Standard Query Language
What is a primary key in a database table?
a. A key used for encryption
✔✔b. A unique identifier for a record
c. A key that allows multiple entries
d. A type of data backup
Which of the following best describes normalization in databases?
a. The process of duplicating data
b. The method of securing data
✔✔c. The process of organizing data to reduce redundancy
d. The technique for data visualization
What is the purpose of a foreign key in a relational database?
a. To increase data security
✔✔b. To establish a link between two tables
2
,c. To define the primary key
d. To restrict user access
Which SQL command is used to retrieve data from a database?
✔✔a. SELECT
b. GET
c. FETCH
d. RETRIEVE
What does the term "data integrity" refer to?
a. The size of the data
b. The speed of data processing
✔✔c. The accuracy and consistency of data
d. The amount of data storage
What is an example of unstructured data?
a. A customer database
✔✔b. An email message
3
, c. A sales report
d. A spreadsheet
What is the primary function of data warehousing?
✔✔a. To consolidate and store large amounts of data for analysis
b. To create real-time data reports
c. To secure sensitive information
d. To manage user access to data
Which of the following describes a data lake?
a. A type of database for small datasets
b. A structured storage system
✔✔c. A centralized repository for storing raw data
d. A method for data normalization
What is the purpose of data mining?
✔✔a. To discover patterns and relationships in large datasets
b. To secure sensitive information
4
