You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?
You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?
To ensure that the data is updated to meet the report requirements with minimal configuration effort, you should configure a scheduled refresh without using an on-premises data gateway. Since the data source mentioned is an Azure SQL Database, there is no need for an on-premises data gateway, and using a scheduled refresh directly is the simplest approach. This minimizes the configuration effort while ensuring the data is updated as required.
Trick question, depends whether the Microsoft Dynamics 365 is cloud or on prem. https://learn.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn708055(v=crm.8)#in-this-topic
From your link: "Scheduled refresh of reports isn’t supported with Dynamics 365 (on-premises) datasets that are published to the Power BI service. You can refresh reports using in Microsoft Power BI Desktop or Microsoft Office Excel and then upload the reports to the Power BI service." So D is impossible. C is correct.
The question mentions that "The balance sheet is IMPORTED." My understanding is that it is on-premise and the correct answer is D.
Migrating to the cloud with Business Central can help you reduce costs associated with maintaining on-premises systems, streamline operations by using more timely data, and enhance security. You’ll also have access to AI capabilities such as Copilot, enabling your teams to work smarter, adapt faster, and perform better.
At the 'Data type' table, it literally says Azure SQL database
Somewhere in the requirements: "An Azure Active Directory (Azure AD) group will be used to share information with the board." So apparently the solutions is build on Azure. So answer: C
Ah! And even more clearly: the table with data sources states clearly "Azure SQL Database"!
C is the answer. The database is on Azure database, not on-premise
C ONLY
Both C and D can achieve the results, but gateway requires more configuration effort, so the answer goes to C. Do not discount D just because it uses on-premise data gateway. Gateway can be used even if all data in a dataset is in Azure. Here below is directly copied from PowerBI service gateway connection configuration page for a dataset that comes out of an Azure SQL database. "You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect".
On-premises allows multiple users to connect to multiple on-premises data sources. The report has to be related in a many-to-one relationship.
Azure SQL Server is considered as ON_PREM checki it....
It is the only option that works