Home » Microsoft » DA-100 v.2 » What should you recommend?
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?
A. Increase the number of times that the dataset is refreshed.
B. Split the visuals onto multiple pages.
C. Change the imported dataset to DirectQuery.
D. Implement row-level security (RLS).
Correct Answer: C
Explanation/Reference:
Explanation:
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.
Note:
There are several versions of this question in the exam. The question can have other incorrect answer options, include the following:
Implement row-level security (RLS)
Increase the number of times that the dataset is refreshed.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery