WGU C175 Study NotecardS- ACTUAL EXAM NEWEST
VERSION 2025/2026 QUESTION AND CORRECT DETAILED
VERIFIED ANSWERS FROM VERIFIED SOURCES RATED A
GRADE.
What are 6 potential problems that need to be considered with
databases? - ANSWER-1. Size
2. Ease of updating
3. Accuracy
4. Security
5. Redundancy
6. Importance
What are the values of Business Intelligence? - ANSWER--
Financial value associated w/ increased profitability.
- Productivity value associated with increased throughput.
- Trust value (customer, employee, supplier satisfaction) as well
as increased confidence in forecasting.
- Risk value - decreased risk associated with decision making
What are the reasons for using the Dimensional Model for
Business Intelligence? - ANSWER-- Simplicity.
- Lack of bias.
- Extensibility.
,What are three important points about Third Normal Form? -
ANSWER-1. It is completely free of redundancy
2. All foreign keys appear where needed to logically tie together
related tables. 3. It is the same structure that would have been
derived from a properly drawn entity-relationship diagram of
the same business environment.
Write the SQL query to "Add a new salesperson into the
SALESPERSON table whose salesperson number is 489, name
is Quinlan, commission percentage is
15, year of hire is 2011, and department number is 59.": -
ANSWER-INSERT
INTO SALESPERSON
VALUES
('489','Quinlan',15,'2011','59');
*Hint, this is DML, so remember that INSERT is one of the
keywords for DML.
Write the SQL query to "Delete the row for salesperson 186
from the
SALESPERSON table.": - ANSWER-DELETE FROM
SALESPERSON
WHERE SPNUM = '186';
, What is the correct syntax of the INSERT command? -
ANSWER-INSERT INTO table_name VALUES
(value1,value2,value3,...):
What is the correct syntax of the CREATE VIEW command? –
ANSWER-CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
What is called a decomposition process? - ANSWER-Data
normalization
What are the fundamental aspects of a Data Warehouse? -
ANSWER-- Centralized repository of information.
- Organized around relevant subject areas.
- Provides platform for queries.
- Used for analysis and not transactional processing.
- Data is nonvolatile.
- Target location for integrating data from multiple sources.
What is the name of this model? - ANSWER-One-to-one unary
relationship
VERSION 2025/2026 QUESTION AND CORRECT DETAILED
VERIFIED ANSWERS FROM VERIFIED SOURCES RATED A
GRADE.
What are 6 potential problems that need to be considered with
databases? - ANSWER-1. Size
2. Ease of updating
3. Accuracy
4. Security
5. Redundancy
6. Importance
What are the values of Business Intelligence? - ANSWER--
Financial value associated w/ increased profitability.
- Productivity value associated with increased throughput.
- Trust value (customer, employee, supplier satisfaction) as well
as increased confidence in forecasting.
- Risk value - decreased risk associated with decision making
What are the reasons for using the Dimensional Model for
Business Intelligence? - ANSWER-- Simplicity.
- Lack of bias.
- Extensibility.
,What are three important points about Third Normal Form? -
ANSWER-1. It is completely free of redundancy
2. All foreign keys appear where needed to logically tie together
related tables. 3. It is the same structure that would have been
derived from a properly drawn entity-relationship diagram of
the same business environment.
Write the SQL query to "Add a new salesperson into the
SALESPERSON table whose salesperson number is 489, name
is Quinlan, commission percentage is
15, year of hire is 2011, and department number is 59.": -
ANSWER-INSERT
INTO SALESPERSON
VALUES
('489','Quinlan',15,'2011','59');
*Hint, this is DML, so remember that INSERT is one of the
keywords for DML.
Write the SQL query to "Delete the row for salesperson 186
from the
SALESPERSON table.": - ANSWER-DELETE FROM
SALESPERSON
WHERE SPNUM = '186';
, What is the correct syntax of the INSERT command? -
ANSWER-INSERT INTO table_name VALUES
(value1,value2,value3,...):
What is the correct syntax of the CREATE VIEW command? –
ANSWER-CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
What is called a decomposition process? - ANSWER-Data
normalization
What are the fundamental aspects of a Data Warehouse? -
ANSWER-- Centralized repository of information.
- Organized around relevant subject areas.
- Provides platform for queries.
- Used for analysis and not transactional processing.
- Data is nonvolatile.
- Target location for integrating data from multiple sources.
What is the name of this model? - ANSWER-One-to-one unary
relationship
