Please state the correct answer below: 35. The subset of data warehouse that is
ID: 421016 • Letter: P
Question
Please state the correct answer below:
35. The subset of data warehouse that is customized for decision making application of a particular
user group is known as:
A) Database
B) Mini data warehouse
C) Data mart
D) Data clone
E) Data store
36. John wants to use the data warehouse to help him to determine whether loan applicants are likely to default on their loan repayments. Which tools can John use to draw the required data from the data warehouse?
A) Reports
B) Queries
C) Summarized data
D) Data mining
E) OLAP
37. Mary is using OLAP to help with her marketing campaign. First she looks at the quarterly sales figures for US, UK and Australia. Then she navigates to the quarterly sales figure of the various Australian cities, before examining the monthly sales figure for each Australian cities. The operation that Mary uses with OLAP is known as:
A) Drill down
B) Slicing
C) Dicing
D) Roll up
E) Zoom in
38. Which of the following statements is INCORRECT about the evolution of ERP systems?
A) ERP systems grew primarily out of MRP and MRPII.
B) The first generation of ERP system emphasises on integrating the primary and secondary value
chain activities of an organisation.
C) The first generation of ERP system focuses on the "back office" activities.
D) The second generation ERP system, ERP II, is perceived as the single system that can replace
all other systems within an organisation.
E) The second generation ERP system, ERP II, is e-Business ready.
39. XYZ Enterprise runs a proprietary accounting software (i.e. developed in-house) using a cloud model. It installs and hosts the accounting software using the hardware and software rented from acloud vendor. The type of cloud model that XYZ Enterprise is using is the:
A) Infrastructure as a Service
B) Platform as a Service
C) Software as a Service
D) Public cloud
E) Private Cloud
40. Which of the following is NOT a characteristics of SaaS ERP?
A) The client company rents the use of the ERP from the vendor
B) The client company determines the location of the ERP software.
C) The vendor company installs and maintains the ERP software.
D) The client company incurs operational expenses instead of capital expense.
E) The client company shares the access to the ERP software other companies
Explanation / Answer
35. C) Data mart
This is quite a subset of Data warehouse and the data marts are collectively used to form a datawarehouse.
36. D) Data mining
This is the science or research behind datawarehousing based on the data the reports or analysis or conclusion that is drawn is known as data mining and if something likely needs to be understood then it is the possible way.
37. B) Slicing
This is known as slicing because each and every subset is considered in detail.
39. A) Infrastructure as a Service
In this case the organization has used its in house resources to use this is as a service.
40. C) The vendor company installs and maintains the ERP software.
There is actually no need of this as its is hosted directly at the location.