PL-300 Exam QuestionsBrowse all questions from this exam

PL-300 Exam - Question 41


HOTSPOT -

You have a Power BI imported dataset that contains the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

Show Answer
Correct Answer:

Box 1: Assume Referential Integrity

When connecting to a data source using DirectQuery, you can use the Assume Referential Integrity selection to enable running more efficient queries against your data source. This feature has a few requirements of the underlying data, and it is only available when using DirectQuery.

Note: The following requirements are necessary for Assume referential integrity to work properly:

Data in the From column in the relationship is never Null or blank

For each value in the From column, there is a corresponding value in the To column

Box 2: Star schema -

Star schema is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.

Generally, dimension tables contain a relatively small number of rows. Fact tables, on the other hand, can contain a very large number of rows and continue to grow over time.

Example:

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Discussion

17 comments
Sign in to comment
Guru1337
Sep 6, 2022

It should be cross filter direction. As the answer correctly states "Assume Referential Integrity" only works for direct query connections.

nevesrf
Feb 15, 2023

but it is a Direct query from powerbi service, so the integrity gona make it perform well

semauni
Apr 25, 2023

How do you know that? It is stated nowhere

RicoPallazzo7
Sep 21, 2023

first line

carlosmmspereira
Sep 13, 2023

"You have a Power BI imported dataset ".... Imported. It should be Cross filter direction

bdub1976
Dec 12, 2023

Yep, and to be clear, the first line in this particular question says it's imported data, not direct query.

__Sai_Mounika__
Feb 5, 2024

same, the question says "imported the data" and explanation says the "ARI" works only for Direct Query

aloulouder
Sep 13, 2022

It should be : - cross filter direction - star schema

SamuComqi
Jul 20, 2023

I passed the exam today (948/1000). My answer was: - Cross filter direction - star schema

Gamie90
Jul 20, 2023

Congrats! I am preparing to take the exam. May I ask you how many % of the sample questions here can help you with the test? Thank you.

SamuComqi
Aug 19, 2023

100% (not kidding) :D

SteveTheBeast
Aug 19, 2023

wow! really? Damn!

Van09181996
Aug 30, 2023

Hey man, Can I pass the exam without subscribing to the full version of the questions? Thanks!

Wadyba
Oct 2, 2023

You passed the exam doesn't mean you passed this particular question. Answer is cross-filter and snowflake.

AdrianBalescu
Dec 17, 2023

SNOWFLAKE schema has subdimensions beyond dimensions(many long ramifications) above example is a simple STAR schema

bbshu0801
Dec 23, 2023

I totally agree with your first sentence, but the second one is completely wrong.

Giuditta
Mar 15, 2024

this was on exam on 14/03/2024 i scored 948 my answer was Cross filter direction and star schema

Shalaleh
May 2, 2023

Assume Referential Integrity only work for DirectDquery connections. but in the beginning of the question said it is Imported!

Igetmyrole
Sep 5, 2023

Cross filter Direction and Star Schema are the correct options. Changing the cross filter direction setting can have a significant impact on query performance. Setting it to "Single" when appropriate can often improve performance by reducing unnecessary filtering in both directions. In Star Schema, the central table (usually a fact table) is connected to dimension tables through one-to-many or many-to-many relationships.

rick1997
Oct 25, 2023

Absolutely. Something I did not notice at first was that every single connection has the arrows pointing in both directions. That's a dead giveaway to a flaw in the current design. Changing as many of those to single where appropriate will improve performance since excessive bidirectional cross-filtering can cause Power BI to slow down. Only do that where it is needed

28485e1
Feb 24, 2024

answer choke

EwoutBI
Aug 10, 2023

I wonder why cardinality is wrong as an answer here. Doesn't the umbrella-term of cardinality also include cross filter direction ?

MayurV19
Dec 22, 2023

The answer should be: Cross Filter direction. Star Schema.

DANIEL
Feb 20, 2024

Honestly.. I think Microsoft is publishing fake answers to avoid people studying answers only and force them to think based on acquired knowledge. When you look at the icons next to the tables in the model, those are IMPORTED icons, not direct query. Direct query icons are represented with a square having at the bottom right corner two arrows, one in, one out. Also, when you do the labs, you have an exercise called Sales Analysis with a similar model (star) that you will publish to PBI service and there is no cross filter direction

RMUK
Oct 16, 2023

Cross filter direction & Start schema

28485e1
Feb 27, 2024

Assume referential integrity? Really? After seeing that mess of cross filters in the star schema? And then in the provided answer it says assume referential integrity setting works for direct query, even though the question states this is an imported dataset.

Pocu
Sep 13, 2023

As to the confusion of star or snowflakes schema, If this is a star schema, then the Employee table is a factless fact table.

RicoPallazzo7
Aug 24, 2023

import dataset --> cross filter, the referential itnegrity only works with direct query. And star schema, pretty direct

seaverick
Jan 7, 2024

you are right --> https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity

__Sai_Mounika__
Feb 5, 2024

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

0e18c76
Apr 16, 2024

The answers can only be: - cross filter direction - star schema Cross filter direction set to both in msot relatioships are a mess.

Kiran37
Jul 21, 2024

Cross Filter & Star is correct