WGU C175 EVALUATION EXAM UPDATED QUESTIONS AND
SOLUTIONS RATED A+
✔✔What data mining activity is a process of assigning some continuously valued
numeric value to an object? - ✔✔Estimation
✔✔What includes exploiting the discovery of table and foreign keys for representing
linkage between different tables? - ✔✔Integration
✔✔What data mining activity is the process of organizing data into predefined classes?
- ✔✔Classification
✔✔Which activity groups data members that have similarities? - ✔✔Clustering
✔✔Data Warehouse - ✔✔A data warehouse is the primary source of information that
feeds the analytical processing within an organization.
✔✔Data Mart - ✔✔A data mart is a subject-oriented data repository, similar in structure
to the enterprise data warehouse, but it's main purpose is to serve directed reporting
and drill down into specific data.
✔✔OLAP - ✔✔OLAP (Online Analytical Processing) is both a process of viewing
comparative metrics via a multidimensional analysis of data and the infrastructure to
support that process.
✔✔OTAP - ✔✔OTAP (online transaction processing) provides a means for presenting
data sourced from a data warehouse or a data mart in a way that allows the data
consumer to view comparative metrics across multiple dimensions.
✔✔Cartesian product - ✔✔Usually the result of a missing join condition or a method of
expanding the data of 1 table by the number of rows in the second table.
✔✔Data volatility - ✔✔Describes how often stored data is updated.
✔✔DCL - ✔✔Data control language is used to control access to data stored in a
database.
✔✔Definer - ✔✔Definer is a MySQL term where AuthID is the same for another DBMS
✔✔Domain of values - ✔✔The shared values between a primary key and foreign key.
✔✔Extraction essentially boils down to two questions: - ✔✔1. What data should be
extracted?
2. How should that data be extracted?
, ✔✔Inner join - ✔✔Shows row that have matches in both tables
✔✔Logical view - ✔✔Logical view is a mapping onto a physical table or tables that
allows an end user to access only a specified portion of data.
✔✔Outer join - ✔✔Shows rows in one table that have no match in the other table. Two
kinds of outer joins are left and right joins.
✔✔Referential Integrity - ✔✔Referential integrity is a database concept that ensures
that relationships between tables remain consistent.
✔✔Response Time - ✔✔Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
✔✔Scalar subquery - ✔✔Is the most restrictive subquery because it produces only a
single value
✔✔Superkey - ✔✔A superkey is any number of columns that forces every row to be
unique.
✔✔Throughput - ✔✔Is the measure of how many queries from simultaneous users must
be satisfied in a given period of time by the application set and the database that it
supports.
✔✔UNION - ✔✔To create a result set that combines the results from several queries
✔✔What are 6 potential problems that need to be considered with databases? - ✔✔1.
Size
2. Ease of updating
3. Accuracy
4. Security
5. Redundancy
6. Importance
✔✔ Flat Files - ✔✔a file having no internal hierarchy
✔✔Hashed Files - ✔✔A file that has been encrypted for security purposes.
✔✔Heap File - ✔✔An unsorted set of records.
✔✔Information - ✔✔The transformation of raw data into useful facts.
✔✔Punch Card - ✔✔A card that is perforated and can hold commands or data.
SOLUTIONS RATED A+
✔✔What data mining activity is a process of assigning some continuously valued
numeric value to an object? - ✔✔Estimation
✔✔What includes exploiting the discovery of table and foreign keys for representing
linkage between different tables? - ✔✔Integration
✔✔What data mining activity is the process of organizing data into predefined classes?
- ✔✔Classification
✔✔Which activity groups data members that have similarities? - ✔✔Clustering
✔✔Data Warehouse - ✔✔A data warehouse is the primary source of information that
feeds the analytical processing within an organization.
✔✔Data Mart - ✔✔A data mart is a subject-oriented data repository, similar in structure
to the enterprise data warehouse, but it's main purpose is to serve directed reporting
and drill down into specific data.
✔✔OLAP - ✔✔OLAP (Online Analytical Processing) is both a process of viewing
comparative metrics via a multidimensional analysis of data and the infrastructure to
support that process.
✔✔OTAP - ✔✔OTAP (online transaction processing) provides a means for presenting
data sourced from a data warehouse or a data mart in a way that allows the data
consumer to view comparative metrics across multiple dimensions.
✔✔Cartesian product - ✔✔Usually the result of a missing join condition or a method of
expanding the data of 1 table by the number of rows in the second table.
✔✔Data volatility - ✔✔Describes how often stored data is updated.
✔✔DCL - ✔✔Data control language is used to control access to data stored in a
database.
✔✔Definer - ✔✔Definer is a MySQL term where AuthID is the same for another DBMS
✔✔Domain of values - ✔✔The shared values between a primary key and foreign key.
✔✔Extraction essentially boils down to two questions: - ✔✔1. What data should be
extracted?
2. How should that data be extracted?
, ✔✔Inner join - ✔✔Shows row that have matches in both tables
✔✔Logical view - ✔✔Logical view is a mapping onto a physical table or tables that
allows an end user to access only a specified portion of data.
✔✔Outer join - ✔✔Shows rows in one table that have no match in the other table. Two
kinds of outer joins are left and right joins.
✔✔Referential Integrity - ✔✔Referential integrity is a database concept that ensures
that relationships between tables remain consistent.
✔✔Response Time - ✔✔Is the delay from the time that the Enter Key is pressed to
execute a query until the result appears on screen.
✔✔Scalar subquery - ✔✔Is the most restrictive subquery because it produces only a
single value
✔✔Superkey - ✔✔A superkey is any number of columns that forces every row to be
unique.
✔✔Throughput - ✔✔Is the measure of how many queries from simultaneous users must
be satisfied in a given period of time by the application set and the database that it
supports.
✔✔UNION - ✔✔To create a result set that combines the results from several queries
✔✔What are 6 potential problems that need to be considered with databases? - ✔✔1.
Size
2. Ease of updating
3. Accuracy
4. Security
5. Redundancy
6. Importance
✔✔ Flat Files - ✔✔a file having no internal hierarchy
✔✔Hashed Files - ✔✔A file that has been encrypted for security purposes.
✔✔Heap File - ✔✔An unsorted set of records.
✔✔Information - ✔✔The transformation of raw data into useful facts.
✔✔Punch Card - ✔✔A card that is perforated and can hold commands or data.
