70-779 · Question #63
You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a PivotTable and a…
The correct answer is A. Run the Document Inspector. Document Inspector allows you to remove data from the Data Model (which is the point of the question). Chaning the credentials will make it impossible to refresh the data but won't delete the existing data from the data model.
Question
You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server database and loads data to the data model. You create a PivotTable and a PivotChart. You plan to share SalesResults.xlsx to several users outside of your organization. You need to ensure that the users can see the PivotTable and the PivotChart when they open the file. The data in the model must be removed. What should you do?
Options
- ARun the Document Inspector.
- BSave the workbook as an Excel Binary Workbook (.xlsb).
- CFrom Query Editor, open the Data Source Settings and delete the credentials.
- DModify the source of the query.
How the community answered
(27 responses)- A78% (21)
- B4% (1)
- C11% (3)
- D7% (2)
Explanation
Document Inspector allows you to remove data from the Data Model (which is the point of the question). Chaning the credentials will make it impossible to refresh the data but won't delete the existing data from the data model.
Topics
Community Discussion
No community discussion yet for this question.