ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 65 discussion

Actual exam question from Microsoft's PL-300
Question #: 65
Topic #: 2
[All PL-300 Questions]

HOTSPOT
-

You have the Power BI data model shown in the following exhibit.



The Sales table has the following columns.



The data model must support the following analysis:

• Total sales by product by month in which the order was placed
• Quantities sold by product by day on which the order was placed
• Number of sales transactions by quarter in which the order was placed

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by jiriz at March 29, 2023, 10:51 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
RazaTheLegend
Highly Voted 2 years ago
Yes - No - Yes no need to discuss anymore
upvoted 66 times
Tex02
7 months, 1 week ago
you can't tell me what to discuss - you're not the boss of me
upvoted 7 times
...
cs3122
1 year, 3 months ago
I think we're all here to literally discuss
upvoted 30 times
...
CheyrouLag
1 year, 6 months ago
I discuss if i want but yesnoyes
upvoted 22 times
reignreign03
1 year, 5 months ago
Yeah, we'll discuss if we want, don't order us around xD
upvoted 15 times
bbshu0801
1 year, 3 months ago
Can't understand why "no need to discuss anymore" lol.
upvoted 7 times
anishk
9 months ago
so what are we discussing..
upvoted 1 times
...
...
...
...
...
Shalaleh
Highly Voted 2 years ago
correct, yes, no, yes
upvoted 6 times
...
jaume
Most Recent 5 months, 1 week ago
My vote in this Discussion will be for Yes - No - Yes
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
Yes, No, YEs
upvoted 1 times
rcaliandro
8 months, 1 week ago
Yes, We can remove the LastUpdated column and support the requirements No, we need the productId in the requirements Yes, we can remove the shipDate and still support the requirements
upvoted 1 times
...
...
noone420
1 year, 2 months ago
Second one is no because productID is the foreign key that links to product table to filter by product. Can't filter by product without it.
upvoted 2 times
...
dede1723
1 year, 5 months ago
YES - YES - YES We don't need ProductID, there is AUDITID
upvoted 2 times
jaume
5 months, 1 week ago
If we would remove ProductID column we would be not able to produce the required analysis "by product" as we would lose linkage to Product table. AuditID could be not related to the Product is sold
upvoted 2 times
...
...
Arenke
1 year, 6 months ago
The second one cannot be YES? We have the AuditId field, and even if it was not a PK, by deleting ProductId we would lose the relationship between the Product and Sales tables, but we could continue to perform the required analysis (without the product detail, we would only have the id).
upvoted 4 times
jaume
5 months, 1 week ago
If we would remove ProductID column we would be not able to produce the required analysis "by product" as we would lose linkage to Product table. AuditID could be not related to the Product is sold
upvoted 1 times
...
Starvosxant
1 year, 4 months ago
What is the relation AuditID has with products? I mean, How can you know that each audit id refers to a product? It may reference the lastupdate time.
upvoted 4 times
...
...
RMUK
1 year, 6 months ago
why second is No, we have auditID column in both tables (sales and Product)
upvoted 2 times
...
thomas_90
1 year, 6 months ago
the final sentence is Yes. All requirements can be calculated with only Order Date, so the Ship Date is no need for using.
upvoted 3 times
...
Igetmyrole
1 year, 7 months ago
Yes No NO Yes, you can remove the lastupdated column without affecting the ability to perform the required analysis. No, you should not remove the ProductID column. It is a critical column for linking the sales table to the product table and performing analysis by product. No, you should not remove the shipdate column. It is essential for analyzing sales by day, which is one of the require analyses.
upvoted 2 times
jaume
5 months, 1 week ago
All the required anaysis are "on which the order was placed" and we need th OrderDate column. ShipDate could be not the same the product was ordered
upvoted 1 times
...
Dsbuff
1 year, 4 months ago
- Total sales by product by month in which the order was placed: This analysis requires the OrderDate, ProductID, and SalesAmount columns. The ShipDate column is not required for this analysis. - Quantities sold by product by day on which the order was placed: This analysis requires the OrderDate, ProductID, and SalesQuantity columns. Again, the ShipDate column is not necessary for this analysis. - Number of sales transactions by quarter in which the order was placed: This analysis requires the OrderDate and InvoiceNumber columns. The ShipDate column is not needed for determining the number of transactions by quarter. Therefore, ShipDate column is not needed. So the 3rd answer should be Yes.
upvoted 6 times
SylUK
3 months ago
Good explanation thanks
upvoted 1 times
...
...
Elfmo11
1 year, 7 months ago
You don't need ShipDate. Analysis by day should be done with OrderDate. The last one should also be yes.
upvoted 2 times
...
...
Rinesh25
1 year, 10 months ago
Yes No Yes
upvoted 3 times
...
hanjoe
1 year, 11 months ago
Can't we remove the ProductID column, as we have the AuditID column in both tables anyway?
upvoted 4 times
EwoutBI
1 year, 8 months ago
It's an unlikely Primary Key.
upvoted 1 times
...
ElieG
1 year, 4 months ago
as Starvosxant said: What is the relation AuditID has with products? I mean, How can you know that each audit id refers to a product? It may reference the lastupdate time.
upvoted 1 times
...
...
duydld
1 year, 11 months ago
I think the answer should be Y-N-N. The last one is NO because we need shipdate for transaction as required
upvoted 2 times
Sjakie
1 year, 11 months ago
In which the order was placed,order date. Last one is yes.
upvoted 3 times
...
...
Shalaleh
1 year, 11 months ago
YES-NO-YES
upvoted 1 times
...
UlyUkr
1 year, 11 months ago
Yes, No, Yes
upvoted 1 times
...
gldana
2 years ago
Why do we need the ship date then? why don't we remove it?
upvoted 1 times
Large94
2 years ago
I've got the same question, in all three options we need to sort by order date right?
upvoted 2 times
...
Win_111
1 year, 11 months ago
We don't need the ShipDate. It's removed from the answer!
upvoted 2 times
...
...
Akhilesh_Maithani
2 years ago
Answer is correct
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago