PrepAway - Latest Free Exam Questions & Answers

What should you do in the data model?

You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

Exhibit:

Your company has 100 product subcategories and more than 10,000 products.

You need to create a simplified view of the workbook for some users. The simplified view must only display data from FactSales, DimProduct, and DimDate.

What should you do in the data model?

A. Click Hide from Client Tools for all the tables except FactSales, DimProduct, and DimDate

B. Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set
C. Create a new perspective
D. Modify the Table behavior settings for FactSales, DimProduct, and DimDate

References: https://support.office.com/en-us/article/hide-columns-and-tables-in-power-pivot-ddf5b1f2-2ed2-4bdb-8f78-6f94503ca87a


Leave a Reply