2025-26-1S-COGNATES3-IST3-MQ8

Advanced measures often involve __________ metrics.  

• a. Random

• b. Derived

• c. Static

• d. Hidden

MDX is commonly used to define __________.  

• a. Error logs

• b. Calculated measures

• c. Firewalls

• d. Keys

A semi-additive measure can be aggregated across some but not all __________.  

• a. Networks

• b. Dimensions

• c. Logs

• d. Keys

The LASTNONEMPTY function in MDX is used for __________.  

• a. Logs

• b. Time-based measures

• c. Metadata

• d. Security

A KPI in cubes measures progress against __________.  

• a. Metadata

• b. Transactions

• c. Defined goals

• d. Firewall rules

YTD stands for __________.  

• a. Your Time Dimension

• b. Year To Date

• c. Yield Trend Data

• d. Yesterday Trend Data

A calculated member can exist in both measure and __________ dimensions.  

• a. Log

• b. Non-measure

• c. Static

• d. Firewall

Weighted averages in BI are implemented using __________ formulas. 

• a. Random

• b. Custom MDX

• c. Log

• d. Binary

Non-additive measures include metrics like __________.  

• a. Revenue

• b. Ratios

• c. Units sold

• d. Costs

Advanced time intelligence functions can calculate __________ performance.  

• a. Firewall

• b. Period-over-period

• c. Cache

• d. Random