Exam DP-500 All Questions

View all questions & answers for the DP-500 exam

Exam DP-500 topic 1 question 43 discussion

Actual exam question from Microsoft's DP-500

Question #: 43
Topic #: 1

DRAG DROP -
You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails contains three date columns named OrderDate, CreatedOnDate, and ModifiedDate.
You need to implement an incremental refresh of SalesDetails. The solution must ensure that OrderDate starts on or after the beginning of the prior year.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Show Suggested Answer

Suggested Answer:

by nbagchi at Dec. 13, 2022, 3:33 p.m.

Comments

Submit Cancel

MaryemSB

1 year, 6 months ago

it's required to exclude data before start of prior year, so, best practice is to filter it out first. if we are in June 2023, then all data we have is 1 year and 6 months. data will be split into 1 year of incremental refresh and 6 months will be archived. we can't use the option "configure IR to archive data 2 years before refresh date" otherwise, IR will have no sense! solution is : 1. filter prior year 2. create parameters 3. create custom filter for date 4. configure incremental refresh ONE YEAR BEFORE REFRESH DATE

upvoted 1 times

MaryemSB

1 year, 6 months ago

small adjustment: 1 year will be archived and 6 months will be incrementally refreshed

upvoted 1 times

...

Deloro

1 year, 9 months ago

create filter based on start and end refresh 2 years, start of previous needs to be included

upvoted 1 times

...

Plb2

2 years ago

I feel there's an error in the answers. It should be (create parameters, filter orderdata on parameters and then) configure incr refresh to archive data 2 years before refresh date configure incr refresh to incrementally refresh (instead of archive) data since 1 year before refresh date

upvoted 4 times

hoss29

1 year, 10 months ago

I think the answer provided is correct, because we have to consider a refresh date that occurs in june 2023 for example, which means we need to refresh from Jan 2022 onwards, and that cannot be done by "configure incr refresh to incrementally refresh (instead of archive) data since 1 year before refresh date" . After the first 2 steps, we need to first archive the last 2 years and then filter OrderDate to the start of the prior year.

upvoted 1 times

...

DarioReymago

2 years, 3 months ago

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure is ok

upvoted 1 times

DarioReymago

2 years, 3 months ago

I mean, I not sure why archive 2years before. I prefere 1 year before

upvoted 2 times

fdsdfgxcvbdsfhshfg

2 years, 2 months ago

yeah it's weird, but if it has to be 4 steps...

upvoted 1 times

Deloro

1 year, 9 months ago

2 years, so you always include start of prior year ?

upvoted 1 times

...

stfglv

2 years, 5 months ago

I don't understand why would we need four steps. I would say that the first 3 steps should be 1. create RangeStart and RangeEnd parameters 2. filter the OrderDate column using a customer filter based on these wo parameters 3. configure an incremental refresh to archive data before the last two years. But after that you should arguably publish the report and do a manual refresh as explained here https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview. So what is this 4th step supposed to do?

upvoted 2 times

stfglv

2 years, 5 months ago

Just realized that filtering OrderDate to start of previous year is also needed (but does not have to be the 4th step, can even be the first thing) gives us the subset of data that is relevant since the question more/less states that nothing before that matters. Also this type of filtering determines that the incremental policy should not affect the last two years but only the previous year.

upvoted 3 times

...

fdsdfgxcvbdsfhshfg

2 years, 2 months ago

Let's suppose we're in 2023 and the solution requires us to have OrderDate starting on or after the beginning of the prior year (so 2022 onward): 1. Create RangeStart RangeEnd - obviously 2. Add an applied step to filter our dates between these two params - obviously 3. Create an incremental refresh to archive data that starts ONE YEAR BEFORE THE REFRESH DATE. Now what that third step does is all we need for the solution - it creates a yearly partition for the entire 2022, and the quarterly/monthly partitions in the current 2023 year. We don't need any additional filtering. The same can be achieved in 4 steps, with last 2 years being archived (2021, 2022) and then by filtering OrderDate to the start of the prior year. So two approaches are possible in here, but we should select the 4-steps one. https://youtu.be/Kui_1G6kQIQ?t=466 Correct me If I'm wrong

upvoted 3 times

...

nbagchi

2 years, 6 months ago

Correct

upvoted 4 times

...