CLOUD COMPUTING

CLOUD COMPUTING

DATABASE MANAGEMENT

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What is Analytical database?
A
Stores historical data and business metrics used exclusively for tactical or strategic decision making
B
Enable retrieving, processing, and modeling data from the data warehouse
C
Stores sari-sari stores for business metric and strategic decision making
D
Captures and processes business data to generate information that support decision making
Explanation: 

Detailed explanation-1: -A data mart is a subject-oriented relational database that stores transactional data in rows and columns, which makes it easy to access, organize, and understand. As it contains historical data, this structure makes it easier for an analyst to determine data trends.

Detailed explanation-2: -An analytic database, also called an analytical database, is a read-only system that stores historical data on business metrics such as sales performance and inventory levels.

Detailed explanation-3: -data warehouse database-A database that focuses primarily on the storage of data used to generate information required to make tactical or strategic decisions.

Detailed explanation-4: -An analytical database stores and manages big data, including business, market and customer data for business intelligence (BI) analysis. Analytical databases are specially optimized for faster queries and scalability.

There is 1 question to complete.