WGU C175/D426 DATA MANAGEMENT z z z z
FOUNDATIONS OA EXAM ACTUAL EXAM LATEST z z z z z
VERSIONS 300 QUESTIONS AND CORRECT z z z z
DETAILED ANSWERS WITH RATIONALES (100% z z z z z
CORRECT AND VERIFIED ANSWERS)|ALREADY z z z z
GRADED A+ z
What functions does the DBMS perform to guarantee
z z z z z z z z
integrity and consistency of the data in a database? -
z z z z z z z z z
...ANSWER...- Data Integrity Management z z z
- Data storage mangagement
z z
- Security management z
A pet owner can have many pets; a specific pet is linked to
z z z z z z z z z z z z z
one pet owner. What is the binary relationship described? -
z z z z z z z z z
...ANSWER...One-To-Many
What is the term for the value of one particular attribute
z z z z z z z z z z z
associated with a specific single value of another attribute? -
z z z z z z z z z
...ANSWER...Functional dependency z
Which set of results should a company expect from
z z z z z z z z z
implementing a business intelligence system? - z z z z z
...ANSWER...Increased profitability and increased z z z z
throughput
,Which issue is focused on the loading component of extract,
z z z z z z z z z z
transform, load (ETL)? - ...ANSWER...Monitor refreshing
z z z z z z
volume and frequency z z
During which step in the extract, transform, load (ETL)
z z z z z z z z z
process are raw data sets aggregated? -
z z z z z z
...ANSWER...Transformation
How is prediction distinguished from estimation in data
z z z z z z z z
mining? - ...ANSWER...Prediction classifies objects
z z z z z
according to an expected future behavior. z z z z z
Where does affinity grouping occur in data mining? -
z z z z z z z z
...ANSWER...Between objects z
Which item represents unstructured data? A. Video training
z z z z z z z z
content. B. SQL tables of training instructors. C.Relational
z z z z z z z z
db for training tracking. D. Training db backup -
z z z z z z z z
...ANSWER...A. Training Video Content z z z
What is the entity-relationship diagram about a car rental
z z z z z z z z z
agency showing? - ...ANSWER...One manufacturer created
z z z z z z
at least one of the agency's cars
z z z z z z
Image shows Salesperson (with 1 bar) to Customers (with 1
z z z z z z z z z z
bar).
zHow is the cardinality of the customers misrepresented? -
z z z z z z z z
...ANSWER...There are many customers, but the cardinality z z z z z z z
indicates one customer. z z
Image shows Salesperson (with 2 bars) to Customer (with
z z z z z z z z z
open circle and Crow's Feet). What is the correct way to
z z z z z z z z z z
,read the modality on the right side of the association? -
z z z z z z z z z z
...ANSWER...A minimum of zero customers z z z z
What is the key factor based on the need for linear
z z z z z z z z z z z
scalability? - ...ANSWER...Performance
z z
What is used for populating summaries or any cube
z z z z z z z z z
dimensions that can be performed at the staging area (ETL)?
z z z z z z z z z
- ...ANSWER...Aggregation
What data mining activity is a process of assigning some
z z z z z z z z z z
continuously valued numeric value to an object? -
z z z z z z z
...ANSWER...Estimation
What includes exploiting the discovery of table and foreign
z z z z z z z z z
keys for representing linkage between different tables? -
z z z z z z z
...ANSWER...Integration
What data mining activity is the process of organizing data
z z z z z z z z z z
into predefined classes? - ...ANSWER...Classification
z z z z
Project Code Employee No. Employee Name Department
z z z z z z z
No. Department Name Hourly Rate
z z z z
PC010 S10001 A. Smith L004 IT 22.00
z z z z z z
PC010 S10030 L. Jones L023 Pensions 18.50
z z z z z z z
PC010 S21010 P. Lewis L004 IT 21.00
z z z z z z z
PC045 S10010 B. Jones L004 IT 21.75
z z z z z z z
PC045 S10001 A. Smith L004 IT 18.00
z z z z z z
PC045 S31002 T. Gilbert L028 Database 25.50
z z z z z z z
PC045 S13210 W. Richards L008 Salary 17.00
z z z z z z z
PC064 S31002 T. Gilbert L028 Database 23.25
z z z z z z
, PC064 S21010 P. Lewis L004 IT 17.50 z z z z z z z
PC064 S10034 B. James L009 HR 16.50 z z z z z z
zIn which state are the attributes shown? -
z z z z z z z
...ANSWER...First normal form z z
Students
IDSt LastName IDProf Prof Grade
z z z z
1 Mueller 3 Schmid 5
z z z z
2 Meier 2 Borner 4
z z z z
3 Tobler 1 Bernasconi 6
z z z z
Which factor determines whether the table is in first normal
z z z z z z z z z z
form? - ...ANSWER...The attributes are all single valued.
z z z z z z z
ID Contract Code
z z
1 Vinod 091
z z
2 Rajiv 091
z z
Code City Country z z z
091 Bangalore India
z z
The primary key in the first table is ID, and the primary key
z z z z z z z z z z z z z
in the second is Code.
z z z z
How advanced are the two tables in the normalization
z z z z z z z z z
process? - ...ANSWER...Third normal form z z z z
Which characteristic points to the tables being in third
z z z z z z z z z
normal form? - ...ANSWER...The tables are completely free
z z z z z z z z
of data redundancy.
z z
FOUNDATIONS OA EXAM ACTUAL EXAM LATEST z z z z z
VERSIONS 300 QUESTIONS AND CORRECT z z z z
DETAILED ANSWERS WITH RATIONALES (100% z z z z z
CORRECT AND VERIFIED ANSWERS)|ALREADY z z z z
GRADED A+ z
What functions does the DBMS perform to guarantee
z z z z z z z z
integrity and consistency of the data in a database? -
z z z z z z z z z
...ANSWER...- Data Integrity Management z z z
- Data storage mangagement
z z
- Security management z
A pet owner can have many pets; a specific pet is linked to
z z z z z z z z z z z z z
one pet owner. What is the binary relationship described? -
z z z z z z z z z
...ANSWER...One-To-Many
What is the term for the value of one particular attribute
z z z z z z z z z z z
associated with a specific single value of another attribute? -
z z z z z z z z z
...ANSWER...Functional dependency z
Which set of results should a company expect from
z z z z z z z z z
implementing a business intelligence system? - z z z z z
...ANSWER...Increased profitability and increased z z z z
throughput
,Which issue is focused on the loading component of extract,
z z z z z z z z z z
transform, load (ETL)? - ...ANSWER...Monitor refreshing
z z z z z z
volume and frequency z z
During which step in the extract, transform, load (ETL)
z z z z z z z z z
process are raw data sets aggregated? -
z z z z z z
...ANSWER...Transformation
How is prediction distinguished from estimation in data
z z z z z z z z
mining? - ...ANSWER...Prediction classifies objects
z z z z z
according to an expected future behavior. z z z z z
Where does affinity grouping occur in data mining? -
z z z z z z z z
...ANSWER...Between objects z
Which item represents unstructured data? A. Video training
z z z z z z z z
content. B. SQL tables of training instructors. C.Relational
z z z z z z z z
db for training tracking. D. Training db backup -
z z z z z z z z
...ANSWER...A. Training Video Content z z z
What is the entity-relationship diagram about a car rental
z z z z z z z z z
agency showing? - ...ANSWER...One manufacturer created
z z z z z z
at least one of the agency's cars
z z z z z z
Image shows Salesperson (with 1 bar) to Customers (with 1
z z z z z z z z z z
bar).
zHow is the cardinality of the customers misrepresented? -
z z z z z z z z
...ANSWER...There are many customers, but the cardinality z z z z z z z
indicates one customer. z z
Image shows Salesperson (with 2 bars) to Customer (with
z z z z z z z z z
open circle and Crow's Feet). What is the correct way to
z z z z z z z z z z
,read the modality on the right side of the association? -
z z z z z z z z z z
...ANSWER...A minimum of zero customers z z z z
What is the key factor based on the need for linear
z z z z z z z z z z z
scalability? - ...ANSWER...Performance
z z
What is used for populating summaries or any cube
z z z z z z z z z
dimensions that can be performed at the staging area (ETL)?
z z z z z z z z z
- ...ANSWER...Aggregation
What data mining activity is a process of assigning some
z z z z z z z z z z
continuously valued numeric value to an object? -
z z z z z z z
...ANSWER...Estimation
What includes exploiting the discovery of table and foreign
z z z z z z z z z
keys for representing linkage between different tables? -
z z z z z z z
...ANSWER...Integration
What data mining activity is the process of organizing data
z z z z z z z z z z
into predefined classes? - ...ANSWER...Classification
z z z z
Project Code Employee No. Employee Name Department
z z z z z z z
No. Department Name Hourly Rate
z z z z
PC010 S10001 A. Smith L004 IT 22.00
z z z z z z
PC010 S10030 L. Jones L023 Pensions 18.50
z z z z z z z
PC010 S21010 P. Lewis L004 IT 21.00
z z z z z z z
PC045 S10010 B. Jones L004 IT 21.75
z z z z z z z
PC045 S10001 A. Smith L004 IT 18.00
z z z z z z
PC045 S31002 T. Gilbert L028 Database 25.50
z z z z z z z
PC045 S13210 W. Richards L008 Salary 17.00
z z z z z z z
PC064 S31002 T. Gilbert L028 Database 23.25
z z z z z z
, PC064 S21010 P. Lewis L004 IT 17.50 z z z z z z z
PC064 S10034 B. James L009 HR 16.50 z z z z z z
zIn which state are the attributes shown? -
z z z z z z z
...ANSWER...First normal form z z
Students
IDSt LastName IDProf Prof Grade
z z z z
1 Mueller 3 Schmid 5
z z z z
2 Meier 2 Borner 4
z z z z
3 Tobler 1 Bernasconi 6
z z z z
Which factor determines whether the table is in first normal
z z z z z z z z z z
form? - ...ANSWER...The attributes are all single valued.
z z z z z z z
ID Contract Code
z z
1 Vinod 091
z z
2 Rajiv 091
z z
Code City Country z z z
091 Bangalore India
z z
The primary key in the first table is ID, and the primary key
z z z z z z z z z z z z z
in the second is Code.
z z z z
How advanced are the two tables in the normalization
z z z z z z z z z
process? - ...ANSWER...Third normal form z z z z
Which characteristic points to the tables being in third
z z z z z z z z z
normal form? - ...ANSWER...The tables are completely free
z z z z z z z z
of data redundancy.
z z
