WGU C175 Practice Study Guide Questions
with Distinction level Marking scheme
version 2024/2025
What would this SQL statement accomplish? - correct answer List all entries in the
PRODUCT table.
What is a methodology for organizing attributes into tables? - correct answer Data
normalization
What is the term for the value of one particular attribute associated with a specific single
value of another attribute? - correct answer Functional dependency
Which set of results should a company expect from implementing a business
intelligence system? - correct answer Increased profitability and increased throughput
Which issue is focused on the loading component of extract, transform, load (ETL)? -
correct answer Monitor refreshing volume and frequency
During which step in the extract, transform, load (ETL) process are raw data sets
aggregated? - correct answer Transformation
How is prediction distinguished from estimation in data mining? - correct answer
Prediction classifies objects according to an expected future behavior.
Where does affinity grouping occur in data mining? - correct answer Between objects
Which item represents unstructured data? A. Video training content. B. SQL tables of
training instructors. C.Relational db for training tracking. D. Training db backup - correct
answer A. Training Video Content
, What is the entity-relationship diagram about a car rental agency showing? - correct
answer One manufacturer created at least one of the agency's cars
Image shows Salesperson (with 1 bar) to Customers (with 1 bar).
How is the cardinality of the customers misrepresented? - correct answer There are
many customers, but the cardinality indicates one customer.
Image shows Salesperson (with 2 bars) to Customer (with open circle and Crow's Feet).
What is the correct way to read the modality on the right side of the association? -
correct answer A minimum of zero customers
Project Code Employee No. Employee Name Department No. Department Name Hourly
Rate
PC010 S10001 A. Smith L004 IT 22.00
PC010 S10030 L. Jones L023 Pensions 18.50
PC010 S21010 P. Lewis L004 IT 21.00
PC045 S10010 B. Jones L004 IT 21.75
PC045 S10001 A. Smith L004 IT 18.00
PC045 S31002 T. Gilbert L028 Database 25.50
PC045 S13210 W. Richards L008 Salary 17.00
PC064 S31002 T. Gilbert L028 Database 23.25
PC064 S21010 P. Lewis L004 IT 17.50
PC064 S10034 B. James L009 HR 16.50
In which state are the attributes shown? - correct answer First normal form
Students
IDSt LastName IDProf Prof Grade
1 Mueller 3 Schmid 5
2 Meier 2 Borner 4
3 Tobler 1 Bernasconi 6
with Distinction level Marking scheme
version 2024/2025
What would this SQL statement accomplish? - correct answer List all entries in the
PRODUCT table.
What is a methodology for organizing attributes into tables? - correct answer Data
normalization
What is the term for the value of one particular attribute associated with a specific single
value of another attribute? - correct answer Functional dependency
Which set of results should a company expect from implementing a business
intelligence system? - correct answer Increased profitability and increased throughput
Which issue is focused on the loading component of extract, transform, load (ETL)? -
correct answer Monitor refreshing volume and frequency
During which step in the extract, transform, load (ETL) process are raw data sets
aggregated? - correct answer Transformation
How is prediction distinguished from estimation in data mining? - correct answer
Prediction classifies objects according to an expected future behavior.
Where does affinity grouping occur in data mining? - correct answer Between objects
Which item represents unstructured data? A. Video training content. B. SQL tables of
training instructors. C.Relational db for training tracking. D. Training db backup - correct
answer A. Training Video Content
, What is the entity-relationship diagram about a car rental agency showing? - correct
answer One manufacturer created at least one of the agency's cars
Image shows Salesperson (with 1 bar) to Customers (with 1 bar).
How is the cardinality of the customers misrepresented? - correct answer There are
many customers, but the cardinality indicates one customer.
Image shows Salesperson (with 2 bars) to Customer (with open circle and Crow's Feet).
What is the correct way to read the modality on the right side of the association? -
correct answer A minimum of zero customers
Project Code Employee No. Employee Name Department No. Department Name Hourly
Rate
PC010 S10001 A. Smith L004 IT 22.00
PC010 S10030 L. Jones L023 Pensions 18.50
PC010 S21010 P. Lewis L004 IT 21.00
PC045 S10010 B. Jones L004 IT 21.75
PC045 S10001 A. Smith L004 IT 18.00
PC045 S31002 T. Gilbert L028 Database 25.50
PC045 S13210 W. Richards L008 Salary 17.00
PC064 S31002 T. Gilbert L028 Database 23.25
PC064 S21010 P. Lewis L004 IT 17.50
PC064 S10034 B. James L009 HR 16.50
In which state are the attributes shown? - correct answer First normal form
Students
IDSt LastName IDProf Prof Grade
1 Mueller 3 Schmid 5
2 Meier 2 Borner 4
3 Tobler 1 Bernasconi 6
