MENU
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?
Suggested Answer: A
Get Premium PL-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
LA
Lai
11 months ago
Sounds good, but what about performance issues with multiple tables?
WA
Wava
11 months ago
Wait, can you really have multiple active relationships like that?
DE
Dean
11 months ago
Not sure if calculated tables are the best way to handle this.
BE
Bernadine
11 months ago
Totally agree, that should work!
JA
Janine
12 months ago
This approach creates separate date tables for analysis.
FR
Franklyn
12 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.
LO
Loreta
1 year 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.
DA
Daniel
1 year 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.
BR
Brittni
1 year 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.
SA
Sang
1 year 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.
CA
Casie
1 year ago
I'm leaning towards the zoom lens option, but it feels like it might not optimize retention as much as some other features.
AN
Antonio
1 year 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.