Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 65 discussion

Actual exam question from Microsoft's PL-300

Question #: 65
Topic #: 2

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

Suggested Answer:

by jiriz at March 29, 2023, 10:51 a.m.

Comments

Submit Cancel

RazaTheLegend

Highly Voted 2 years, 2 months ago

Yes - No - Yes no need to discuss anymore

upvoted 66 times

Tex02

9 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, 5 months ago

I think we're all here to literally discuss

upvoted 30 times

...

CheyrouLag

1 year, 8 months ago

I discuss if i want but yesnoyes

upvoted 22 times

reignreign03

1 year, 7 months ago

Yeah, we'll discuss if we want, don't order us around xD

upvoted 15 times

bbshu0801

1 year, 5 months ago

Can't understand why "no need to discuss anymore" lol.

upvoted 7 times

anishk

11 months, 1 week ago

so what are we discussing..

upvoted 1 times

...

Shalaleh

Highly Voted 2 years, 2 months ago

correct, yes, no, yes

upvoted 6 times

...

jaume

Most Recent 7 months, 1 week ago

My vote in this Discussion will be for Yes - No - Yes

upvoted 1 times

...

rcaliandro

10 months, 1 week ago

Yes, No, YEs

upvoted 1 times

rcaliandro

10 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, 4 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, 7 months ago

YES - YES - YES We don't need ProductID, there is AUDITID

upvoted 2 times

jaume

7 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, 8 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

7 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, 6 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, 8 months ago

why second is No, we have auditID column in both tables (sales and Product)

upvoted 2 times

...

thomas_90

1 year, 8 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, 9 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

7 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, 6 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

5 months ago

Good explanation thanks

upvoted 1 times

...

Elfmo11

1 year, 9 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

2 years ago

Yes No Yes

upvoted 3 times

...

hanjoe

2 years, 1 month ago

Can't we remove the ProductID column, as we have the AuditID column in both tables anyway?

upvoted 4 times

EwoutBI

1 year, 10 months ago

It's an unlikely Primary Key.

upvoted 1 times

...

ElieG

1 year, 6 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

...