PL-300 Exam - Question 16

Question

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The

Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:

✑ Minimize online processing operations.

✑ Minimize calculation times and render times for visuals.

✑ Include data from the current year, up to and including the previous day.

What should you do?

Examice · Accepted Answer

Using Import mode with a daily refresh schedule ensures that data is loaded and stored in Power BI, which minimizes online processing operations as calculations and updates are done during the refresh rather than in real-time. This approach decreases calculation and rendering times for visuals. Scheduling a daily refresh guarantees that the data remains up-to-date, including data from the current year up to and including the previous day, by retrieving and importing data at a set interval.

IxIsa · Answer

C, because one of the requirements is 'Minimize online processing operations'. Although the dataflow uses DirectQuery, the Dataset can be refreshed with Import.https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery

SanaCanada · Answer

Correct Answer C

Based on the requirements mentioned, the best option would be to choose option C: Create a dataflows connection that has Import mode selected and schedule a daily refresh.

Option A is not the best choice as it requires online processing operations, which goes against one of the requirements.

Option B is not necessary since the SQL Server is on-premises and not in a cloud environment. Gateway connections are typically used for cloud-based data sources that require access to on-premises data.

Option D refreshes the data too frequently and might lead to unnecessary processing operations, which goes against one of the requirements.

Therefore, the best approach is to use Import mode with daily scheduled refreshes to include data from the current year, up to and including the previous day. This would minimize online processing operations and also reduce calculation times and render times for visuals.

No confusion, and no need to discuss further

Igetmyrole · Answer

The correct answer is C. 
It is because:

Import mode allows us to load and store the data from the DirectQuery source in the Power BI service. This minimizes online processing operations, as calculations are performed during data refresh rather than in real-time during report rendering.

Scheduling a daily refresh ensures that our dataflow data is up to date while minimizing the frequency of refresh operations. Since we only need data up to and including the previous day, a daily refresh is sufficient.

T1M2P · Answer

This question was in Exam today.

Mphatso · Answer

The best option to meet the given requirements would be:

B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.

Explanation:

The requirement to minimize online processing operations suggests that DirectQuery mode should be used. DirectQuery allows Power BI to directly query the on-premises SQL server without importing the data into Power BI.
The requirement to minimize calculation times and render times for visuals is also achieved through DirectQuery mode. With DirectQuery, calculations are performed on the SQL server, reducing the computational load on Power BI.
The requirement to include data from the current year, up to and including the previous day can be handled by configuring a gateway connection. The gateway allows Power BI to establish a secure connection to the on-premises SQL server and retrieve the required data.
Option B fulfills all the requirements by using DirectQuery mode and configuring a gateway connection for the dataset.

nick0651 · Answer

given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.

ajelizi · Answer

The right answer is
B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.
This option allows you to use DirectQuery mode, minimizing online processing operations, while also ensuring that you can access on-premises data from the Microsoft SQL server using a gateway connection.

AnshulK · Answer

C option as it decreases the processing time.

pverde · Answer

C is correct

Chenemi · Answer

SINCE WE ARE MINIMIZING ONLINE PROCESSING

mordaro · Answer

C because it meets all requirements

momo1165 · Answer

C: Import will:
1. Minimize online processing operations.
2. Minimize calculation times and render times for visuals.
the daily scheduled refresh will keep data updated and thus Include data from the current year, up to and including the previous day.

AZFabio · Answer

correct

LOCOBI · Answer

Option C.

Altought the dataflow (witch is a collection of tables) gets its data from Direct Query. The Dataset (Model of those tables) can use import, and because of that, save recourses.

So that discarts options A and B.

Also for option B a Gateway connection is not needed since the SQL sever is ON PREMISE and a gateway is used for cloud envarioment that require access for on premise data.

Then you can also think that since we are trying to minimize resource, the hourly refresh is more expensive that option C

So option C is correct

RoxyRishi · Answer

What is the correct one finally

shazzzy · Answer

Answer: A
If you read https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features#use-the-enhanced-compute-engine, you will see that there is a special instance where query folding eliminates slow visuals. Is says use Directquery to connect to dataflow (meaning not the source SQL db).

Daniel16 · Answer

I don't understand that we already have a dataflow using DirectQuery to access tables, why do we need to create a dataflow connection with Import mode?

PL-300 Exam - Question 16

Discussion