Exam DP-900 All QuestionsBrowse all questions from this exam
Question 199

HOTSPOT -

Select the answer that correctly completes the sentence.

    Correct Answer:

Discussion
Mega2

Correct: An aggregated measure. In an analytical model, any point where dimensions intersect represents an aggregated measure. These intersections represent specific data points within the multidimensional structure, and the aggregated measures provide quantitative values based on the selected dimensions and context. Each intersection corresponds to a unique combination of dimension values, and the aggregated measure represents the result of applying aggregation functions (such as sum, average, count, etc.) to the underlying data associated with that combination of dimension values.

Flora606060

The answer should be Cube. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/cubes-in-multidimensional-models?view=asallproducts-allversions

SgnBaiocchi

INCORRECT. From ChatGPT: In the context of multidimensional databases or OLAP systems, a cube represents a multi-dimensional data structure that contains measures, dimensions, and hierarchies. A cube consists of cells that store aggregated data at the intersections of various dimensions. So, cube is the answer

AGTraining

option A - Cube

cloudbaron

A cube is composed of cells, organized by measure groups and dimensions. A cell represents the unique logical intersection in a cube of one member from every dimension in the cube. # https://learn.microsoft.com/en-us/analysis-services/multidimensional-models-olap-logical-cube-objects/cube-cells-analysis-services-multidimensional-data?view=asallproducts-allversions

Sr18

Correct Answer: Qube, associated dimensions are facts but with numerical values. To get all the associated information you will need whole start schema tuple. So that' Qube.

Koteyko

Microsoft websites do not mention such notions as "aggregated measure" and "aggregated dimension", there`re "aggregate measure", i.e., Sum, Avg, Count etc and "aggregate dimension" which come from the defined dimension tables. I assume it`s wrong wording intentional or not. The only valid reference found for the question is by the link and it relates to Cube https://learn.microsoft.com/en-us/analysis-services/multidimensional-models-olap-logical-cube-objects/cube-cells-analysis-services-multidimensional-data?view=asallproducts-allversions

_s3r3nd1p1t1_

it doesn't ask about the overall structure, but about the points of intersection. C is correct.

Yomzie

Answer is: CUBE **A cube is a multidimensional structure that contains information for analytical purposes; the main constituents of a cube are dimensions and measures. **Dimensions define the structure of the cube that you use to slice and dice over, and measures provide aggregated numerical values of interest to the end user. As a logical structure, a cube allows a client application to retrieve values, of measures, as if they were contained in cells in the cube; cells are defined for every possible summarized value. A cell, in the cube, is defined by the intersection of dimension members and contains the aggregated values of the measures at that specific intersection.