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. An economic feasibility measure. So is Internal rate of return.
near-line secondary storage devices
Count
machine learning
Breakeven analysis
2. 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
degrees of summarization
numeric prediction
composite semantic objects
lift charts
3. Which data mining technique utilizes linkage analysis to search operational transactions for patterns with a high probability of repetition?
system catalog
data visualization
Association
Fact or Measurement table
4. 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.
lift charts
Insert
OLAP
MOLAP
5. The minimum cardinality and m is the maximum cardinality Cardinalities in Semantic Objects are shown as subscripts in the format n-m where _____
data mart
system catalog
changing/UPDATE-ing
n
6. A synonym for data mining
groves law
DROP TABLE Salesrep;
numeric prediction
knowledge data discovery
7. 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 ________________.
Sum
transformation mapping
database administrator
aggregate
8. Which statement will take away user privileges to the database?
average error
Revoke
project readiness assessment factor
composite semantic objects
9. Semantic object link (SOL) attributes establish a relationship between one _______ and another.
Horizontal integration
dimension
data visualization
semantic object
10. To create the primary key clause for the Customer table on the CustomerNum field - which of the following is the correct statement?
PRIMARY KEY (CustomerNum)
principle component analysis
Group By
UNION
11. To add a new row to a table - use the _____ command.
lift charts
Insert
near-line secondary storage devices
ERD Modeling
12. Which function calculates the number of entries in a table?
Count
machine learning
data mart
data visualization
13. Which of the following database design and data warehouse design approaches is viewed to take a more strategic rather than operational perspective?
machine learning
composite semantic objects
Top-down approach
numeric prediction
14. The term "ETL" in data warehousing stands for: Extraction - ________________________ - & Loading.
Top-down approach
cascading delete
Transformation
DROP TABLE Salesrep;
15. Which of the following is at the center of a star schema?
Sum
Fact or Measurement table
Horizontal integration
data mining
16. 'Signatures' are used for intrusion detection by _______?
Association
aggregate
degrees of summarization
recognizing known patterns
17. An ___________ relates two other objects.
association semantic object
MAE (Mean Absolute Error) deviation
volatile data
Fact or Measurement table
18. __________ occurs when the initial scope of a project continues to expand as new features are incorporated into the project.
groves law
Scope creep
Fact or Measurement table
Sum
19. This is not considered one of the four major categories of processing algorithms and rule approaches.
principle component analysis
recognizing known patterns
data visualization
Horizontal integration
20. Increased affordability of ____________ is a reason for the growth in popularity of data mining.
ALTER TABLE Part DELETE Warehouse;
machine learning
artificial Key
MOLAP
21. Gives an idea of systematic over- or under-prediction. Magnitude of average absolute error.
average error
PRIMARY KEY (CustomerNum)
composite semantic objects
Sum
22. A compound semantic object is an object that contains at least one ____.
Top-down approach
machine learning
semantic object (SOL) attribute
DROP TABLE Salesrep;
23. The set of activities used to find new - hidden - or unexpected patterns in data is referred to as _____.
PRIMARY KEY (CustomerNum)
data mining
ERD Modeling
The degree of granularity
24. When an entity has a minimum cardinality of one it means the entity is required in _______.
database administrator
surrogate key
maximum
the relationship
25. Which function should be used to calculate the total of all entries in a given column?
neural networks & Decision Trees
Insert
knowledge data discovery
Sum
26. Models that do ___________: MLR; KNN; Regression and Classification Trees; ANN; SVM
average error
UNION
Transformation
numeric prediction
27. Gives us an idea of the magnitude of errors. Actual value - estimated value.
numeric prediction
MAE (Mean Absolute Error) deviation
Association
groves law
28. Which statement removes the table Salesrep from a DBMS?
DROP TABLE Salesrep;
PRIMARY KEY (CustomerNum)
transformation mapping
Document Analyzer
29. ___________ is not a characteristic of a data warehouse.
volatile data
system catalog
Into
semantic object
30. The deletion of a record that also deletes related records is referred to as a(n) _____.
Association
cascading delete
The degree of granularity
Fact or Measurement table
31. ____________ would not normally be associated with ROUTINE data warehouse maintenance.
ALTER TABLE Part DELETE Warehouse;
changing/UPDATE-ing
Sum
artificial Key
32. Which clause would be used to create groups of records?
semantic object (SOL) attribute
Group By
Referential integrity
average error
33. The SQL built-in functions - which may appear on the same line as the SELECT statement (before the FROM clause) are called _____ functions.
data mart
MOLAP
Scope creep
aggregate
34. The product of two tables is also called the ________ product.
Cartesian
ALTER TABLE Part DELETE Warehouse;
MOLAP
operational and external layer
35. On an ER Diagram the number (mark) on relationship line that is farthest away from each entity (rectangle) represents the _______ cardinality.
Referential integrity
Count
maximum
volatile data
36. You can save the results of a query as a table by including the _____ clause in the query.
Into
average error
project readiness assessment factor
transformation mapping
37. An analytical-oriented organizational structure is a data warehouse _____________.
project readiness assessment factor
The degree of granularity
measuring predictive error
lift charts
38. 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:
data mart
market basket analysis
Into
Referential integrity
39. ___________________ 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
Regression analysis
PRIMARY KEY (CustomerNum)
average error
knowledge data discovery
40. 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
the relationship
machine learning
Fact or Measurement table
41. _________ seeks to ensure that each application under development is fully integrated within its own boundaries and to eliminate any inconsistencies in the final software product.
Sum
Horizontal integration
Transformation
numeric prediction
42. The ACCESS feature that tests to see if your tables are normalized properly is the ____.
surrogate key
Document Analyzer
association semantic object
operational and external layer
43. Within most organizations - the person known as the _____ determines the type of access various users can have to the corporate or enterprise database.
association semantic object
drill-across report
system catalog
database administrator
44. A ___________ combines result sets from more than one fact table.
association semantic object
drill-across report
semantic object (SOL) attribute
near-line secondary storage devices
45. The process by which numerical data is converted into graphical images is referred to as:
data visualization
machine learning
semantic object
transformation mapping
46. An alternative to the data warehouse concept is a lower-cost - scaled-down version referred to as the _____________.
MAE (Mean Absolute Error) deviation
Group By
OLAP
data mart
47. Are a data mining technology.
neural networks & Decision Trees
data mart
measuring predictive error
aggregate
48. These are considered an alternate storage techniques for data warehousing include.
Fact or Measurement table
recognizing known patterns
near-line secondary storage devices
surrogate key
49. Why are Star Schemas so useful in Financial Planning and Accounting Information Systems?
Count
database administrator
semantic object
degrees of summarization
50. A powerful trend in IT is known as - which maintains that Computer transmission speed doubles every 18 months.
operational and external layer
Cartesian
groves law
aggregate