WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM ACTUAL
EXAM LATEST VERSIONS 300
QUESTIONS AND CORRECT
DETAILED ANSWERS WITH
RATIONALES (100%
CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
What functions does the DBMS perform to guarantee integrity and
consistency of the data in a database? - ...ANSWER...- Data
Integrity Management
- Data storage mangagement
- Security management
A pet owner can have many pets; a specific pet is linked to
one pet owner. What is the binary relationship described? -
...ANSWER...One-To-Many
What is the term for the value of one particular attribute
associated with a specific single value of another attribute? -
...ANSWER...Functional dependency
Which set of results should a company expect from implementing a
business intelligence system? - ...ANSWER...Increased profitability
and increased throughput
,Which issue is focused on the loading component of extract,
transform, load (ETL)? - ...ANSWER...Monitor refreshing volume and
frequency
During which step in the extract, transform, load (ETL)
process are raw data sets aggregated? -
...ANSWER...Transformation
How is prediction distinguished from estimation in data
mining? - ...ANSWER...Prediction classifies objects
according to an expected future behavior.
Where does affinity grouping occur in data mining? -
...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 - ...ANSWER...A. Training
Video Content
What is the entity-relationship diagram about a car rental agency
showing? - ...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? -
...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? -
...ANSWER...A minimum of zero customers
,What is the key factor based on the need for linear
scalability? - ...ANSWER...Performance
What is used for populating summaries or any cube dimensions that
can be performed at the staging area (ETL)?
- ...ANSWER...Aggregation
What data mining activity is a process of assigning some
continuously valued numeric value to an object? -
...ANSWER...Estimation
What includes exploiting the discovery of table and foreign
keys for representing linkage between different tables? -
...ANSWER...Integration
What data mining activity is the process of organizing data
into predefined classes? - ...ANSWER...Classification
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? - ...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
Which factor determines whether the table is in first normal
form? - ...ANSWER...The attributes are all single valued.
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
The primary key in the first table is ID, and the primary key
in the second is Code.
How advanced are the two tables in the normalization
process? - ...ANSWER...Third normal form
Which characteristic points to the tables being in third normal form?
- ...ANSWER...The tables are completely free of data redundancy.
A product-marketing company publishes an Internet-based
newsletter about their new products to increase their
customer base.
What is an advantage that this company will gain from investing in
a relational database management system that will store customer
information? - ...ANSWER...Improved query response times
FOUNDATIONS OA EXAM ACTUAL
EXAM LATEST VERSIONS 300
QUESTIONS AND CORRECT
DETAILED ANSWERS WITH
RATIONALES (100%
CORRECT AND VERIFIED
ANSWERS)|ALREADY GRADED A+
What functions does the DBMS perform to guarantee integrity and
consistency of the data in a database? - ...ANSWER...- Data
Integrity Management
- Data storage mangagement
- Security management
A pet owner can have many pets; a specific pet is linked to
one pet owner. What is the binary relationship described? -
...ANSWER...One-To-Many
What is the term for the value of one particular attribute
associated with a specific single value of another attribute? -
...ANSWER...Functional dependency
Which set of results should a company expect from implementing a
business intelligence system? - ...ANSWER...Increased profitability
and increased throughput
,Which issue is focused on the loading component of extract,
transform, load (ETL)? - ...ANSWER...Monitor refreshing volume and
frequency
During which step in the extract, transform, load (ETL)
process are raw data sets aggregated? -
...ANSWER...Transformation
How is prediction distinguished from estimation in data
mining? - ...ANSWER...Prediction classifies objects
according to an expected future behavior.
Where does affinity grouping occur in data mining? -
...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 - ...ANSWER...A. Training
Video Content
What is the entity-relationship diagram about a car rental agency
showing? - ...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? -
...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? -
...ANSWER...A minimum of zero customers
,What is the key factor based on the need for linear
scalability? - ...ANSWER...Performance
What is used for populating summaries or any cube dimensions that
can be performed at the staging area (ETL)?
- ...ANSWER...Aggregation
What data mining activity is a process of assigning some
continuously valued numeric value to an object? -
...ANSWER...Estimation
What includes exploiting the discovery of table and foreign
keys for representing linkage between different tables? -
...ANSWER...Integration
What data mining activity is the process of organizing data
into predefined classes? - ...ANSWER...Classification
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? - ...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
Which factor determines whether the table is in first normal
form? - ...ANSWER...The attributes are all single valued.
ID Contract Code
1 Vinod 091
2 Rajiv 091
Code City Country
091 Bangalore India
The primary key in the first table is ID, and the primary key
in the second is Code.
How advanced are the two tables in the normalization
process? - ...ANSWER...Third normal form
Which characteristic points to the tables being in third normal form?
- ...ANSWER...The tables are completely free of data redundancy.
A product-marketing company publishes an Internet-based
newsletter about their new products to increase their
customer base.
What is an advantage that this company will gain from investing in
a relational database management system that will store customer
information? - ...ANSWER...Improved query response times
