Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 16

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?

    Correct Answer: C

    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.

Discussion
IxIsaOption: C

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

Sunny_Liya

Need a gateway

Dovoto

The BI developer has already created the dataflow, so the gateway must be present. Import and daily scheduled refresh should do the trick.

Shalaleh

in all options, it says :" create a dataflow...." it means we already do not have the dataflow

Maniula

No, it's already created by the developer. Your task is "to use the dataflow in a report"

thanhtran7

"Although the dataflow uses DirectQuery, the Dataset can be refreshed with Import." -> I dont understand this point. Can you help explain more details?

NLeeXTung

Image the Dataflow like the Common Data Model which has been ETL from the external data sources and PBI Desktop will connect to Dataflow by Import mode to create its dataset

spamhz

direct query is to on prem database, does it still use online processing operation?

SanaCanadaOption: C

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

KAYBOL

I would think Gateways are need for ON premises DB.

IgetmyroleOption: C

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

This question was in Exam today.

MphatsoOption: B

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

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.

DOUNIA

and your answer to this it was C ?

ajeliziOption: B

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.

Inesd

I also think that B is the correct answer. For those who have voted for C is possible to use import mode from Dataflow without gateway ?

Daniel16Option: C

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?

shazzzyOption: A

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).

RoxyRishi

What is the correct one finally

LOCOBIOption: C

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

AZFabioOption: C

correct

momo1165Option: C

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.

mordaroOption: C

C because it meets all requirements

ChenemiOption: C

SINCE WE ARE MINIMIZING ONLINE PROCESSING

pverdeOption: C

C is correct

AnshulKOption: C

C option as it decreases the processing time.