Why should you do?

You have multiple workbook queries that load data from tables in Microsoft Azure SQL Database to a Power Pivot data model.

You discover that new rows were added to the tables in Azure SQL Database.

You need to ensure that the workbook has the new data.

Why should you do?
A . Select a cell in the worksheet and pressF5.
B . From the data tab, click Refresh All.
C . Close and open the workbook.
D . From the Power Pivot tab, click Update All.

Answer: B

Explanation:

Refresh data from a Microsoft Query, the Data Connection Wizard, or web query

Latest 70-779 Dumps Valid Version with 101 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments