PL-300 Exam - Question 46

Question

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

Examice · Accepted 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.

simplex06 · Answer

Yes - No - No

Wadyba · Answer

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

Tareqk · Answer

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

rainy_255 · Answer

This was in the exam this week.

Usm_9 · Answer

was on the exam 02/03/2024

tke44 · Answer

yes No No

sdaaram · Answer

This was on exam yesterday

Judec · Answer

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

JohnChung · Answer

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

LouStar2 · Answer

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

Chellz · Answer

was on June 8, 2024 exam

svg10gh · Answer

Correct

RazaTheLegend · Answer

Yes - No - No

BarNouha · Answer

Yes Yes No .. the date is important

AbuAbdillah · Answer

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

wassefriahi · Answer

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.

agelee · Answer

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.

PL-300 Exam - Question 46

Discussion