Information and analytical systems Synergy answers to the test. Score 97-100 points (Excellent) 29 out of 30
After purchase, you will receive a file with answers to the questions listed below. 30 questions with answers.
The data warehouse is ...
a subset of corporate data created for a specific group of users, departments or divisions within an organization
online transaction processing systems used to store data on ongoing business transactions
a domain-specific, time-bound and immutable collection of data to support the management decision-making process
The main task of online analysis, or OLAP analysis, is ... to extract information
slow
swift
primary
secondary
Information display of a property of an object, process or phenomenon is ...
database
data store
index
props
The mode in which the data in the store is updated at the same time as the source is called ...
real time
close to real time
batch data integration
The indicator consists of a set ...
attributes-identifiers and attributes-attributes
attributes-bases and attributes-attributes
reason-attributes and value-attributes
When forming the structure of the report, the data area is placed -
measurements
measures (facts)
columns
strings
A kind of composite unit of information is ...
props
index
database
data store
... is a direction of analysis, a way of data detailing that determines the components of aggregated measures
Measure
Measurement
Attributes
Hierarchy
Arrange in the order of execution the technological processes that make up the technology of the data warehouse:
data collection technology
data cleansing and loading technology
settlement technology
query processing technology
The main components of the information space include ...
informational resources
information flows
means and technologies of information interaction
information infrastructure
When forming the structure of the report, the active dimensions include ...
filters
measures (facts)
columns
strings
Live integration starts at the moment of data change, that is, it happens ...
"of necessity"
"By event"
"optional"
The requirement ... in the FASMI test means that the system should provide users with the analysis results in a reasonable time
FAST ("fast")
ANALYSIS ("analysis")
SHARED ("shared")
MULTIDIMENSIONAL ("multidimensional")
INFORMATION
E. Codd formulated ... the basic requirements for OLAP implementation tools
12
13
15
A way of storing data in which the data used for reports is stored in disparate sources is called ...
decentralized
centralized
spaced
united
The totality of banks and databases, technologies for their maintenance and use, information telecommunication systems are
information documents
information space
information objects
informational resources
... data is a domain-specific data store (usually of aggregated information) intended for use by a group of users within the framework of a specific type of enterprise activity
Showcase
Centralized storage
Distributed storage
Documents and arrays of documents stored in information systems are ...
information documents
information space
information objects
informational resources
... are turnkey solutions that support one or more data integration technologies
Applications
Products
Technologies
Methods
... are the final solutions created by information system providers in accordance with the client´s requirements
Applications
Products
Technologies
Methods
In E-LT technology, data transformation can occur ...
before uploading them to the target storage
after uploading them to the target storage by user request
after they are uploaded to the target storage according to a specific schedule
Arrange the categories of structured information space in order of increasing complexity:
unstructured (NISP)
semi-structured (SSIP)
formalized-structured (FSIP)
machine-structured (MSIP)
Base attributes are displayed as a dot ...
on the X-axis of the information space
on the Y-axis of the information space
in the information space
on the Z-axis of the information space
The properties of information storages include ...
time binding
redundancy
immutability
subject orientation
When ... data is pulled from disparate sources and loaded into a single persistent data store
consolidation
federalization
dissemination
Codd´s definition has been reworked into a so-called test ...
DASMI
PASMI
FASMI
LASMI
When filling storages with data that allows a significant update time interval, it is used ...
real time mode
near real time
batch data integration
When generating a report on the sales of a certain product to various customers throughout the year, you need to place ...
time
volume of sales
client
product
When an OLAP cube is "cut" by any plane, it turns out
several small OLAP cubes
two equal parts of an OLAP cube
one-dimensional table
two-dimensional table
is the arrangement of parts or elements of a whole in order from highest to lowest
Measure
Measurement
Attributes
Hierarchy
No feedback yet