Microsoft PL-300 Exam - Topic 2 Question 17 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 17
Topic #: 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: A

by Selma at Nov 20, 2022, 08:41 PM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Barney

4 months ago

Sounds right, but I’d double-check the model first!

upvoted 0 times

...

Magda

4 months ago

Wait, can you really analyze all those dates like that?

upvoted 0 times

...

Kathryn

5 months ago

I’m not so sure about that. Inactive relationships can complicate things.

upvoted 0 times

...

Shawnna

5 months ago

Totally agree, this should work!

upvoted 0 times

...

Arlette

5 months ago

Inactive relationships can be used for multiple date fields.

upvoted 0 times

...

Mireya

5 months ago

I think the solution might be correct since it allows for flexibility in using different date fields, but I’m worried about how it affects filtering and context in the report.

upvoted 0 times

...

Kenneth

5 months ago

I feel like we discussed how inactive relationships can be useful for certain measures, but I’m not sure if they would allow for proper analysis over time in this case.

upvoted 0 times

...

Lajuana

5 months ago

This reminds me of a practice question where we had to manage multiple date fields. I think using inactive relationships could work, but I’m not confident it meets the goal completely.

upvoted 0 times

...

Luis

5 months ago

I'm not entirely sure if adding inactive relationships is the right approach. I remember something about needing active relationships for certain calculations.

upvoted 0 times

...

Delmy

6 months ago

Hmm, this seems straightforward. I think option D is the way to go - creating a new virtual environment and installing the package there. That way, it's isolated from the main codebase.

upvoted 0 times

...

Brigette

6 months ago

I'm a bit confused by this question. I know Scrum has rules, but I'm not sure which one is relevant for Sprint duration specifically.

upvoted 0 times

...

Junita

6 months ago

Hmm, this seems like a tricky one. I'll need to carefully review the options and think through the potential issues with the voicemail system and SCCP routing.

upvoted 0 times

...