WGU C175 FINAL EXAM QUESTIONS
WITH
CORRECT DETAILED SOLUTIONS
LATEST EXAM GRADED A+
What is a methodology for organizing attributes into tables? - ANS✔✔---Data
normalization
What is the term for the value of one particular attribute associated with a specific
single value of another attribute? - ANS✔✔---Functional dependency
Which set of results should a company expect from implementing a business
intelligence system? - ANS✔✔---Increased profitability and increased throughput
Which issue is focused on the loading component of extract, transform, load
(ETL)? - ANS✔✔---Monitor refreshing volume and frequency
During which step in the extract, transform, load (ETL) process are raw data sets
aggregated? - ANS✔✔---Transformation
How is prediction distinguished from estimation in data mining? - ANS✔✔---
Prediction classifies objects according to an expected future behavior.
Page 1 of 17
,Where does affinity grouping occur in data mining? - ANS✔✔---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 - ANS✔✔---A. Training Video Content
What is the entity-relationship diagram about a car rental agency showing? -
ANS✔✔--- 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? - ANS✔✔---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?
-
ANS✔✔---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
Page 2 of 17
, 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? - ANS✔✔---First normal form
Students
IDSt LastName IDProf Prof Grade
1 Mueller 3 Schmid 5
2 Meier 2 Borner 4
3 Tobler 1 Bernasconi 6
Which factor determines whether the table is in first normal form? - ANS✔✔---
The attributes are all single valued.
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
Page 3 of 17
WITH
CORRECT DETAILED SOLUTIONS
LATEST EXAM GRADED A+
What is a methodology for organizing attributes into tables? - ANS✔✔---Data
normalization
What is the term for the value of one particular attribute associated with a specific
single value of another attribute? - ANS✔✔---Functional dependency
Which set of results should a company expect from implementing a business
intelligence system? - ANS✔✔---Increased profitability and increased throughput
Which issue is focused on the loading component of extract, transform, load
(ETL)? - ANS✔✔---Monitor refreshing volume and frequency
During which step in the extract, transform, load (ETL) process are raw data sets
aggregated? - ANS✔✔---Transformation
How is prediction distinguished from estimation in data mining? - ANS✔✔---
Prediction classifies objects according to an expected future behavior.
Page 1 of 17
,Where does affinity grouping occur in data mining? - ANS✔✔---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 - ANS✔✔---A. Training Video Content
What is the entity-relationship diagram about a car rental agency showing? -
ANS✔✔--- 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? - ANS✔✔---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?
-
ANS✔✔---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
Page 2 of 17
, 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? - ANS✔✔---First normal form
Students
IDSt LastName IDProf Prof Grade
1 Mueller 3 Schmid 5
2 Meier 2 Borner 4
3 Tobler 1 Bernasconi 6
Which factor determines whether the table is in first normal form? - ANS✔✔---
The attributes are all single valued.
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
Page 3 of 17
