nerdexam
Microsoft

70-778 · Question #95

70-778 Question #95: Real Exam Question with Answer & Explanation

Sign in or unlock 70-778 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.

Question

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?

Exhibit

70-778 question #95 exhibit

Options

  • AFrom Query Editor, refresh all the data.
  • BChange the query to use Live connection mode.
  • CDelete the Remove Duplicates step.
  • DAdd an Unpivot Columns step.

Unlock 70-778 to see the answer

You've previewed enough free 70-778 questions. Unlock 70-778 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-778 Practice