QUESTION 1
You need to configure a hierarchy for DimProduct that meets the technical requirements.
What should you do?
A. Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductName. For ProductCategory, click Hide if Name Equals Parent
B. Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent.
C. Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent
D. Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent.
Correct Answer: B QUESTION 2
After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the report by
email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?
A. From Central Administration, modify the properties of the Reporting Service Application.
B. Modify the Rssrvrpolicy.config file.
C. Modify the Rsmgrpolicy.config file.
D. From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
Correct Answer: C QUESTION 3
After you deploy the RegionalSales report, users report that they cannot see product data when they
receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?
A. In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive).
B. In When the report is initially run, select Show or hide based on an expression. Se: The expression to =NOT (GlobalslRenderFormat.IsInteractive)
C. In when the report is initially run, select Show.
D. In When the report is initially run, select Hide.
Correct Answer: D QUESTION 4
You need to recommend a solution for the sales department that meets the security requirements. What should you recommend?
A. Create one role for all of the sales department users. Configure the role to have read access to the sales transactions. Ensure that all of the reports that access the sales transaction data restrict read access to the data from the corresponding sales department region only.
B. Create one role for each region. Configure each role to have read access to a specific region. Add the sales department users to their corresponding role.
C. Create one role for all of the sales department users. Add a DAX filter that reads the current user name and retrieves the user’s region.
D. Create a table for each region. Create a role for each region. Grant each role read access to its corresponding table.
Correct Answer: C QUESTION 5
You need to ensure that all reports meet the reporting requirements.
What is the best way to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.
A. Create a report part. Publish the report part to a server that has SSRS installed. Add the report part to each new report that is created.
B. Create a report part. Publish the report part to a SharePoint site. Add the report part to each new report that is created.
C. Create a report. Copy the report to source code control. Create each new report by using the report template in source code control.
D. Create a report. Copy the report to the PrivateAssemblies\ProjectItems\ReportProject folder in the Visual Studio directory. Create each new report by using the locally stored report
Correct Answer: D
