ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-779 All Questions

View all questions & answers for the 70-779 exam
Go to Exam

Exam 70-779 topic 1 question 27 discussion

Actual exam question from Microsoft's 70-779
Question #: 27
Topic #: 1
[All 70-779 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
exam_taker5
Highly Voted 5 years, 10 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, 5 months ago
"A. From the Data tab, click Refresh All" is the correct answer
upvoted 9 times
...
jason69
Most Recent 4 years, 4 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
4 years, 11 months ago
A is definitely correct.
upvoted 2 times
...
Dev28
5 years ago
I believe Option B also right, however option A is also correct. Any suggestions?
upvoted 1 times
Mange
4 years, 12 months ago
That option isn't available in the Power Pivot menu
upvoted 1 times
jason69
4 years, 4 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 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, 3 months ago
Correct answer is A
upvoted 8 times
...
GST0101
5 years, 7 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
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago