Questão 1
Questão
1.BI is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
Questão 2
Questão
2.Monitoring results to evaluate outcomes of the business decisions is outside the scope of BI.
Questão 3
Questão
3.The BI architecture is composed of data, people, processes, technology, and the management of such components.
Questão 4
Questão
4.A data store is used by the data analyst to create the queries that access the database.
Questão 5
Questão
5.MDM’s main goal is to provide a partial and segmented definition of all data within an organization.
Questão 6
Questão
6.SAP is a portal vendor.
Questão 7
Questão
7. To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.
Questão 8
Questão
8.Operational data and decision support data serve the same purpose.
Questão 9
Questão
9.Decision support data are a snapshot of the operational data at a given point in time
Questão 10
Questão
10.Queries against operational data typically are broad in scope and high in complexity.
Questão 11
Questão
11.The decision support database query optimizer must be enhanced to support non-normalized structures.
Questão 12
Questão
12.Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
Questão 13
Questão
13.Once data enter the data warehouse, they are never removed.
Questão 14
Questão
14.Creating a data warehouse is a simple exercise that takes little time, money, or effort.
Questão 15
Questão
15.The data warehouse development life cycle differs from classical systems development.
Questão 16
Questão
16.Facts can be computed or derived at run time.
Questão 17
Questão
17.The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search, group information, or describe attributes.
Questão 18
Questão
18.Data warehouses usually have one fact table
Questão 19
Questão
19.Normalizing fact tables improves data access performance and saves data storage space.
Questão 20
Questão
20.Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.
Questão 21
Questão
21.It is a relatively easy task to provide a precise list of characteristics of data-mining tools.
Questão 22
Questão
22.In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes
Questão 23
Questão
23.Multidimensional data analysis techniques include advanced computational functions.
Questão 24
Questão
24.The mainframe environment enables an OLAP system to be divided into several components that define its architecture.
Questão 25
Questão
25.In most implementations, the data warehouse and OLAP are stand-alone, independent environments.
Questão 26
Questão
26.To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.
Questão 27
Questão
27.The star schema is designed to optimize data query operations rather than data update operations.
Questão 28
Questão
28.MOLAP is a logical choice for companies that already use relational databases for their operational data.
Questão 29
Questão
29.Because a data cube’s dimensions are predefined, all cells are populated.
Questão 30
Questão
30.ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.