Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 15 Question 28 Discussion

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 DateYou 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?
A) Yes
B) No

Microsoft PL-300 Exam - Topic 15 Question 28 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 28
Topic #: 15
[All PL-300 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Lai
6 months ago
Sounds good, but what about performance issues with multiple tables?
upvoted 0 times
...
Wava
7 months ago
Wait, can you really have multiple active relationships like that?
upvoted 0 times
...
Dean
7 months ago
Not sure if calculated tables are the best way to handle this.
upvoted 0 times
...
Bernadine
7 months ago
Totally agree, that should work!
upvoted 0 times
...
Janine
7 months ago
This approach creates separate date tables for analysis.
upvoted 0 times
...
Franklyn
8 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
8 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
8 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
8 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
8 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
8 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
8 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
...

Save Cancel