QUESTION 51 You need to define the trend calculation for the sales performance KPI. Which KPI trend MDX expression should you use? A.    CASE WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN -1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE 1 END B.    IIF([Sales Variance %3 < ([Sales…

Continue reading →

QUESTION 41 You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product. You need to calculate…

Continue reading →

QUESTION 31 You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse. Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at…

Continue reading →

QUESTION 21 You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at…

Continue reading →

QUESTION 11 You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription schedules and report formats. You need to ensure that users can receive reports by email according to their preferences. What should you do? (More than one answer choice…

Continue reading →

QUESTION 1 You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a data model. Which role permission should you use? A.    Browser B.    Process C.    Read D.    Administrator E.    Explorer F.    Select Answer: C

Continue reading →