Question 37

Explanation

<<This entire discussion is on Power BI service, NOT Power BI Desktop>>

If you need to monitor and detect fraudulent transactions in real-time, you wouldn’t manually refresh the Power BI report with a mouse click. The reports should be automatically updated as soon as a transaction is created in the database so you can take corrective action.

Automatic page refresh in Power BI automatically updates the active report if the source data changes.

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh

But automatic page refresh works only with data sources that support DirectQuery. Thankfully, relational data sources like Teradata support DirectQuery.

Quick Preview:

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#considerations-and-limitations

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#determining-the-queries-sent-by-power-bi-desktop

This means that both the options related to Import models are incorrect. You can safely ignore the options Use Import as Data Connectivity mode with Premium capacity and Use Import as Data Connectivity mode with shared capacity.

For workspaces in shared capacity, automatic page refresh has a minimum refresh interval of 30 minutes. Refreshing the report once in 30 minutes is not ideal as you need to quickly remediate any fraudulent transaction.

The option Use DirectQuery as Data Connectivity mode with shared capacity is incorrect too.

Quick Preview:

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#restrictions-on-refresh-intervals

For workspaces in Premium capacity, automatic page refresh has a minimum refresh interval as low as 1 second (even in Power BI service). Since we need to detect fraudulent transactions in real-time, you can set the interval as low as allowed by the capabilities of the data source and the capacity administrator.

Option Use DirectQuery as Data Connectivity mode with Premium capacity is the correct answer.

Quick Preview:

Reference Link: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#restrictions-on-refresh-intervals