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:
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
It should be cross filter direction. As the answer correctly states "Assume Referential Integrity" only works for direct query connections.
but it is a Direct query from powerbi service, so the integrity gona make it perform well
How do you know that? It is stated nowhere
first line
"You have a Power BI imported dataset ".... Imported. It should be Cross filter direction
Yep, and to be clear, the first line in this particular question says it's imported data, not direct query.
same, the question says "imported the data" and explanation says the "ARI" works only for Direct Query
It should be : - cross filter direction - star schema
I passed the exam today (948/1000). My answer was: - Cross filter direction - star schema
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.
100% (not kidding) :D
wow! really? Damn!
Hey man, Can I pass the exam without subscribing to the full version of the questions? Thanks!
You passed the exam doesn't mean you passed this particular question. Answer is cross-filter and snowflake.
SNOWFLAKE schema has subdimensions beyond dimensions(many long ramifications) above example is a simple STAR schema
I totally agree with your first sentence, but the second one is completely wrong.
this was on exam on 14/03/2024 i scored 948 my answer was Cross filter direction and star schema
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.
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
Assume Referential Integrity only work for DirectDquery connections. but in the beginning of the question said it is Imported!
answer choke
I wonder why cardinality is wrong as an answer here. Doesn't the umbrella-term of cardinality also include cross filter direction ?
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
The answer should be: Cross Filter direction. Star Schema.
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.
Cross filter direction & Start schema
As to the confusion of star or snowflakes schema, If this is a star schema, then the Employee table is a factless fact table.
import dataset --> cross filter, the referential itnegrity only works with direct query. And star schema, pretty direct
you are right --> https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-assume-referential-integrity
Cross Filter & Star is correct
The answers can only be: - cross filter direction - star schema Cross filter direction set to both in msot relatioships are a mess.
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema