A central repository of information that can be analyzed to make more informed decisions is known as:
- A.Data mining
- B.Data storing
- C.Data sorting
- D.Data warehouse
Correct answer
Explanation
The correct answer is D, data warehouse. A data warehouse is exactly that, a central store into which data from many operational systems is extracted, cleaned and loaded so that it can be analysed for decision making. Bill Inmon's standard definition calls it subject-oriented, integrated, time-variant and non-volatile, which means it is arranged around business subjects, merged from several sources, keeps history, and does not overwrite old records. Option A is wrong because data mining is an activity performed on stored data, the search for patterns such as clusters and association rules, not a repository. Option B is wrong because data storing is a loose phrase for keeping data and is not a technical term for such a repository. Option C is wrong because sorting merely arranges records in order and creates no store of analytical data.
Read the full article: Big Data, Data Mining and Data Analytics: Exam Notes
Practice Questions
View allWhich of the following statement(s) is/are correct regarding On-Line Transaction Processing (OLTP)? I. Responses to the user inquiry are immediate. II. The associated cost is economical with efficient utilization of resources. III. The database is always up-to-date.
- A.Only II
- B.I and III
- C.I and II
- D.Only III
Show answer
On-Line Transaction Processing is the mode in which a bank counter, a railway booking window or a payment gateway works: each transaction is processed the moment it is entered, so the response to the user is immediate, and every committed transaction is written at once, so the database always reflects…
Read the full explanation →Which of the following is NOT one of the three Vs of big data?
- A.Volume
- B.Velocity
- C.Variety
- D.Virtualisation
Show answer
Virtualisation is the technique of running several logical machines on one physical machine and belongs to the chapter on cloud computing, not to the definition of big data.
Read the full explanation →In Hadoop, which component is responsible for storing data across the machines of a cluster?
- A.MapReduce
- B.HDFS
- C.YARN
- D.Hive
Show answer
It splits a large file into fixed-size blocks, 128 megabytes by default in current versions, scatters those blocks over the machines of the cluster and keeps more than one copy of each block so that the failure of a machine does not lose data.
Read the full explanation →Data mining is best described as which step of the knowledge discovery process?
- A.The collection of raw data from sensors
- B.The step that finds patterns in prepared data
- C.The backing up of a database
- D.The printing of a management report
Show answer
In the process called Knowledge Discovery in Databases, or KDD, the stages run from selection of the relevant data, through cleaning and preprocessing, to transformation, then data mining, and finally interpretation and evaluation of what was found.
Read the full explanation →Which algorithm is most closely associated with association rule mining and market basket analysis?
- A.Apriori
- B.k-means
- C.Dijkstra
- D.Quicksort
Show answer
The Apriori algorithm first finds the sets of items that appear together often enough to pass a support threshold, using the rule that any subset of a frequent set must itself be frequent, and then turns those frequent sets into rules measured by confidence.
Read the full explanation →