Select Reporting Tools in Finance and Operations Apps MB-500 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A company has a report that displays sales order totals. The report currently uses a query data source that sums the SalesLine amounts. The sales director wants the report to also display the sales tax amount for each order. You need to enhance the report to include the sales tax amount. What should you do?

   • ACreate a new report that uses the SalesTax table as a data source and link it to the existing report.
   • BModify the report data source to use a data provider class that calculates the sales tax amount and returns it in a temporary table.
   • CAdd a calculated field to the SalesLine table that computes the sales tax amount.
   • DUse the report designer to add a calculated field to the report dataset that references the SalesLine table.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   An existing report in Dynamics 365 Finance and Operations uses a data provider class that populates a temporary table. The report currently shows only the total amount for each sales order. The business now wants the report to also show the number of lines for each order. You need to modify the report to meet this requirement. What should you do?

   • AChange the report data source to a query that joins SalesTable and SalesLine and use the query directly.
   • BModify the data provider class to add a field for the line count to the temporary table and populate it in the class.
   • CCreate a new report that uses the SalesLine table as a data source and link it to the existing report.
   • DAdd a calculated field to the report dataset that counts the number of lines.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company has a report that shows employee salary information. Only HR managers should be able to view this report. You need to ensure that the report is accessible only to authorized users. What should you do?

   • AUse the report's 'Permissions' property to specify the HR managers group.
   • BCreate a security duty that includes the report and assign the duty to the HR managers role.
   • CSet the report's 'Access' property to 'Internal' and grant the HR managers read permission to the report in the security model.
   • DPlace the report in a shared folder and set NTFS permissions for the HR managers group.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In Dynamics 365 Finance and Operations, which datastore is used for operational reports that require real-time data from the application?

   • ATransaction database
   • BEntity store
   • CAzure Synapse
   • DData lake
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company has a report that shows the aging of customer accounts receivable. The report currently uses a query data source that joins the CustTrans table. The finance manager wants the report to also show the customer's credit limit from the CustTable. You need to enhance the report to include the credit limit. What should you do?

   • AAdd the CustTable table as a join to the existing query data source and add the CreditLimit field to the report dataset.
   • BCreate a data provider class that returns the credit limit and use it as a separate data source.
   • CCreate a new report that uses the CustTable as a data source and link it to the existing report.
   • DAdd a calculated field to the CustTable table that returns the credit limit.
   Reveal Solution Discussion Select an answer first