Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DA-100 Topic 19 Question 45 Discussion

Actual exam question for Microsoft's DA-100 exam
Question #: 45
Topic #: 19
[All DA-100 Questions]

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Show Suggested Answer Hide Answer
Suggested Answer: C

DirectQuery: No data is imported or copied into Power BI Desktop.

Import: The selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data.

Benefits of using DirectQuery

There are a few benefits to using DirectQuery:

DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all the data with pre-aggregation.

Underlying data changes can require a refresh of data. For some reports, the need to display current data can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports always use current data.

The 1-GB dataset limitation doesn't apply to DirectQuery.


https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel