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
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
