Microsoft Power BI Data Analyst — Question 123

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?

Answer options

• 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 answer: D

Explanation

The correct answer is D, as DirectQuery allows real-time data access, making updates visible within minutes, which is essential for detecting fraud quickly. Option A, adding a SQL statement, does not impact how data is accessed in real-time. Option B, adjusting the Command timeout, only affects how long a command waits before timing out and does not ensure timely data visibility. Option C, using Import mode, would lead to delays since it requires periodic data refreshes, making it unsuitable for immediate reporting.