Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 46

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:

    Correct 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.

Discussion
simplex06

Yes - No - No

Wadyba

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

dopass

I agree with you.

cnmc

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.

momo1165

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

cs3122

Primary Key is not needed here

Tareqk

This is was on the exam today. 2024-04-19

Usm_9

was on the exam 02/03/2024

RedRoss

whats your answer?

rainy_255

This was in the exam this week.

JohnChung

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

Judec

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

rick1997

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.

sdaaram

This was on exam yesterday

FinelogBiseum

What was your answer?

tke44

yes No No

Chellz

was on June 8, 2024 exam

LouStar2

This was on todays exam but I am not sure the 3rd question was as it is here. The first 2 I am pretty sure appeared as is

Jwad

I have a question, what percent of questions from this website were in the actual exam?

agelee

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.

wassefriahi

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.

AbuAbdillah

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

BarNouha

Yes Yes No .. the date is important

RazaTheLegend

Yes - No - No

svg10gh

Correct