DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Hardware.
|
|
|
Software.
|
|
|
End users.
|
|
|
Middle ware.
|
Detailed explanation-1: -Who is responsible for running queries and reports against data warehouse tables? Answer-D) End-users are responsible for running queries and reports against data warehouse tables.
Detailed explanation-2: -Generally, the users of data warehouses are business analysts, data engineers, data scientists, and decision-makers that use the data to power analytics reports, dashboards, and other analytics tools.
Detailed explanation-3: -Top-Tier − This tier is the front-end client layer. This layer holds the query tools and reporting tools, analysis tools and data mining tools.
Detailed explanation-4: -In Inmon and Hackathorn’s book, they define a query as, “a request for access to information in the data warehouse, with possibly some processing of that data before the results of the query are returned to the end user.” They have classified end-user queries using the following taxonomy, see Figure 3.
Detailed explanation-5: -Data warehouse contains summary data that is not found in operational environment.