Microsoft 70-470 - Recertification for MCSE: Business Intelligence Exam
Page: 3 / 64
Total 316 questions
Question #11 (Topic: Topic 2)
You need to configure SSRS to meet the maximum number of snapshots requirement.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. In SharePoint Central Administration, set the System Snapshot Limit option to 5.
B. In Reporting Services Configuration Manager, set the System Snapshot Limit option to 5.
C. For each report, set the Limit number of snapshots option to 5.
D. Use PowerShell to set the System Snapshot Limit option to 5.
Answer: A,C
Question #12 (Topic: Topic 2)
You need to optimize the Regions dimension.
How should you configure the attribute relationships? (To answer, drag the appropriate
attribute from the list of attributes to the correct location in the hierarchy relationship. Use
only attributes that apply.)
[Microsoft-70-470-5.0/Microsoft-70-470-18_2.png]
How should you configure the attribute relationships? (To answer, drag the appropriate
attribute from the list of attributes to the correct location in the hierarchy relationship. Use
only attributes that apply.)
[Microsoft-70-470-5.0/Microsoft-70-470-18_2.png]
Answer: [Microsoft-70-470-5.0/Microsoft-70-470-18_3.png]
Question #13 (Topic: Topic 2)
You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which S5A5 feature should you use?
Which S5A5 feature should you use?
A. Calculation
B. Translation
C. Action
D. Perspective
Answer: B
Question #14 (Topic: Topic 2)
You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose
all that apply.)
What should you do? (Each correct answer presents part of the complete solution. Choose
all that apply.)
A. Create Service Principal Names (SPNs).
B. Configure account delegation.
C. Enable forms-based authentication.
D. Enable mixed-mode authentication.
Answer: A,D
Question #15 (Topic: Topic 2)
You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A. Remove default values from all parameters.
B. Implement dataset query parameters to filter data.
C. Set the data source to use Windows authentication.
D. Set the data source to use stored Windows credentials.
E. Provide default values for all parameters.
F. Implement dataset filters to filter data.
Answer: B,D,E
