You work as a Database Administrator for XYZ CORP. The company has a multi-platform network. The company requires a database that can receive data from various types of operating systems. You want…

Question

Options

• AIt is used to optimize Online Analytical Processing (OLAP) applications.
• BIt is used to optimize data warehouse.
• CIt is rarely created using input from existing relational databases.
• DIt allows users to ask questions that are related to summarizing business operations and trends.

• A
  76% (34)
• C
  24% (11)

Explanation

A multidimensional database (MDB) is a type of database that is optimized for data warehouse and Online Analytical Processing (OLAP) applications. Multidimensional databases are frequently created using input from existing relational databases. Whereas a relational database is typically accessed using a Structured Query Language (SQL) query, a multidimensional database allows a user to ask questions like "How many Aptivas have been sold in Nebraska so far this year?" and similar questions related to summarizing business operations and trends. An OLAP application that accesses data from a multidimensional database is known as a MOLAP (multidimensional OLAP) application. Answer: C is incorrect. A multidimensional database is frequently created using input from existing relational databases.

No community discussion yet for this question.