Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 4 question 5 discussion

Actual exam question from Microsoft's DA-100

Question #: 5
Topic #: 4

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

Suggested Answer:

Reference:
https://finance-bi.com/power-bi-basket-analysis/

by Maue at May 2, 2021, 3:57 a.m.

Comments

Submit Cancel

Maue

Highly Voted 4 years, 3 months 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, 3 months ago

Yes No No

upvoted 12 times

...

weirdos_noone

4 years, 2 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

4 years, 1 month 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

4 years, 1 month 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, 6 months ago

2 different orders in the same day doesnt count, so date is unnecessary

upvoted 1 times

...

Shan

3 years, 7 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

...

Amuzinde

Highly Voted 4 years, 3 months ago

YES NO NO

upvoted 10 times

...

QWERTYman

Most Recent 2 years, 12 months ago

Answer Yes No No

upvoted 1 times

...

backuptrap

3 years, 3 months ago

Question in the 27/04/2022 exam

upvoted 1 times

...

Ashley090521

3 years, 5 months ago

on exam 3/1/2022

upvoted 1 times

...

Shan

3 years, 7 months ago

In exam 30/12/21

upvoted 2 times

...

aguilartu1

3 years, 8 months ago

on exam - Nov 11, 2021. my answers: yes no no

upvoted 4 times

...

Thong

3 years, 9 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, 10 months ago

question in exam on 18th September

upvoted 5 times

Ihueghian

3 years, 9 months ago

Same 16/10

upvoted 2 times

...

francis6170

3 years, 11 months ago

Got this in the exam - Aug 15, 2021.

upvoted 3 times

...

geky123

4 years ago

OrderDateKey is useless for own case. Yes, NO, NO.

upvoted 1 times

...

Andy7622

4 years, 1 month 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

4 years, 2 months ago

Yes No No

upvoted 3 times

...

Koen123

4 years, 3 months ago

I believe it should be NO, NO, NO.

upvoted 3 times

bobs2021

4 years, 2 months ago

Nope, that's just what she said.

upvoted 7 times

...

ashfaq_mcs

4 years, 2 months ago

How, How How?

upvoted 1 times

...

Praveenkumar0017

4 years, 2 months ago

Please read the question carefully and check your answers. Dont get confused.

upvoted 2 times

...

bpxgeek

4 years, 2 months ago

Can you read it well?

upvoted 1 times

...

Amuzinde

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

Date is not required for the Basket analysis mentioned

upvoted 2 times

andimohr

4 years 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

...