Question
You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?
- A. Add a SQL statement.
- B. Set the Command timeout in minutes setting.
- C. Set Data Connectivity mode to Import.
- D. Set Data Connectivity mode to DirectQuery. Correct
Explanation
DirectQuery sends queries to the Azure SQL database when visuals load, so reports show the current data within minutes of an update. Import mode only shows data as of the last scheduled refresh, which cannot run often enough to guarantee five-minute freshness. A SQL statement or the command timeout setting does not change how current the data is.
