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+

WGU C175/D426 DATA MANAGEMENT i i i i



FOUNDATIONSOAEXAMACTUALEXAM LATEST i i i i i



VERSIONS300 QUESTIONSAND CORRECT i i i i



DETAILEDANSWERSWITH RATIONALES (100% i i i i i



CORRECTAND VERIFIED ANSWERS)|ALREADY i i i i



GRADED A+ i




What functions does the DBMS perform to guarantee
i i i i i i i i



integrity and consistency of the data in a database? -
i i i i i i i i i



...ANSWER...- Data Integrity Management i i i



- Data storage mangagement
i i



- Security management i




A pet owner can have many pets; a specific pet is linked to
i i i i i i i i i i i i i



one pet owner. What is the binary relationship described? -
i i i i i i i i i



...ANSWER...One-To-Many


What is the term for the value of one particular attribute
i i i i i i i i i i i



associated with a specific single value of another attribute? -
i i i i i i i i i



...ANSWER...Functional dependency i




Which set of results should a company expect from
i i i i i i i i i



implementing a business intelligence system? - i i i i i



...ANSWER...Increased profitability and increased i i i i



throughput

,Which issue is focused on the loading component of extract,
i i i i i i i i i i



transform, load (ETL)? - ...ANSWER...Monitor refreshing i i i i i i



volume and frequency i i




During which step in the extract, transform, load (ETL)
i i i i i i i i i



process are raw data sets aggregated? - i i i i i i



...ANSWER...Transformation

How is prediction distinguished from estimation in data
i i i i i i i i



mining? - ...ANSWER...Prediction classifies objects i i i i i



according to an expected future behavior. i i i i i




Where does affinity grouping occur in data mining? -
i i i i i i i i



...ANSWER...Between objects i




Which item represents unstructured data? A. Video training
i i i i i i i i



content. B. SQL tables of training instructors. C.Relational
i i i i i i i i



db for training tracking. D. Training db backup -
i i i i i i i i



...ANSWER...A. Training Video Content i i i




What is the entity-relationship diagram about a car rental
i i i i i i i i i



agency showing? - ...ANSWER...One manufacturer created
i i i i i i



at least one of the agency's cars
i i i i i i




Image shows Salesperson (with 1 bar) to Customers (with 1
i i i i i i i i i i



bar).
iHow is the cardinality of the customers misrepresented? -
i i i i i i i i



...ANSWER...There are many customers, but the cardinality i i i i i i i



indicates one customer. i i




Image shows Salesperson (with 2 bars) to Customer (with
i i i i i i i i i



open circle and Crow's Feet). What is the correct way to
i i i i i i i i i i

,read the modality on the right side of the association? -
i i i i i i i i i i



...ANSWER...A minimum of zero customers i i i i




What is the key factor based on the need for linear scalability?
i i i i i i i i i i i i



- ...ANSWER...Performance
i




What is used for populating summaries or any cube
i i i i i i i i i



dimensions that can be performed at the staging area (ETL)?
i i i i i i i i i



- ...ANSWER...Aggregation

What data mining activity is a process of assigning some
i i i i i i i i i i



continuously valued numeric value to an object? - i i i i i i i



...ANSWER...Estimation

What includes exploiting the discovery of table and foreign
i i i i i i i i i



keys for representing linkage between different tables? -
i i i i i i i



...ANSWER...Integration

What data mining activity is the process of organizing data
i i i i i i i i i i



into predefined classes? - ...ANSWER...Classification
i i i i




Project Code Employee No. Employee Name Department No.
i i i i i i i i



Department Name Hourly Rate i i i



PC010 S10001 A. Smith L004 IT 22.00
i i i i i i



PC010 S10030 L. Jones L023 Pensions 18.50
i i i i i i i



PC010 S21010 P. Lewis L004 IT 21.00
i i i i i i i



PC045 S10010 B. Jones L004 IT 21.75
i i i i i i i



PC045 S10001 A. Smith L004 IT 18.00
i i i i i i



PC045 S31002 T. Gilbert L028 Database 25.50
i i i i i i i



PC045 S13210 W. Richards L008 Salary 17.00
i i i i i i i



PC064 S31002 T. Gilbert L028 Database 23.25
i i i i i i

, PC064 S21010 P. Lewis L004 IT 17.50 i i i i i i i



PC064 S10034 B. James L009 HR 16.50 i i i i i i



iIn which state are the attributes shown? -
i i i i i i i



...ANSWER...First normal form i i




Students
IDSt LastName IDProf Prof Grade
i i i i



1 Mueller 3 Schmid 5
i i i i



2 Meier 2 Borner 4
i i i i



3 Tobler 1 Bernasconi 6
i i i i




Which factor determines whether the table is in first normal
i i i i i i i i i i



form? - ...ANSWER...The attributes are all single valued.
i i i i i i i




ID Contract Code
i i



1 Vinod 091
i i



2 Rajiv 091
i i




Code City Country i i i



091 Bangalore India i i




The primary key in the first table is ID, and the primary key in
i i i i i i i i i i i i i i



the second is Code.
i i i




How advanced are the two tables in the normalization
i i i i i i i i i



process? - ...ANSWER...Third normal form i i i i




Which characteristic points to the tables being in third
i i i i i i i i i



normal form? - ...ANSWER...The tables are completely free
i i i i i i i i



of data redundancy.
i i