Exam 70-778 topic 1 question 61 discussion

Actual exam question from Microsoft's 70-778

Question #: 61
Topic #: 1

You have a Microsoft SQL Server Analysis Services (SSAS) cube that contains historical data.
In Power BI Desktop, you have the following query for the cube.

The query retrieves 25,499 records.
When you check the data warehouse that is the source of the cube, you discover that there are 26,423 records.
You need to ensure that the query retrieves all 26,423 records.
What should you do?

A. From Query Editor, refresh all the data.
B. Change the query to use Live connection mode.
C. Delete the Remove Duplicates step.
D. Add an Unpivot Columns step.

Show Suggested Answer

Suggested Answer: C 🗳️

by prokocim at April 25, 2020, 7:08 a.m.

Comments

Submit Cancel

prokocim

Highly Voted 5 years, 1 month ago

C is correct

upvoted 9 times

...

Waltmas

Most Recent 4 years, 10 months ago

correct answer is c

upvoted 1 times

...

NiGi

4 years, 11 months ago

This query shows that we are deleting duplicates so the answer is correct C . If we delete that step it will not remove duplicates and we will get same result.

upvoted 2 times

...

NiGi

4 years, 11 months ago

We should change the query to live connection when we deal with SSAS.

upvoted 1 times

KGwash

4 years, 11 months ago

It's historical data so there are no changes happening in the warehouse

upvoted 2 times

...

AxxxD

4 years, 8 months ago

When you use the live connection you will not get the Query editor screen. It shows that the Query editor is used to making a connection with the Analysis server. Power BI>DataSource>Blank Query> Analysis Server On other hand if you remove the step in between you will

upvoted 1 times

...

angelluc

4 years, 12 months ago

Can anyone explain this? Is it that the Remove Duplicates step is added automatically? thanks!

upvoted 1 times

AxxxD

4 years, 8 months ago

It's added to remove duplicate from FACT internet sales 'CarrierTrackingNumber' column

upvoted 1 times

...