Why should you do?

Posted by: Pdfprep Category: 70-779 Tags: , ,

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

Leave a Reply

Your email address will not be published.