Exam 70-778 topic 1 question 129 discussion

Actual exam question from Microsoft's 70-778

Question #: 129
Topic #: 1

HOTSPOT -
You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.
You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.
You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.
How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

by barlason at Jan. 15, 2020, 8:47 a.m.

Comments

Submit Cancel

cs3122

Highly Voted 5 years, 6 months ago

Answer is correct - you need to hide customer_ID so as to preserve the relationship in the model. However, the customer photo is not needed in this scenario, so you can delete it from the model since the goal is to minimize the size.

upvoted 16 times

...

coupet

Most Recent 5 years, 2 months ago

Binary columns aren't supported in the Power BI data model. It exists in the Data View and Report View menus for legacy reasons but if you try to load binary columns to the Power BI model you may run into errors. If a binary column is in the output of the steps of a query, attempting to refresh the data through a gateway can cause errors. It's recommended that you explicitly remove any binary columns as the last step in your queries. Data types in Power BI Desktop https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-types

upvoted 1 times

...

byebye

5 years, 4 months ago

wouldnt you want to remove duplicates?

upvoted 3 times

byebye

5 years, 4 months ago

nevermind im dumb

upvoted 8 times

...