Question 105 of 388
Single answerYou 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?
AAdd a SQL statement.
✓BSet Data Connectivity mode to DirectQuery.
CSet the Command timeout in minutes setting.
DSet Data Connectivity mode to Import.
✓
Correct Answer: B
Set Data Connectivity mode to DirectQuery.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.