Which of the Following Is True

question 23

Multiple Choice

Which of the following is true?

• A)You can create a pivot table from the data in an Excel Data Model,but you must first ensure that Power Pivot is loaded.
• B)You can create a pivot table from the data in an Excel Data Model even if Power Pivot is not loaded.
• C)If your data are stored in an Excel Data Model,not in one or more worksheets,you can view the data regardless of whether Power Pivot is loaded.
• D)Assuming that you want to build a pivot table and Power Pivot has not been loaded,your data should be stored in an Excel Data Model and in one or more worksheets.

---

Definitions:

Data Warehouse

A centralized repository for data that allows an organization to store, query, and analyze large amounts of structured data from various sources.

Data Dictionary

A unified storage space for data details, including its meaning, connections with other data, source, application, and structure.

Relational Database

A relational database is a digital database based on the relational model of data, where data is organized into tables (known as relations) that are related by common fields, allowing for efficient data retrieval and management.

Batch Processing

The accumulation of transaction data until a certain point is reached, at which time several transactions are processed at once.