SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Data Mining
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. The minimum cardinality and m is the maximum cardinality Cardinalities in Semantic Objects are shown as subscripts in the format n-m where _____
Referential integrity
n
OLAP
Sum
2. Twice as likely to identify the important class (compared to avg. prevalence)
Cartesian
decile chart
artificial Key
Insert
3. A powerful trend in IT is known as - which maintains that Computer transmission speed doubles every 18 months.
degrees of summarization
Regression analysis
market basket analysis
groves law
4. Why are Star Schemas so useful in Financial Planning and Accounting Information Systems?
maximum
degrees of summarization
operational and external layer
surrogate key
5. You can save the results of a query as a table by including the _____ clause in the query.
data mart
system catalog
The degree of granularity
Into
6. A _____________ is a system-generated primary key.
ERD Modeling
surrogate key
composite semantic objects
The degree of granularity
7. Which of the following is at the center of a star schema?
drill-across report
transformation mapping
semantic object
Fact or Measurement table
8. A compound semantic object is an object that contains at least one ____.
database administrator
semantic object (SOL) attribute
Fact or Measurement table
surrogate key
9. Which clause would be used to create groups of records?
semantic object
transformation mapping
numeric prediction
Group By
10. __________ occurs when the initial scope of a project continues to expand as new features are incorporated into the project.
aggregate
Association
data mining
Scope creep
11. A Star diagram has two types of tables (objects). They are called the___________________ tables and ; fact tables.
database administrator
transformation mapping
dimension
Association
12. The ACCESS feature that tests to see if your tables are normalized properly is the ____.
artificial Key
Insert
n
Document Analyzer
13. An analytical-oriented organizational structure is a data warehouse _____________.
project readiness assessment factor
Document Analyzer
Revoke
artificial Key
14. An alternative to the data warehouse concept is a lower-cost - scaled-down version referred to as the _____________.
data mart
data visualization
Document Analyzer
measuring predictive error
15. The process by which numerical data is converted into graphical images is referred to as:
data visualization
semantic object (SOL) attribute
Count
MOLAP
16. An economic feasibility measure. So is Internal rate of return.
Breakeven analysis
Count
Revoke
Association
17. A single column that you create for an entity to serve as the primary key - because you otherwise would need many concatenated columns to do so - is called a(n) ____________.
artificial Key
Count
Horizontal integration
performance metrics - Numeric Prediction
18. To add a new row to a table - use the _____ command.
surrogate key
Insert
volatile data
UNION
19. When an entity has a minimum cardinality of one it means the entity is required in _______.
composite semantic objects
the relationship
Transformation
Regression analysis
20. Gives us an idea of the magnitude of errors. Actual value - estimated value.
Cartesian
Document Analyzer
MAE (Mean Absolute Error) deviation
data mart
21. ____________ would not normally be associated with ROUTINE data warehouse maintenance.
data visualization
changing/UPDATE-ing
MOLAP
system catalog
22. 'Signatures' are used for intrusion detection by _______?
principle component analysis
knowledge data discovery
recognizing known patterns
database administrator
23. Which rule would you be violating - if you tried to delete a sales rep record - who currently has customers on file?
Referential integrity
Revoke
decile chart
transformation mapping
24. The product of two tables is also called the ________ product.
recognizing known patterns
knowledge data discovery
Cartesian
Document Analyzer
25. Generally Semantic Object Modeling (SOM) is consideredmore bottom-up oriented than _____________.
PRIMARY KEY (CustomerNum)
Insert
aggregate
ERD Modeling
26. Not the same as goodness-of-fit; We want to know how well the model predicts new data - not how well it fits the data it was trained with; Key component of most measures is difference between actual y and predicted y (error)
measuring predictive error
Horizontal integration
neural networks & Decision Trees
Sum
27. Which statement will take away user privileges to the database?
Top-down approach
changing/UPDATE-ing
Revoke
ERD Modeling
28. Gives an idea of systematic over- or under-prediction. Magnitude of average absolute error.
Regression analysis
average error
UNION
volatile data
29. Organizes and analyzes data as an n-dimensional cube. The cube can be thought of as a common spreadsheet with two extensions: (1) support for multiple dimensions and (2) support for multiple concurrent users.
MOLAP
Cartesian
lift charts
near-line secondary storage devices
30. A ___________ combines result sets from more than one fact table.
cascading delete
numeric prediction
drill-across report
measuring predictive error
31. Which function should be used to calculate the total of all entries in a given column?
recognizing known patterns
Breakeven analysis
Sum
data mining
32. A common example of the use of association methods where a retailer can mine the data generated by a point-of-sale system - such as the price scanner you are familiar with at the grocery store is referred to as:
Insert
measuring predictive error
market basket analysis
PRIMARY KEY (CustomerNum)
33. The SQL built-in functions - which may appear on the same line as the SELECT statement (before the FROM clause) are called _____ functions.
Cartesian
The degree of granularity
Regression analysis
aggregate
34. Within most organizations - the person known as the _____ determines the type of access various users can have to the corporate or enterprise database.
UNION
database administrator
groves law
Document Analyzer
35. Increased affordability of ____________ is a reason for the growth in popularity of data mining.
semantic object
recognizing known patterns
Group By
machine learning
36. ___________________ is used to relate one set of outcomes (dependent variable) to a set of predictor (independent) variables (e.g. - in time series analysis). Through this analysis we attempt to predictive future events - as the dependent variables b
dimension
decile chart
the relationship
Regression analysis
37. In general - ______________ are transformed to relations/tables by defining one relation for the object itself and another relation for each multivalued attribute.
near-line secondary storage devices
composite semantic objects
Transformation
average error
38. This is not considered one of the four major categories of processing algorithms and rule approaches.
database administrator
principle component analysis
knowledge data discovery
Fact or Measurement table
39. The term _____ has been generally agreed to represent the broadest category of software technology that enables decision makers to conduct many dimensional analysis of consolidated enterprise data.
data visualization
OLAP
knowledge data discovery
Into
40. On an ER Diagram the number (mark) on relationship line that is farthest away from each entity (rectangle) represents the _______ cardinality.
system catalog
n
maximum
PRIMARY KEY (CustomerNum)
41. A synonym for data mining
knowledge data discovery
PRIMARY KEY (CustomerNum)
Horizontal integration
Group By
42. The deletion of a record that also deletes related records is referred to as a(n) _____.
neural networks & Decision Trees
cascading delete
Group By
Insert
43. The _______________________ represents the source data for the DW. This layer is comprised - primarily - of operational transaction processing systems and external secondary databases.
operational and external layer
system catalog
Insert
Horizontal integration
44. Which function calculates the number of entries in a table?
system catalog
Count
data mart
Top-down approach
45. Are a data mining technology.
maximum
ERD Modeling
neural networks & Decision Trees
Fact or Measurement table
46. Useful for assessing performance in terms of identifying the most important class. Helps such choices as: How many tax records to examine; How many loans to grant; How many customers to mail an offer
lift charts
drill-across report
Document Analyzer
DROP TABLE Salesrep;
47. Which data mining technique utilizes linkage analysis to search operational transactions for patterns with a high probability of repetition?
knowledge data discovery
Association
Horizontal integration
operational and external layer
48. The SQL command for deleting the Warehouse field from the Part table is _____.
ALTER TABLE Part DELETE Warehouse;
association semantic object
changing/UPDATE-ing
aggregate
49. Semantic object link (SOL) attributes establish a relationship between one _______ and another.
Association
ALTER TABLE Part DELETE Warehouse;
Group By
semantic object
50. The process that records how data from operational data stores and external sources are transformed on the way into the warehouse is referred to as ________________.
Revoke
ALTER TABLE Part DELETE Warehouse;
The degree of granularity
transformation mapping