Page: 1
/ 36
Total 176 questions
You need to select an appropriate tool for creating the Regional Sales report.
Which tools or tools should you use? (Each correct answer presents a complete solution.
Choose all that apply.)
- A. Power View, using a table configured for vertical multiples
- B. Excel 2010, using a PivotTable
- C. Report Builder, using a Matrix
- D. Power View, using a table configured for horizontal multiples
Answer : B,C
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 Variance %], [Date].[Calendar].PrevMember), 1, 0)
- C. IIF([Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember), 0, 1)
- D. CASE WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE -1 END
Answer : A
You need to configure package execution logging to meet the requirements.
What should you do?
- A. Configure logging in each ETL package to log the OnError, OnInformation, and Diagnostic events.
- B. Set the SSIS catalog's Server-wide Default Logging Level property to Performance.
- C. Set the SSIS catalog's Server-wide Default Logging Level property to Basic.
- D. Set the SSIS catalog's Server-wide Default Logging Level property to Verbose.
- E. Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events.
Answer : B
You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
- A. Set the AttributeHierarchyVisible property to False.
- B. Set the IsAggregatable property to False.
- C. Set the Usage property to Parent.
- D. set the DefaultMember property to the Forecast member.
- E. Set the AttributeHierarchyEnabled property to False.
- F. Set the RootMemberIf property to ParentIsMissing.
Answer : C,D
Explanation:
The Sales measure group is based on the FactSales table. The Sales Plan measure group is based on the FactSalesPlan table. The Sales Plan measure group has been configured with a multidimensional OLAP (MOLAP) writeback partition. Both measure groups use
MOLAP partitions, and aggregation designs are assigned to all partitions.
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)
Answer :
Explanation:
/ The schema design must be extended to include the product dimension data.
* DimProduct table need to contain a foreign key to the DimSubCategory table. No further
SubCategory data should be stored in the DimProduct table.
* No time related columns (StartDate, EndDate) should be included in the DimProduct table.
31 days access 