Microsoft PL-300 Exam - Topic 15 Question 28 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 28
Topic #: 15

You have a Rawer Bl report That imports a dace 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 three dates at the same time.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

AYes

BNo

Show Suggested Answer

Suggested Answer: A

by Jutta at Jul 29, 2023, 12:24 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lai

4 months ago

Sounds good, but what about performance issues with multiple tables?

upvoted 0 times

...

Wava

4 months ago

Wait, can you really have multiple active relationships like that?

upvoted 0 times

...

Dean

4 months ago

Not sure if calculated tables are the best way to handle this.

upvoted 0 times

...

Bernadine

5 months ago

Totally agree, that should work!

upvoted 0 times

...

Janine

5 months ago

This approach creates separate date tables for analysis.

upvoted 0 times

...

Franklyn

5 months ago

I thought we could only have one active relationship at a time, so I'm not sure if this solution meets the goal.

upvoted 0 times

...

Loreta

5 months ago

I feel like using calculated tables for Order Date and Delivery Date could work, but I'm uncertain if that's the best approach for analysis over time.

upvoted 0 times

...

Daniel

5 months ago

I remember practicing a similar question where we had to create multiple date tables, but I can't recall if we needed active relationships for all of them.

upvoted 0 times

...

Brittni

6 months ago

I think renaming the date table to Due Date might cause confusion later on, but I'm not sure if that affects the relationships.

upvoted 0 times

...

Sang

6 months ago

Hmm, this is a tricky one. I'm not super familiar with Cisco ONE, so I'll need to think through the options carefully. I don't want to just guess and risk getting it wrong.

upvoted 0 times

...

Casie

6 months ago

I'm leaning towards the zoom lens option, but it feels like it might not optimize retention as much as some other features.

upvoted 0 times

...

Antonio

6 months ago

Okay, let me think this through. The question is asking about the factors that determine the charitable deduction limit, so I need to pay close attention to the options and see which one best matches that.

upvoted 0 times

...