Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 27 discussion

Actual exam question from Microsoft's 70-779

Question #: 27
Topic #: 1

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.
What should you do?

A. From the Data tab, click Refresh All
B. From the Power Pivot tab, click Update All
C. Close and open the workbook
D. Select a cell in the worksheet and press F5

Show Suggested Answer

Suggested Answer: C 🗳️
References:
https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-2016-for-windows-1524175f-777a-48fc-8fc7-c8514b984440

by exam_taker5 at July 15, 2019, 7:29 p.m.

Comments

Submit Cancel

exam_taker5

Highly Voted 5 years, 11 months ago

The answer is A, as per the source that is linked. https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440

upvoted 25 times

...

mohroshdy

Highly Voted 5 years, 7 months ago

"A. From the Data tab, click Refresh All" is the correct answer

upvoted 9 times

...

jason69

Most Recent 4 years, 5 months ago

As the link provided shows, the answer is ambiguous and depends on the version of Excel used. Option A for Excel 2016. Option B for Excel 2013.

upvoted 1 times

...

CibrevN

5 years ago

A is definitely correct.

upvoted 2 times

...

Dev28

5 years, 1 month ago

I believe Option B also right, however option A is also correct. Any suggestions?

upvoted 1 times

Mange

5 years, 1 month ago

That option isn't available in the Power Pivot menu

upvoted 1 times

jason69

4 years, 5 months ago

In Excel 2013, Option B is definitely available. Powerpivot > Tables > Update All. I think Option A is the solution in Excel 2016.

upvoted 1 times

...

Mar_tin

5 years, 2 months ago

Very confusing because in the link they attached it is "at the first view" also mentioned to use the Refresh (All) Button. https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440?ui=en-US&rs=en-US&ad=US

upvoted 2 times

...

SN22

5 years, 4 months ago

Correct answer is A

upvoted 8 times

...

GST0101

5 years, 8 months ago

I was thinking it was using the same logic as how Power BI connects to an Azure SQL Database and how Power BI can support live data with a connection to Azure SQL database. But, I was able to find this article referencing Excel Online and Azure SQL database that also states to refresh the connections. This question is really confusing... https://docs.microsoft.com/en-us/office365/troubleshoot/excel-online-refreshing-data-to-a-sql-azure-database

upvoted 2 times

...