I85PREP
⌘ K
MicroStrategy Analyst study materials
MicroStrategy Analyst study resources

MicroStrategy Analyst practice questions

One question at a time. Build your MicroStrategy Analyst understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Semantic Layer Fundamentals

In a MicroStrategy project, what is the primary purpose of a schema object?

  1. To schedule subscriptions and report deliveries
  2. To control which users may log in to the project
  3. To store the physical table and column mappings that connect the project to the data warehouse Correct answer.
  4. To define the visual formatting applied to reports at runtime

Explanation

A schema object holds the logical-to-physical mapping: which warehouse tables and columns supply attributes and facts. Report formatting, user authentication, and subscription scheduling are handled by other object types, not the schema.

Question 2Semantic Layer Fundamentals

Which schema object represents a business concept such as Customer or Product that is used to slice and group metric data?

  1. Attribute Correct answer.
  2. Filter
  3. Transform
  4. Fact

Explanation

Attributes model the business entities by which metrics are grouped, such as Customer or Product. Facts supply the numeric data, transforms remap time or other relationships, and filters restrict the rows returned.

Question 3Semantic Layer Fundamentals

Which object holds the numeric column, such as Revenue or Quantity, that a metric aggregates?

  1. Hierarchy
  2. Prompt
  3. Fact Correct answer.
  4. Attribute form

Explanation

A fact maps to one or more numeric warehouse columns and is the raw input a metric aggregates. Attribute forms describe an attribute, hierarchies organize attributes, and prompts collect user input at run time.

Question 4Semantic Layer Fundamentals

A metric definition specifies SUM(Revenue) with no filter. What does the metric return when placed on a report grouped by Region?

  1. Revenue summed across all regions regardless of the report grouping
  2. Revenue summed within each Region on the report Correct answer.
  3. The average Revenue per region
  4. The count of rows in the fact table

Explanation

A metric without its own filter is calculated at the level of the attributes placed on the report, so SUM(Revenue) aggregates within each Region. It does not collapse across regions unless the grouping is removed.

Question 5Semantic Layer Fundamentals

What distinguishes a compound attribute from a simple attribute?

  1. A compound attribute can only be used in filters and never on a report grid
  2. A compound attribute must map to a single warehouse column
  3. A compound attribute stores numeric measures instead of descriptive data
  4. A compound attribute is built from two or more other attributes and derives its ID from their combination Correct answer.

Explanation

A compound attribute is defined from multiple component attributes, and its element ID is formed from the combination of the component IDs. It can be used on reports and in filters like any other attribute.

Question 6Semantic Layer Fundamentals

Which object type defines a reusable set of qualifications, such as Revenue greater than 1000, that can be applied to reports?

  1. Consolidation
  2. Filter Correct answer.
  3. Drill map
  4. Custom group

Explanation

A filter object stores reusable qualification criteria, including metric qualifications, that can be applied to reports and templates. Consolidations combine attribute elements, custom groups group elements, and drill maps define drill paths.

Question 7Semantic Layer Fundamentals

In a MicroStrategy project, what is the role of the fact table in the schema?

  1. It stores user account and privilege information
  2. It stores the numeric measures and the foreign keys that join to attribute lookup tables Correct answer.
  3. It stores report definitions and formatting settings
  4. It stores only attribute descriptions and no numeric data

Explanation

Fact tables hold the numeric measures plus the foreign keys that relate them to attribute lookup tables, forming the star or snowflake structure. Attribute descriptions live in lookup tables, while report and user definitions are stored in metadata.

Question 8Semantic Layer Fundamentals

What does an attribute's ID form uniquely identify?

  1. A single element of the attribute, such as one customer Correct answer.
  2. The metric that aggregates the attribute
  3. The physical table where the attribute is stored
  4. The report on which the attribute appears

Explanation

The ID form provides the unique key for each attribute element, so one customer is distinguished from another. It is separate from the physical table mapping and unrelated to report or metric definitions.

Question 9Semantic Layer Fundamentals

A metric is defined as SUM(Revenue) with a filter of Year = 2024. When the metric appears on a report that also has Year on the grid, what happens?

  1. The report filter overrides the metric filter entirely
  2. The metric filter is ignored and all years are shown
  3. The report fails to execute because two filters conflict
  4. The metric's filter and the report filter combine, so only 2024 data appears for that metric Correct answer.

Explanation

Metric filters and report filters are both applied, and their qualifications are combined. Placing Year on the grid does not remove the metric's own Year = 2024 restriction, so only 2024 values are returned for that metric.

Question 10Semantic Layer Fundamentals

Which level of aggregation does a metric use by default when no dimensionality is specified in its definition?

  1. The lowest level of every hierarchy in the project
  2. The level of the attributes on the report Correct answer.
  3. The level of the fact table's primary key
  4. The highest level of every hierarchy in the project

Explanation

By default a metric is calculated at the dimensionality of the report, meaning the attributes placed on the grid. Dimensionality can be restricted explicitly in the metric definition, but the default follows the report.

Question 11Semantic Layer Fundamentals

Which metric level setting forces a metric to be calculated at the level of a specific attribute regardless of the report grid?

  1. The drill map
  2. The dimensionality setting in the metric definition Correct answer.
  3. The attribute form
  4. The report filter

Explanation

The metric dimensionality setting specifies the attributes at which the metric is calculated, independent of what appears on the grid. Report filters restrict rows, while attribute forms and drill maps serve unrelated purposes.

Question 12Semantic Layer Fundamentals

What is the effect of setting a metric's dimensionality to a single attribute such as Customer?

  1. The metric can only be displayed on reports that contain Customer
  2. The metric is calculated at the Customer level and then re-aggregated to whatever the report displays Correct answer.
  3. The metric is automatically converted to a count metric
  4. The metric ignores the report filter

Explanation

Setting dimensionality to Customer calculates the metric at that level and then aggregates the result up to the report's grouping. The metric can still appear on reports that lack Customer, and it does not bypass the report filter.

Question 13Semantic Layer Fundamentals

Which object groups attribute elements into named buckets defined by filter criteria, for example grouping products that meet a revenue threshold into a 'Premium' bucket?

  1. Custom group Correct answer.
  2. Hierarchy
  3. Consolidation
  4. Transform

Explanation

A custom group defines named groupings using filter criteria, such as a metric qualification selecting products that meet a revenue threshold. Consolidations group explicit attribute elements rather than defining a group through that filter. Hierarchies define levels, and transforms remap relationships.

Question 14Semantic Layer Fundamentals

What does a consolidation object do on a report?

  1. It combines two filters into a single qualification
  2. It merges two metrics into one calculated metric
  3. It combines multiple attribute elements into a single new element that can be displayed alongside the originals Correct answer.
  4. It merges two projects into one shared schema

Explanation

A consolidation creates a new element from several attribute elements, such as combining East and West into a new region element. It operates on attribute elements, not metrics, projects, or filters.

Question 15Semantic Layer Fundamentals

A report shows Year-to-Date Revenue using a transform. What does the transform accomplish in this case?

  1. It remaps each month to the set of months from the start of the year through that month Correct answer.
  2. It filters the report to show only December
  3. It converts the metric into a rank metric
  4. It permanently stores year-to-date totals in the warehouse

Explanation

A YTD transform maps each period to the range of periods from the beginning of the year to that period, allowing the metric to aggregate over that range. It does not store data in the warehouse, filter to December, or convert the metric to a rank.

Question 16Semantic Layer Fundamentals

Which object defines the drill path a user follows when drilling from one attribute level to another, such as from Category to Subcategory?

  1. Fact
  2. Drill map Correct answer.
  3. Filter
  4. Consolidation

Explanation

A drill map specifies the attributes and hierarchy levels a user can drill to and the order of navigation. Filters restrict data, consolidations combine elements, and facts store measures.

Question 17Semantic Layer Fundamentals

A parent-child hierarchy is used in a schema. Which characteristic distinguishes it from a standard user hierarchy?

  1. It stores metric values instead of attribute relationships
  2. Its relationships are stored as data rows rather than being fixed in the schema Correct answer.
  3. It cannot be used for drilling
  4. It must contain exactly two attributes

Explanation

A parent-child hierarchy derives its relationships from data, typically a parent ID column, so the structure can change without schema changes. It supports drilling and is not limited to two attributes.

Question 18Semantic Layer Fundamentals

What is the purpose of an attribute relationship in the schema?

  1. It defines how one attribute determines another, such as City determining State Correct answer.
  2. It defines which metric aggregates a fact
  3. It defines the formatting of an attribute's column
  4. It defines which users can view a report

Explanation

Attribute relationships capture determination between attributes, so that City determines State. They inform how the engine joins tables and aggregates data, and are unrelated to metrics, security, or formatting.

Question 19Semantic Layer Fundamentals

A report groups data by Customer and displays a metric defined at the Region level only. What does the metric return for each customer?

  1. The customer-specific value
  2. An error because the levels differ
  3. The Region-level value repeated for every customer in that region Correct answer.
  4. A null for every customer

Explanation

Because the metric's dimensionality is fixed at Region, the value is computed per region and then displayed for each customer in that region. It does not compute at the customer level, and no error or null results.

Question 20Semantic Layer Fundamentals

Which object is used to define a nested grouping of attribute elements with multiple levels, such as grouping stores into districts and regions?

  1. Simple filter
  2. Fact
  3. Transform
  4. Custom group with multiple levels Correct answer.

Explanation

A custom group can be defined with multiple levels so elements are grouped hierarchically, such as stores into districts and regions. A simple filter restricts rows, a fact stores measures, and a transform remaps relationships.

Question 21Semantic Layer Fundamentals

Which statement best describes the relationship between a metric and a fact in the schema?

  1. A metric references one or more facts and applies an aggregation function to them Correct answer.
  2. A fact references one or more metrics and applies an aggregation function to them
  3. A metric and a fact are the same object with different names
  4. A metric stores warehouse columns while a fact stores report formatting

Explanation

Metrics are built on facts, applying functions such as SUM or AVG to the fact columns. Facts are the raw numeric inputs, so the dependency runs from metric to fact, not the reverse.

Question 22Semantic Layer Fundamentals

A metric uses a filter on a different attribute than the report's grouping. How does the engine handle the aggregation?

  1. It applies the metric filter in the query and aggregates over the resulting set, which can produce values that do not sum to the report total Correct answer.
  2. It converts the metric filter into a report filter
  3. It automatically removes the conflicting attribute from the report
  4. It ignores the metric filter whenever the attributes differ

Explanation

The metric filter is applied within the metric's calculation, so the metric aggregates over its own qualified set. When that set differs from the report grouping, the metric values may not reconcile to the report total, which is expected behavior.

Question 23Semantic Layer Fundamentals

Which combination correctly describes a level metric versus an absolute (unnested) metric?

  1. A level metric is always a count, while an absolute metric is always a sum
  2. A level metric is calculated at specified attributes and re-aggregated, while an absolute metric is calculated at the report level Correct answer.
  3. A level metric ignores dimensionality, while an absolute metric fixes dimensionality
  4. A level metric stores warehouse data, while an absolute metric stores metadata

Explanation

Level metrics (nested metrics) declare the attributes at which they are computed and then re-aggregate to the report. Absolute metrics have no such declared level and are calculated at the dimensionality of the report.

Question 24Semantic Layer Fundamentals

A schema includes a snowflake structure where Customer joins to City, which joins to State. Which statement about querying by State is accurate?

  1. State must be defined as a fact to be queried
  2. The engine can join through City to reach State, so State can be used for grouping without placing City on the report Correct answer.
  3. State requires a separate fact table to be joined
  4. State cannot be used unless City is placed on the report grid

Explanation

Attribute relationships let the engine traverse intermediate attributes such as City to reach State, so State can be used for grouping without City on the grid. State is an attribute, not a fact, and does not require a separate fact table.

Question 25Semantic Layer Fundamentals

Which scenario best demonstrates when a transform is required rather than a standard attribute relationship?

  1. Counting customers by state
  2. Filtering a report to a specific product category
  3. Comparing each month's revenue to the same month of the prior year Correct answer.
  4. Summing revenue by region for the current year

Explanation

A transform remaps attribute relationships to support comparisons such as same-period prior year, which a standard relationship cannot express. Summing by region, counting by state, and filtering by category use ordinary attributes and filters.

Question 26Semantic Layer Fundamentals

Which MicroStrategy object stores the business definition that maps an attribute to its source column and determines how its elements are displayed on a report?

  1. The fact extension
  2. The report filter
  3. The security filter
  4. The attribute form Correct answer.

Explanation

An attribute form is the definition that ties an attribute to a specific column in a lookup table and supplies the display value for its elements. A single attribute can have many forms, but only one is used as the display form on a given report.

Question 27Semantic Layer Fundamentals

What does an attribute's lookup table provide in a MicroStrategy schema?

  1. The join order used by the query engine
  2. The cached report results for the project
  3. The rows of transaction data that metrics aggregate
  4. The distinct element list and descriptive columns for the attribute Correct answer.

Explanation

A lookup table holds one row per attribute element together with its ID and descriptive columns, letting the engine resolve element lists and display values. Transaction data lives in fact tables, while joins are defined by the schema itself.

Question 28Semantic Layer Fundamentals

Which schema component connects an attribute lookup table to a fact table so that metric values can be sliced by that attribute?

  1. A relationship defined between the tables Correct answer.
  2. A prompt definition
  3. A metric formula
  4. A filter qualification

Explanation

The schema records relationships between tables, and these relationships let the engine join fact data to attribute lookup data. Without a defined relationship the engine cannot relate the attribute to the fact and will report the metric at a higher level.

Question 29Semantic Layer Fundamentals

Which object type holds the numeric columns, such as Revenue and Cost, that metrics aggregate in a MicroStrategy project?

  1. Hierarchy
  2. Fact Correct answer.
  3. Transform
  4. Attribute

Explanation

A fact object maps to a numeric column in a fact table and serves as the building block that metrics aggregate. Attributes describe the dimensions by which those facts are sliced.

Question 30Semantic Layer Fundamentals

Which object type is created when an analyst needs to combine several attributes into one reusable unit, such as a Geography object built from Region, State, and City, for display and drilling?

  1. A consolidation
  2. A compound attribute Correct answer.
  3. A filter
  4. A custom group

Explanation

A compound attribute groups multiple attributes so they behave as one unit on reports and in drill paths. It is distinct from a consolidation, which groups elements rather than attributes.

Question 31Semantic Layer Fundamentals

What is the primary function of a filter object in the semantic layer?

  1. To define the aggregation level of a metric
  2. To set the cache expiration for a report
  3. To specify which attribute elements or metric values qualify for inclusion Correct answer.
  4. To determine the display format of a metric

Explanation

A filter contains qualifications that determine which rows or elements are included when a report or metric is executed. It does not change aggregation levels or formatting.

Question 32Semantic Layer Fundamentals

Which statement describes an attribute relationship in a MicroStrategy schema?

  1. It defines the order in which reports are executed
  2. It defines how one attribute's elements map to another attribute's elements through their tables Correct answer.
  3. It defines which users may view a report
  4. It defines the numeric precision used when aggregating a metric

Explanation

An attribute relationship records that one attribute determines another, such as City determining State, which lets the engine resolve levels and aggregate correctly. These relationships are stored in the schema and drive how attributes can be combined on a report.

Question 33Semantic Layer Fundamentals

Which term describes the lowest level of detail at which a metric can be calculated given the attributes present on a report?

  1. The fact level
  2. The schema level
  3. The report filter
  4. The metric level Correct answer.

Explanation

The metric level is the set of attributes at which the engine computes the metric for a given report. It is derived from the metric definition combined with the attributes on the report.

Question 34Semantic Layer Fundamentals

A metric is defined as SUM(Revenue) with no dimensionality specified. A report contains Region and Category. At what level does the engine compute the metric?

  1. At the Category level only
  2. At the project level, ignoring both attributes
  3. At the Region level only
  4. At the report level, which includes both Region and Category Correct answer.

Explanation

When a metric has no explicit dimensionality it is computed at the level of the report, using all attributes present in the report's grouping. Here that means the combination of Region and Category.

Question 35Semantic Layer Fundamentals

A metric's dimensionality is set to the Customer attribute. Which result appears when the metric is placed on a report grouped by Region?

  1. The metric returns a single grand total across all regions
  2. The metric repeats the same Customer-level value for every Region row Correct answer.
  3. The metric cannot be placed on the report and returns an error
  4. The metric returns the value for the first customer in each region

Explanation

When a metric is fixed at the Customer level and the report is grouped by a higher attribute, the engine cannot aggregate the Customer-level values to Region, so the same value is repeated. The report still executes but the numbers are not region-specific.

Question 36Semantic Layer Fundamentals

Which metric setting should be used to force a metric to be computed at the level of the Order attribute even when the report groups by Customer and Day?

  1. Set the metric to use a consolidation
  2. Set the dimensionality to the Order attribute Correct answer.
  3. Set the metric filter to Order
  4. Set the metric to use a transform

Explanation

Setting the metric dimensionality to Order fixes the calculation level at that attribute regardless of the report's grouping. A metric filter would only restrict rows and would not change the calculation level.

Question 37Semantic Layer Fundamentals

A metric contains a filter of Year = 2024, and the report also groups by Year. What does the report display for years other than 2024?

  1. An error because the filter conflicts with the report grouping
  2. The metric value for 2024 repeated in every year row Correct answer.
  3. The metric value for each year, because the report overrides the metric filter
  4. A null value because no data qualifies

Explanation

A filter embedded in a metric definition applies to the metric itself, so the metric always evaluates the 2024 subset regardless of the report's Year grouping. The 2024 result therefore repeats across the other year rows.

Question 38Semantic Layer Fundamentals

Which object should be used to group specific store elements into named sets such as 'Flagship' and 'Outlet' for use as a report grouping?

  1. A custom group Correct answer.
  2. A consolidation
  3. A compound attribute
  4. A transform

Explanation

A custom group defines named sets of attribute elements using qualifications and can be used as a grouping on reports. A consolidation also groups elements but is intended for combining elements into buckets for calculation, not for qualification-based groupings.

Question 39Semantic Layer Fundamentals

Which statement best distinguishes a metric from a fact in the semantic layer?

  1. A fact can contain filters, while a metric cannot
  2. A metric is a business measure with an aggregation formula, while a fact is the underlying numeric column Correct answer.
  3. A fact is a business measure with an aggregation formula, while a metric is a raw column
  4. A metric is stored in the lookup table, while a fact is stored in the fact table

Explanation

A fact maps to a numeric column in a fact table, while a metric adds the business definition such as the aggregation function, filters, and dimensionality. Metrics are built from facts and can include logic that a fact alone does not carry.

Question 40Semantic Layer Fundamentals

A report groups by Category and displays a metric whose dimensionality is fixed at the Region level. What does the metric return for each Category row?

  1. A null value because Region is not on the report
  2. The metric value for the region that contains the most categories
  3. The metric value summed across all regions
  4. The metric value repeated at the Region level for each Category row Correct answer.

Explanation

A metric fixed at the Region level cannot be aggregated to Category because Category is unrelated to Region in the aggregation path, so the Region-level value repeats on each row. The report does not error and does not return null.

Question 41Semantic Layer Fundamentals

Which object type creates a time comparison such as Revenue for the current month versus the same month last year?

  1. A consolidation
  2. A hierarchy
  3. A custom group
  4. A transform Correct answer.

Explanation

A transform defines a relationship between time periods, such as current month to same month last year, and is applied to a metric to produce the comparison. It relies on the time attribute's relationships in the schema.

Question 42Semantic Layer Fundamentals

What is the purpose of a drill map in a MicroStrategy project?

  1. To define the sequence of attributes a user can drill through from a given report Correct answer.
  2. To define the cache settings for a report
  3. To define which users may access which reports
  4. To define the aggregation formula for a metric

Explanation

A drill map specifies the drill paths available from a report, determining which attributes a user can navigate to when drilling. It is separate from security, metric formulas, and caching.

Question 43Semantic Layer Fundamentals

A schema contains Customer joined to City, and City joined to State. Which statement about querying a metric grouped by State is accurate?

  1. The engine returns an error because the join path is indirect
  2. The engine joins through City to resolve State and aggregates the fact data accordingly Correct answer.
  3. The engine cannot use the snowflake and must denormalize the tables first
  4. The engine ignores the City table because it is not on the report

Explanation

The engine follows the defined relationships through the intermediate City table to resolve State and aggregate the fact data at that level. Snowflaked schemas are supported without requiring denormalization.

Question 44Semantic Layer Fundamentals

Which scenario requires a transform rather than a standard attribute relationship?

  1. Filtering a report to a single year
  2. Comparing this year's revenue to last year's revenue for the same store Correct answer.
  3. Grouping stores into named regions
  4. Displaying the state for each city on a report

Explanation

A transform is needed when the comparison involves the same attribute at a different point in time, such as this year versus last year. Standard relationships cannot express that offset, so a transform object supplies the time comparison logic.

Question 45Semantic Layer Fundamentals

A report displays a metric defined at the Day level while grouping by Month. What does the engine do with the Day-level values?

  1. It returns only the first day's value for each month
  2. It returns an error because the levels differ
  3. It aggregates them to the Month level using the metric's aggregation function Correct answer.
  4. It returns a null for each month

Explanation

When the metric's level is finer than the report's grouping, the engine rolls the values up to the report level using the metric's aggregation function. This is the normal behavior that lets detailed metrics appear on higher-level reports.

Question 46Semantic Layer Fundamentals

Which characteristic distinguishes a parent-child hierarchy from a standard user hierarchy in the schema?

  1. It cannot be used for drilling on reports
  2. It stores the relationships between elements in a single table rather than relying on attribute relationships Correct answer.
  3. It requires every attribute to have a lookup table
  4. It can only be used with time attributes

Explanation

A parent-child hierarchy stores the element-to-element relationships in one table, such as employee to manager, rather than deriving them from attribute relationships. This allows variable-depth hierarchies that standard user hierarchies cannot represent.

Question 47Semantic Layer Fundamentals

A metric's dimensionality is set to the Customer attribute, but the report also includes a filter on Region. How does the engine resolve the two?

  1. The dimensionality fixes the calculation level and the filter restricts which rows are read Correct answer.
  2. The filter overrides the dimensionality and the metric is computed at Region
  3. The engine raises an error because the settings conflict
  4. The engine ignores both settings and computes at the report level

Explanation

Dimensionality and filters serve different purposes: dimensionality fixes the level of calculation, while the filter restricts which rows are read before aggregation. Both are applied together rather than one overriding the other.

Question 48Semantic Layer Fundamentals

A report groups by Category and displays a metric defined at the Region level, but Region is not related to Category in the schema. What is the most likely result?

  1. The engine returns an error and blocks execution
  2. The metric returns a null value for every row
  3. The metric returns the same Region-level value on every Category row Correct answer.
  4. The engine automatically adds Region to the report grouping

Explanation

When the metric's level and the report's grouping share no relationship path, the engine cannot aggregate between them, so the fixed-level value repeats on each row. This is a common cause of misleading repeated numbers on reports.

Question 49Semantic Layer Fundamentals

Which combination correctly describes a level metric versus an absolute metric?

  1. A level metric is fixed to specified attributes, while an absolute metric is computed at the report level Correct answer.
  2. A level metric is computed at the report level, while an absolute metric is fixed to specified attributes
  3. Both are fixed to specified attributes and differ only in formatting
  4. Both are computed at the report level and differ only in caching

Explanation

A level metric carries explicit dimensionality that fixes its calculation to named attributes, while an absolute metric has no fixed dimensionality and is computed at the level of the report. The distinction determines whether the value changes with the report's grouping.

Question 50Semantic Layer Fundamentals

A report groups by Year and displays a Year-to-Date Revenue metric built on a transform. What does the transform accomplish in this case?

  1. It removes the Year attribute from the report grouping
  2. It converts revenue into a different currency
  3. It accumulates revenue from the start of each year through the current period Correct answer.
  4. It restricts the report to the current year only

Explanation

A Year-to-Date transform relates each period to the start of its year so the metric accumulates values across the year. It does not filter rows, convert currency, or alter the report's grouping.