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

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 4 question 5 discussion

Actual exam question from Microsoft's DA-100
Question #: 5
Topic #: 4
[All DA-100 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:
Reference:
https://finance-bi.com/power-bi-basket-analysis/
by Maue at May 2, 2021, 3:57 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
Maue
Highly Voted 4 years ago
The Answer is: YES NO NO Because the only columns needed for that "Basket analysis" is Product, Transaction (Order) and Territory.
upvoted 113 times
Zakriya
4 years ago
Yes No No
upvoted 12 times
...
weirdos_noone
3 years, 11 months ago
how are we gonna know if two items are bought together if we don't have the order date ?
upvoted 1 times
Jajabink
3 years, 11 months ago
Only eithhttps://www.examtopics.com/exams/microsoft/da-100/view/17/#er OrderDate or OrderDateKey is required, NOT both, since there is no time data in OrderDate column (these columns are essentially the same). YES NO NO is the answer
upvoted 5 times
...
ken218
3 years, 10 months ago
Bought together means they are within the same order, so the SalesOrderNumber is good enough to identify it.
upvoted 8 times
...
steeeva
3 years, 3 months ago
2 different orders in the same day doesnt count, so date is unnecessary
upvoted 1 times
...
...
Shan
3 years, 4 months ago
how come the anser of A is Yes because sales row id is the index column n you cant delete this
upvoted 3 times
[Removed]
2 years, 10 months ago
Because SalesRowID is a row ID of unique combination of SalesOrderNumber and SalesOrderLineNumber. AuditID is the ID of the data load process in which identifies the updated row. Removing these columns will not impact the overall goal, which is to identify which products are bought together in same transaction in same territories. Basically, this will be identifying the regional trend.
upvoted 1 times
...
...
...
Amuzinde
Highly Voted 4 years ago
YES NO NO
upvoted 10 times
...
QWERTYman
Most Recent 2 years, 9 months ago
Answer Yes No No
upvoted 1 times
...
backuptrap
3 years ago
Question in the 27/04/2022 exam
upvoted 1 times
...
Ashley090521
3 years, 2 months ago
on exam 3/1/2022
upvoted 1 times
...
Shan
3 years, 4 months ago
In exam 30/12/21
upvoted 2 times
...
aguilartu1
3 years, 5 months ago
on exam - Nov 11, 2021. my answers: yes no no
upvoted 4 times
...
Thong
3 years, 6 months ago
The answers are correct: _ Y: not related _ N: At the first time, I thought it was a Y, because the combination of OrderDate and SalesOrderNumber will be used to distinguish with OrderNumber on other dates (some systems reset the SalesOrderNumber daily). However, taking a closer look at OrderDate and SalesOrderNumber, they are parallelly incremented. Thus, SalesOrderNumber has enough information. _ N: not related
upvoted 1 times
...
nowwin
3 years, 7 months ago
question in exam on 18th September
upvoted 5 times
Ihueghian
3 years, 6 months ago
Same 16/10
upvoted 2 times
...
...
francis6170
3 years, 8 months ago
Got this in the exam - Aug 15, 2021.
upvoted 3 times
...
geky123
3 years, 9 months ago
OrderDateKey is useless for own case. Yes, NO, NO.
upvoted 1 times
...
Andy7622
3 years, 10 months ago
Ouch, how I was tricked with the first statement after reading next ones)) Of course YES they can be removed!))
upvoted 1 times
...
kwamek
3 years, 12 months ago
Yes No No
upvoted 3 times
...
Koen123
4 years ago
I believe it should be NO, NO, NO.
upvoted 3 times
bobs2021
3 years, 12 months ago
Nope, that's just what she said.
upvoted 7 times
...
ashfaq_mcs
3 years, 11 months ago
How, How How?
upvoted 1 times
...
Praveenkumar0017
3 years, 11 months ago
Please read the question carefully and check your answers. Dont get confused.
upvoted 2 times
...
bpxgeek
3 years, 11 months ago
Can you read it well?
upvoted 1 times
...
...
Amuzinde
4 years ago
Are orderDateKet and OrderDate Necessary in this case? There is no requirement for date analysis is that so?
upvoted 1 times
Maue
4 years ago
Date is not required for the Basket analysis mentioned
upvoted 2 times
andimohr
3 years, 10 months ago
Nevertheless you can use one or the other date column and do not need to keep both. The OrderDateKey is a valid Date Format (easily test it yourself using enter data to create a table, enter 20101229 in row 1 and change Type to date)
upvoted 1 times
...
...
...
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