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




ht FOUNDATIONS OA EXAM ACTUAL EXAM LATEST ht ht ht ht ht




VERSIONS 300 QUESTIONS AND CORRECT ht ht ht ht




DETAILED ANSWERS WITH RATIONALES (100% ht ht ht ht




CORRECT AND VERIFIED ANSWERS)|ALREADY
ht ht ht ht




GRADED A+ ht ht




What functions does the DBMS perform to guarantee integrity
ht ht ht ht ht ht ht ht




and consistency of the data in a database? -
ht ht ht ht ht ht ht ht ht




...ANSWER...- Data Integrity Management ht ht ht




- Data storage mangagement ht ht




- Security management ht




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




pet owner. What is the binary relationship described? -
ht ht ht ht ht ht ht ht ht




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


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




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




...ANSWER...Functional dependency ht




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




implementing a business intelligence system? -
ht ht ht ht ht ht




...ANSWER...Increased profitability and increased ht ht ht




throughput
ht

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




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




volume and frequency
ht ht ht




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




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




...ANSWER...Transformation

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




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




according to an expected future behavior.
ht ht ht ht ht ht




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




...ANSWER...Between objects ht




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




content. B. SQL tables of training instructors. C.Relational db
ht ht ht ht ht ht ht ht ht




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




...ANSWER...A. Training Video Content ht ht ht




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




agency showing? - ...ANSWER...One manufacturer created at
ht ht ht ht ht ht ht




least one of the agency's cars
ht ht ht ht ht ht




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




bar).
ht




How is the cardinality of the customers misrepresented? -
ht ht ht ht ht ht ht ht ht




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




indicates one customer.
ht ht ht




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




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

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




...ANSWER...A minimum of zero customers ht ht ht ht




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




- ...ANSWER...Performance
ht ht




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




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




- ...ANSWER...Aggregation

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




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




...ANSWER...Estimation

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




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




...ANSWER...Integration

What data mining activity is the process of organizing data into
ht ht ht ht ht ht ht ht ht ht




predefined classes? - ...ANSWER...Classification
ht ht ht ht




Project Code Employee No. Employee Name Department No.
ht ht ht ht ht ht ht




Department Name Hourly Rate
ht ht ht ht




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




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




PC010 S21010 P. Lewis L004 IT 21.00 PC045
ht ht ht ht ht ht ht ht




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




S10001 A. Smith L004 IT 18.00
ht ht ht ht ht ht




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




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




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

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




S10034 B. James L009 HR 16.50
ht ht ht ht ht ht




In which state are the attributes shown? -
ht ht ht ht ht ht ht ht




...ANSWER...First normal form ht ht




Students
IDSt LastName IDProf Prof Grade
ht ht ht ht




1 Mueller 3 Schmid 5
ht ht ht ht




2 Meier 2 Borner 4
ht ht ht ht




3 Tobler 1 Bernasconi 6
ht ht ht ht




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




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




ID Contract Code
ht ht




1 Vinod 091
ht ht




2 Rajiv 091
ht ht




Code City Country ht ht




091 Bangalore India
ht ht ht




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




the second is Code.
ht ht ht ht




How advanced are the two tables in the normalization process?
ht ht ht ht ht ht ht ht ht




- ...ANSWER...Third normal form
ht ht ht ht




Which characteristic points to the tables being in third normal
ht ht ht ht ht ht ht ht ht




form? - ...ANSWER...The tables are completely free of data
ht ht ht ht ht ht ht ht ht




redundancy.
ht