Microsoft Certified: Power BI Data Analyst Associate

0/11 checked

Q_01 domain/d1 · medium single discuss →

A business analyst wants to centralize the data preparation logic that is currently duplicated in Power Query across many Power BI Desktop files, so multiple semantic models can reuse it. Which approach best achieves this reusability goal?

A Relocate the data preparation work into a Power BI dataflow built in Power Query Online
B Copy the same query steps into each individual .pbix file to keep them consistent
C Build the transformations directly in the report editor of the Power BI service
D Store the source data in an ADLS Gen2 account without any transformations

Q_02 domain/d1 · medium single discuss →

A team plans to use a Power BI dataflow to deliver prepared data to report authors. A colleague asks whether a report can connect directly to the dataflow. What is the correct explanation?

A A report can connect directly to a dataflow just like it connects to a semantic model
B A report cannot connect directly to a dataflow; semantic models use the dataflow as a data source
C A report can connect to a dataflow only when the dataflow is stored in ADLS Gen2
D A report can connect directly to a dataflow only in a personal workspace