How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?
How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?
A . an incremental refresh of Product where the ModifiedDate value is during the last three days.
B. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last three days.
C. a full refresh of all the tables
D. an incremental refresh of dbo.SalesTransactions where the SalesDate value is during the last hour.
Answer: B
Explanation:
The sales data in SQLDW is updated every 30 minutes. Records in dbo.SalesTransactions are updated in SQLDW up to three days after being created. The records do NOT change after three days.
Latest DP-500 Practice Questions with 83 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments