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 14 discussion

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

HOTSPOT -
You are creating a Microsoft Power BI imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
Sales contains the data shown in the following table.

You are evaluating how to optimize the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Yes -
Those two columns not need in the analysis.

Box 2: No -
Can remove the surrogate key OrderDateKey from the analysis.

Box 3: No -
Tax charged not relevant for the analysis.
by simplex06 at Sept. 4, 2022, 10:34 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
simplex06
Highly Voted 2 years, 4 months ago
Yes - No - No
upvoted 110 times
...
Wadyba
Highly Voted 2 years, 2 months ago
NO- SalesRowID is the primary key for the Sales table, hence needed in the model NO- the analysis is not time based No- decimal place is irrelevant in the analysis
upvoted 16 times
cnmc
2 years ago
you're thinking in "ops database" mode... In analytics it's not required for tables to have a primary key. Tables would break NF all the time due to performance needs. Also if you read the column description, a sales row is an "unique combination" of Sales Order and Sales Order Details... So if you need to do analytics at those levels, you can go to those columns.
upvoted 29 times
...
cs3122
1 year ago
Primary Key is not needed here
upvoted 3 times
...
dopass
2 years, 1 month ago
I agree with you.
upvoted 1 times
...
momo1165
1 year ago
SalesRowID is not needed, the Fact table PK will not be needed to connect to other tables, you will need FKs though. The correct answer is Yes, No, No
upvoted 3 times
...
Load full discussion...
...
jaume
Most Recent 2 months, 1 week ago
My vote here is YES-NO-NO Since there are no details on the dimension tables, we don't know what are the fields in the fact table we should use to link fact-dimensions hence, althoufgh column in the fact table is a "key column", no assurance it's required in this model. The analysis is about products bought in same transaction ("in the same order") and within sales territories, so we don't need any explicit detail about date/time (it's implicit in the "SalesOrderNumber" different code is different date/time) so no need for ORDERDATEKEY nor ORDERDATE columns TaxAmt is also not needed for the analysis
upvoted 2 times
...
seffy
2 months, 3 weeks ago
idk why some people say we don't need pK, this is from Oracle: The star schema arrangement depends entirely on primary key and foreign key relationships. A primary key is a column (or columns) in a dimension table whose values uniquely identify each row in the table. Primary keys enforce entity integrity by uniquely identifying entity instances.
upvoted 1 times
...
23042b9
3 months ago
YES YES NO
upvoted 2 times
...
MichaelZheng
3 months, 2 weeks ago
This question is not about primary or foreign keys. it about the metrics for basket analysis: Transactional Data: You need a dataset that captures individual transactions. This can include: 1.Transaction IDs 2.Product IDs or names 3.Quantity of each item purchased 4.Date and time of the transaction So, ofc, first option: Yes, no need for these informations. second option: no,we need only the format of date+time Third option: no,tax make no sense for basket analysis
upvoted 1 times
...
rcaliandro
5 months, 1 week ago
Yes, No, No
upvoted 2 times
...
Endeetheanalyst
5 months, 1 week ago
The Option 2 says "Both the OrderDateKey and OrderDate...." If you pick yes it means that you need both of them. But you don't.. at most you need only the OrderDate. So it should be NO
upvoted 1 times
...
agelee
6 months, 1 week ago
YES, NO, NO The second answer with assumption of understanding it in a way that we can remove either "OrderDateKey" or "OrderDate" but not both.
upvoted 3 times
...
wassefriahi
8 months ago
NO - NO - NO Retain Primary Keys in Dimension Tables: Do not remove primary keys from dimension tables. They are essential for establishing and maintaining relationships with the fact table, which is critical for the integrity and performance of your data model.
upvoted 1 times
...
JohnChung
1 year ago
I agree with Yes - No- No There is SaleOrderNumber that identifies the orders. Date should be the same under the same SalesOrderNumber, so Date can be removed
upvoted 3 times
...
AbuAbdillah
1 year ago
Yes: Primary key for the fact table is not needed only foreign keys are needed to connect with other dimension tables Yes: OrderDateKey column is needed to connect with the Date dimension table which may be used for analysis. The basket analysis requires date info No: Not necessary
upvoted 2 times
...
BarNouha
1 year, 3 months ago
Yes Yes No .. the date is important
upvoted 1 times
...
Judec
1 year, 3 months ago
But I am thinking that the orderDate is necessary to know when an Item was bought so that one can know the Items that were bought at time and by the same customer. I think is Yes-Yes-No
upvoted 4 times
rick1997
1 year, 3 months ago
I think we do not need dates. We are trying to see if they are within the same transaction (or order). The date is completely irrelevant, what we really would want to see is the orderID. There can be many different items bought on the same date that are part of different transactions, or orders.
upvoted 5 times
...
...
rainy_255
1 year, 3 months ago
This was in the exam this week.
upvoted 4 times
...
tke44
1 year, 7 months ago
yes No No
upvoted 3 times
...
RazaTheLegend
1 year, 9 months ago
Yes - No - No
upvoted 1 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